My data has the following four columns
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?