Inventory with QR Codes in Google Sheets and Google Forms

Рет қаралды 69,410

Жыл бұрын

In this project we will learn how to use QR codes with Google Forms and Google Sheets to easily input new items to your inventory system
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheets.com/patreon
➤Webpage: practicalsheets.com
➤Newsletter: practicalsheets.com/newsletter
➤Telegram: practicalsheets.com/telegram
➤Facebook: practicalsheets.com/facebook
➤Twitter: practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below

Пікірлер: 93

@practicalsheets 3 ай бұрын

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 2 ай бұрын

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

@dvncfilm 2 ай бұрын

what about size?

@petecandelario1700 2 ай бұрын

@@dvncfilm did you get it to work?

@dvncfilm 2 ай бұрын

@@petecandelario1700 yes

@dvncfilm 2 ай бұрын

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

@user-kh1cs4ci9j 8 ай бұрын

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 8 ай бұрын

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

@curiousmk5569 Жыл бұрын

It works well! Thank you so much!

@sarahbutti2943 Жыл бұрын

Thank you….. nice solution and great explanation

@malukufree 7 ай бұрын

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 22 күн бұрын

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

@liching35 Жыл бұрын

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

@practicalsheets 11 ай бұрын

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

@gabrielcambronero4338 11 ай бұрын

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

@practicalsheets 11 ай бұрын

Mil gracias Gabriel!

@user-bw3mk4kj4j Жыл бұрын

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

@Typestries 11 ай бұрын

Fantastic, thank you!

@practicalsheets 11 ай бұрын

Thank you for commenting!

@user-mt3jy6vi6f 9 ай бұрын

Thank you! This was a great tutorial.

@practicalsheets 9 ай бұрын

Thank you!

@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

@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?

@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!

@edwardrambanpinem1359 Жыл бұрын

Thks, very usefull

@manojwankhede9610 Жыл бұрын

Really thank U

@srisukartimostafa6279 9 ай бұрын

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

@practicalsheets 9 ай бұрын

Thank you for commenting!

@tsuijoan 9 ай бұрын

This is really helpful. thank you

@practicalsheets 9 ай бұрын

Thank you for commenting!

@lauradziuban6973 8 ай бұрын

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

@krissabastian1961 Жыл бұрын

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

@user-sc8lh3io6i 8 ай бұрын

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?

@nicholasanwar1525 4 ай бұрын

you're the man

@practicalsheets 3 ай бұрын

🙏

@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!

@am040473 Жыл бұрын

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!

@kevingalang9955 Жыл бұрын

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

@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 kzfaq.info/get/bejne/oZaChpegteDdaGQ.html Regards!

@user-nt9ul8jh6j 7 ай бұрын

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 7 ай бұрын

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!

@user-nt9ul8jh6j 7 ай бұрын

Thank you for your response!

@renaudgg 3 ай бұрын

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 3 ай бұрын

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

@bryanasiimwe4200 15 күн бұрын

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 14 күн бұрын

Hello! I think you are referring to this one kzfaq.info/get/bejne/oZaChpegteDdaGQ.html Thank you for letting me know I'll include it n the description Kind Regards

@bryanasiimwe4200 9 күн бұрын

@@practicalsheets Thank you for your quick response

@renaudgg 3 ай бұрын

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 3 ай бұрын

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

@renaudgg 3 ай бұрын

⁠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

@agnesv.5383 8 ай бұрын

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 7 ай бұрын

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

@fernmoss3539 7 ай бұрын

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 7 ай бұрын

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!

@vaclavmatousek7178 6 ай бұрын

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 22 күн бұрын

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

@aakashbatra1 2 ай бұрын

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

@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!

@texasp5897 Жыл бұрын

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

@Rockingwithms.R 11 ай бұрын

That’s what I want 😅

@revosven 3 ай бұрын

Plus one for this request too.

@latenttweet 2 ай бұрын

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)

@cdn_diesel6570 8 ай бұрын

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 7 ай бұрын

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!

@DaleyKreations 10 ай бұрын

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 10 ай бұрын

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

@practicalsheets 10 ай бұрын

Excellent! Glad you figured it out Regards!

@jacobuys-pd3iq 2 ай бұрын

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

@practicalsheets 2 ай бұрын

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

@user-gf9dp9zo4t 10 ай бұрын

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

@practicalsheets 10 ай бұрын

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

@FoodLifestyle1234 Жыл бұрын

Mine is showing an error

@valentintauleahu2653 3 ай бұрын

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

@practicalsheets 3 ай бұрын

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 4 ай бұрын

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

@practicalsheets 3 ай бұрын

Did you solve? Kind Regards

@Openupmind 3 ай бұрын

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

@practicalsheets 3 ай бұрын

@@Openupmind Thanks for sharing!

@FunLearningPiano 22 күн бұрын

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 22 күн бұрын

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 21 күн бұрын

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