Recurring maintenance tasks/records

Topic Labels: Base design
1404 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

0 Replies 0