Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Keeping track of updates

Topic Labels: Base design
Solved
Jump to Solution
2003 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Poyan_Katebi
4 - Data Explorer
4 - Data Explorer

I have a table with 290 records and 10 fields that need to be updated yearly and I am struggling knowing if a record has been updated or not. Essentially I need help creating a system to track if records have been updated and if they need to be.

My table consists of fields that either update all the records at once yearly, or get updates spontaneously throughout the year (sort of like a company yearly earnings). You know it is coming but they don’t release them all at the same time.

Any suggestions of what it could look like? or how to think about this?

1 Solution

Accepted Solutions
Jon_Stephenson2
4 - Data Explorer
4 - Data Explorer

If it is record level changes and not field level then why not use the last modified field?

See Solution in Thread

3 Replies 3
Jon_Stephenson2
4 - Data Explorer
4 - Data Explorer

If it is record level changes and not field level then why not use the last modified field?

Thanks for the suggestion! Sometimes, I have the tendency to overcomplicate things in airtable. I have now created a new view with all the last modified dates for each field and can easily filter when it has been too long since a record was updated.

Michaela_Staff1
6 - Interface Innovator
6 - Interface Innovator

Hey there :wave:

I see you already got an answer. I’m gonna chime in anyway, though. Not a long time ago, I needed to do something similar and since I also tend to overcomplicate things, I solved the situation with an Integromat scenario. I’m gonna leave the link to Integromat-Airtable documentation here just in case it ever is helpful to anyone :slightly_smiling_face: