Create an Inventory Management System with Google Forms and Google Sheets

In this project we will use Google Forms to easily submit inputs and outputs to an Inventory Management System in Google Sheets, as always, from scratch.
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
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: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below

[@walterwa256]

I have already like and subscribed before watching

[@practicalsheets]

Thank you so much!

[@janemitchell2103]

I have built this Google Sheet and 2 forms, input and output. This works great. Thank you! Can you tell me how I can wipe everything out to start fresh? I have done tons of testing and have inventory amounts but I am concerned about running out of usable rows. How can I refresh without affecting my Inventory totals?

[@zarlsss]

Any chance you could instruct how to shift from a dropdown to multiple choice? I need to add images next to each product but still need an accurate count for each item. Perhaps you have another suggestion?

[@practicalsheets]

Use this asMultipleChoiceItem() Regards!

[@schmonkeytube]

This is great! How would you build in tracking inventory on one product with various types, for example, Hat sizes S, M, L, as well as colors blue, red, green? Would you just create various Product Names: Hat Sm Blue, Hat Med Red, Hat Large Green, etc., or is there a formula that can accomodate it?

[@MuntazirJacksi]

Hello. Can you advice how to add another condition in the sum if equation

[@practicalsheets]

Hello! You need to use the SUMIFS function, which unfortunately wont work with arrayformula. There are some workarounds for this Regards!

[@BraveHeart-ht8zf]

problem if use google form to create inventory is difficult to update

[@NabeelAhmed-fg6it]

i tried input answer is perfect while for output i am unable to get answer i am getting 0 for the column. while i submit data in the form.Could you please advise where i am mistaken.

[@practicalsheets]

Were you able to solve? Regards!

[@jayplaays3194]

Hello, I have question? This is very informative. But some of the data in input doesn't show up. It is just zero even though I putted it multiple times. Do you have a solution for that?

[@practicalsheets]

Were you able to solve? Regards!

[@jayplaays3194]

@@practicalsheets Yes, the invisible spaces at the end of the words is the problem. ^^

[@practicalsheets]

Excellent! @@jayplaays3194

[@QMEDSTOCKMGMT]

How can i reset my numbers to start over in my stock

[@tmrotuyelu]

Link nor website isn’t working tho😕

[@mn04147]

18:28 that function example was like a magic

[@practicalsheets]

Jaja, hope you use it soon! Kind Regards

[@divyasaibabu10]

How do I get my output form to update as per changes in the input form

[@practicalsheets]

This could be Part 2, updating with Google Apps Script Regards!

[@ricoadhyasta3006]

Hello, can you make if the stock of the product is 0(zero), so the product he product doesn't appear on the output form?

[@PizzaCircle-yn5bg]

We have to select each different item in one form and how to calculate their quantity.

[@practicalsheets]

Hello! How do you mean? Do you want to do a formula for the quantity? Kind Regards

[@Makmaven]

Thanks for this very useful project, meanwhile, please if the price of some of the products change how do we manage it, to keep the former one but update the new one, thanks

[@practicalsheets]

Thank you for your words There are 2 ways, with formulas using LAMBDA or recurrences (As in this video kzbin.info/www/bejne/r4WyhoqkZ9t_hJo), or with a VLOOKUP-type function in Google Apps Script I would choose the latter, which, actually you may find here kzbin.info/www/bejne/oKiqioKPmrN-qaM Regards!

[@stuartmcneill7576]

Could you also in addition to this create this very system with using the QR codes? Nice explanation.

[@practicalsheets]

Thank you! Have you seen this? kzbin.info/www/bejne/jKLRYqmerZeEf9U Regards!

[@diaamaamoun4621]

What a great video 👏🏻

[@GAMESKICRAZE]

Sir, I am not technical so plz tell me I can share the link of output form to my customer.And if I purchase template I can add more fields i.e name, address ect. input,product form.plz reply me.

[@practicalsheets]

Hello! Yes you may share it I'm actually not selling a customizable template If you join the patreon page, you'll access the exact template I did for the video, and you could tinker with it and add new things Regards!

[@GAMESKICRAZE]

@@practicalsheets thanks sir

[@makelifeeasy1917]

you said free membership, when i got membership and see temple it again say 5$. now i m not sure after 5$ paid, you connect to anoth page for 100$ then 10000$ then million $ for your marverlous impossible templates. regards. no hot feeling.

[@practicalsheets]

Hello! So sorry for the confusion I don´t have any free membership Is just the 5 USD a month I hope it is OK to support me with this, but if not, it is OK also! I could reimburse your 5 no problem! Just having you here commenting, and seeing the videos is great support Sorry again for any misunderstanding Kind Regards!

[@zerkorj]

LMFAO

[@ladykew]

HORRIBLE! YOU DIDN'T EXPLAIN WHAT TO HIT TO CREATE THE FORM TO ENTER THE SHEETS. I'M TOTALLY LOST WITH YOUR VIDEO. IT SUCKS!

[@DaleyKreations]

Yes he did - @ 2:03. You go to Tools - Create A New Form.