# conditional logic

• sisters7
Asked 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.

• ashwin_d
Answered 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!

• sisters7
Answered 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.

• sisters7
Answered 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
• Kiran
Answered 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!

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

Thanks for letting me know.

• ashwin_d
Answered 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!

• sisters7
Answered 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."

• seth
Answered 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

All the best!

• sisters7
Answered 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.

• sisters7
Answered 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.

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

Hi,

Thank you for contacting us.

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

• sisters7
Answered 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.

Thanks.

• Kiran
Answered 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!

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

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

• sisters7
Answered 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.

• Kiran
Answered 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!