I’m looking for guidance on how to best design this in Airtable. I’m building a base to track vehicles and their maintenance records.
Each vehicle needs to have an inspection every X weeks, and ideally this should be a row in an inspection table in order to store the date it was done, any slippage, and upload relevant paperwork.
What would be a good way to design this?
I think I’ll probably need a Zapier or Integromat integration to run regularly to go through each asset and create the inspection rows with due dates of every X weeks. This to me seems a bit messy and presents more questions; how far in the future would you want to create planned inspections for? How often would you run the task? What would happen if a vehicle is added or deleted? Or if inspections need to be re-planned?
Any advice would be appreciated.