Help how to use UTCNOW() and USERTZOFFSET()

[Silber]

Hi

i'm new in developing appsheets, i needed a way to make the timestamp un-manipulatable, some user change the devices time and date to change the timestamp of the entry. i wanted to use UTCNOW() and USERTZOFFSET() but dont know how to use it.

[Noah_Beach]

Use now() instead in an initial value column of whatever row your storing timestamps.

[dbaum]

Both the UTCNOW() and the USERTZOFFSET() functions reference the user device's time zone setting. See lots of discussion elsewhere about this challenge (e.g., Re: Prevent timestamp manipulation? - Google Cloud Community). I don't know that there's a reliable solution other than contriving a way to capture a timestamp processed in the context of the AppSheet server , which would be at the time of data sync, rather than the context of the user's device.