Automation with time & rows added



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.




  • Bassam Khalil
    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

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Khari Shiver
    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?