Best Practice to get Update_Time when editing a record through a form or through API

AppSheet AppSheet Q&A
1

Do I just set the app formula for the Update_Time column to NOW()?

or do I need to create a bot that updates the Update_Time column whenever the record is updated?

2

Create a column in your table eg. Timestamp, value = now()

Now when it actually prints to googlesheets or your database is another story. But you have exactly when that row was edited for you to audit, thats something you cant forge unless the device that sends it changes their device clock probably

1 Like
3

It depends on what you want.

  • If you want the time the user opened the form, use Initial value with an expression of NOW().
  • If you want the time the user saved the form, create an Event Action for Form Saved that sets the column value from the expression, NOW().
  • If you want the time the row was received by the server–and thus first available to everyone–create a bot that triggers on adds and/or updates that sets the column value from the expression, NOW().
2 Likes
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.