limit times for starttime and endtime input fields

[sandeepraon]

hi, 

any suggestion on how to accomplish below is appreciated.

have two time fields  for the user to set. 1)Starttime 2)Endtime

i would want the endtime field always showing greater time input than starttime and viceversa.

how can i design and formulate the time fields to display / show that coorelation to user  before submitting the form and not allow the form to be submitted when the user tries to enter an invalid entry. im simple terms how can the times be limited in display based on the users input.

[dbaum · Accepted solution]

Check form input validity (Valid_If) - AppSheet Help. For example:

[Checkin Start] < [Checkin End]

In many situations, it can also be useful to provide a helpful initial value to users. For example, for the Checkin End column:

[Checkin Start] + 7

[sandeepraon]

Thank you @dbaum for reminding,