Filter by time | Trigger automation by time

[itsmeayyub]

I have a date & time field.

For example, below is the data. I will have a different date and time and 100 rows with data.

1 Jan 2024 1:00 PM

At 1:00 PM on 1 Jan 2024, I want to send a Slack message using airtable automation.

How can we make this trigger?

My ideas: using formulas and views

[Sho]

Add a formula field and a checkbox field.
The Formula field returns TRUE when the specified date is past the current date and time.
The checkbox field should be checked when a Slack is sent.

Set the trigger to "When record matches condisions" so that it is triggered when the formula field is TRUE and the checkbox is FALSE.

Automation runs about every 5 minutes when the user is active and every hour when the user is inactive, so I think it should be possible to automatically send Slack messages on an hourly basis.