Update data in start of each day

[shira]

Hello.
Im new in Adalo and find it as a great tool.
but have question I cannot figure out-
I want to update some user’s data in every start of day ,
or to be more clear how can I scedule time to update Data of the database
how can I do this ?

thanks for any reply
Shira

[Victor]

Hi @shira,

Unfortunately Adalo doesn’t have any server-side scheduler / procedure which could be run regularly. For your case, there are a couple of workarounds:

• you can use 3rd party tool like Make: create a scenario which runs based on some schedule and connect it to Adalo. With this you can update data in Adalo collections using Collections API. However you will need to have at least Team plan for that.
• you can update user’s data when a user opens the app. If a user doesn’t open the app - the data will not be updated; but at the time the app is opened by a user you can run some actions to change data as required.

Best regards, Victor.

[shira]

Thank you very much for your reply Victor,
I understand the issue better now,
I tried to solve it by adding an action in the screen action
Can I provide more details so that I can get help for the best solution for my case?
In my app the user has a list of tasks he needs to finish each day and he checks it off once it’s done, but I have to uncheck all the tasks at the start of a new day.

Can you help me find the condition for my case?

Appreciate any answer
Shira

[shira]

Hi Victor and everyone.

I found a solution for my case. I believe this information can help others so I am back to share it with you.

I added a property called Enter_last_time for the user
Then when loading the application I check this situation - if start_of_day is between Enter_last_time and the current time then all the data is updated and Enter_last_time is now updated to the current time.

if not nothig is changed
This is how I actually keep the user’s first login time for each day

Thanks, Shira