Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Show last 24 hours

Topic Labels: Views
402 1
Showing results for 
Search instead for 
Did you mean: 

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…)

1 Reply 1

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.