@JWPowder
Well, you've got a couple of things wrong in the formula.
First, if there is an offset based on time zone, then you should be using the TimeZoneOffset function. Also, Value(5) is not necessary...5 is already the Value. You would use Value to convert a Text string to a numeric. Thus, Value("5") would return 5. So again, not needed.
Next, your Notify is referencing a control...not a property. Label8 is a control. You would want to reference the .Text property of the Label - i.e. Label8.Text This kind of thing causes issues at run time.
And finally, you are missing a closing paren in your DateAdd formula.
And as a little extra...it is best not to reference the label, but instead reference what your label derives from. In the context of your formula, my guess is that it references one of the column values of the record you just wrote. So, it should be stated that way in the formula.
With all the above...the formula should be (this version showing your original add to the time):
Patch('StatusBoardData_HILLIARD_Rev2.0',
LookUp(Sort('StatusBoardData_HILLIARD_Rev2.0', Created, Descending), Title = Self.LastSubmit.Title),
{'End Time': DateAdd(Now(),Value(5),Hours)}
);
NewForm(Form4);
Notify("Success, " & Self.LastSubmit.Title & " Status Updated!", NotificationType.Success)
This version showing the time zone offset):
Patch('StatusBoardData_HILLIARD_Rev2.0',
LookUp(Sort('StatusBoardData_HILLIARD_Rev2.0', Created, Descending), Title = Self.LastSubmit.Title),
{'End Time': DateAdd(Now(), TimeZoneOffset(), Minutes)}
);
NewForm(Form4);
Notify("Success, " & Self.LastSubmit.Title & " Status Updated!", NotificationType.Success)
