Recurring maintenance tasks/records

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.

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.