LinkedIn
Twitter
First time setting up a scheduled event here,
When I test it, the bot works fine
However it is not firing at the scheduled time
Perhaps the UTC server time has something to do with this?
The action being executed is setting all TimeSheet table records (Time) column to TIMENOW() using the formula TIME(UTCNOW()+โ007:00:00โ)
Perhaps this is redundant as i could just stamp 17:00:00 so longโฆ thatโs beside the point i guess, iโm just trying to create a feature that automatically clocks off all employees at business close.
The Gsheet spreadsheet settings are set to GMT+7 (Hanoi) and the TimeSheet table locale within app-sheet is set to Vietnam
Also not sure why we can select the timezone for the event if the server time does not recognize other timezonesโฆ
My device is in Philippines (UTC+8) but from what i understand that should not be affecting anything here
Iโm starting to confuse myself with time-zones here, luckily the business who will use this app is location anchored to UTC+7 and Vietnam does not observe any daylight savings
I understand this is a Core plan feature, should this scheduled event run as i have not deployed the app yet, still testing
