Using calculation and conditions in the time field to autofill another time field

  • Profile Image
    poolmanagementgroup
    Asked on March 13, 2016 at 09:54 AM

    We are trying to make a party form with a mandatory 2 hour party window.  Is there a way to allow the person to pick the start time of the party and then the end time will auto-populate the end time at 2 hours later?  We currently have the time to calculate total hours based on Start and End time.  Any help is appreciated.

  • Profile Image
    Jan
    Answered on March 13, 2016 at 11:08 AM

    Please give me some time to create a workaround for this inquiry. The time field have limitations in terms of calculation. I'll get back to you once I finish the demo form. Thank you for understanding.

  • Profile Image
    Jan
    Answered on March 13, 2016 at 01:42 PM

    Unfortunately, there is really no option to auto-fill another time field depending on the chosen value on another time field.

    The solution I made was using the condition that calculates the value of the field. I created 2 drop downs (start time hours and minutes) and 1 text box (end time).

    Once you chose a value in the hours, the condition will add 2 on it and then it will copy the value of the minutes.

    Demo form: https://form.jotform.com/60723958514966

    You can clone it if you like. Here is the condition I used:

    Hope that helps. Thank you.

  • Profile Image
    grade4pagasa
    Answered on March 13, 2016 at 01:53 PM

    An alternative workaround was provided by BJoanna in this forum thread. Specially helpful if the current time (+2 hours) will transition or crossover between 2 dates, am-pm, or pm-am.

  • Profile Image
    poolmanagementgroup
    Answered on March 14, 2016 at 07:37 AM

    Thanks!  I'll play with these and see what happens.