I am wondering the suitability and some guidance on setup of data for a potential app I wish to create.
A rough outline of the data would look like this:
Formula - A base “recipe” - consists of Ingredients and has “Dispensed Formula”
Ingredients - Consists of Batches (Physical bulk ingredients ordered and received)
Dispensed Ingredients - represents the actual amounts of Ingredient Batches used in Dispensed Formulas
Dispensed Formula - The physical representation of a Formula - contains Dispensed Ingredients; Customer
Is that enough information for someone to answer whether this appears achievable and whether this represents a good fit to the appsheet environment?