Good day,
I am renewing may question from a previous post with a similar title. I have two bots with Scheduled events. One has the task of setting row values and the other has the task of creating a file, but they do not run automatically at the scheduled times. They run fine when I run them manually and test them. Nothing shows up on monitoring except what I manually trigger.
I have a Core license. The app is deployed and I have bypass security filter enabled. I have tried scheduled every weekday and chose M-F and I have tried daily schedule. I noticed that the automatic timestamp that gets attached to the file is in UTC (not PST), so I tried changing my scheduled time to the time it would be for UTC but on PST, and I tried using UTC and the correct time for UTC, but neither of those worked. I always set my time a few minutes in advance before saving so that there was enough time for it to be triggered when I tested these other ways of scheduling. I also tried returning to prototype and then redeploying. I also tried disabling and then saving and then enabling the bots again.
@HeathBiller mentioned in my first post that he had a similar issue and that Google tried looking at his bots and could not determine the issue, so they escalated it to a specialist team. As of yesterday, he will test his bots over the next few days. But I am still having no success.
A part of me thinks it has something to do with the fact that the automatic timestamps are saving as UTC and not PST, but all of my app settings are set for PST. To get me files to save under the proper date, I have to disable timestamp and set the File Name Prefix to TEXT(Now()). It isn't the optimal solution as it saves a folder for the month, a subfolder for the day, and then the year and time as the file name.
If anyone can think of something else I can try without having to recreate the app, I am all ears.
LinkedIn
Twitter
