How can I perform calculations with dropdown fields

  • Profile Image
    cheapo
    Asked on February 08, 2018 at 02:31 PM

    I went on YouTube and looked at your videos

    What you have there and what you have now is different
    The only thing I find now its
    " form calculator"
    It was straightforward and make sense
     
    I'm doing a food menu to every one of my pulldown menu would be in addition
    It seems like I can only do 5 or 6 calculations a row
    Am I using the right widget
     
    If I do (2 ) calculation it worked fine
    So obviously everytime we pick an item on the menu would add an addition
    At the end of the form would have a total
     
    There's a test Brooklyn Pizza inside my account
    Like I said two or three or four not a problem they work it's after the 5th and 6th and 7th it don't calculate anymore can you please give me example in my account thank you

  • Profile Image
    Adrian
    Answered on February 08, 2018 at 03:50 PM

    To make calculations in your form, you can use the Form Calculation Widget.

    You can add as many fields you want in the Widget.

    Complete Guide: How to Perform Form Calculation Using a Widget

    You can also make calculations based on conditions.

    Complete Guide: How to Insert Text or Calculation into a Field Using Conditional Logic

    Here is a demo form where all the values of the fields (10) are added.

    https://form.jotform.com/80386276482970

    15181230011.png

    Make sure you have no errors in the calculation widget, like leaving trailing operations.

  • Profile Image
    cheapo
    Answered on February 08, 2018 at 04:43 PM
    I'm using pull-down menu is that a problem?
    ...
  • Profile Image
    cheapo
    Answered on February 08, 2018 at 04:43 PM
    Is it possible to check my test Brooklyn Pizza account
    You can see what I'm doing and try to correct me or explain to me what I'm
    doing wrong if pull down menu at work I believe I'm doing everything right
    thank you
    ...
  • Profile Image
    Jim_R
    Answered on February 08, 2018 at 06:55 PM

    I'm using pull-down menu is that a problem?

    No, that won't be a problem. In fact, with a DROPDOWN field, it's easier to calculate totals because you can assign CALCULATION VALUES for each of the dropdown options you have on that field.

    You just need to add the DROPDOWN field within your FORM CALCULATION WIDGET if you wish to include them in your formula.

    Related guide: How-to-Assign-Calculation-Value

    My recommendation when building a form is to start simple. Have a look at this demo form (or clone it) to see how dropdowns are used in conjunction with the form calculation widget.

    https://www.jotform.com/80387626043963

  • Profile Image
    cheapo
    Answered on February 08, 2018 at 09:43 PM
    Actually I'm aware how to do this
    It's very straightforward and logical we're having a problem in my account
    test Pizza The tests Pizza form
    I think they have a lot of pull-down menu maybe 20 or 30 of them
    It seems like I can't put them all in there it's not working the first four
    to five work fine but after that it's a problem this is my issue
    ...
  • Profile Image
    Nik_C
    Answered on February 09, 2018 at 04:22 AM

    We didn't receive any screenshot (if you tried to post it). 

    But I checked your form and there is only one condition there and it is broken:

    1518168011Screen Shot 2018-02-09 at 10.1

    That is the reason why the conditions wouldn't work.

    If you want to post the screenshot please follow: https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum

    Thank you!