Scheduled bot is not working (sequel)

[mmulligan]

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.

[Steve]

Is the bot event's timezone set properly?

[mmulligan]

It is set for GMT-7:00 Pacific Standard Time, which is the correct time for Los Angeles.

[Steve · Accepted solution]

I think you'll have to engage Support for help determining why your scheduled bots aren't running. Nothing you've mentioned throws any red flags for me.

---

@mmulligan wrote:

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.

---

Try TEXT(NOW(), "YYYMMDDHHMMSS").

[mmulligan]

Thank you Steve. I will be contacting support as there does not appear to be anything we can do to solve it ourselves. 

As for your response to the format for the Date and Time, that worked well. It is now saving as the file name with the format I established (I used this instead: "YYYYMMDD_HHMMSS"). 

[mmulligan]

Though I was having issues before with this, I decided to change my Daily schedule to Weekly, selecting M-F instead. That is the only thing I changed, and it appears to have worked. Still not a resolution to the Daily issue, but it is all that I need. If anyone experiences issues with the Daily, I suggest talking to support.

[Appsheet-ID]

I also experienced the same thing, the Webhook BOT that I usually use couldn't function properly, things like this often happen This is very annoying, please pay more attention from the Appsheet team, because this is very detrimental to Appsheet users

[Steve]

---

@Appsheet-ID wrote:

please pay more attention from the Appsheet team

---

The AppSheet team really doesn't pay much attention at all to the community. Your best chance to get their attention is to engage Support.