Conditional calculation in the form when fields are filled

  • sisters7
    Asked on June 6, 2016 at 1: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.

  • Welvin Support Team Lead
    Replied on June 6, 2016 at 4:54 PM

    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.

  • sisters7
    Replied on June 6, 2016 at 5:15 PM

    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.

  • Welvin Support Team Lead
    Replied on June 6, 2016 at 6:35 PM

    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.