Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Additions to Email Output

hoye
7 - Meteor

Hello All, 

 

I am running a workflow and would like these key details below displayed in the email, when it runs each month. Is there a way to do this? 

 

Key Details:

Workflow name-

Output Location-

Input Location-

Date and Time of Run-

Runtime-

 

I am sure some of these, I could manually input each time, but I would love to have these key detail display dynamically every time the report is ran.

 

Thank you so much to whoever is willing to help!

 

Thank you,

 

e

4 REPLIES 4
Rags1982
10 - Fireball

You can add these into a formula tool to get what you want:

 

Workflow name : [Engine.WorkflowFileName]

Output location: may have to manually type this unless it's a field in your workflow

Input location: This can be pulled as a field from your input tool, checkbox in tool. 

Date/Time: DateTimeNow() in formula tool

Runtime: Not really possible unless you output the workflow log, then rerun the workflow, bring that field in and run again. 

hoye
7 - Meteor

Thank you so much for the help! I do have a follow-up, some of the formulas you are talking about, how do I get them to run inside the "Report Text" Tool. or am I going about this is the wrong way? 

 

 

follow up.jpg

 

I appreciate your help,

 

e

Rags1982
10 - Fireball

No problem. 

 

You can't create the fields in the Report tool. You'll need to create them in a formula tool before. You can then use these fields in the Report tool. Simply click on the 'Available fields' drop down box, just above where you type your text. 

 

Also, you can use HTML in this box to make your writing look better. (Colours, bolds, italics etc), just click the 'Expert mode'. There are html editors online that can help you build your text. I use this one: Free Online Instant HTML Editor (html-online.com)

hoye
7 - Meteor

Thank you so much for your response, could you show an example of how you would set up the workflow name, input location, and runtime. I am stuck on those three and I just can't get the right configuration with the tools. If this is too big of an ask, no worries at all!

 

hope you have a great day,

 

e

Labels