how to make each row "REQUIRE?" in appsheet

[mohsenshahbaghi]

Hi Appsheet community,

Thanks for reading this question.

I have a checklist which I made a calendar to generate tasks every week. Users go to the checklist to check a task in which the font color is changed from black to green. However, they sometimes forget to check all the tasks and hit the sync before ticking all of them. I even made tasks to be fade away after clicking instead of conditional formatting but still, users leave some tasks unticked accidentally.

The reason I am asking this question is I can not allocate a column for each task and make it "REQUIRE?". Each workstation has different tasks from each other and different frequencies on each workstation and also so many tasks to be ticked (+1000 tasks a day).

I am looking for writing a function or app script to prevent users from syncing/saving and walking away before completing all the tasks.

For example, as soon as a user logs in and chooses a workstation and goes to a checklist, and ticks the first task, the system doesn't let the user save until all tasks get ticked off.  Users should be able to discard the ticked tasks in between to make minimum flexibility as well.

Your help in this regard is greatly apprecieated