Inventory Tracker on Google Sheets
ฝัง
- เผยแพร่เมื่อ 26 ก.ย. 2024
- In this video, I demonstrate how to create an inventory tracking system on Googe Sheets that uses transactions of receipt, shipment, transfer, and adjustment sidebar forms. Video, Code, and Documentation can be found at codewithcurt.c...
Great programming structure this has helped me greatly for a legacy project i had stalled for some time. Thanks 🚒🔥
Your videos are always awesome ❤️
I saw this video once before but enjoy watching it several times thereafter, to relearn what is being shown in this video. Thanks for pulling this together Curt! I appreciate this and will try and customize what you have and will add additional functionality that I would like to see in this awesome utility!
Awesome Man!!! I was asked by a relatively new boss to throw something together to track inventory at 2 different sites. I'm going to populate the spread sheet a bit and send if to my boss with less than a half a day into it and let him think I'm a Google Sheets God for a minute just to see the reaction. I'm not going to let him believe it for long because if he wants any changes I'll be lost LOL. Thanks!!!
Great training Code With Curt, as always I enjoyed it.
I am trying to add Columns to have more information but it makes it so the script doesnt work, Is there a way this can be explained
For example : I have Parts # as a column but i want to make a column for Description which it will V Lookup that part numbers description for employees who dont know things off of part # perfectly
thank you
Dear, Please share your sheet as a copy...
your provided code showing an error........
please help me
I got it to work but if i add any columns it doesnt work as intended sadly
Is there a way to have the dropdowns populate options as you type? currently you have to scroll through all part numbers and find what your looking for...
You are the top!! One information, Is possible add dynamic multi item inline ? Thanks
Hi, I am trying to make embedd this to a google site. How should the doGet function in that case ? Appreciate your help!
I just spent 3 hours following your instructions. Now when I open any of the sidebar menus I get this error notice, "Exception: Malformed HTML content." Why is this happening?
I figured it out. The part of the video where you were making the receipt, transfer, ect. HTML files was a little fast and
I couldn't catch what you were doing. I got it working now.
@@matthewroeder3886 dear, Can you tell me how to fix the problem?
What if you have too many items? how do you make the input field as text while still having to select from drop down list? Thanks!
Thanks for the well informed video as I was trying to use Sheetgo and what you created is way better. [[However, How do I go about connecting a description with the Part Numbers?]]
Awesome. Thanks for sharing the code!
For some reason, the Location & Part Number dropdowns are not working. Any idea why?
Can I get the code please?
Hey, love your videos 2 questions on this one. On the part numbers drop down of side bar it only let's you click 1 letter and the you see all parts that begin with that letter is there a way to allow further letters to further filter drop down results. Second is there a way to make receiving shipments etc for more then one part number to be added shipped etc
i cant reach the link below video pls help me
anyone figure out how to add more to the side bar?
I like the system, I'm trying to create a solution similar to this for our department's inventory which can expire but also is fairly large. Ideally I'd like each location to have users who can pull from inventory by scanning individual items using a barcode or QR code scanner. Do you know of a way to implement this? Definitely subscribing for future content.
Thinks
why location dropdown not working?
sorry, thanks
Awesome pls. provide code
There is a link in the description that takes you to the code.
hello coach code.gs.70 say cannot read property getdatarange of null? how can i fix this?
@@bong-bongtv147 make sure the sheet names match exactly what is in the code.
Hey Curt!,
still curious how to add more to script ?
for example i would like to enter the following and have it auto populate
Machine
SN
Location
QTY
HZ
Tumbler
How would i do this ?
i tried numerous ways with the current script but can't get it to show on the script when i choose it
any chance u are able to read your emails or reply here ?
thanks !
just looking to learn how to add one more option to "Receipt"
did he reply? ^
@@kimreyes4777 nothing ! , maybe he is a busy fellow which is fine . I kind of made it work for what I needed by re watching his videos
@@kimreyes4777 still nothing to my knowledge on him replying , He has posted again recently though!
Are you able to share this sheet with the script already prepared?
or is that something that is difficult
source code is missing?