Events schedule

Hi, this is the first time I´m asking for appsheet community help, so sorry if I´m not ussing the correct place to my question or if it is already answered, if so, I haven´t been able to find it.

In my app, I want some columns in a table be updated once a day. I have implemented a bot for this and the event to run this process is a scheduled event type in wich I select the Table whose rows I want to update and a filter to choose some of those rows. I select Schedule Daily, Time 7:00 am and Time Zone Romance Standart Time, because I´m in Spain.

As a consequence of this event a run a process whose Entity is the Table whose rows I want to update and runs a Change data Task that runs a Data: set the values os same columns in this row, so it´s supossed tha the event select the rows to be updated.

As a result, nothing happens. I look in the Bot Monitor and there is no no evidences of activity, events, processes or tasks…

I would appreciate any help.

Thank you

Hello @jemn

The screenshot you gave is only for the event - it doesn’t show the ACTIONS that the bot takes.

You should have some Actions that make the approriate updates you want, and a ref action to collectively group the records you’re talking about together - then enact that data change action on those records.

You’d have tasks to accomplish these things inside the bot.

We’d need to see these things in order to troubleshoot. :+1:

OK, thank you very nuch.

Of course, this is my first time and I did´nt know that only one image is possible.
All the other components are defined. I attach to this mail an image with all them. Nevertheless, independently of the other components, I think the problem is in the event, because there are not data about triggs of it in the bot monitor.

Thank you again. I´m enjoying a lot learning with appsheet but now I´m a little frustated, because I can´t find the solution. I´m stuck and I can´t continue developing my app.

Hi Juan,

Please send an email to support@appsheet.com and allow access to your apps. We will investigate and provide a solution for you.

Thanks,
Dan

1 Like

Hi Juan,

One quick thing to check – did you mark your app as “deployable”?
In order for scheduled event to trigger process, you will first need to “deploy” your app.
So you will need to go to Manage > Deploy tab of the editor, run a deployment check and if all is good, move your app to “deployable” state.

Thanks!

Thank you,

I´m using a free plan and I think that automation features are not supported. I have done what you suggested me and I have received all these errors.

Do you know what plan I need to get automation features?

Thank you very much.

it has to work on the free plan. no need to implant

log in to the editor in anonymous mode then you will be able to open the monitor and see the errors

Hi Marco,

thank you.

What anonymous mode is? How can I log in this mode?
Logged with my account I can see the bot → monitor but it is empty. There is not signs of activity.

I am a bit frustrated with this . It can´t be so difficult¡¡¡

Thank you very much

open a browser window in incognito mode and log in to the appsheet

check if the appshet events add-on is installed in your spreadsheet

Uploading: Screenshot 2021-02-20 at 10.26.30.png…

Hi Marco, thanks again,

In my app, data is in excel spreedsheet in OneDrive 365.

I think this shloudn´t be a limitation…

Bie.

Hi Juan,

You will need to be on the Pro Plan (and above) in order to have scheduled event working.

Thanks!

Hi Dan,

In reference to my issue with Schedule Events, from google support I have received indications pointint that the error can be in the use of different accounts for AppSheet an for Automation. From de AppSheet Community I have received comments pointing that the problem may be I am using a free account, and I must upgrade to pro to get Scheduled Events Work, even if I´m not deploying de App.

I have done tests ensuring that accounts are ok and I have not been able to make things work.

Is the free account a limitation for the use of that functionality?

than you very much.,

Yes Juan, @Zhifeng_Lin is correct, Scheduled event requires a Pro Plan or above.

OK,

thanks for all.

regards