Hello, I am brand new to AppSheet, and brand new to any kind of app building. I am trying to create an inventory management app for our company, and have looked at the many sample apps Appsheet has. But as a manufacture, the sample apps don’t have any kind of Assembly or Parent/child info. My table has a list column for Product(what is sold on website), Assembly(a group of parts), Parts (things we make), and Hardware(outside sourced). It also has a Parent Column that has the name of the Product or Assembly that is its’ respective parent (only products and assemblies can be parents)
What I am looking at doing is when I add X amount of one product/assembly to inventory, the app will check if any rows have that product/assembly as a parent, and remove it’s Qty from the inventory.
Example, I have a product of 2 plates and 4 bolts in one package. If I make assemble 10 packages for stock, it should remove 20 plates and 40 bolts from inventory because they’re packaged as a product now.
I have started using a sample app as my base template with receiving and shipping, and thought when I add inventory to the receiving to just add the child parts to the shipping, but I am at a loss on how to do it with the actions/workflow.
Any help would be greatly appreciated. Thank you in advance.