AnsweredAssumed Answered

Autofill time fields

Question asked by grapeboy on Jul 31, 2018
Latest reply on Aug 1, 2018 by keywords

I have three time fields in a table to track event details for our clients- Start Time; Arrival Time and End Time

I would like to have Arrival Time and End Time autofill from Start Time based on a standard 5 hour end after Start time and a 1 hour arrival before Start Time.  However, since there is an option to add additional time to Arrival or End by the client, I would like those values to shift by one hour based on another set of fields for Early Arrival or Additional Hour.  I believe I need to create a script in the field for each autofill time but am having difficulty getting the time to advance by five hours or select one hour earlier.  For the optional hour options, would I need to use If, Then to reset the time options?

Thank You. 

Outcomes