Check Expired Training
  • 12 Aug 2024
  • 2 Minutes to read
  • Contributors

Check Expired Training


Article summary

Learn how to use Automations to check for expired training for your operators. This can also be extended to equipment, machines, and any number of items to check on your manufacturing floor.

Pre-Reading

Please make sure to read before reading this article:

Scenario

You want to fire a scheduled automation that runs every week on Wednesday and Friday at 9 AM and check a table to see if operator's training has been expired. If it has, the operator should receive an email.

This is a simplified example and you can utilize a Query as part of table API call to only return expired operators. This would remove the need for a decision block. You would only need the returned IDs to get the operator name/email via a Table Record Get call and an email block to the operator.

Video

Walkthrough

The first step is to set up the schedule. Set the frequency to weekly. Set the days to Wednesday and Friday at 9 AM on Eastern Time.
Screenshot 2024-05-09 at 7.30.29 PM

Then, a set up a connector function to Tulip's Table API which returns a list of IDs.
Screenshot 2024-05-09 at 7.30.43 PM

The list of IDs are automatically entered into the loop block, which generates the loop variables. The loop is set and ready to go!
Screenshot 2024-05-09 at 7.30.50 PM

Any action that you take within the loop, which is denoted by the solid line and ending at the dotted line), is repeated for each element of the list.

The "Get Table Record" block retrieves two critical pieces of information:

  1. The date of the completed training
  2. The user's email.
    Screenshot 2024-05-09 at 7.30.57 PM

The decision block compares the current date against the training date plus a year. If the current date is greater than the training date plus a year (meaning training is not expired), nothing happens.
Screenshot 2024-05-09 at 8.02.45 PM

If the current date is less than the training date plus a year (meaning training is not expired), an email is sent to the user.
Screenshot 2024-05-09 at 7.31.11 PM

Further Reading


Was this article helpful?