What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    conditional logic

    Asked by sisters7 on December 11, 2016 at 06:05 PM

    I selected Entitled III, delegate; and picked Thursday night lodging in a dorm double occupancy for $39.50; and also added three meals, from Thursday project dinner, Friday breakfast and Honor's luncheon. The total is $84.50 for housing and meals. Since MSC pays up to $159.00, I would like to show $84.50 in the field of the amount paid by MSC, not the maximum amount $159.00. The conditional logic I entered did not work.

    Please help. Thanks for your time and effort.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on December 11, 2016 at 10:44 PM

    Hello sisters7,

    I am looking at your conditions but it is taking a bit of time. I will get back to you this soon.

    Thank you!

  • Profile Image

    Answered by sisters7 on December 12, 2016 at 02:40 PM

    Hello,

    I wonder if you have found an answer to my question. Or if anyone else has an answer.

    Thanks for all your help.

  • Profile Image

    Answered by sisters7 on December 12, 2016 at 02:59 PM

    The newest conditional logic I added create strange problems: the total of meals became a blank box, a double occupancy dorm rate got transferred to max $ paid by MSC. The 159.00 I originally input in max $ paid by MSC was gone.

    UPDATE / CALCULATE FIELD
  • Profile Image
    JotForm Support

    Answered by Kiran on December 12, 2016 at 05:00 PM

    Unfortunately, our colleague is offline at the moment. However, your message has been reached by him. You'll be posted once he has some useful information with the conditions issue on your form.

    We appreciate your patience and understanding. Thank you! 

  • Profile Image

    Answered by sisters7 on December 12, 2016 at 05:32 PM

    Thanks for letting me know.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on December 13, 2016 at 05:07 AM

    Hello,

    I did check your form's condition and found that you have added multiple conditions to insert the value in "Max. $ paid by MSC" field.

    Example: If  "Entitled III" is selected, you insert 159.00 in "Max. $ paid by MSC" field.

    Again if "Thursday night lodging in a dorm double occupancy for $39.50" is selected, you calculate "39.5" in the "Total $" which is again populated in "Max. $ paid by MSC" field. This causes the calculation error you see in form. Please check the screenshot below:

     

    I would suggest you to please let us know the calculation formula what you want to achieve in form and we will try to help you.

    We will wait for your response.

     

    Thank you!

  • Profile Image

    Answered by sisters7 on December 13, 2016 at 05:58 AM

    Thank you for your reply. What I want to do is simple, except I couldn't do it. All I want to do is simply add "if total $ is less than max.$ paid by MSC, then insert total $ into the field of max $ paid by MSC."  

     

  • Profile Image
    JotForm Support

    Answered by seth on December 13, 2016 at 07:01 AM

    Hello, I see that there is a condition that inserts 159$ to amount paid by MSC field when Entitled III is selected:

     

    You need to update this condition like:

     

    And also you need to add a new condition to handle the values that are less than 159$:

     

    I think this solves your problem. Here is my clone of your form. You can inspect it freely. Please follow this guide to clone my form:

    My form with new conditions: https://www.jotformpro.com/form/63473363990969

    Guide on cloning from URL: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    I hope this answer helps. Please don't hesitate to contact us for your further queries.

     

    All the best!

  • Profile Image

    Answered by sisters7 on December 13, 2016 at 07:26 AM

    Thanks. However this conditional logic created a new mistake.

    I selected dorm double occupancy for June 1 & 2, housing total $79.00.

    I selected all the 5 meals form Thursday project dinner to Sat. breakfast, meals total $80.00. The total of housing and meals is $159.00 which is the max $ paid by MSC. The balance due should be "0", yet it showed $151.00 as the max $ paid by MSC with a balance due of $8.00.

    Please help again.

  • Profile Image

    Answered by sisters7 on December 13, 2016 at 07:33 AM

    Never mind my last post. I changed my condition from if "all" to if "any". Now it works. Thanks. Thank you to all of you who helped.

  • Profile Image
    JotForm Support

    Answered by Helen on December 13, 2016 at 07:38 AM

    Hi,

    Thank you for contacting us.

    We glad to solve your problem on your own.

    If you have any questions or issue feel free to contact us.

  • Profile Image

    Answered by sisters7 on December 13, 2016 at 11:11 AM

    Seth's suggestions worked for Entitled II, III, IV & V. However this created a problem for Not Entitled.

    For example if 'Not Entitled I' is filled and '2017 Convention Worker' is also filled. the amount paid by MSC should be $10.00 (pre-convention lunch, Thursday only). MSC does not paid lodging or other meals for 2017 convention worker.

    Also, if 'Not Entitled I' is filled, and '2017 Convention Worker' is filled and 'I'm an Honoree' is filled; the amount paid by MSC should only be $25.00 (Pre-convention lunch, Thursday) and Honor's Lunch Friday. MSC does not pay lodging and other meals.

    Right now the all these totals got carried to the field of max $ paid by MSC.

    Please help.

    Thanks.

     

  • Profile Image
    JotForm Support

    Answered by Kiran on December 13, 2016 at 11:44 AM

    I have tried checking the form and the conditions and see that there is no field 2017 Convention worker available in the form. Did you delete the field from the form? Or are you referring to the field "I'm a 2017 hostess worker"?

    Please confirm so that we can check the conditions further.

    We will wait for your response. Thank you! 

  • Profile Image

    Answered by sisters7 on December 13, 2016 at 12:54 PM

    Yes, that was what I meant, "I'm a 2017 hostess worker". Thanks.

  • Profile Image

    Answered by sisters7 on December 13, 2016 at 02:02 PM

    I just realized that I have not entered C. logic for not entitled I. So please hold your answers. Let me get my side done first and if I have more question, I will post. I don't want you to waste your precious time on me. Thanks.

  • Profile Image
    JotForm Support

    Answered by Kiran on December 13, 2016 at 03:17 PM

    Ok. Thank you for letting us know. Please let us know here if you need any further assistance. We will be happy to assist you.

    Thank you!