Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Nov 22, 2022 03:25 AM
Hi, I have a roll up field, let’s call it “income”
What I want is to create an automation with these conditions:
I can make an automation “live”, that is: to send an email as soon as “income” exceeds the 10,000€ with the name of the record and all the info I want,
but what I want is to check the situation on that time interval.
When I chose as a trigger: “scheduled time” then in the configuration I have 3 options for fields: “Actual Trigger Time”, “Expected…” and “Next…” And that’s it.
What’ am I missing or doing wrong?
Nov 23, 2022 11:40 AM
You didn’t declare to your automation where to search the data.
From the beginnging of your automation, the only data available is the properties of your schedule.
One solution could be:
1 - Trigger : At a scheduled time
2 - Action : Find records (define the table and the view where to find the data)
3 - Conditionnal action :
3.1 - Condition: If “Income” (field available since the “Find records” action has run) > 1000
3.2 - Action: Send mail
Another could be:
1 - Trigger : At a scheduled time
2.1 - Action : Find records (define the table and declare your income condition)
2.2 - Action: Send mail