Automation with time & rows added

Khari Shiver

Hello,

I am trying to figure out a way to send an alert when a new row is added AND have the automation run at a particular time of the day. If I understand the way the automation is configured, you can choose one or the other. Is there a way to say:

If a row new row has been added as of 9am send an alert.

Check again at 4pm to see if any additional rows have been added. If yes, send another alert.

Thanks.

Bassam Khalil

Hi @Khari Shiver

Hope you are fine, yes you can do that as following:

1- add the system column ( Created Date ) to define the date and time of adding the new row.

2- add a helper column called Time and use the following formula to calculate the creation hour :

=IFERROR(MID(Created@row, 11, 3), "")

add the following automation for rows created before 9:00 AM

add the following automation for rows created before 4:00 PM

Khari Shiver

Hello Bassam,

Looking at your before 9am conditions, wouldn't an alert be sent whenever a row was added before 9am rather than the automation checking to see what had been added from 12am -9am and sending an alert?