Report Text Tool - Adding unwanted http://

[ImMoinak94]

Hi Community Members,

I understand that the internal configuration of the tool commands it to automatically add http:// to any script or web links or email address it comes across when it’s hyperlinked. For example – If it’s a mailto link which is typically used for email address, it will add http://mailto:alteryxuser@outlook.com which renders it useless. When I click, it opens chrome and not my email client so generally I don't hyperlink it and use as a general text. Now, I have a very long script with a mailto which I want to be present in the email body and it has to be hyperlinked. How can I bypass the unwanted http://?

Alteryx version - 2019.4

[giulianosua1]

Hi @TheOC! is there a way for when you click on the link it would open up an email and a subject line?

Client Name	Product	Sales Person	Email
Johnson	Shoes	Alan, Jackson	alan.jackson@email.com

So what I would like is that when I click on Sales Person, it would open an email using the last column, and the subject of the email would be: 

"Johnson - Shoes"

Thanks in advance for your help!

Giuliano

[TheOC]

Hi @giulianosua1 !

Yes ofcourse, here's some documentation on mailto links, which may help:
https://css-tricks.com/snippets/html/mailto-links/

I managed to get this working, with the original workflow as an example through adding ?Subject= to the link, and passing in a subject field:

Hope this helps!

[ImMoinak94 · Accepted solution]

@giulianosua1 

I have implemented the same using the method suggested by @TheOC to structure my mailto link. Since my requirement included the To, CC, Subject line, and body. I have first structured my link using a formula tool and then used the Report Text tool in Expert Mode.

In the formula tool -  you can create a column named "Link", and type in the following

"mailto:"+[Email]+"?cc=moinakpersonal@gmail.com&subject="+[Client Name]+" - "+[Product]+"&body= This is my body of the email"

You can discard portions of the link based on your requirement. If you want to dynamically change the hyperlink name, you can change it based on a condition in your formula tool. Let's name that column as "Link Name"

And then use a report text tool in PCXML format something like this

<div style="width: 100%; font-family: Arial; font-size: 10.00pt; "><a href="[Link:A]"> [Link Name:A] </a></div>

It should work as expected.