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

[Audit_CKGoC]

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.

[Rafael_ANEIC-PY]

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()))

[Audit_CKGoC]

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.

[Marc_Dillon]

Audit_CKGoC:

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?

help.appsheet.com

ISBLANK()

Is value absent?

help.appsheet.com

SELECT()

Gather column values from row in table or slice