Automation with time & rows added

Options

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.

Tags:

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    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

    bassam.khalil2009@gmail.com

    ☑️ 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 ✭✭✭✭✭
    Options

    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?