Hi all,
I wondering if it is possible to add dinamically a VCard QrCode in a table
cell.
I'm using the following formula:
=if(isblank(A4), "",
image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&A4))
Oviously didn't work, the chl variable need to be as the following:
BEGIN:VCARD VERSION:3.0 N:Clark;Jason FN:Jason Clark ORG:MSU Library
TITLE:Team Leader/Digital Initiatives Librarian [Associate Professor]
TEL;TYPE=WORK,VOICE:(406) 994-6801
EMAIL;TYPE=PREF,INTERNET:[email protected]
URL:http://www.jasonclark.info REV:20111013T195243Z END:VCARD
and need to be encoded using a URI encoder and the results will be:
BEGIN%3AVCARD%0D%0A%09%09
VERSION%3A3.0%0D%0A%09%09N%3AClark%3BJason%0D%0A%09%09
FN%3AJason+Clark%0D%0A%09%09ORG%3AMSU+Library%0D%0A%09%09
TITurLE%3ATeam+Leader%2FDigital+Initiatives+Librarian+%5BAssociate+Professor%5D%0D%0A%09%09
TEL%3BTYPE%3DWORK%2CVOICE%3A%28406%29+994-6801%0D%0A%09%09EMAIL%3BTYPE%3DPREF%2CINTERNET%3Ajaclark%40emailaddress.ema%0D%0A%09%09
URL%3Ahttp%3A%2F%2Fwww.jasonclark.info%0D%0A%09%09
REV%3A20111013T195243Z%0D%0A%09%09
END%3AVCARD
(source
http://diginit.wordpress.com/2011/10/19/getting-vcard-info-into-a-qr-code-using-the-google-chart-api/).
So, it's possible to encode url directly in the Google Drive Spreadsheet?
Thanks!
--
You received this message because you are subscribed to the Google Groups
"Google Chart API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-chart-api/-/sxFSA5yLILUJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-chart-api?hl=en.
