Skip to main content
Cartegraph Campus

Automation Example: Create Work Order From New Preventative Maintenance Tasks

You must have administrator rights to access this feature.

This feature may not be available in every package. Not sure if you have this feature or you want to learn more about it? Send us a message at

In this example, we will combine tasks from a preventative maintenance plan into one work order. Make sure the Plan Name field is in your data structure.

Due to the complicated nature of this automation, Cartegraph recommends creating a test version and running it repeatedly and tweaking it until you are confident it works correctly.

  1. Click iAdministration_sm.png>Automation Manager.
  2. Click Create Automation.
  3. In the Search for Trigger field, select Create or edit records after a task is created.
  4. You can modify this by only triggering certain departments or activity types.
  5. Using an aggregate block, we need to compare the plan name on the work order and the plan on the task. Click the (s).
  6. Use the Condition block to compare the number generated from the aggregate block to see if any work orders exist. If the number of work orders is 0, then create the work order using the Create Record block. Further, to notify staff by email when the work order was created, we will add that in the Condition block as well.
    AutoManConditionBlock SendEmailOpenWorkOrder.png
  7. Use the Loop Records block to access the new or existing work order so we can add that work order number to the task. This uses the same filter as the previous condition block.
    AutoManLoopRecordsBlock NeworExistingWorkOrder.png
    AutoMan GettheWorkOrderforthePlan.png
  8. Within that filter, we need another Loop records block to access the task, so we will use a Set Fields block to add the work order to the task. The Save Record block saves the change.
    AutoManLoopRecordsBlock GettheCreatedTask.png

The automation is tested, saved, activated, and made live. It should look like this:
AutoManExCreateWork OrderFromNewPMTasks.png