Create an Inventory Management System with Google Forms and Google Sheets
Vložit
- čas přidán 20. 07. 2023
- 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
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
What a great video 👏🏻
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?
I have already like and subscribed before watching
Thank you so much!
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?
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?
Could you also in addition to this create this very system with using the QR codes? Nice explanation.
Thank you!
Have you seen this?
czcams.com/video/Vqn1vhx2QIs/video.html
Regards!
problem if use google form to create inventory is difficult to update
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
Thank you for your words
There are 2 ways, with formulas using LAMBDA or recurrences (As in this video czcams.com/video/yTOUWn2vLN8/video.html), or with a VLOOKUP-type function in Google Apps Script
I would choose the latter, which, actually you may find here czcams.com/video/jwGYOYeNKsA/video.html
Regards!
Hello. Can you advice how to add another condition in the sum if equation
Hello!
You need to use the SUMIFS function, which unfortunately wont work with arrayformula. There are some workarounds for this
Regards!
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?
Use this
asMultipleChoiceItem()
Regards!
How can i reset my numbers to start over in my stock
How do I get my output form to update as per changes in the input form
This could be Part 2, updating with Google Apps Script
Regards!
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.
Were you able to solve?
Regards!
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?
Were you able to solve?
Regards!
@@practicalsheets Yes, the invisible spaces at the end of the words is the problem. ^^
Excellent! @@jayplaays3194
Link nor website isn’t working tho😕
We have to select each different item in one form and how to calculate their quantity.
Hello!
How do you mean?
Do you want to do a formula for the quantity?
Kind Regards
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.
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!
@@practicalsheets thanks sir
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.
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!
LMFAO
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!
Yes he did - @ 2:03. You go to Tools - Create A New Form.