How can I formula this situation: for example, I need to receive an email if my chef did not prepare or set a plan for todayโs meal.
Hello, well, first you would need a suscription, since this is gonna require to use the โscheduled runโ feature, or some knowledge of google scripts to obtain a similar behaviour.
Youโre gonna need a table for everyday meal plans, and then a bot scheduled to run at the time of your choice, that runs the email task if the following condition is met:
ISBLANK(SELECT(mealPlans[plan],[date]=today()))
Thank, but the scenario is quite different. The bot should be triggered if the user of the app did not prepare a meal plan for today.
And this differs from the solution Rafael described, how?
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |