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

(Henry Scott) #1

#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:197211127767603DATEOFPERMIT:11/02/2018

Hope you enjoyed the trails at Buffelsdrift

Hope to see you soon

Regards Trail Parks SA

(Aleksi Alkio) #2

How about…

TEXT

(Henry Scott) #3

@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+ Post does by resolving the URL and Displaying it

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

(Henry Scott) #4

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] & “/>”)>>

(Stephen Mattison) #5

@Henry_Scott

Nice! Thx for the follow up!

(Aleksi Alkio) #6

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

(Henry Scott) #7

@Aleksi_Alkio ok spot on. That works as well

(Aleksi Alkio) #8

So… you don’t want to show a text like “Link to QR” instead of the link itself?

(Henry Scott) #9

@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

(Henry Scott) #10

@Aleksi_Alkio will “

<img src=” maybe assist? Translate

(Henry Scott) #11

@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] & “/>”)>>

(Aleksi Alkio) #12

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

(Aleksi Alkio) #13

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

(Henry Scott) #14

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

(Henry Scott) #15

@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