This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I use a timesheet table with a field called TimeStamp set to default to NOW() with a Show of false. This week I noticed that one of the employees looked like he entered his day sheet the day before the day he worked but when I looked through the Version history on the GSheet, it is clear that he entered it on the correct date but the TimeStamp was incorrect. What could cause this behaviour? How reliable is NOW()?
This approach to capture the server time was suggested by @Steve in the thread mentioned below. To capture server time, please use following approach. However please be aware that for this approach, the app needs to be online.
Create an action that sets the timestamp column to NOW()
Call this action in a data change workflow. The workflow update event will be โAdds Onlyโ
There had been a very substantial discussion on a relevant topic sometime ago, please take a look at it.
LinkedIn
Twitter
