How to dinamically change text in text tool with analytical app?

[Joker_Hazard]

Spoiler

Morning all.

I am trying to dinamically change some inputs in a text tool:

The user will input multiple e-mails, and text tool should add thoses e-mails one after one, without destroying the order of rows, only adding lines of emails after X-UNSENT: 1  and "Subject..."

I tried using text interface tool but it only updates one cell. How can I change multiple cells respecting the structure?

Thanks

[christine_assaad]

Hi @Joker_Hazard 

Can't you have all emails in one cell, separated by a comma, and just allow the end user - via text interface tool to add as many emails as needed? The email tool should accept this format.

If you need every email to be on its own row, you can use text to column but after the user input emails. Cheers!

[Joker_Hazard]

@christine_assaad Hey christine!

I wish I could use e-mail tool. Unfortunatelly I had to find a workaround to create a draft e-mail before sending. Its basically a 4 eyes check. Alteryx does not have any feature to help us with that. 

So, I'm using this solution here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-an-Outlook-Thunderbird-Draft-...

About your workflow, very clever idea! I was just wondering, can you show me how to add a To: before each email in your workflow? I really need that to feed the html in .eml.

Thanks in advance!! 

[christine_assaad · Accepted solution]

Hi @Joker_Hazard 

Sure. See attached

I added a formula tool to prepend "To:" to every single row created after Text to column.

[Joker_Hazard]

Thank you very much!!!!!!

@christine_assaad Would you know if Alteryx Dev team is aware of this enhancement? I've seen lots of people inserting this idea on the forum. 

Thank you once again!

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Why-doesn-t-Alteryx-have-a-draft-email...

[christine_assaad]

Thanks @Joker_Hazard 

I know they monitor ideas closely. They are just trying to prioritize requests based on the # of customers that requested it. If I find more about Draft emails, I'll let you know.

Cheers!