Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 03, 2020 09:20 AM
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?
Solved! Go to Solution.
Dec 03, 2020 02:01 PM
If it is record level changes and not field level then why not use the last modified field?
Dec 03, 2020 02:01 PM
If it is record level changes and not field level then why not use the last modified field?
Dec 04, 2020 02:06 AM
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.
Dec 04, 2020 04:46 AM
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: