Automation with time & rows added

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.
Answers
-
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
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"
-
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?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives