Changing the values on an input table after a given date

  • Profile Image
    dist1070foundation
    Asked on November 18, 2018 at 03:04 PM

    Hi. I am working on a registration form and after a given registration date i.e. 31Mar2019 I need to increase the delegate cost by £4 to £38.


    Is it possible to change the option values using logic. from:-

    34,10,23,35

    to

    38,10,23,35

    ?

    Thanks

    Irvin Metcalf

  • Profile Image
    Mike_G
    Answered on November 18, 2018 at 06:26 PM

    What you are trying to accomplish is possible with the help of conditions.

    I have checked how your form is set up and I understand that you are inserting the calculation value of the Delegate column of the Event Selection into the "DelReg" form calculation widget to get an average.

    To get a different value based on the current date, you first need to add a Date Field in your form and set its "Default Date" to "Current".

    1542577302t16_39_01.png

    Also, please set the calculation value to 34,10,23,35 as the base value.

    1542582956t18_15_22.png

    After that, add a Form Calculation widget to get the Sub-total (base) for the delegates selected.

    1542581350t17_46_54.png

    You also need to include 2 additional Number fields in your form.

    1542581641t17_53_17.png

    The value of the (1) Sub-total(after a specific date) Number field is based on the value in the Sub-total (base) and you will create these 3 conditions in your form.

    If Sub-total (base) value is equal to 34, add 4 to it and put the total in the Sub-total(after a specific date) Number field.

    If Sub-total (base) value is equal to 68, add 8 to it and put the total in the Sub-total(after a specific date) Number field.

    If Sub-total (base) value is equal to 102add a 12 to it and put the total in the Sub-total(after a specific date) Number field.

    1542582050t17_59_01.png

    1542582197t18_02_22.png

    As for the value of the (2) Total field, it is based on the value of the Date Field that is set to have the current date. You will add the following conditions to your form.

    1542583105t18_14_57.png

    Once you've done all that, use the new Total field in the DelReg Form Calculation widget in your form.

    1542583407t18_21_41.png

    And, hide the unnecessary fields in your form. How-to-Hide-Form-Fields

    Here's a clone version of your form where I have applied the changes above — https://form.jotform.com/83215822167961