Automation to determine whether a form has been completed today

AppSheet AppSheet Q&A
1

Hi community, I’ve been asked to create a notification via email when a form is not filled in for the day.

I want to check that if at 5pm, the [Date] column value <> Today() , then fire off an email.

But the column values are not present in the condition section (This formula is not evaluated in the context of a row, so column values are not available.)

How would I go about this?

2

If today entry is not there ( form is not filled)

Last value filled would be less than today

use MAX([Date])<TODAY ()

to trigger your email automation

1 Like
3

Thank you for your answer. I would have thought this could work but in the condition section of the Event section in automation it says that column values are not present as the formula is not evaluated in context of a row.

So it is unable to find the column [Date].

So I get an error Unable to find column 'Date".

I wonder how do I get appsheet to determine whether the row was created today or not if it does not look at the values in the column? Or is this not possible?

4

Enabling “ForEachRowInTable”

will take column values.

5

Thanks again. When I enter it it works in the expression assistant but when I save it gives me this error

The event and process of the ‘Send an email daily’ Bot are not compatible. The output of event ‘Scheduled: Every day’ and the input of the process ‘Handle Daily event’ must be the same table or ‘None’ in the case of a scheduled event that is not ‘For Each Row’. No “Call Process for each row” step is allowed in the process if ‘For Each Row’ is enabled.

6

This problem was eventually solved here

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Event-is-not-compatible-with-process/m-p/294086

1 Like