I am developing a preventive maintenance program for our facility management department.
I have already designed the database with the respective tables for locations, equipment, inventory, schedules, etc.
The final step is to generate work order records based on information found in the main tables.
I’m struggling with how to generate the work order records within the Knack system.
I’ve looked at the workflow feature, but can’t really see any way to accomplish this.
The pseudo code would be something like this…
“Generate work orders for all equipment where the Last_Maintenance_Date is older than 6 months”
Thanks Dean. I will research Record Rules within the Form Rules feature. I’m also going to look at the Action Links feature. The Knack docs suggest both features can be used to generate new records. Hopefully within a separate table.
Manually create Work Orders for all assets with the last maintenance greater than 6 months.
When you complete each of these Work Orders you use a Record Rule to create a new Work Order with a maintenance due date based on the scheduled maintenance cycle for the equipment.
Here’s an example of what we do for our recurring cleaning jobs.
Dean
Prior to reading your response, I started think that I would likely have to manually create the first batch of work orders due to the fact that there doesn’t appear to be any feature to loop through records.
So, your reply has confirmed this assumption.
This is very helpful to see an example of a Record Rule. Thanks!