Automated Slack message - Chronological list?

[Alix]

I have an automation which sends a slack message at a scheduled time with a list of tasks due that week, sent in formatted single messages for display purposes.

It's a repeating action which runs through a list found, but it never runs in chronological due date order and I need the list to appear in chronological order. Airtable has on their guide that it can't guarantee the order of the run and you should consider other options. What would these options be? Help would be much appreciated, thank you!

[Alix · Accepted solution]

I actually solved this today by using Zapier. It was a multi-step Zap:

Trigger - At a scheduled time

Action - GET Webhook - the records from a chronological week view on Airtable 

Action - Utility formatter - Line item to Text

(formatted this the way I needed including a record URL field using a concatenate formula) 

new line per item separator

Action - Send to Channel slack message using the “output text” from the formatter