*This tip will let you trigger a workflow without having to double back and clear the trigger column.
Let’s create an action to trigger a workflow that sends an email.
- First, every table I create has a hidden trigger column, type text.
- Second, let’s create a simple data change action for the table that we want to trigger on with the following expression:
CONCATENATE("UNIQUE_KEY_WORDS", " - ", NOW())
- The key word can be anything you want, but you’ll want it to be unique and descriptive to what you’re trying to accomplish. So if I’m sending a project summary email, I might make it
- Third, in our workflow condition expression use the following:
This ensures that we can use our trigger column for many different types of triggers, and that we can also trigger the same workflow over and over without needing to double back and clear the trigger.