JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Conditional calculation in the form when fields are filledAsked by sisters7 on June 06, 2016 at 01:51 PM
Mike just answered the following question:
If “entitled I” (Section 2) is selected, then the
Total=Thursday housing + Friday housing + Thursday dinner + Friday BF + Friday lunch + Friday dinner + Saturday BF
Should appear in “Amount Paid by MSC” (Section 5. Payment).
Thank you for your help.
Please answer the additional related question:
MSC only pays "Entitled I" housing and meals from Thursday to Saturday. What if "Entitiled I" arrives early and stays overnight on Wednesday, the calculation needs to show that MSC does not pay Wednesday housing/Thursday lunch. She has to pay the amount that she is not entitled.
Hope you understand my question. Thanks.
Can you clarify this, please? Please mention field by field. But are you asking not to calculate any price or amount when "Entitled I" and "Pre-convention Housing Wednesday, May 31" fields are filled?
I look forward to your reply.
I think I know what to do:
If 19 "EntitledI" is filled, copy multiple field values, add field: 26 Thursday housing, 27 Friday housing, 30 propject dinner, 31 Friday Bf, 32 Friday lunch, 33 Firday lunch, 34 Saturday BF.
Summary, select a field for final output: 39 amount paid by MSC.
Please let me know if not correct.
I did that calculation in the cloned version of your form, check it here: https://form.jotform.com/61576827792976. The calculation is correct, but I can't say if this will work as soon as you add the other calculation. Well, you can always contact us if you need any help with the calculation.