Very good video. Kindly make a video on How to Scan Barcode or QR Code and send it back to Google Sheets for real time updates. Also guide how to generate a QR code in sheets having a picture inside it.
Thank you very much for making a video on generating the bulk QR code in a single go. The video is simple with minimum steps. Will you please let me know whether there is any provision to add two/three/four columns instead of one. If yes, will you post the formula here?
Thank you for your tutorials, it really helped me a lot. Please if you're looking for requests can you make a tutorial on how i can scan QR codes and encodes to google sheet. TIA
Great video. Is there anyway we can generate an image directly within a custom function using app script without the need of an external server service and return it as an image object just like image() does? Or perhaps there may be some javascript that can be called upon to generate the image with in the app script? (The reason behind this is that Google Chart function really need a lot of improvement)
Hello sir ive trying your json Google sheet tutorial with google book api but it doesn't work it returns undefined because the json is complicated can u do a tutorial about that please please
Always good info from you - thanks. Q1: The new-ish 'insert > image in cell' function is more useful (as can take our own google images instead of .jpg links) but is there a way to code it rather than using mouse clicks? (next video...? ;) And could it then be put into an array formula to read addresses from one column and automatically insert images into another column? thanks again :)
Thanks for a very useful tip. However I am failing to transfer it to Docs and then to a pdf document. I am using Google App Script to work in a spreadsheet and make a pdf from the information. I am trying to make a qr code with that information. I tried to to do a copy paste special too. I also tried to paste it in slides. Please help me.
You'll need to add the image directly to your Doc. Something like. const blob = UrlFetchApp.fetch("imgasite.com/locnameofimage.png").getBlob() const cursor = doc.getCursor() cursor.insertInlineImage(blob);
Love your videos and I highly recommend them ! :) I was wondering if there is a way or how would I go about making a chrome extension that saves data on google sheets?? I already know how to make extensions and store with local storage chrome API (chrome.storage.local.set). I just don't know how I would go about linking the chrome local storage into a spread sheet ?
Nice demo, thanks, really enjoying your videos! Have you ever thought of doing a google sheets/script for implementing a bot for MediaWiki servers? I can think of some cool applications for being able to script updates to a wiki page for example.
Dude you are absolutely amazing. I feel like writing a whole paragraph about how you helped me solve most of my problems but there's no point in that. Thanks man.
I'm wondering if it would be possible to add control characters like Tab and Enter with this method. Regular escape sequences like \t and don't work. I also tried ~d009 and ~d013 without success. By the way... I'm a fan of your channel. Thanks for sharing these amazing classes.
cell values: &ENCODEURL(A3) spaces blanks between words: &"%20" line breaks between sentences: &"%0A" values written manually in the function: &"Text"
&ENCODEURL(A3)&ENCODEURL(A4) spaces blanks between words: &"%20" line breaks between sentences: &"%0A" values written manually in the function: &"Text"
Can I download those images (QR Codes) as separate Image files ? Can those images (QR Codes image files) have the respective name from which they are generated ?
How can I add additional information to the qr code so my google app scripts can grab the data from the URL ? I want the link to be https.....data=url/helloworld/. How do I add "helloworld" to the qr code link and then later grab it from Google app scripts? Your videos have been immense help. Thanks!
Using array formula will be awesome..Thanks Ben Collins
Very good video. Kindly make a video on How to Scan Barcode or QR Code and send it back to Google Sheets for real time updates. Also guide how to generate a QR code in sheets having a picture inside it.
Thanks a lot. Very good method of generating qr codes in larger quantities.
Thank you very much for making a video on generating the bulk QR code in a single go. The video is simple with minimum steps. Will you please let me know whether there is any provision to add two/three/four columns instead of one. If yes, will you post the formula here?
I find this tutorial too useful. I suggest a second part where you can show us the usefulness of this powerful tool. Thank you, teacher.
This popped in my recommendations when I just needed it! Thanks, dude!
Thank you for your tutorials, it really helped me a lot. Please if you're looking for requests can you make a tutorial on how i can scan QR codes and encodes to google sheet. TIA
Great tutorial!, Thanks.
How do you export those QR codes as images, ideally named after the value of one of the cells..
Great video. Is there anyway we can generate an image directly within a custom function using app script without the need of an external server service and return it as an image object just like image() does? Or perhaps there may be some javascript that can be called upon to generate the image with in the app script? (The reason behind this is that Google Chart function really need a lot of improvement)
A very clear tutorial!! Thanks!
Hello sir ive trying your json Google sheet tutorial with google book api but it doesn't work it returns undefined because the json is complicated can u do a tutorial about that please please
Can you also tell us how to download the qr codes that have been generated using these formulas?
thank you
Always good info from you - thanks.
Q1: The new-ish 'insert > image in cell' function is more useful (as can take our own google images instead of .jpg links) but is there a way to code it rather than using mouse clicks? (next video...? ;) And could it then be put into an array formula to read addresses from one column and automatically insert images into another column?
thanks again :)
Thanks for a very useful tip. However I am failing to transfer it to Docs and then to a pdf document.
I am using Google App Script to work in a spreadsheet and make a pdf from the information. I am trying to make a qr code with that information. I tried to to do a copy paste special too. I also tried to paste it in slides. Please help me.
You'll need to add the image directly to your Doc. Something like.
const blob = UrlFetchApp.fetch("imgasite.com/locnameofimage.png").getBlob()
const cursor = doc.getCursor()
cursor.insertInlineImage(blob);
@@ExcelGoogleSheets Thank you very much. I cant open the link, however I have a hint and I will try to do it.
You are awesome, I am really grateful for your all videos.
how can link a image file location with a fixed QR code...so if the image is chnaged...Scan result should show new image....any idea how to do
Love your videos and I highly recommend them ! :) I was wondering if there is a way or how would I go about making a chrome extension that saves data on google sheets?? I already know how to make extensions and store with local storage chrome API (chrome.storage.local.set). I just don't know how I would go about linking the chrome local storage into a spread sheet ?
How would I estimate cost to generate one qr code with API
superb teacher..thanks a lot !
Nice demo, thanks, really enjoying your videos!
Have you ever thought of doing a google sheets/script for implementing a bot for MediaWiki servers? I can think of some cool applications for being able to script updates to a wiki page for example.
Excellent as always, very useful
Parcipate photo including add print certificate please tell me sir
👍👍👍
Dude you are absolutely amazing. I feel like writing a whole paragraph about how you helped me solve most of my problems but there's no point in that.
Thanks man.
Man, this video is really awesome!! Very handy! Will be nice to see more, how can I say, integrations (?!?) like this one. Thank you!
I'm wondering if it would be possible to add control characters like Tab and Enter with this method. Regular escape sequences like \t and
don't work. I also tried ~d009 and ~d013 without success. By the way... I'm a fan of your channel. Thanks for sharing these amazing classes.
I'm not sure I understand. What are you trying to escape?
cell values: &ENCODEURL(A3)
spaces blanks between words: &"%20"
line breaks between sentences: &"%0A"
values written manually in the function: &"Text"
@@nerearita That works!!!! Thank you so much for your help.
@@luciolibanori Glad I was able to help: D
How can I send email with attachment img code?
what if I use TEXT in column A instead of URL, how to adjust the formula ? many thanks for your help
Same should work, no?
Hi! Good Video.
Time ago, you could do this work using Google Api Chart, but no more... It's deprecated.
it works ty - Hans
Thank you very much !!!
Thank you very much for this very informative video. But how do I save the images into my disk?
I have an upcoming video for those who need actual image files. Should be live on the channel next week.
@@ExcelGoogleSheets Great! Thanks a ton. I will tune in for that definitely.
how to copy the qr code image to another spreadsheet?
what if you don't have a url but you just want text could that work?
Yes
Thanks bro!!
image function doesn't work with me
How to add two or more column data like A3 A4 etc?
&ENCODEURL(A3)&ENCODEURL(A4)
spaces blanks between words: &"%20"
line breaks between sentences: &"%0A"
values written manually in the function: &"Text"
where is or code link
Waiting for your video
Can I download those images (QR Codes) as separate Image files ?
Can those images (QR Codes image files) have the respective name from which they are generated ?
Use node ua-cam.com/video/UjJSJAMcD44/v-deo.html
What about the Google QR Code API?
It's being discontinued.
How can I add additional information to the qr code so my google app scripts can grab the data from the URL ? I want the link to be https.....data=url/helloworld/. How do I add "helloworld" to the qr code link and then later grab it from Google app scripts?
Your videos have been immense help. Thanks!
&"helloworld"
it didn't generate an image for me, everything is okay
but in vain