This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi - I'm trying to send alert emails from my workflow only when certain conditions are met. The conditions are simple: there needs to be at least one record in that lane of data. Please see my workflow below. Basically, after each of the two Unique tools, I only want to construct and send the downstream emails if the count of records coming out of each of those Uniques is 1 or greater. Any thoughts? I've tried summing by grouping on all fields, then doing a count distinct, then applying a filter before the container that is CountDistinct_Field >= 1. When I attached that to the Basic Table part of my email, it worked, but the photo and the Intro text both still showed and the email was sent. Any insights appreciated. Thanks!
Two lanes of my workflow. I want the emails within the containers to only be sent if the lane contains 1 or more records.
@BradFolger How about using a Count Records then Test tool after your Unique tool?
With this setting, your workflow will error (and therefore stop) on this condition. I use this without a Block Until Done tool and don't have any issues but you might need one to make sure the test happens before the email is generated.
@ivoller, thanks for your initial guidance. Below is what I wound up doing, for anyone with the same question. Basically, I added a count distinct of the rows, then appended it back to the result set, then used a formula just before the email tool to check for "count >= 1". Works well, thank you everyone for your input.