Dear Glide community,
My spreadsheet consists of hundreds of contacts, and I was wondering if it’s possible to download a selected individual’s VCF with a click of a button, so users can easily add contacts from Glideapp to their phone.
Currently, my not-so-easy solution is to generate a VCF with a direct Google Drive download link and make a button action in Glideapp that goes to that link. But it can become tedious when there are hundreds of contacts on the list (which means I have to create VCF for each individual one at a time)
I’ve also attempted using Zapier to trigger a Google Contact download action, but it’s not possible
Is there a possible way to download the VCF of an individual with just a click of a button? Wish someone can help me
Seems like this is the best solution for now.
oh darn- i wanted to check your demo out, but it says Not Found…
If it’s possible @kabookie can you walk through the solution here again Thank you.
Thank you for your comment sir. This is the not-so-easy way I was talking about.
Hey @ThinhDinh. Thank you for your information
I looked into VCardHosting.com. It is for sure a bit easier in terms of generating VCF direct download links, but you still gotta go to the site, copy in the name, email, phone, generate a link, and put that link into the Glide Spreadsheet. and the most premium option only allows 200 vCards, not more than that
Still would be great to just download VCF with a click, based on the Glideapp row information.
Maybe one can use a template column to generate a column of VCF text (each cell under the template column contains a complete VCF text), only if users can download a single cell as a .vcf file …
Here are the notes that I wrote down at the time:
- Fill in data on GSheet - (make this a Google form in future if doing many files)
- Download sheet as CSV file
- Convert CSV to VCF file with “Importer For Contacts” - launch app
- Add VCF file to VCard Hosting here: https://vcardhosting.com/cp/dashboard.
- Download VCard link from MyVCards / file name / yellow box on right
- Add link to GlideApp worksheet as action for download button.
Thanks for the info! Have a great day.
I was going to suggest that you could create a VCF file through a template and then convert it to a qr code (this should all be possible in app with the qr code stuff that was mentioned the other day). However I then realised you wouldn’t be able to read that file through the phone camera of the phone that you are using this can be done on a android phone, but requires processes that a user may not be familiar with.
Instead of downloading, can you get Zapier to email it? Receiving vCards via email is something that users will be used to.
Thank you for your suggestions @Mishta_P
I don’t really see a Glide feature that allows you to generate QR code within Glide. But I’ll confirm that.
I just tried sending a cell value as an attachment to Gmail through Zapier trigger action. The file receives as .txt and I don’t find a way to make it automatically VCF. Thank you for your idea though.
Another thing I tried with Zapier is to send Name, Email, and Phone columns in Glide to Google Contacts, which supports vCard download, but I expect Zapier can handle the downloading for me but it doesn’t, so I still have to go to Google Contacts myself and download vCard there, which is still too many steps for me Would still prefer a way to just click and download a vCard in Glide
Thank you for your information! I wish it could be more efficient. At this point perhaps I should request a feature update or something
You can build url template column that points to quickchart.io . They have an option to return an image of a qr code based in the url you pass it.
This post should do it. I have tested this at my end and it all works. It pops up on screen to add a contact.
The vCard format appears as though it can be a little flakey, I have tested a couple of contacts and it got funny with some extra data.
Just messed around with the MECARD format, it certainly works on Android (I can’t imagine it won’t on iOS), it is simpler in terms of the data string and was a little more reliable in my test.
Wiki entry for MECARD
This is so far the best solution. Now each of my contacts has a button that links to a QR code of MECARD text that contains the Glideapp spreadsheet column: Name, Email, and Phone. This is what I did:
Create a Template Column with text: https://quickchart.io/qr?text=MECARD:N:item1;TEL:item2;EMAIL:item3;;
Add 3 replacements in the template column, and replace item1, item2, item3 with their corresponding columns.
Create a button for all contacts that leads to the QR code link in their row.
Still not the most elegant way comparing to click and download in my opinion. Perhaps I’ll make a feature request, once I find out it’s a reasonable request.
Thank you @Mishta_P
There may be a way to do this, but I think you will need one of the Experts to weigh in on it.
If you can get a template column to build an hCard (this should give you an idea of the format)
Assuming there is a way to display that in app, in a way that can be deeplinked to.
Check out this link which will point you in the direction of a live hcard to vcf downloader.
It is tenuous, but is as near as I could get.
I was reading about this just the other day, although I haven’t tried it yet. Uses integromat.
And for the vcard format, see https://vcardmaker.com/
Again, I haven’t tried implementing this yet, but looks promising
This information helped me set up what i needed for my app. Thanks