Adding Updated By/Date fields to the data, and automatically populating them

Good morning!

My data has the following four columns
CREATE DATE
CREATE BY
UPDATE DATE
UPDATE BY

I’ve been trying to figure out a way that I could get AppSheets to automatically populate them, but I’ve had limited success.

For CREATE DATE and CREATE BY, it looks like the Initial Values being set to TODAY() and USEREMAIL() do the job perfectly, and this has worked in testing. I’m assuming that’s the way I should do that?

Its the UPDATE fields that I’m having an issue with. I want these to change everytime someone changes a record, but I haven’t been able to get that to work, and don’t know what I can do. Any ideas?

Set their respective App formula expressions to produce the values you want. App formula expressions for normal (non-virtual) columns are automatically updated any time the row is updated.

2 Likes

Ahhhh, that seems easy enough, and definitely works. Okay, that’s perfect, thank you!

1 Like