a few google sheets masters in here.. sorry for the off topic post again....

Im making a agenda for my production team to not lose shit and make errors and the paper nightmare they are doing now..

essentially anyone who takes in an order can add it to the list, and boom its on the list..

Here is what i have... and below what i want thats different.

Changes/upgrades:

1. Under brand, id like the brand thats chosen, to then generate a new dropdown under Flavor, so if i drop down Brand 1, its makes column C the flavors for brand 1. if i choose brand 2, i want column C to be the flavors for column C

2. In Column G, instead of a dropdown, id sort of like those to be buttons, even if they take up several columns, click Complete, Missing Incgredient, Pending would be the default status.. so maybeG is just a status column and buttons are H/I/J or something?

3. Lastly, when the status is changed to complete, is like it to filter up above any pending or missing ingredient status lines, so once its marked complete, its above the rest (or below, whatever works) so the working sheet is always primarily focused on what needs to be done still, BUT we can go back and see the last time something was made in case someone fucked up something.

4. Also i guess, id like column A to default to todays date, anything something is added, so if anyone drops down column b/c/d/e/f, auto input that days date on column And if it can get fancy, maybe add a date completed column so when its marked complete, it auto inputs THAT day as well.

i did some googling and youtube watching. enough to think its all possible, i just didnt want to do triple the work if anyone has some shortcuts or knew how to function this quicker..

oh and idf it can be locked so old ass mofos i work with cant fuck it up... that would be keen.

I've only used it for basic temp projects, nothing this deep.. but I have to ask: do you really want your biz dependent on access to Google's web services? Not to mention thoroughly parsed by their own AI, agents, or anyone that pays them? Or, curse the thought, happily grabbing ankles for regulatory or other alphabet agencies that might get a wild hair up their ass.. Sure, nothing to hide, but that doesn't mean some competitor or lowly employee's ex-bf might cause you problems. Haters gonna hate. To say their shit is not secure would be to imply there is much security at all to speak of, but there's only so much they can do while offering what they're offering, scaling for growth or rebranding etc etc.. It's not particularly stable, ask my Google Music library - if you can find it. With all their resources they've still been hacked and compromised before & will be again, they're too big to prevent every leak. Gotta plan for that if you're using web-based services in general, as you well know, but while this place can go down for the afternoon and it's NBD...

If you're going to bother to build something like this I'd think you'd want to keep it in-house on your own backed-up hardware. I'd suggest OpenOffice or licensing something OTS that fits your needs and will come with on-demand support & will run on discount hardware. I think you've asked this sort of question before re: inventory systems? Suspect your time would be better spent running shit on something you can easily config in a matter of days or even hours. Whole thing would be PnP compatible with barcode scanners or whatever inv/shipping tools you want to use, guessing it'd mesh easily with your whole supply chain & customer systems. Yanno? It would've been mostly done by now rather than trying to DIY this with a bottom-of-the-barrel platform that's barely suited for something more complex than batting averages or keeping books for Nana's Quilt Barn.

Glad it's working out there regardless though! Get while the gettin's good.

ps dont give in to the temptation to hire coders for a bespoke proprietary thing, ppl will try to sell you one if you start shopping around for something OTS & I've seen enough unfinished data/ticketing sys in places that really ought to know better.. had to mention it though I expect you'd know better, too.

9 hours ago, T-Dub said:

I've only used it for basic temp projects, nothing this deep.. but I have to ask: do you really want your biz dependent on access to Google's web services? Not to mention thoroughly parsed by their own AI, agents, or anyone that pays them? Or, curse the thought, happily grabbing ankles for regulatory or other alphabet agencies that might get a wild hair up their ass.. Sure, nothing to hide, but that doesn't mean some competitor or lowly employee's ex-bf might cause you problems. Haters gonna hate. To say their shit is not secure would be to imply there is much security at all to speak of, but there's only so much they can do while offering what they're offering, scaling for growth or rebranding etc etc.. It's not particularly stable, ask my Google Music library - if you can find it. With all their resources they've still been hacked and compromised before & will be again, they're too big to prevent every leak. Gotta plan for that if you're using web-based services in general, as you well know, but while this place can go down for the afternoon and it's NBD...

If you're going to bother to build something like this I'd think you'd want to keep it in-house on your own backed-up hardware. I'd suggest OpenOffice or licensing something OTS that fits your needs and will come with on-demand support & will run on discount hardware. I think you've asked this sort of question before re: inventory systems? Suspect your time would be better spent running shit on something you can easily config in a matter of days or even hours. Whole thing would be PnP compatible with barcode scanners or whatever inv/shipping tools you want to use, guessing it'd mesh easily with your whole supply chain & customer systems. Yanno? It would've been mostly done by now rather than trying to DIY this with a bottom-of-the-barrel platform that's barely suited for something more complex than batting averages or keeping books for Nana's Quilt Barn.

Glad it's working out there regardless though! Get while the gettin's good.

ps dont give in to the temptation to hire coders for a bespoke proprietary thing, ppl will try to sell you one if you start shopping around for something OTS & I've seen enough unfinished data/ticketing sys in places that really ought to know better.. had to mention it though I expect you'd know better, too.

its something i have considered, we arent a big enough company for anyone to really care about. and i was just going to create a blank pointless gmail account for that machine, and the only thing on that machine would be this, at worst if i got concerned i could move it to a local document within proton office/sheets. As I have begun moving corporate mail from workforce to proton mail for business. Most of our business is segmented, nest security cams are on a burner gmail account, etc.. its a paper thin pretend vail of privacy and security, but its something separating various aspects so if someone gets into an account, its not access to all accounts and information.

2 hours ago, GoBengals said:

its something i have considered, we arent a big enough company for anyone to really care about. and i was just going to create a blank pointless gmail account for that machine, and the only thing on that machine would be this, at worst if i got concerned i could move it to a local document within proton office/sheets. As I have begun moving corporate mail from workforce to proton mail for business. Most of our business is segmented, nest security cams are on a burner gmail account, etc.. its a paper thin pretend vail of privacy and security, but its something separating various aspects so if someone gets into an account, its not access to all accounts and information.

That's some level of remove but not much security. The main thing though is you're still dependent on access to Google services. Anything from an outage with your local ISP to someone at Google deciding to discontinue Sheets and you're dead in the water.

You're going to be doing the same work to set it up anyway so may as well use software you can rely on & easily control access to yourself, as I see it. Not that hard to set up remote access if that's the issue & you can still run your biz off a laptop plugged into a car charger if it came down to it.