Inventory with QR Codes in Google Sheets and Google Forms

[@practicalsheets]

Unfortunately Google API is not working anymore You can try any of these 3 alternatives ="api.qrserver.com/v1/create-qr-code/?data="&B11 ="qrcode.tec-it.com/API/QRCode?data="&B11 ="quickchart.io/qr?text="B11 Kind Regards

[@martyyalmartyyal9702]

Could you tell us more about that your API

[@JoshTeiken]

I would love to see a part 2 of this that includes the output and how to create a form where you can select the quantities that are received/removed in bulk.

[@stuartmcneill7576]

Would love to see a part 2 on the output, thank you for this great explaining video

[@mrdimmu]

Same, I am guessing still has not put one up, can't see on channel

[@malukufree]

First of all have a Merry Christmas. Thanks for the clear explanation, this was really helpful. Looking forward to your next video for the output version. 🎄🎄🎄

[@practicalsheets]

Thank you! And sorry for answering almost at the next christmas ;)

[@MelanieNelson-e7x]

Thank you! This was a great tutorial.

[@practicalsheets]

Thank you!

[@srisukartimostafa6279]

Thank you for the video.. It is very clear..

[@practicalsheets]

Thank you for commenting!

[@tsuijoan]

This is really helpful. thank you

[@practicalsheets]

Thank you for commenting!

[@rmwaye]

I've added another qr code for when items are scanned out. How would I update the quantity in stock logic so it shows the correct quantity when an item has been scanned out?

[@gabrielcambronero4338]

Bro muchas gracias por el video!! Te ganaste un seguidor!!

[@practicalsheets]

Mil gracias Gabriel!

[@thethtoonaing5045]

Hi Sri, great video. Is there anyway to add quantity when doing inventory input QR scanning? Where can i check part 2 for output inventory qty? thank you

[@Typestries]

Fantastic, thank you!

[@practicalsheets]

Thank you for commenting!

[@nicholasanwar1525]

you're the man

[@practicalsheets]

🙏

[@liching35]

Thanks very much. that's very well explained and followed. Would definitely appreciate part 2 of video

[@practicalsheets]

Thanks for the words Any suggestions for Pt 2? Regards!

[@sarahbutti2943]

Thank you….. nice solution and great explanation

[@TanyaBlanchard-r9j]

I spent a lot of time searching for videos and this was by far the best easy to follow video. I simply want to track company assets as they leave the warehouse and when they get returned so I have set up two bar codes per asset but how do I get google sheets to enter the name of the individual that is scanning the item to appear on the spreadsheet without the employee having to enter their name each time in a field on the google form or is this not an option? Also, how do I print the QR codes and possible name them with the asset name (ie. baker-1, baker-2, baker-3)?

[@practicalsheets]

Thank you for your words! I don´t see how without using code (Even with code I would have to think deeply) I´ll think about it and come back if I find a solution Kind Regards!

[@TanyaBlanchard-r9j]

Thank you for your response!

[@bryanasiimwe4200]

Hello, How are you? Thank you for your videos and the effort you put behind them. However, at 4:54, you talked of sharing the link on the automatic way of updating the Google form once you input data in the sheet. You mentioned including the link in the description, which I can't find. Could you have forgotten to include it or if it doesn't bother you, kindly share it as a reply to this comment. Thanks!

[@practicalsheets]

Hello! I think you are referring to this one kzbin.info/www/bejne/oWG1hGelhd-sbpI Thank you for letting me know I'll include it n the description Kind Regards

[@bryanasiimwe4200]

@@practicalsheets Thank you for your quick response

[@vaclavmatousek7178]

Thank you for the video. I have a question - My google sheets does not generate the qr picutre (=image(...)). and I do everything as you do. What could be the reason please? Thank you.

[@practicalsheets]

Hello! It could be that the qr generator from google stopped working. You shoul change it for something like this ="quickchart.io/qr?text="&ENCODEURL(A2) Kind Regards

[@fernmoss3539]

Is there something like this which will allow tracking the use of tools? I would like to be able to loan tools out and know who has them. Of course check them back in when they are returned, and even allow people to exchange the tools using their cell phones.

[@practicalsheets]

Very interesting case, I would use thw QR but taking the to a form where they would put their name and maye more data Regards!

[@texasp5897]

How can you make it so that you can scan in and scan out inventory and have the quantity updated automatically?

[@Haulventuras]

That’s what I want 😅

[@revosven]

Plus one for this request too.

[@latenttweet]

Wireless bar code scanner. Bar code scanners are nice because they just tell the computer the number and then carriage return. Then just the coding portion (I know I make it sound easy lol)

[@renaudgg]

if for 1 input i would like an extra word to go on the input sheet on a second column... is there any way? like I know a QR can have tons of info.. if lets say in input there is timestamp then on ther other column the product name .. is there a way to add another column that could be example the customer name and so on .. ?

[@practicalsheets]

Hi That's the beauty of the QR. As you say, you may add al the amount of information you want Kind Regards

[@renaudgg]

⁠Yes but how can it get back in more columns into the result page? am i supposed to write the products with semi column delimited with other info? thats where i get confused

[@renaudgg]

so does that mean we have to enter both in the form and in the COlumn A the products? or is there a way to simply fill the form (or the Column, vice versa) and it would fill the other one ?

[@practicalsheets]

It should be one or the other. But you still have to have the question ecause you need the id Kind Regards

[@curiousmk5569]

It works well! Thank you so much!

[@MamuteManager]

Hello, Thank you so much for your video. I tried adding new products and dragging the URLs and the QR code. I also added the product name onto the google form, when I tried to scan the qr code it kept saying a new question was added, and it didn't let me automatically submit the form. How can I add new products and have everything else work?

[@donahramos1239]

Would like to see an output for this and as well if you can implement in a form a name of who have taken items out would be good as well

[@practicalsheets]

Of course. I will work in part 2 Regards!

[@agnesv.5383]

Is there a way I can use the QR code to also track the location of the product? Like if we had pre determined "aisles" or sections the product can be placed like A1, A2...

[@practicalsheets]

Hmmm. You would have to open the form so you could manually write the location Regards!

[@aakashbatra1]

If i print this on my product label so its easier for someone to scan it and out the product. Can I take the response only for a particular email ID so when someone buys my product and scans at home, the stock shouldn't work there.

[@practicalsheets]

Hmmm I think it could work You could set up the countif only for that particular email Kind Regards

[@blueberrySerbia]

great video, is there a way to close the google form after the qr code reads it? the camera appear so it can scan the qr code again. Thanks

[@practicalsheets]

Hello! I´m not sure There may be. I´ll look into it Regards!

[@alanalejandroaranzola1972]

Can we modify the quantity displayed from the QR? (for example if in a reading there´s 50 of the same product i just scan 1 and i can count the whole batch)

[@practicalsheets]

we could add a field in the form of quantity so you could add a lot of the same product Regards!

[@cdn_diesel6570]

would like to know how you can do it so that when you scan the qr, it asks for the product type (eg, hoodie, t-shirt, hat etc), the color, the size and the quantity purchased or sold per item.

[@practicalsheets]

Hello! In order to send immediately you use ...ft5Ty/formResponse?entry... In order to display the form you use ...ft5Ty/viewform?usp=pp_url&entry... Regards!

[@mysinsehtcm6824]

Thank you!I found it is practical

[@practicalsheets]

Yes! I´m glad I´m sticking with the title "Practical Sheets" ;) Really, thanks for the message! Regards!

[@lauradziuban6973]

If I wanted to be able to input a number for the quantity of item from just scanning the QR once, like if I purchased 20 shirts that were all the same and wanted to add them into the inventory. Instead of just scanning 20 times, can I somehow have the google form recognize the different unique names still but also keep a running quantity total? Sorry if this didn't make sense

[@jacobuys-pd3iq]

thanks this is awesome but can it work with normal barcode 128 not just qr

[@practicalsheets]

Hmmm Up to my knowledge (which is not too much), I think not, given that normal barcodes store numbers and not urls (I think) If someone knows more bout classic barcodes, excuse my ignorance Kind Regards

[@DaleyKreations]

Hi! I've gotten to the stage where I'm editing the URL To Input to add &A2 at the end. But when I try and test scan the new QR code instead of opening the link to the Google Form it says "Note:" and tries to make a note that has the link and the word "guitar" (I'm using a Samsung Galaxy Note 10 Plus) I checked I have all my quotation marks etc in the right places. Any suggestions?

[@DaleyKreations]

Nevermind - apparently it is my phone. When I use a different QR scanner it works

[@practicalsheets]

Excellent! Glad you figured it out Regards!

[@krissabastian1961]

Can we move a column in Google Spreadsheet for validating what has been scanned ?

[@CahKeneOmaheKono-l8m]

IF my product already has the line QR how to linked with google form?

[@practicalsheets]

Hmmm, I´m not sure if it can be done with Forms Maybe better try appsheet instead? Regards!

[@RaphaelSolsConcepts]

hi there very interesting video soo much to learn about it! with this technique is it possible to create the input/output forms for different users (only for output and some in and output). and when you scan the QR code that you can put in the number of items you in input or output so that you dont have to scan 10 times the same code to have the right amount of items in or out? I'm looking to do this for a long long time but never find how to do it! this idea of you may bring me to the good path. just wondering is the items mentioned above were possible to add in ? :) kind regards

[@kevingalang9955]

It works! However after I created another multiple choice, it didn't work. Do you know how to solve it? Thanks in advance!

[@edwardrambanpinem1359]

Thks, very usefull

[@manojwankhede9610]

Really thank U

[@AdminCoordinator-g8c]

how can I contact with you if I have a query

[@practicalsheets]

Best way is through the patreon page Or you can write to [e-mail] Kind Regards

[@rotg2925]

Great video, How do you auto update the form if you keep adding new products in google sheet?

[@practicalsheets]

Hello! Here is a video where I do that kzbin.info/www/bejne/oWG1hGelhd-sbpI Regards!

[@rashidnasirov8005]

If I have more than 1000 items, can I find/go to the specific cell (for example A556) by scanning QR code?

[@practicalsheets]

Yes I think so You stand in the cell, right click get the link for the cell, and this is what you will put in the QR Code. I wouldn´t know how to make it dynamic though Regards!

[@valentintauleahu2653]

I tried the formula but I don't now why it's not showing the Qr code , always blank

[@practicalsheets]

You are right The google charts api is malfunctioning. This is the one I've used in my QR videos. I suggest changing it for now to this one qrcode.tec-it.com Here is an example of its use =image("qrcode.tec-it.com/API/QRCode?data="&encodeurl(B2)) Regards!

[@rikayahrosario2358]

My google sheets didn’t generate a QR picture and I did everything you did. How do I fix it?

[@practicalsheets]

Did you solve? Kind Regards

[@Openupmind]

​​​@@practicalsheets facing the same issue but after few refreshes of page its working

[@practicalsheets]

@@Openupmind Thanks for sharing!

[@FunLearningPiano]

I followed your instruction. I am still getting stuck at 11:56. I spend 5 hours to figure out how to do QR code. It is not easy.

[@practicalsheets]

You are right there is a bug with the google chart api. You need to change it with an alternative such as this ="quickchart.io/qr?text="&ENCODEURL(A2) Kind Regards

[@FunLearningPiano]

@@practicalsheets Let me try. I will let you know if it fix. Thank you

[@cast1678]

I am having a hard time creating the QR code

[@practicalsheets]

ATTENTION: (9/4/24): The google charts api is malfunctioning. This is the one I've used in my QR videos. I suggest changing it for now to this one qrcode.tec-it.com Here is an example of its use =image("qrcode.tec-it.com/API/QRCode?data="&encodeurl(B2))

[@petecandelario1700]

Not sure i’m putting it in correctly cause it’s not working

[@dvncfilm]

what about size?

[@petecandelario1700]

@@dvncfilm did you get it to work?

[@dvncfilm]

@@petecandelario1700 yes

[@dvncfilm]

@@petecandelario1700 but I can't control the size of QR codes in Google Sheet

[@Ninjatravels28]

Not working for me.. 😢

[@practicalsheets]

Hello! Any specific error? Regards!

[@FoodLifestyle1234]

Mine is showing an error

[@dalecollins-smith3551]

Is anyone else still unable to get a QR code?

[@practicalsheets]

Unfortunately Google API is not working anymore You can try any of these 3 alternatives ="api.qrserver.com/v1/create-qr-code/?data="&B11 ="qrcode.tec-it.com/API/QRCode?data="&B11 ="quickchart.io/qr?text="B11 Kind Regards

[@dalecollins-smith3551]

@@practicalsheets yeah thanks. I got it. But how unusual for Google to stop services

[@practicalsheets]

@@dalecollins-smith3551 It is unusual. No press release or anything Kind Regards

[@zetkoofficial]

how to get link