Wrong group? Better to Google Docs group? Sorry if so..
Il giorno giovedì 8 novembre 2012 11:53:08 UTC+1, Fabio Pegorari ha scritto:
>
> 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/-/9WNCQTQgbroJ.
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.
