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!

reddit.com
u/Rocker_Raccoon — 2 days ago

Data Analysis Maters prep

I am an elementary school teacher who would like to get my Masters in Data Analytics so that I can eventually switch careers. My biggest point of anxiety is that I am not coming from a Business/STEM background. I am wondering what I can do to help offset that, both to improve my application strength and not feel completely lost once enrolled.

My plan is to enroll in a Fall 2027 program to give myself time to prepare. Many schools' prereqs include either some sort of Python course, calculus, and/or a probability course, all at the college level. Does anybody have recommendations for the best way to complete these? I know GA Tech offers an EdX Python course (has anybody done this/is it good? I wasn't familiar with EdX prior to searching for programs), but beyond that I'm not sure where the best place to start would be. I am off for the summer but then work full time, so online options are preferred.

I'd also love to hear any tips about how I might start to strengthen my application in general, as obviously teaching is not giving me a lot of tangibles and relevant experience lol. That isn't to say there is NO relevant experience as obviously data is a part of teaching, but certainly not to the degree of what I expect business and STEM careers are experiencing.

Any advice is very appreciated, and if you know of another subreddit where I might have success crossposting please let me know. Thanks!

reddit.com
u/Rocker_Raccoon — 2 months ago
▲ 16 r/TeachersInTransition+1 crossposts

Hi everyone,

I know this question is asked a lot, I'm just hoping to get some guidance because I'm feeling quite stuck. I currently teach/am certified to teach K-6 grade in VA. I really enjoy teaching and can't seem to make up my mind if I truly want to leave or not. I find a large part of my hesitancy is that I have absolutely no idea what else I would do. Maybe asking teachers how to leave isn't great, if you know a sub where I'm likely to get better feedback please let me know lol. Maybe this question isn't even best posted here because in part I think I'm just unsatisfied with life in general, not teaching lol.

My only degree is in teaching, and it is my only job experience. Beyond teaching what I really love is being outside and active in any way possible. A big hang up for me is that I really, REALLY do not want to go back to school. I'm struggling to imagine what jobs I could do. For me salary is important, but really not a big factor. Anything where I could make 70-80k would be plenty for me. I make 60k at my current district and I don't want to leave teaching just to make less than that. I'm not even opposed to switching to some sort of desk job but again....I just can't imagine what that would be.

I know many people switch to EdTech or curriculum development. I don't think I'm against that, but I'm not exactly enthused by it. I think I'd prefer something away from education altogether. I really enjoy working hard and being challenged, but I find myself getting "bored" by the challenge of teaching - it's not fun to feel like I'm trying to find solutions for students who are suffering from systemic problems. If you have any type of career suggestions, I am all ears. I deeply appreciate everyone willing to share their experiences and insight!

reddit.com
u/Rocker_Raccoon — 4 months ago