The best you can get is the time the AppSheet server received the new or updated row. The time recorded by the AppSheet server cannot be manipulated by the user and is not subject to the user’s device’s time. But, the server-provided time reflects the current server time when the data was received by the server, not the time when the data was actually added or updated by the user on their device. There will always be at least a small delay between the user input and the server timestamp because the user’s change must sync to the server. If the user is offline and doesn’t sync for three days (for example), the server-provided time will be three days after the actual change.
To capture the server time, create a workflow on the table that triggers on adds and/or updates and sets a column in the added or updated row to either NOW() or UTCNOW() (depending on your comfort level dealing with time zones).
LinkedIn
Twitter
