Equipment Status Reset

Scenario

In the production area, once cleaning is completed, the equipment is assigned a CLEAN status. When the clean-standing time expires, the equipment loses its CLEAN status. This automation provides support for this process. It conducts an hourly check on the equipment enlisted in the Equipment & Assets table, identifying any items with a CLEAN status and expired clean-standing time. If such records are identified, their status is automatically updated to DIRTY.

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.

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, then select the status field from the fields list and set the desired status (e.g. DIRTY).

Changing the Clean Status Duration

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

To adjust the duration:
Update the part of the expression that specifies the allowed maximum clean 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.