Prevent user from entering incorrect End Time

  • woolebull
    Asked on August 2, 2019 at 10:43 AM

    Hi,


    Is there a way to create an error in the form if someone enters a end time that is before a start time? 

    Esentially I have people submitting requests and forgetting to make sure that the end time is after the start time. 

    For example- Start time is 1:00pm but then for end time they put 2:00 am which messes up my automation to my google calendar.

  • John Support Team Lead
    Replied on August 2, 2019 at 11:49 AM

    I can see that you already used a Form Calculation widget to identify the difference between the 2 time fields, which I am about to suggest too:

    1564760513dcw Screenshot 10

    However, I think that the formula should be the other way, "End Time - Start Time". Then create a condition to show the "Cannot Submit" text when the value is a negative number, which means that the End time was set to "A.M". While if it's set to "P.M", it will return a non-negative number.

    Here's the condition I came up with:

    1564760949conditionss Screenshot 21

    Here's a quick demo:

    1564761317start time end time Screenshot 32

    Please try this workaround and let us know how it goes.