Re: vCard QRCode in Google Drive spreadsheet

[Fabio Pegorari]

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:jac...@emailaddress.ema 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!