@@balazskeisz I checked the code and it seems like everything is in working order. Did you download the latest file from the link the the description of the video?
Hello, thank you very much for this video. What if i want QR code that is only URL adress? What would the excel entry look like then? Would the "URL:...." be enough or does there have to be something else before that? I'm not creating a vcard, but a product label, where I need to have a QR code with only a link to the website.
Great tutorial, all works except phone number is blank when scanning the QR. even with the default excel file i downloaded from your link. I can see all info for phone is there in the excel, but still blank
That's a great catch. I forgot to put a "n" before "TEL" in the phone number part of the excel file. That's what caused it to not read properly. I just updated the file on the Google Drive, feel free to redownload and test again. Thanks for catching that. One small character missing and the whole thing blows up on you.
The image in the center does require some testing. I had to shrink it down a couple of times before it worked properly, but it does scan. There is a certain percentage of the code that can be covered and still work.
@@tharindushanaka1990 check and make sure you’ve still got commas between the coded elements. I don’t have the file in front of me at the moment, but I believe each section of code has be separated by a comma. I can double check later.
That shouldn’t have anything to do with it. Did you download the file from the link in the description? One little mistake in syntax can blow the whole code up.
I would doubt it, but maybe??? I can’t say for sure. The only thing I can think of is that maybe since the language is different the abbreviation changed.
@@miketheprintman What I found out for now is that the european version uses a semicolon instead of a comma. Commas in the formulas generates a parsing error. But I am not out of the woods yet. I will let you know when I resolve this.
Excellent video. Thank you! Where does the data source live so that the QR code works when scanned?
You can find the link to the excel file in the description. Simply download and customize to your needs.
@@miketheprintman So it just stays on my computer? It doesn't need to be put on a website or something?
@@sarahroesch849 when you scan these QRs with your phone it will prompt you to add the persons contact info to your address book.
@@sarahroesch849 from my understanding, the infos are written inside the QR code
Excellent, thank you! (Just one note: QR code becomes visible after Creating Merged Document.)
Do you mean the QR is readable after merging?
@@miketheprintman yes, which seems to be obvious, but at my first time I thought I did something wrong, but not 😅
@@miketheprintman one more thing. In your code (google sheet cell), there is an extra comma after ",G2," like >> ",G2,",
@@balazskeisz I will check that and fix it. Thank you.
@@balazskeisz I checked the code and it seems like everything is in working order. Did you download the latest file from the link the the description of the video?
Hello, thank you very much for this video. What if i want QR code that is only URL adress? What would the excel entry look like then? Would the "URL:...." be enough or does there have to be something else before that? I'm not creating a vcard, but a product label, where I need to have a QR code with only a link to the website.
Great tutorial, all works except phone number is blank when scanning the QR. even with the default excel file i downloaded from your link. I can see all info for phone is there in the excel, but still blank
That's a great catch. I forgot to put a "n" before "TEL" in the phone number part of the excel file. That's what caused it to not read properly. I just updated the file on the Google Drive, feel free to redownload and test again. Thanks for catching that. One small character missing and the whole thing blows up on you.
@@miketheprintman dude. Awesome thank you.
how icon at middle of your QR code not affecting the data while scanning?? Can i also keep icon middle of QR without affecting the QR data?
The image in the center does require some testing. I had to shrink it down a couple of times before it worked properly, but it does scan. There is a certain percentage of the code that can be covered and still work.
I'm trying to add another telephone number, company name and URL. When I add company name as Org the name is missing from the QR
Do you mean the URL doesn’t work, or the name of the company doesn’t show?
@@miketheprintman when I add the organization, first and last name disappears on QR
@@tharindushanaka1990 check and make sure you’ve still got commas between the coded elements. I don’t have the file in front of me at the moment, but I believe each section of code has be separated by a comma. I can double check later.
@@miketheprintman I just got into bed. I will try tomorrow again. are you able to send me the template is much appreciated.
@@tharindushanaka1990 you should be able to download the excel file from the link in the description.
QRcode concat field generates an error code. Maybe because I am in Europe?
That shouldn’t have anything to do with it. Did you download the file from the link in the description? One little mistake in syntax can blow the whole code up.
@@miketheprintman I did//Maybe because I have a Dutch version of Excel and googles sheets?
I would doubt it, but maybe??? I can’t say for sure. The only thing I can think of is that maybe since the language is different the abbreviation changed.
@@miketheprintman What I found out for now is that the european version uses a semicolon instead of a comma. Commas in the formulas generates a parsing error. But I am not out of the woods yet. I will let you know when I resolve this.
Right on. Glad you found at least a partial solution.