Show last 24 hours

Hi folks
I’m new in Airtable, how can I show last 24 handled records, suppose I have a “completed” status, so how can I view the only last 24 hours where a record became “completed” from another status (such as pending or in progress…)

Welcome to the Airtable community!

You can have a “last modified time” field that watches only the {status} field. Then create a filtered view that shows records where that last modified time is within the last day.


This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.