Have employees' hours added up

[Roy_Binder]

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

[kuovonne]

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.