Long time listener, first time caller. Absolutely loving AppSheet.
I’m developing an app to manage component inventory for a circuit board manufacturer. On the surface the use-case seems a very straight-forward Inventory use-case. I have looked at all the Inventory-related Sample Apps which have gotten me fairly far…however none of them specifically address the Products w/ Components use-case.
This Topic is similar to a few others in the forums, however I’m starting a new topic to add a few additional elements of clarity to the use-case. Thanks in advance for any guidance!
- Circuit boards contain components (transistors, resistors, etc…)
- Different circuit boards contain different mixes of components (types/quantities)
Users to input how many circuit boards of a particular type they have produced and have the component inventories updated appropriately.
A fully constructed ‘ALPHA’ circuit board contains (10)x-transistors, (8)y-transistors, and (5)z-resistors.
User submits he/she has produced 10 fully constructed ALPHA circuit boards. The inventory of x-transistors should be reduced by 100, the inventory of y-transistors should be reduced by 80 and the inventory of z-resistors should be reduced by 50.
I believe my questions relate to 1. Is this product/component schema possible within AppSheet? and 2. The data model (table structures) that would support these types of product/component inventory updates. Ultimately, we’re trying to manage to the ‘component’ inventory and I seem to be going round and round in my own head for the last couple of days on this thing…
Thank you in advance for any/all guidance.