A ToDo list for each user that resets for daily use

Need help Database
1

Hi there - I have a ToDo list (item + complete/incomplete) and wish to let each user change the complete/incomplete without affecting other users, and have the ability to Reset the list for daily use over again.

What is the best approach? I hope the above makes sense

2

Hey @grapper2020 :wave:

You can use a backend workflow that runs every midnight and does the following based on your design:

  • Copy new todo items of your choosing that are assigned to a user.
  • Reset the status of the items of your choosing.
  • Archieve the todo items (so you still have access to the ones not completed that day) and reset the existing ones.

Maybe reveal your design a little bit, so we can give more concrete suggestions.

But at the end of the day, you have to use backend workflows scheduled for a specific time daily. You can check more about them here:

bdk_512x512 @Huseyin from Flusk | Discover the #1 Security and Monitoring Tool for Bubble

3

Another option, if you want to save on WU, is to run the WF on a list only when user login and last update date was yesterday (you store this info with current user). However, if the list is large, it’s better to stay with @flusk setting