Dinamic QR on email

[TalkNet_TechnoS]

Hello AppSheet Community
I need to send a QR by mail that depends on the Key Id of a record.
The idea is to get the QR from the google api:

https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=site.com?keyid=<<KeyId>>

But I have no idea how to position it in the .doc template of the email.
I inserted it via URL expecting <<Key Id>> to be replaced by the value of the field, but that didn't work.
Any ideas?

[SkrOYC · Accepted solution]

Try adding that expression as an image column on the table.

CONCATENATE(
  "https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=site.com?keyid=",
  [_THISROW]
)

Then if you reference this <<newColumn>> on your template it'll be rendered as an image 

[SkrOYC · Accepted solution]

Try adding that expression as an image column on the table.

CONCATENATE(
  "https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=site.com?keyid=",
  [_THISROW]
)

Then if you reference this <<newColumn>> on your template it'll be rendered as an image 

[Steve · Accepted solution]

https://help.appsheet.com/en/articles/2347653-encodeurl