Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Maintenance Schedule for equipment

Topic Labels: Formulas
1731 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello Everyone, I’m looking to get some fresh thoughts on this project I’m working on. I have a working base, but I feel like it will be too bulking as the tables grow.
The goal is to create a notification message or message string in a record when a piece of equipment reaches a certain mileage or hours. Think of a car manual. In the maintenance section is a schedule of suggested repairs to be made once the car gets to a certain mileage. ie…at 30,000 - replace cabin air filter, replaced engine air filter. at 60,000mi replace the fuel filter, check belts,…

I have a base with 3 tables - Equipment, PM Record, Repair History

06%20PM

I’ve linked all 3 together using Equipment as the main working table. PM Records is used to capture mileage and hours at the time of maintenance. I then use two rollup fields on the Equipment table to display the Max() Miles and Hours record. I also have columns on the Equipment table per repair that display a repair message based on the rollup field.

Screen Shot 2019-06-05 at 8.17.29 PM.png

Then use another column to concatenate the messages together into one string. Finally I use the Repair History table to record the repairs and “turn off” the repair message.

In the specific repair columns I’ve used an IF statement to display or not display the repair message.
IF(SEARCH(“2222”,{REPAIR HISTORY})>=“1”,"",IF(OR(AND({CURRENT HOURS}>5000,{CURRENT HOURS}<5999), AND({CURRENT HOURS}>10000,{CURRENT HOURS}<10999)), “REPLACE DRIVE BELTS”,""))

Thanks

2 Replies 2

Hi Dan, am not so skilled user as You are. Am looking for some system for maintenance management of agricultural machines. Would You be so nice and share Your experiences with Your system please? Are You still using it? Kindly, pavel (Vokral6@gmail.com)

Hi Pavel, sorry for the delay. I’m quite happy with my setup in Airtable and use it everyday. I’ve been using the Pro version for awhile now. Do you have any specific questions about Airtable? My base is kinda like a CRM, but focuses more the customer’s equipment and repairs history.