AppSheet - Scheduling based on frequency

[Millie]

Hello,

I am just learning Appsheet and am creating a Chore app. I have 3 Tables: Chore, People, and Chore Assignment. I want the “Add” which adds a new row to the Chore Assignment table to only work filtered by frequency. I have 3 frequencies: Daily, Weekly and by appointment. How can I make it check the virtual column “Related Chore Assignments” to see if a specific chore has already been added for the week or month depending on the frequency?

[TeeSee1]

Schedule three bots with an appropriate interval. and use the following to setting to filter corresponding rows. (use the condition setting further fine tune execution conditions)