I am a university student working on a finals project to create a Glide app for a local non-profit cooperative. I am attempting to create a Glide app that can let buyers view the flowers that florists enter as inventory within the app, and when the buyer selects a flower to purchase, the quantity needs to be reduced. I would also like to somehow mark an order as “fulfilled” when a form is also submitted from within the Current Orders section.
My web app is available publicly and can be copied and shared here: akuev.glideapp.io
When a buyer goes to Flowers Available, selects a flower, and clicks “order” and enters the quantity to purchase, I need the quantity to purchase to reduce the value of the quantity thats in “current inventory”. Is there some sort of excel formula or glide relation that can help me do this?
I would also like the ability for items in “Current Orders” to be able to click a button and have that specific item be “fulfilled”, and be removed from the “Current Orders” area of the Glide app. Is this at all possible?
I appreciate all your help.