#SOLVED - See final post below in the Replies...

#SOLVED - See final post below in the Replies

Any suggestions on the challenge below? I am sending a confirmation Email to a Visitor through Workflow and I include a URL link that I have built with CONCATENATE to display a QRCode when clicked on the URL link. I however want to display the QRCode in the Email directly. Surely there must be some HTML Tag to add to my CONCATENATE statement to achieve this - let the URL resolve (as can be seen in this post in Goolge+) in the email by displaying the QRCode and not the URL Link?

CODE IN THE โ€œEMBED IN EMAIL BODYโ€ as follow:

Hi <<SELECT(Visitor[VisitorFullName], [VisitorID] = [_THISROW].[VisitorID])>>

Thank you for purchasing a

<<[PermitIndicator]>> Permit at <<[PermitCreatedBy]>> on <<[PermitDateCreated]>>

Present this QR Code below at the Start Office to validate your <<[PermitIndicator]>> Permit

<<CONCATENATE(โ€œhttp://chart.apis.google.com/chart?cht=qr&chs=150x150&chl=โ€ & โ€œTRAILPARKSNUMBER:โ€ & [VisitorID].[VisitorTPSANumber] & โ€œDATEOFPERMIT:โ€ & [PermitDate])>>

Hope you enjoyed the trails at <<[PermitCreatedBy]>>

Hope to see you soon

Regards Trail Parks SA

DISPLAY IN THE EMAIL is as follow:

Hi John Doe

Thank you for purchasing a Day Permit at Buffelsdrift on 11/2/2018

Present this QR Code below at the Start Office to validate your Day Permit

http://chart.apis.google.com/chart?cht=qr&chs=150x150&chl=TRAILPARKSNUMBER:197211127767603DATEOFPERM...

Hope you enjoyed the trails at Buffelsdrift

Hope to see you soon

Regards Trail Parks SA

0 14 388
14 REPLIES 14

How aboutโ€ฆ

TEXT

@Aleksi_Alkio thank you for the input. I tried this code below and it just gives me a clickable link as an does in HTML. My request was that I want the QRCode displayed in the email directly like the Google...

<<CONCATENATE("<a href=" & โ€œhttp://chart.apis.google.com/chart?cht=qr&chs=150x150&chl=โ€ & โ€œTRAILPARKSNUMBER:โ€ & [VisitorID].[VisitorTPSANumber] & โ€œDATEOFPERMIT:โ€ & [PermitDate] & โ€œ/a>โ€)>>

SOLVED!!

This worked and displays the QR Code in the Email

<<CONCATENATE("<img src=" & โ€œhttp://chart.apis.google.com/chart?cht=qr&chs=150x150&chl=โ€ & โ€œTRAILPARKSNUMBER:โ€ & [VisitorID].[VisitorTPSANumber] & โ€œDATEOFPERMIT:โ€ & [PermitDate] & โ€œ/>โ€)>>

@Henry_Scott

Nice! Thx for the follow up!

If you have the virtual image column, try this one with the body textโ€ฆ <a href=<<[VirtualImage]>> ><img src=<<[VirtualImage]>> />

@Aleksi_Alkio ok spot on. That works as well

Soโ€ฆ you donโ€™t want to show a text like โ€œLink to QRโ€ instead of the link itself?

@Aleksi_Alkio I want to show the actual QRCode Image and not the link - see how Google+ display it in this postโ€ฆ I want the same in the Email

@Aleksi_Alkio will โ€œ

<img src=โ€ maybe assist? Translate

@Aleksi_Alkio SOLVED!!

This worked and displays the QR Code in the Email

<<CONCATENATE("<img src=" & โ€œhttp://chart.apis.google.com/chart?cht=qr&chs=150x150&chl=โ€ & โ€œTRAILPARKSNUMBER:โ€ & [VisitorID].[VisitorTPSANumber] & โ€œDATEOFPERMIT:โ€ & [PermitDate] & โ€œ/>โ€)>>

Add a virtual column and call that image there with a app formula and then bring that column to your email body.

The virtual column will give you the chance to show that QR in the app itself.

@Aleksi_Alkio I have the Virtual Column already and that displays in my App the QRCode

@Aleksi_Alkio โ€ฆbut the Virtual Column when embedded in the Workflow of the EMail Body does not display unless you add the <img src= HTML Tag to it as mentioned above. That works and displays it in the Email I received

Top Labels in this Space