Maintenance equipment status update

Scenario

In the production area, once maintenance is completed, equipment is assigned an OPERATIONAL status. When the maintenance-standing time expires, the equipment loses its OPERATIONAL status. Automation aids this process by conducting hourly checks on the equipment listed in the Equipment & Assets table. It identifies any items that have an OPERATIONAL status and expired maintenance-standing time. If such records are identified, their maintenance status is automatically updated to MAINTENANCE REQUIRED.

Flow of the automation

Configure automation

Pre-requisites

This automation utilizes a Tulip table connector function to pull records from the table that need modification. The connector is installed on the instance simultaneously with the automation. To ensure the connector functions properly, a few settings must be configured:

Set the authentication

1. Create an API token on the instance that has the necessary permissions to read the Tulip tables. If an API token with the required access already exists, this step can be skipped.

2. Enter the API token details in the connector for authentication.
   

If you want to know more about connectors, check out this link: How to Create a Connector.

Set your server address

Along with the authentication of the connector, the server address must also be configured. Under the connector environment settings, paste the instance URL into the server address field for the environment where you want to use the automation.

Modifying the automation

In the automation, you can modify almost everything to fit your process.

To adjust the automation for a different table

If you want to use the automation with a different table, you need to change the table ID in the Get records from the Equipment & Assets table function, which is located under the Connector for Tulip table manipulations connector. Simply update the table ID to the one corresponding to the table from which you wish to retrieve the list.

Once the connector function has been modified, you only need to update the table data in the automation. Under the block configuration, find the appropriate table under the table field.

Changing the Operational Status Duration

The evaluation condition is located in the decision block. The expression is structured so that the value of the Last Maintenance field from the loaded record is added to the maximum allowed operational status duration, which is 30 days in this example.

To adjust the duration:
Update the part of the expression that specifies the allowed maximum operational status duration to your desired value.

The automation then checks whether this calculated value is less than or equal to the current date and time at the moment of evaluation.