Todo list app - forcing users to sequentially complete task eg. do 1st task then 2nd task ......

[jeffchoy]

I am currently creating a Todo app where each day a number of todo tasks are set for staff to complete. I have based the todo task entry and management on the sample Manual Sorting App (where the order of the todo task is important)

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Manual-Sorting-Move-Items-w-Buttons-Bonus-Sequen...

where the PARENT table contains  dates as a record (each day is a separate record) and the CHILD records are the todo task that need to be completed each day.

I would like the staff to have to complete the todo task sequentially or give them the 2 task at a time. So if the todo list for today has 10 child records then they would be allowed to mark only task 1 and task 2 as complete. The remaining 8 task would be locked (they can still view but cannot mark as complete). If task 2 is complete, then task 1 and task 3 would be allowed to be marked as complete, task 4-10 would still be locked. and so on ...

Is anyone able to give me any idea on how I could implement this ?

Thanks

[MultiTech · Accepted solution]

Like everything in AppSheet, there's 4-ways of doing it - but here's one option you might pursue:

• If your main interface view (meaning... the place where your users are doing most of the interacting with the app) is the detail view of your parent record...
• Assuming you've already got the list of [Remaining_ToDo_Items]....
• You could create a secondary vc in the parent table, with the following formula:

TOP([Remaining_ToDo_Items], 2)

• This will take out the first time items of the list, and since the [Remaining_ToDo_Items] is dynamic... as the items slip away, the top 2 will always be the next 2 items in the list. (^_^)

https://support.google.com/appsheet/answer/10107704?hl=en

[jeffchoy]

Thanks