My Problem is obviously with Daylight Savings Time which ends in the US at 11/01/2020 2:00 am (reverts to 1:00am) For any date/time that I set for after 11/1/2020 2am, GCalendar subtracts an hour.
Example:
I create an event item for 10/31/2020 at 2:30am; It properly adds/syncs to GCalendar as 10/31//2020 @ 2:30am
If I edit the above (or create a new event) for 11/01/2020 at 2:30am ; it syncs to GCalendar as 11/01/2020 @ 1:30am.
Thoughts?
Bump. Iโm still stuck with this.
My Event table has separate [Time] and [Date] fields, which automatically creates a separate [DateTime] Field by formula.
A trigger ADDS A NEW ROW to the Google Calendar Table using the calculated [Date Time] as [Start]
Google [End] field is [Date Time] + [Duration]
The AppSheet Logs show the correct [Start] and [End] data being added
โ11/20/2020 11:00:00โ,
โ11/20/2020 12:00:00โ,
But on Google Calendar it subtracts 1 hour (11/2020 10:00:00)
Again it does not do this IF the date/time is before 11/1/2020 2:00a.m.
Any Ideas?
Please contact support@appsheet.com for help with this.
@BMAP
Did you ever found a solution or got an answer from supprt?
I found one workaround from @Suvrutt_Gurjar
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Timezone-bug/m-p/363805/highlight/true#M133013
@Fabian_Weller The @BMAP account was mine under a different GApp login that I no longer have. I seem to recall a PM from an admin indicating there was a bug, but I had already come to some resolution.
My recollection is a bit fuzzy, except to note that I no longer use Appsheet's built in Calendar database. I created a separate calendar table and use external App Scripts to create/modify/delete Google Calendar entries via API.
Sorry I don't have more info.
User | Count |
---|---|
60 | |
25 | |
13 | |
12 | |
6 |