I’m capturing date/time record is entered in a field EnteredWhen, using the field’s auto-entry option. That’s working fine. In another field, UpdatedWhen, I’m capturing when record is modified, using a record rule defined with the view on a page. They’re both working, but apparently they’re using ‘current date/time’ calculations in two different time zones!
EXAMPLE: It’s about half past noon here in San Antonio, Texas. I just created a record. EnteredWhen = 1/7/22 12:26PM. A couple of minutes later, I edited the record slightly and saved the edits. The UpdatedWhen field now says 1/7/22 1:29PM — clearly referencing the eastern time zone of the US rather than the Central time zone which is local for us in Texas. What’s up with this and how can I make them consistent?
And one other thing: I can’t capture updated date/time if I allow inline editing, right? That’s according to this page: “This capability only applies to forms, and is currently not available for changes made via inline editing on a table.” That’s too bad as it means I probably won’t be able to allow users to do inline editing, no matter how convenient it may be.