Order form tied to live inventory?
Looking for help on creating an order form that can block orders (or remove options, etc.) if something is out of stock. It could be a message, form is stopped from going through, anything really that tells people what they want isn't in stock. Would also be great if once an order is placed the inventory sheet is updated to reflect live inventory (although I'm pretty confident I can do that part myself, and fairly certain this is a necessary part of building what I'm asking about.)
For context - I run my school's store that students get prizes from. They submit orders using a google form each week. Unfortunately we often have kids ordering only to find out on pick up day that whatever they ordered is out of stock, as there's often not an easy way for us to update options.
I've done some research and seen a few options that use a chrome extension. I'm not opposed to this but would love to do it without an extension if possible, because the extension appears to be blocked by my district's firewall. I MIGHT be able to submit a request for it to get unblocked (or I could set up the form from my personal computer?) but would prefer not to have to go that route.
If you know a great tutorial or have some tips, please let me know. Thanks so much for any suggestions!