#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
Hope you enjoyed the trails at Buffelsdrift
Hope to see you soon
Regards Trail Parks SA
How aboutโฆ
@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] & โ/>โ)>>
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
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |