How can I perform calculations with dropdown fields

  • cheapo
    Asked on February 8, 2018 at 2: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

  • Adrian
    Replied on February 8, 2018 at 3: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

    How can I perform calculations with dropdown fields Image 10

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

  • cheapo
    Replied on February 8, 2018 at 4:43 PM
    I'm using pull-down menu is that a problem?
    ...
  • cheapo
    Replied on February 8, 2018 at 4: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
    ...
  • Support_Management Jotform Support
    Replied on February 8, 2018 at 6: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

  • cheapo
    Replied on February 8, 2018 at 9: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
    ...
  • Nik_C
    Replied on February 9, 2018 at 4: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 Screenshot 10

    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!