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.

2 Likes

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