Don’t you hate it when you can do something on paper easily, but are struggling to make it work digitally!?! Wondering if someone can point me in the right direction.
I want to create a new Service Record (let’s call that record B), based on the mileage of a previous Service Record (let’s call that record A).
We’re using Airtable for to manage a small fleet of vehicles and trailers. We have tables for vehicles, mileage records, defect reporting, etc. That’s all fine.
We want to record at what mileage vehicle servicing is carried out, and create new servicing records based on previous mileage. From there we use the calendar view to schedule services on vehicles (so we know when trucks will be off the road, etc).
Servicing is slightly complex.
- There are two kinds of services. Let’s call them Service A (or a small service) and Service B (a big service).
- Different vehicles have different service schedules depending on manufacturer guidelines. Eg, one vehicle has a Service A every 7,500km and a Service B every 15,000km. (So that is an A, B, A, B, A, B schedule), another vehicle as a Service A every 7,000km and a Service B every 35,000km (so that’s an A, A, A, A, B schedule). We have a stand-alone table for the schedules linked to individual vehicle records.
- There some tolerances in scheduling (eg, up to 10% overdue is ok), so next service is always calculated as within X kms from previous service.
Example: We want to record that Truck 3 had Service A done at 150,382km. AND THEN spit out a new record that says the next service will be Service B and that will be due by 157,382km. (We then compare the current mileage with the due mileage… aka that service is flagged when the truck is within 1,000km of it’s next service).
I’m having trouble thinking through how to get Airtable to recognise which service is next. Eg, if a truck is on an A, A, A, A, B schedule… and we’re up to the 4th A… that the next is a B schedule.
Do you have some ideas or a similar base that I could take some inspiration from?