Calculation amount does not change when someone deletes a guest.

  • snit99
    Asked on October 17, 2019 at 6:56 PM

    On my form when someone fills it out - their name and then adds a guest, the total is correct.

    But if someone changes their mind and decides not to bring that guest, the total dollar amount does not change back to the amount for one person.

    The amount for one person is 36.50

    The amount for two people is 73.00

    When you delete the guest, the amount stays at 73.00


    What do I need to do to the form to change the amount when someone changes their mind?


    Jotform Thread 2005536 Screenshot
  • David JotForm Support Manager
    Replied on October 17, 2019 at 9:09 PM

    I have cloned your form, and the conditions are conflicting with each other. You would need to re-calibrate the condition logic to evaluate the state of the other fields, example:

    If Name is filled,

    And If Guest 1 Name is filled

    And If Guest 2 Name is empty

    And If Guest 3 Name is empty

    Then insert (35*2)+ (1.5*2) into Fall Social Amount

    This is how it would look in the builder:

    1571359973conditionexample Screenshot 10

    1571359987conditionexample 001 Screenshot 21

    If you allow me to suggest another method, please try:

    1) Adding a Spinner field to ask how many guest the user wants to add:

    94773 spinner Screenshot 32

    And set a limit on it:

    1571360705limit Screenshot 43

    2) Create 3 conditions to show them based on the number of guests: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    94775 3conditions Screenshot 54

    3) Add this calculation in your Form Calculation widget:

    36.5 + Additional Guests * 36.5

    1571360670calculation Screenshot 65

    Result: https://form.jotform.com/92898376001969

    1571360820result Screenshot 76

    You may clone my version if you want to: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Let us know if you have more questions, we will be glad to assist you.

  • snit99
    Replied on October 18, 2019 at 6:03 PM

    THANK YOU!  Love the spinner and your conditions are so much simpler.

    THANK YOU! THANK YOU!  THANK YOU!