I am trying to make a “Task List” for individual users for the app I am developing for work. Is there a way to add said feature where each task list is saved locally? In other words, each task list will be unique to each user so that they can see what they still need to do, and it will be completely different and independent of other users. It doesn’t have to be fancy, just something that shows date&time, details of the task, and if it has been completed or not. Also needs to be able to move tasks up and down the priority list.
You might also consider private tables, where each user gets their own copy of the data, saved in their own cloud storage. However, this approach is less flexible than security filters, since you cannot change your column structure once it is deployed. https://help.appsheet.com/data/tables/private-tables
For prioritization, you could either use a number column or an enum column.