SOLVED

Can Forms 365 add a calculated field

%3CLINGO-SUB%20id%3D%22lingo-sub-2581908%22%20slang%3D%22en-US%22%3ECan%20Forms%20365%20add%20a%20calculated%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581908%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3A%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20add%20set%20of%20options%20that%20will%20automatically%20add%20up%20on%20the%20form%20if%20that%20option%20is%20chosen%3F%3C%2FP%3E%3CP%3EExample%3A%20How%20many%20coloured%20balls%20would%20you%20like%20to%20buy%3F%3C%2FP%3E%3CP%3EThe%20person%20filling%20out%20with%20form%20selects%20Option%201%20and%204.%3C%2FP%3E%3CP%3E%3CSTRONG%3E_X_%3C%2FSTRONG%3EOption%201%20-%2010%20Balls%20in%20Red%20-%20%3CSTRONG%3E%241.00%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E___Option%202%20-%2020%20Balls%20in%20Blue%20-%20%242.00%3C%2FP%3E%3CP%3E%3CSTRONG%3E___%3C%2FSTRONG%3EOption%203%20-%2030%20Balls%20in%20Green%20-%20%243.00%3C%2FP%3E%3CP%3E_%3CSTRONG%3EX%3C%2FSTRONG%3E_Option%204%20-%2040%20Balls%20in%20Pink%20-%20%3CSTRONG%3E%244.00%3C%2FSTRONG%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20total%20for%20all%20Balls%20selected%20is%3A%20__%3CSTRONG%3E%245.00%3C%2FSTRONG%3E______%26nbsp%3B%20(the%20form%20automatically%20calculated%20%245.00)%3C%2FP%3E%3CP%3EIf%20FORMS%20in%20365%20cannot%20do%20this%2C%20can%20you%20recommend%20a%20Form%20that%20can%20do%20this%2C%20and%20that%20has%20all%20the%20other%20great%20functionality%20that%20FORMS%20365%20has%3F%20Thanks%20so%20much%20in%20advance%20for%20your%20advice.%20I%20can't%20seem%20to%20get%20answers%20when%20I%20call%20the%20365%20hotline.%20No%20one%20on%20the%20phone%20can%20answer%20this%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2581908%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPoll%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuiz%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERegistration%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2582463%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20Forms%20365%20add%20a%20calculated%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2582463%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111420%22%20target%3D%22_blank%22%3E%40joZ99%3C%2FA%3E%26nbsp%3Bno%2C%20unfortunately%20there%20is%20no%20functionality%20that%20lets%20you%20do%20calculations%20like%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 with form selects Option 1 and 4.

_X_Option 1 - 10 Balls in Red - $1.00

___Option 2 - 20 Balls in Blue - $2.00

___Option 3 - 30 Balls in Green - $3.00

_X_Option 4 - 40 Balls in Pink - $4.00 

Your total for all Balls selected is: __$5.00______  (the form automatically calculated $5.00)

If FORMS in 365 cannot do this, can you recommend a Form that can do this, and that has all the other great functionality that FORMS 365 has? Thanks so much in advance for your advice. I can't seem to get answers when I call the 365 hotline. No one on the phone can answer this question.

 

 

 

 

 

3 Replies
best response confirmed by joZ99 (New Contributor)
Solution

@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)

@RobElliott 

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...

@RobElliott 

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.