Forum Discussion
Solved
Can Forms 365 add a calculated field
Hi all: Is it possible to add set of options that will automatically add up on the form if that option is chosen? Example: How many coloured balls would you like to buy? The person filling out wit...
joZ99 no, unfortunately there is no functionality that lets you do calculations like that. If the people completing the form were in your organisation you could create a Power Apps form which does allow you to build quite complex calculations. But from your question I assume that people will be outside your organisation you'll need to use a non-Office 365 app like Jotform.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
joZ99 no, unfortunately there is no functionality that lets you do calculations like that. If the people completing the form were in your organisation you could create a Power Apps form which does allow you to build quite complex calculations. But from your question I assume that people will be outside your organisation you'll need to use a non-Office 365 app like Jotform.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
You are right. As a one person operation, I need one good app that works with "outsiders"... I wish the Business Version 365 could aspire to be better than the competition, an app like Jotform...
365 Forms should be able to do at least as much as them. Hopefully they will catch up.
I am not trying to be negative... I really enjoy 365. As the needs of my small business increase I would like to be able to stay within 365 and not look outside.
Thanks so much for your reply.
Unfortunately, my forms go to adult "students" and so all of them are outside the 365 organization.
It is just the three of us, me, myself and I, that is sending it to 100+ recipients. I appreciate the advice on another App... I will either try a work around with Forms 365... get them to use their own amazing Math skills to add up numbers and write down their answer, and/or I will start looking at Jotform. It seems like such a simple "add-in" to be able to "add-up" but as I am not a techy I am sure it is challenging to create install into Forms 365. Maybe someday soon so I can return it using it.
What a great resource this Forum is as I have tried asking this same question by phoning Microsoft and none of their experts had expertise in Forms.
Thanks again...
