Form calculation widget is not calculating

  • Profile Image
    cheapo
    Asked on February 21, 2018 at 12:21 AM
    Unfortunately I'm having trouble again with the calculation I thought I solve the problem but it is not working
    'Im using the ......form calculator widget
    It seemed to be straightforward and it was work for like 7 entry and then it stopped working completely I can't figure out what I'm doing wrong ???...
    This is the format I'm using
    Name of item  0 9 + abs (  )
     name of item 0 9 + abs (  )
    And like I said it worked for 8 entries 
    Then  I add the 8 entry stopped working
    I'm working in the test Brooklyn Pizza
    If you can be assistance I appreciate it
    Thanks for your help Robert

     
  • Profile Image
    Victoria_K
    Answered on February 21, 2018 at 02:56 AM

    I will check the form you mentioned and get back to you soon.

  • Profile Image
    Victoria_K
    Answered on February 21, 2018 at 03:20 AM

    Upon checking your form, I was able to find out the following.

    It seems that you have added an "absolute value" parameter to your calculations and it is causing the issue. Actually, the fact that it is used not quite correctly. 

    Here is how it should be:

    abs ( Ricotta cheese )

    1519201025Screenshot_6.png

    But, it is not obligatory to use that parameter in your situation. I can see that you have already defined the calculation values for your dropdown fields. So, you can just summ them, it works in my test form:

    1519201054The Easiest Online Form Builde

    I have used just two fields as an example, but you can add all other to your real form.

    Here is the result:

    1519201131screencast2.gif

    Let us know how it goes! 

  • Profile Image
    cheapo
    Answered on February 21, 2018 at 08:43 AM
    I appreciate you getting back to me the system works fine in the beginning
    and we have tried many different scenarios I also use your scenario using
    the plus factor and product and it worked fine up to
    extra topping the 8
    Then it's simply stop calculate
    Please go into my account and check and help me figure out this problem
    there is no conditional Logic on the form
    Someone else suggested I had conditional logic I do not
    I appreciate any help if you can go into my account and play with that you
    can see what I'm dealing with and make more sense than just making a sample
    with two entries example of two entry work fine the problem is when you
    have a lot of entries
    Thanks again Robert
    ...
  • Profile Image
    cheapo
    Answered on February 21, 2018 at 10:29 AM

    Just so everybody understands that the problem has not been fixed and been dealing it for 2 weeks

    Will someone please tell me how to fix this problem and find a solution

    And don't give me a 2 problem example and it works fine that not my issue please read the emails and the postings

     I am so frustrated with your company and your lack of communication I'm ready to cancel my membership and go to another form company that actually works

    Another thought

    I have seen other  posting about Form calculator widget  I am not the only one having problem with it widget I see a whole lot of complaints

    If you don't give phone support you should give live chat service

     I know you been in business for a long time but I don't know how other people deal with you guys it's so much problems getting information from you very bad communication if I don't get my Forum calculating corrected after hours and hours and labor and money spent on this form

    Before I do any more work on there graphic part

    It needs to add up at the end of the day order form is not useful

    If the problem is not fixed by Friday I will leave your company

    Thank you frustrating customer

    Robert Bernay

    And I'm a very big social media person and everybody will know how I feel about your company and what you have done or not done for me

  • Profile Image
    BJoanna
    Answered on February 21, 2018 at 11:04 AM

    Sorry for the inconvenience this may caused you. 

    I cloned your form and I was able to replicate the issue you reported. Your calculation is set correctly, but it is not working. 

    After multiple tests I found out that the fields (Order-7) -Extras) and (Order-8) -Extras) are causing the issue. I am not sure why but it seems that there is a glitch with those fields. 

    To resolve the issue, remove them from your form and re-create them. You can also duplicate the field (Order-6) -Extras). 

    I did this on my cloned form. Here is my form: https://form.jotform.com/80514021663952 

    Feel free to test it and clone it

    If you duplicated field in your form, it is possible that fields (Order-7) -Extras) and (Order-8) -Extras) will cause an issue in other section of your form, when you set the calculation. If that happens, do the same remove the fields and re-add them to the form.

    If you plan to create a calculation for all form fields, I would suggest you to split the calculations. Calculate each section of your form separately and then perform a total calculation at the bottom of the form. 

  • Profile Image
    cheapo
    Answered on February 21, 2018 at 11:43 AM
    Ok
    can you explain to me how to split the calculation and how to get a grand
    total at the bottom I tried it and I couldn't make that work either
    Just to clarify
    To go ahead and delete 7 and 8
    And clone number 6 and that working moving forward
    I try adding the wing and that don't work either
    So when the calculator field don't work reissue a new one?
    That almost like making a whole new form lot of work.....?
    ...
  • Profile Image
    cheapo
    Answered on February 21, 2018 at 12:43 PM
    Clone of clone of test Brooklyn Pizza I'm inside
    So I added "wings" and that works fine
    Then I added the 6 salads and now the system saying
    Total 0
    Show do I need to delete something Andre at it is that the solution maybe
    you guys should fix the widget
    I do appreciate your help it your help if you can update the Clone Pizza
    that be great and see how we can fix it and again if you can tell me how to
    add the price on the first page I would love that as a subtotal
    ...
  • Profile Image
    BJoanna
    Answered on February 21, 2018 at 01:13 PM

    I am testing your cloned form and as far as I can see the calculation is working properly.

    1519235886formcalc1.gif

    I noticed that you set the calcification for 4 out of 6 salads. Did you resolve the issue with salads? Please note that the dropdown fields (Order-7) -Extras) and (Order-8) -Extras) were previously cussing the issue not Form Calculation widget. 

    Regarding your other question, you can move the Form Calculation widget to the first page or have the same calculation field on both pages.

    What I thought is that you can create a separate calculation for each section. For example, calculate only Pasta options in one field, then in another field calculate only Pasta Extras, in the third field calculate Wings and Salads, and so on. Then set Grand Total calculation and sum all other calculation fields. Considering that you have a lot of fields, this will allow you to easier check if there is an issue with your calculations because you will be able to test each section separately. 

  • Profile Image
    cheapo
    Answered on February 21, 2018 at 01:43 PM
    show update 1 one salad was not working
    I added it back like you told me I clone the one before it and now it's
    working
    In retrospect......
    I have to add one calculate a function
    and check it
    Then move forward
    I thank you for finding the fix but this is ridiculous
    again I would love to have the sub total right above the pizza on page one
    If you connect direct me how to make that work or do it for me I would
    appreciate it just check a labor-intensive process I'm going to shoot
    myself .....haha
    ...
  • Profile Image
    cheapo
    Answered on February 21, 2018 at 01:43 PM
    Yes I did fix the salad problem bye by doing what you explain me to do I
    deleted the one that didn't work and then clone the one that did work and
    then change everything on the on the element very time consuming
    Yes I would love to have each section calculate and then at the bottom do a
    Do-A total I don't have any luck as well you condition logic and I know I
    would have to have a condition log it on every calculator
    If you can help me set up that punched out of that be great
    I would love to have at least at the end of each pay the calculate the
    subtotal and then at the bottom total
    So are you telling me that it's not going to work and just having one total
    at the end or I'm going to have problems?
    Other issue
    Also there's one other thing that that no one has answered my question is
    yet and you seem like the smartest person in the bunch
    You see how I'm doing it right I have an item let's say pizza
    My phone people
    Have to check two different options
    Either extra or no topping
    What I see on the internet out there they have something called a sub menu
    That I pulled down cheap pizza 18 in
    And a checkbox box with pop up on the screen
    And you would have two call columns. One would have extras
    And no toppings
    Right now is the only way I found your system to work it be so much easier
    to check some boxes on each Pizza and call it a day
    Right now
    I have about eight options
    Which would probably work but it didn't make the form longer and longer
    If I had a pop-up box for each item
    Versace the pull-down menu
    To be a lot more logical
    If the pop-up (Sub menu) is not available to me
    I understand we all have limitations
    The other issue I'm having
    Is there any way possible
    ...
  • Profile Image
    Victoria_K
    Answered on February 21, 2018 at 03:05 PM

    Upon investigating your form "Clone of clone of test Brooklyn Pizza" in details, it seems that I have found the mistake. 

    Please take a look at your "Lasagna" field, I can not see a value for your "10) order". I have entered 9.40 and the calculation works again. 

    Take a look:

    1519243353Screenshot_10.png

    1519243371screencast2.gif

    Please test this form:

    https://form.jotform.com/80516137583963


    Let me know if filling this value does not fix the issue at your end. 


  • Profile Image
    Victoria_K
    Answered on February 21, 2018 at 03:24 PM

    I am also adding totals for each section, result will be ready in a moment.

  • Profile Image
    Victoria_K
    Answered on February 21, 2018 at 03:48 PM

    https://form.jotform.com/80516137583963

    Now the form has "totals" under each section, that was included to your calculations, and Grand Total at the end. I did not hide calculation fields yet to see how it works. You can do that after checking. 

    How-to-Hide-Form-Fields

     

    Let me know if there is something I have missed.

  • Profile Image
    cheapo
    Answered on February 21, 2018 at 08:29 PM

    Victoria thank you so much for helping me out


     I cannot see what you did for me by the totals and each section of the form I don't see it on my form maybe I'm doing something wrong or I'm  looking at the wrong  form
    Clone clone test Brooklyn Pizza?
     
     also 
    I'm using submission widget for my order number
     now having a problem with the submit button on form I calling it order number it seems like it's not working correctly when I do a preview and when I send it the  is correct 6 on the actual email it had two spots top and bottom I also title it order number one's not moving at all 
  • Profile Image
    ashwin_d
    Answered on February 22, 2018 at 01:01 AM

    My colleague @Victoria_K did not make any changes in your form. She seems to have cloned your form and made changes in the cloned form. 

    I would suggest you to please take a look at the following cloned form and see if it works as expected:  http://www.jotformpro.com/form/80516137583963 

    Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL


  • Profile Image
    cheapo
    Answered on February 22, 2018 at 02:43 AM
    We're adding more of the food option for the calculator I see you're in the
    system do you want me to stop and wait till your done or can I continue?
    ...
  • Profile Image
    cheapo
    Answered on February 22, 2018 at 02:43 AM
    When you have a common field like lasagna
    Order 1
    order 2
    order 3
    Obviously we using the
    2
    4
    6
    8
    Show it we total up to the correct answer
    Thanks for finding a mistake
    ...
  • Profile Image
    cheapo
    Answered on February 22, 2018 at 02:43 AM
    It seem like the calculator and working now I haven't came across any other
    issues
    If you have a solution for any other my problem make the form better I
    would appreciate it
    Thanks again for all your help
    ...
  • Profile Image
    cheapo
    Answered on February 22, 2018 at 02:43 AM
    Thank you I do appreciate and at the bottom of your total?
    ...
  • Profile Image
    cheapo
    Answered on February 22, 2018 at 02:43 AM
    So I don't see
    The form clone of clone of test Brooklyn Pizza
    Am I looking in the right place?
    ...
  • Profile Image
    cheapo
    Answered on February 22, 2018 at 02:43 AM
    Let me restate that I see the form but I don't see any of the totals in the
    individual sections
    ...
  • Profile Image
    cheapo
    Answered on February 22, 2018 at 02:43 AM
    Victoria
    I do not see the totals in the individual section
    I'm looking on the phone working on clone of clone of test Brooklyn Pizza
    Am I in the right spot
    ...
  • Profile Image
    cheapo
    Answered on February 22, 2018 at 02:43 AM
    sorry *Joanna*
    ...
  • Profile Image
    cheapo
    Answered on February 22, 2018 at 02:43 AM
    Sorry for getting the wrong name Joanne I do appreciate all your help
    I get this covered the number submission is not working now actually when
    you a preview the first number is right and the bottom number is different.
    Don't work have to be the same number that the order number it is something
    we can do about that or what's happening with that do i break it
    ...
  • Profile Image
    Victoria_K
    Answered on February 22, 2018 at 02:49 AM

    Hello, I'll provide you a step-by-step guide of how to add calculations to your sections in a moment.

  • Profile Image
    Victoria_K
    Answered on February 22, 2018 at 03:09 AM

    Last time I have created section totals for the items you did have in your grand total field (at the end of your form). 

    So, you can keep adding Form Calculation widgets to other sections of your form and summarize there items of the section.

    Here you can see your CALZZONES & STROMBOLI ROLL section with calculation added:

    1519286364The Easiest Online Form Builde

    You can click on the last field of a section for the Form Calculation widget appear right after it, not at the end of your long form.

    1519286669screencast2.gif

    Afterwards, do not forget to add all section calculations to your Grand Total field:

    1519286881screencast2.gif



  • Profile Image
    cheapo
    Answered on February 22, 2018 at 05:44 AM
    Hopefully you went to lunch had a few question for you and get back to me I
    sent you in previous emails
    ...
  • Profile Image
    Victoria_K
    Answered on February 22, 2018 at 06:39 AM

    I get this covered the number submission is not working now actually when you a preview the first number is right and the bottom number is different. Don't work have to be the same number that the order number it is something we can do about that or what's happening with that do i break it

    Can you please tell me which one of your forms you're working on now, so I could check it closer?

  • Profile Image
    cheapo
    Answered on February 22, 2018 at 12:43 PM
    Victoria
    First thing I really appreciate all the work you did for me and helping me
    out get through this frustrating moment
    I fixed submission button it myself thank you and that's on the working
    test Brooklyn Pizza
    Also I didn't see where you put the sample calculator form for each section
    ...
  • Profile Image
    Victoria_K
    Answered on February 22, 2018 at 12:48 PM

    Here is my test form:

    http://www.jotformpro.com/form/80516137583963

    Please feel free to clone it. Here is a simple guide about cloning:

    How-to-Clone-an-Existing-Form-from-a-URL


    I realy hope that this all helps you! 

    Have a nice day and get back to us if you need more assistance.

  • Profile Image
    cheapo
    Answered on February 22, 2018 at 01:43 PM
    I'm sorry is this the same one they sent me last night or did you update
    this section calculator
    ...
  • Profile Image
    Victoria_K
    Answered on February 22, 2018 at 02:13 PM

    It is updated with section calculations.

  • Profile Image
    cheapo
    Answered on February 22, 2018 at 04:43 PM
    Thanks for help me again I appreciate it
    Any solution for my selecting a pasta and making choosing a pasta a
    mandatory field?
    And get so
    I understand on your updated thanks form we have 2 -calculator and grand
    total
    At bottom they're both exactly the same can I delete the top one (
    calculator)
    Or do I have to keep both
    ...
  • Profile Image
    Victoria_K
    Answered on February 22, 2018 at 04:55 PM

    Any solution for my selecting a pasta and making choosing a pasta a

    mandatory field?

    To set the field Required, you need to enable this option at fields properties:

    1519336388The Easiest Online Form Builde

    At bottom they're both exactly the same can I delete the top one (

    calculator)

    Yes, they are the same. I have left your original field to show that there is no difference, but I have deleted first one in the updated form.


    Let us know if you need more help.

  • Profile Image
    cheapo
    Answered on February 22, 2018 at 05:43 PM
    I know how to make something required
    What I'm trying to accomplish when making a pasta selection I want the
    pasta Choice mandatory
    I hope that make more sense
    Am I not able to clone the calculator with all the calculation inside is
    that not possible?
    ...
  • Profile Image
    cheapo
    Answered on February 22, 2018 at 06:43 PM
    Question
    I rather have a running total then sections calculate
    Can I can I clone my total calculator and then move it where I want to in
    each section?
    ...
  • Profile Image
    Mike
    Answered on February 22, 2018 at 09:11 PM

    I know how to make something required. What I'm trying to accomplish when making a pasta selection I want the pasta Choice mandatory

    I am afraid that we cannot directly set this up since you have many pasta selection dropdowns. For a single dropdown, it is possible to use conditions. For example, if order #1 selected, require 1 pasta choice, if order #2 selected, require 1 pasta choice and require 2 pasta choice.

    Am I not able to clone the calculator with all the calculation inside is that not possible? I rather have a running total then sections calculate. Can I can I clone my total calculator and then move it where I want to in each section?

    This is not possible to duplicate the calculation field with its formula inside. However, there is a workaround. You can use a unique field {name} within a Text field type to get the total value. The unique name of the total field on your form is {calculation}.

    For example, you can use it in each section like this.

    Total Order: $ {calculation}

  • Profile Image
    cheapo
    Answered on February 23, 2018 at 08:43 AM
    I try to give you condition logic
    Again it's candy straightforward
    the if statement
    number 12 tomato sauce and pasta
    equal to
    order 1
    and I understand I would have to do it through 1 through 10
    This is what I'm not getting
    The do statement
    required
    Pasta choice order 1
    This where the problem begins
    My next do statement
    would be positive
    choice order two
    What I read my test
    If I pull down
    tomato sauce and pasta
    1 and 2 pasta Choice are required
    The only time the choice be required
    It the second pulldown
    Ricotta cheese and pasta
    so I am confused
    I hope I made it clear for you it's kind of
    Did you statement don't know which one to apply to not being singled out in
    my opinion
    If I only had one do statement it work fine
    Thanks again Robert
    ...
  • Profile Image
    Richie_P
    Answered on February 23, 2018 at 09:53 AM

    As what my colleague showed you, we can have multiple if statements to require the needed fields. Unfortunately, the sequence you have given will not work with the current format of your fields.

    May I suggest, using a Multiple Choice for the Pasta - Choice, to allow a single require condition for all the Past-Choice and you can also select multiple pastas.

    Here is a sample screen cast.



    Here is my cloned form https://form.jotform.com/80533316371956

    Feel free to clone it, to check the condition.How-to-Clone-an-Existing-Form-from-a-URL

    Please let us know if we can be of further assistance.

  • Profile Image
    cheapo
    Answered on February 23, 2018 at 02:43 PM
    Again thank you for responding so quickly
    Unfortunately I'm using the pull-down menu for a very long list like 85
    item for extra toppings
    For the check box will not work
    There's no work around to make when you pull down a
    pasta dinner selection(10 dinner option)
    To make pull down a pasta choice required
    spaghetti ,linguine, rigatoni??
    Thanks for any input Robert
    ...
  • Profile Image
    Mike
    Answered on February 23, 2018 at 04:49 PM

    If you need to set the Pasta-Choice dropdowns as required based on the number of the ordered pastas, you may try the following.

    Calculate the number of the pasta orders. For example:

    (tomato pasta / 8.95) + (ricotta pasta / 8.35) + (Lasagna / 9.40) + other pasta dropdowns in the same way

    Then, set up the require field conditions based on the number of the orders.

    and so on.

  • Profile Image
    cheapo
    Answered on February 24, 2018 at 07:43 AM
    I set up the the way you explained it and it's still not working correctly
    if I select pasta dinner (tomato sauce and pasta)
    select 1
    It's requiring to have two choices
    thank you for your help
    ...
  • Profile Image
    cheapo
    Answered on February 24, 2018 at 09:43 AM
    It's a miracle I actually got it to work thanks for your help and insight
    Of course I have another question
    Okay scenario
    I select 2 pasta dinners
    ( tomato sauce and pasta)
    also
    I select two
    ( ricotta cheese and pasta)
    That makes a total of four pasta dinners
    That mean I need to choose 4 pasta selections
    Right now the way to setup
    If I pulled two down choice of pasta of anything it will count as both on
    each pasta dinners
    ...
  • Profile Image
    cheapo
    Answered on February 24, 2018 at 09:43 AM
    Example
    ...
  • Profile Image
    Victoria_K
    Answered on February 24, 2018 at 01:14 PM

    If I understand you right, you want to require at least one choice of pasta at "PASTA-CHOICE OF PASTA WITH SIDE SALAD & GARLIC BREAD" section. Am I right?

    I have an idea in mind, so I'll try to implement and explain it and you please tell me if my suggestion is acceptable.

    1. I have added one more field to show pasta total. It is a form calculation widget set up to be read-only.

    1519495841screencast2.gif

    2. Also there was a conditional statement added, if pasta total is less than 8 > require pasta total. 

    1519495856The Easiest Online Form Builde

    Here is my test form:

    https://form.jotform.com/80544858083969

    1519496061screencast2.gif

  • Profile Image
    cheapo
    Answered on February 24, 2018 at 03:43 PM
    Again what I'm trying to say if I select
    I'm not having any trouble with calculating money now the whole different
    issue
    (tomatosauce and pasta)
    I pull down 2 selections
    That mean required 2 Pasta choices
    The hear that scenario
    If I select two pasta dinners
    Example
    Tomato sauce and pasta
    &
    Regatta cheese and pasta
    The require pasta choices are 4
    In total which is required
    The way the system setup now only 2 are required
    Anyway the tell the system you need to pull down 4 required plastic choices
    ...
  • Profile Image
    Victoria_K
    Answered on February 24, 2018 at 04:40 PM

    The logic I've implemented is following:

    As I understood, you want the respondent to choose at least one dish from section. 

    So, I made it possible with estimating total price of section. 

    For example, the lowest price for pasta is ~$8.95, so I've compared total of the section with 8. 

    If it is lower, then no dish is chosen.

    If you want the respondent to choose at least 2 dishes, I'd recommend to compare the section total with ~16.

    Please note that you can HIDE the total of the section to avoid your respondents see it. But, that is the only way to handle the "section requirement". 


    Please provide me more information as to you ideas for Pasta Choice (how many dishes should be required per section?) and please test my form:

    https://form.jotform.com/80544858083969

  • Profile Image
    cheapo
    Answered on February 24, 2018 at 04:43 PM
    Here's another example
    I pulled down
    (tomato sauce and pasta )
    1 order
    Also
    (ricotta cheese and pasta)
    1 order
    That will be a total of 2 orders
    Will require a choice of 2 pasta choices
    The way it's set up now only one is required
    please see the picture thanks Robert
    ...
  • Profile Image
    cheapo
    Answered on February 24, 2018 at 04:43 PM
    This should be a fairly yes or no answer
    I have a lot of calculators in my form now for subtotals
    When I preview or send an email
    I don't want to see the empty calculator entries let the something filled
    in rather than zero
    I looked how to hide it.... I don't see the option
    any suggestions
    ...
  • Profile Image
    Victoria_K
    Answered on February 24, 2018 at 04:50 PM

    It seems that we both had posted in one moment. 

    I'll duplicate my reply to be sure that you've seen that. 

    The logic I've implemented is following:

    As I understood, you want the respondent to choose at least one dish from section. 

    So, I made it possible with estimating total price of section. 

    For example, the lowest price for pasta is ~$8.95, so I've compared total of the section with 8. 

    If it is lower, then no dish is chosen.

    If you want the respondent to choose at least 2 dishes, I'd recommend to compare the section total with ~16.

    Please note that you can HIDE the total of the section to avoid your respondents see it. But, that is the only way to handle the "section requirement". 

    Please provide me more information as to you ideas for Pasta Choice (how many dishes should be required per section?) and please test my form:

    https://form.jotform.com/80544858083969

     

    As to your question

    I looked how to hide it.... I don't see the option

    Here is 2-step guide for hiding fields:

    How-to-Hide-Form-Fields

     

    Hope this helps!

  • Profile Image
    cheapo
    Answered on February 24, 2018 at 05:43 PM
    Victoria
    Actually you don't understand what I'm trying to come across
    If I pull down 2 pasta dishes in one column and then I pulled another 2
    pasta other column column
    It required 4 pasta choices not 2
    The system only sees it at 2
    Please look at my account to see what I'm trying to come across
    The calculator is working fine
    And the mandatory field are working well
    Unless I pull down to choices which cause the problem
    Unless you can do this with the math
    If it adds up to 35.80 width pasta dinners
    Have to be a total of 4 choices required
    ...
  • Profile Image
    cheapo
    Answered on February 24, 2018 at 05:43 PM
    I just looked at your example
    And I pulled down 2 and 2 and it only required 2 pasta choices not the way
    supposed to be be 4 required pic a pasta choices
    Thanks again
    It makes sense what you saying me with money but I have to do for every
    section correct?
    What have to multiple Buy * $8.00
    Depending on the money value
    Would be required pic a pasta choice ??
    Am I thinking this right
    ...
  • Profile Image
    liyam
    Answered on February 25, 2018 at 12:02 AM

    Hello,

    I'm just jumping in on this thread and noticed that this has become long. So please pardon me if I get to misinterpret where this matter is going now.

    Yes, you will have to do it on every section. Please take note that the calculation widgets are individual in its own sense so you will have to setup its calculation setting for each and identify the objects (fields) that you wish to be included in the calculation.

    Thanks.

  • Profile Image
    cheapo
    Answered on February 25, 2018 at 08:43 AM
    last question
    About pasta choices
    I have to get rid of all the other condition logic
    And yes you money
    Required the pick pasta Choices
    So $8 would be 1 pic a pasta
    $16 ---2 pic a pasta
    $24 -3
    And so on and so on
    So I have it right now correct
    I didn't look at your condition logic yet
    I would have to add eight equals
    Then require one pasta choice
    ...
  • Profile Image
    Mike_G
    Answered on February 25, 2018 at 11:38 AM

    Here's what I understand your requirement is based on the information above.

    Require the equal number of Pasta - Choice drop-down field(s) based on the total number of Pasta orders regardless if different kinds of pasta were filled.

    For example, 2 orders were selected from (Tomato Sauce & Pasta) drop-down and 2 orders also for (Ricotta Cheese & Pasta) drop-down. This means that there should be 4 Pasta - Choice drop-down fields that should be required.

    Now, the thought of using the sub-total amount to determine how many orders were placed is one way of getting the total number of orders. However, this may also create confusion since most of the kinds of pasta have a different price from the other.

    I would like to propose a solution where it will require for us to break down the total price to get the total orders. Which, in that case, we will need to add another Form Calculation widget to the form.

    I understand that for each order option you have placed a Calculation Value based on the price of each pasta. Since each pasta has a determined price, we will divide the Calculation Value of each option by its price. Then, in the Form Calculation widget, we will add the quotient to get the total number of orders selected in all kinds of pasta.

    1519575449t11_10_45.png

    After that, we will use the value of that new Form Calculation widget to create conditions to require the equal number of Pasta - Choice drop-down field(s).

    1519575892t11_24_04.png

    1519575911t11_24_28.png

    Note: You need to delete all other conditions that would make the Pasta -Choice drop-down fields required to avoid conflicts.

    Here's a test form — https://form.jotform.com/80554285743967

    Feel free to create a clone version of that form to your account so you can test and inspect it — How-to-Clone-an-Existing-Form-from-a-URL

    I hope this helps. If you have other questions, please feel free to let us know.