Trouble creating Last Modified column using ChangeTimestamp (CSV Upload / UTC Conversion)

Hi Community,

Iโ€™m having trouble using the ChangeTimestamp feature in conjunction with CSV uploads.

When uploading or updating a row with import data (csv upload). The datetime is formatted in UTC but as you can see in the USERTZOFFSET() column, records the time zone of the user. Then if a datetime is edited in the Appsheet interface by a user, it tracks the local time of the user with the same USERTZOFFSET() time zone as the user.

The issue is the incompatibility of the two and lack of ability, Iโ€™ve found, to convert everything to the same TZ.

Would greatly appreciate any help on this or a work around! Thank you in advance.

0 1 115
1 REPLY 1

Happy to provide more info too if its helpful

Top Labels in this Space