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?
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?
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 th-cam.com/video/yTOUWn2vLN8/w-d-xo.html), or with a VLOOKUP-type function in Google Apps Script I would choose the latter, which, actually you may find here th-cam.com/video/jwGYOYeNKsA/w-d-xo.html 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?
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.
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?
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!
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!
18:28 that function example was like a magic
Jaja, hope you use it soon!
Kind Regards
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?
I have already like and subscribed before watching
Thank you so much!
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?
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!
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?
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 th-cam.com/video/yTOUWn2vLN8/w-d-xo.html), or with a VLOOKUP-type function in Google Apps Script
I would choose the latter, which, actually you may find here th-cam.com/video/jwGYOYeNKsA/w-d-xo.html
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!
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!
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
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
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!
problem if use google form to create inventory is difficult to update
Could you also in addition to this create this very system with using the QR codes? Nice explanation.
Thank you!
Have you seen this?
th-cam.com/video/Vqn1vhx2QIs/w-d-xo.html
Regards!
What a great video 👏🏻
How can i reset my numbers to start over in my stock
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
Link nor website isn’t working tho😕
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.