Hello,
I have a fairly simple project that I believe with some time that I can figure out, but need it done sooner. That's never what you want to hear, right?
My business uses google apps engine for a few different purposes and what I would like to do is use Google Forms and AppSheet (or similar program) for three different uses:
1) Warehouse Inventory management
2) Data entry for winery
3) Data collection for winemaking (2&3 are very similar, I know)
Priority is #1 & details below:
We have 3 inventory locations: warehouse, Tasting room, wine cave
We stock the Tasting room and Wine cave with wine from the warehouse weekly.
I would like a google form, in the design of an AppSheet style mobile web or html5 app, that allows a person to enter who they are, what products they are moving, quantities and to where. Then have this update a global inventory sheet. Basic IN/OUT procedures, but we currently use a pen and paper transfer sheet.
I am also open to suggestions on what we could do instead or google form and AppSheet ad on. But they seemed simple enough to cover our basis.
We can discuss #2 & #3 as we move through #1.
Thank you,
Jess
Hi Jess!
Hope you are doing good. I am google form expert. I have designed multiple types of google forms for my clients.
Let's give a chance to me so that we can work together and i can say you now that you'll get the best experience.
Regards,
Yogesh
From what I understand you want a cloud based system that allows you to see how many of X Wine is in Warehouse/Tasting Room/Wine Cave. Allowing you to quickly load up the sheet and see, for example, if you are low on X Wine in the Warehouse?
If this is the case. The cheapest and easiest method (One you may already know about) is Google Drive.
You can use Google Sheets to create a workbook that can be accessed by everyone. You are able to then leave comments (Maybe for managers if stock is incorrect?), easily adjust items etc.