My QR code works but returns an empty Vcard template (awesome!) but the data fields are blank/ not populated with the data from my Row. ty

AppSheet AppSheet Q&A
,
1

Howdy All! Sorry for my AWOL from Appsheet! LOVE AppSheet and still promote it all the time!

I’ve got this formula working in an Image column, but it only returns a blank Vcard template, with no data in the fields. How can I adjust this so data passes through into the Vcard fields? I’m very close to amazing!! tyvm!

“https://quickchart.io/qr?text=” & ENCODEURL(
“BEGIN:VCARD” & “\r\n” &
“VERSION:3.0” & “\r\n” &
“FN:” & [Name] & “\r\n” &
“ORG:” & [Company] & “\r\n” &
“TEL;CELL:” & [Cel Phone] & “\r\n” &
“TEL;WORK:” & [Work Phone] & “\r\n” &
“EMAIL:” & [eMail] & “\r\n” &
"NOTE:Focus Needs: " & [Focus Need] & "\r\nLikes: " & [Likes] & “\r\n” &
“END:VCARD”
)

1 Like
2

Is \r\n understood by quickchart.io? It is not understood by AppSheet. If you want newlines embedded in your vCard text, you’ll need to do this:

"https://quickchart.io/qr?text=" & ENCODEURL(
"BEGIN:VCARD" & "
" & "VERSION:3.0" & "
" & "FN:" & [Name] & "
" & "ORG:” & [Company] & "
" & "TEL;CELL:” & [Cel Phone] & "
" & "TEL;WORK:” & [Work Phone] & "
" & "EMAIL:” & [eMail] & "
" & "NOTE:Focus Needs: " & [Focus Need] & "
" & "Likes: " & [Likes] & "
" & "END:VCARD”
)
2 Likes
3

Nice to see @Stephen_Mattison after many years in the community. I recollect him being one of the prominent community contributors in around 2016-2020 timeframe.

2 Likes
4

Thank you so much, Sir, for the kind words! Yes, I love the amazing AppSheet Community and I am sorry for my long absence. My core lighting business got a huge account at Budweiser’s Warm Springs Ranch in Boonville, Missouri 2017-2024, where every new Budweiser Clydesdale is born. That account took all my time & effort, and then some. To meet their enormous needs, I even had to turn myself into an overseas shipping magnate, ordering numerous 40ft containers full of Christmas lighting and decorations direct from the factories. But I never stopped with AppSheet, I even built an amazing Photo-Booth App for them to organize & vastly speed up their 1,000 person line to get photos with the Clydesdales and automatically email Guest photos directly to their Inbox. AppSheet is amazing, and so is this important Community. I’m thrilled to be back, and to see the upgrades to this crucial help system. Thank you all!!

3 Likes
5

Wow AGAIN! Thank you so much Mr Steve!! You are incredible! look what you/we did! Your adjustments and wisdom made this work and it’s so incredible for my advanced CRM! Scanning the QR code instantly enters data into a Vcard that takes one click to enter their info into my Contacts! INCREDIBE AppSheet! Vcard from QR from AppSheet data!! SO happy again, tyvm!!
I’ll still do some fiddling to get more data, like the Image of my Contact, that would be even more incredible, to have a full Vcard filled out perfectly, powerful stuff here!!

2 Likes
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.