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.
I am a fan of automated processes. Repeated processes should definitely be automated. Even though I don't want to have to push the button(s) to make it go, I do need the process to give me feedback. And since it's not going to ask me to coffee, I'll take email. I find relief in scanning my inbox and seeing that the world is okay. And when the world isn't? I would rather know before my customers, and my boss.
I've talked before about the event properties in Alteryx and leveraging them for process feedback. We're taking it a step further. We have a working prototype of a configurable email tool for Alteryx. I'm very excited to escort it to it's coming out party today!
The tool takes seven inputs configured via XML. The SMTP Server is a static value and if not defined, Alteryx will attempt to auto-detect it. The other inputs can be defined in the XML or dynamically with values upstream. "To" and "From" are required, optionally "cc", "bcc", "subject", the body and the path of any attachments can be added.
To demonstrate the tool, I wrote a module that'll send employees the following email on their birthday:
Pretty nice, right? The salutation is dynamic; the rest of the email is static.
I started with a text input with fname, lname, email and bday. For simplicity I wrote the birthday as mmdd. I have a formula tool defining today as mmdd (formatting the DateTimeToday function as a string %m%d). Next I filter on today, flow into a text tool defined as:
Today is your birthday! Feel free to take the day off, have an expensive lunch
and bill it to the company.
We love you,
ToIsField is true because I am using the field value for email from the data stream; it is not statically defined in the XML. FromIsField is false for the same reason, I am defining it within the XML. I could CC the employee's manager if my source supported that.
If there are two people with the same birthday? Two separate personalized emails are sent, one to each birthday person. This is a double-edged sword. I cannot recommend setting up the email tool unless you are confident you know what your output looks likes. One email is sent for each record. Read that again, one email per record.
A summarize tool ahead of the email will take care of that. Or create a macro that writes the output to a file and drop the macro in a module that will email the previously created output. There are multiple solutions available to control the business process.
The tool is still in early beta. Let us know if you'd like to be kept up to date about its street date.