How can I insert a 'date the form was filled out' field that I can do a calculation on?

  • Profile Image
    Gwynnyd
    Asked on March 06, 2017 at 01:41 PM

    I have an event to take registrations for that has an 'early sign up' price, a 'regular' price, and a 'late registration' price.  Is there some way to have the form itself put in the day the reservation was made into a date field and use that to calculate what the correct amount should be for the date the reservation was made?

    I realize I can brute force it by going in on the day the price changes and changing the amount by hand, but it would be excellent if the form could do it automatically.

    Thank you.

  • Profile Image
    Mike_G
    Answered on March 06, 2017 at 03:14 PM

    Yes, that would be possible. Below is a sample form that is based on what I understand you would like to happen with the form you are planning to create.

    https://form.jotform.com/70645913702960

    Note: The date field should be set to "Current" and it should be hidden from the form. I just set the date field in the test form to where you can change the value and not set it as hidden for testing purposes.

    In the form I have the following:

    Fields and widget

    Conditions

    and PayPal payment field set up

    If you look at the conditions above, you will see that I have set a value to be passed to the "Total Amount" (Form Calculation widget) based on the date value that is is in the Date field.

    Then, whatever value there is in the "Total Amount" (Form Calculation widget), it will be the amount that will appear on the PayPal payment field based on how it is set up.

    Please test the form or create a clone version of it to your account so you can inspect it.

    If you have any questions or you need clarifications, please do not hesitate to get back to us and we will be glad to help you.

    Thank you.