Skip to main content

Show last 24 hours

  • December 5, 2021
  • 1 reply
  • 22 views

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

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • December 5, 2021

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.