DateTime colmuns are shifted in AppSheetEvents

AppSheet AppSheet Q&A
1

I run Automation using the spreadsheet extension AppSheetEvents and copy and register data from table A to table B.
The DateTime colmuns of the registered table B is 9 hours minus that of the copy source table A.

This will not happen if you run Automation from the AppSheet screen.

Please tell me the cause.

2

I believe you might be referring to when a DateTime is recorded from the app versus recorded by a server in another TimeZone?

The best, and currently the only way, to remedy this is to use UTC DateTimes and then translate them into the desired TimeZone of the user. This will ensure that all activity is in correct chronological order for that user.

I hope this helps!