Automation - Scheduled event only works for app owner/admin user

AppSheet AppSheet Q&A
1

Why is my bot (scheduled event) not working for any users other than my app owner/admin email account? The event and process both work, but a new row is created only for my app owner/admin user. The "[Weekday number]=WEEKDAY(TODAY())" is true for some of the other users as well, but no new rows are created for them.

I have tried both to set the scheduled time and wait for the bot to be activated, and to Run the bot. In both cases, the bot only gets activated, i.e. creates a new row, for my app owner user.

My app is deployed.

Pejme_5-1665038391500.png

Testing the bot:

Pejme_7-1665039185571.png
Pejme_7-1665039185571.png909Ɨ484 13.7 KB

Event:
A 12:01 am daily event to be activated when [Weekday number]=WEEKDAY(TODAY()).

Pejme_0-1665037886597.png
Pejme_0-1665037886597.png342Ɨ794 36.2 KB

Pejme_1-1665037902333.png
Pejme_1-1665037902333.png373Ɨ176 6.02 KB

I also tried with the below expression. Same results.

Pejme_6-1665038989887.png
Pejme_6-1665038989887.png374Ɨ104 4.56 KB

Process:
To create a new row in the Pay review table and update two specified columns as per the expression (this works)

Pejme_2-1665038119598.png
Pejme_2-1665038119598.png482Ɨ352 8.61 KB

Pejme_4-1665038303228.png
Pejme_4-1665038303228.png1688Ɨ729 44.7 KB

What am I missing?

2

Are you sure that your table permission allowed other users to add and edit?

1 Like
3

Scheduled bots run as the app owner, so the access allowed to other users plays no role for this bot.

3 Likes
4

@Steve Any idea why it is not working? :thinking:

5

Nope, but Automation is a big mess and Iā€™m not familiar with troubleshooting it. Consider engaging Support.

1 Like