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 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
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
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)
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?
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 :)
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.
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"
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);
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!
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.
&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 ?
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 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
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
You are awesome, I am really grateful for your all videos.
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)
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.
Man, this video is really awesome!! Very handy! Will be nice to see more, how can I say, integrations (?!?) like this one. Thank you!
where is or code link
Can you also tell us how to download the qr codes that have been generated using these formulas?
Using array formula will be awesome..Thanks Ben Collins
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
it works ty - Hans
thank you
This popped in my recommendations when I just needed it! Thanks, dude!
How can I send email with attachment img code?
Hi! Good Video.
Time ago, you could do this work using Google Api Chart, but no more... It's deprecated.
How would I estimate cost to generate one qr code with API
how to copy the qr code image to another spreadsheet?
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 :)
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.
Parcipate photo including add print certificate please tell me sir
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
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.
Great tutorial!, Thanks.
How do you export those QR codes as images, ideally named after the value of one of the cells..
Waiting for your video
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"
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?
what if you don't have a url but you just want text could that work?
Yes
A very clear tutorial!! Thanks!
superb teacher..thanks a lot !
Excellent as always, very useful
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.
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"
Thank you very much !!!
What about the Google QR Code API?
It's being discontinued.
👍👍👍
Thanks bro!!
image function doesn't work with me
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.
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 ruclips.net/video/UjJSJAMcD44/видео.html
it didn't generate an image for me, everything is okay
but in vain