Automation has a trigger to scheduled time & Action for find records for future

[dilipborad]

Automation with set a trigger on a specific scheduled time is awesome and most of us are waiting for it. It’s still in Alpha but now we can sure that it’s will be fully-added in the near future.

Another thing is Action with search records it’s an awesome feature to have while playing with automation and Scripts. This is also in Alpha.

Thanks.

[Bill_French]

dilipborad:

trigger on a specific scheduled time is awesome

Indeed, but with such low quota ceilings, users are unlikely to take advantage of all these new automations because they cannot tolerate them working for some unknown number of days in a month.

The very nature of automation requires us to entrust the system to do our bidding consistently and in a reliable and sustained fashion. If there is any risk of failure, these features might as well not exist for a large and growing slice of users who take their processing seriously.

[Tim_Sullivan]

You don’t have to wait for Airtable to create a scheduled trigger, you can do it yourself. I use a filter that watches for a specific weekday, among other things - when my records hit the filter view, the automation runs.

[Ludo_Paire]

Thank you Tim. I was thinking about something like this, but you wrote it for me and it works perfectly :ok_hand:

[Ludo_Paire]

Maybe it can be useful for others. Here is mine :

1. Create a formula field named “Need update”

2. Create a filtered view. The filter is “Need update” = yes

3. The field “Need update” will show “yes”, if the update is needed. In my case, I want to update on monday, wed. and friday.
   => write a formula like this :
   IF(OR(WEEKDAY(TODAY())=1,WEEKDAY(TODAY())=3,WEEKDAY(TODAY())=5),“yes”,BLANK())

so the “yes” is shown on those days and is not on tuesday, thursday… and it changes everyday. So it can enter, get out, then enter again in the view, in order to launch the automation.

Enjoy