Hi @david1,
I made a quick test based on Airtable and I think I may have a solution for you. Using a date field in my table and Airtable filters, if the items are ordered by timestamp in the table, I’m able to retrieve the “next item” after the current time, using the Clock Interface Asset ISO 8601 date property.
I added this parameter to my Airtable Interface Asset:
- filterByFormula: {Timestamp}>“2018-02-15T10:02:00.000Z”
Then you can add a trigger on the Clock, such as Hours changed that will call the set FilterbyFormula action on the airtable. Bind the parameter on the ISO 8601 property, and add an Enclose Text Manipulation converter to add {Timestamp}>" before the date and " after the date.
Please give it a try and tell me if that would answer your need.
Seb