I created an App that is designed to:
Take kanban ID input by user and define the related SKU using a MySQL connector function. User also inputs the quantity of products made.
Then it uses the SKU to list BOM data (including each part number in the BOM) using a MySQL connector function.
Then it uses an expression to calculate usage (as defined by the BOM for each part number) multiplied by the quantity of products made.
Then it is supposed to loop to the next BOM line item and perform the same calculation until it moves through all lines of the BOM (array).
Then it inserts the results into MySQL via connector function.
@gio helped me make this work with a table, but when I transitioned to inserting to MySQL instead of a table, only the first line of the BOM is inserted and the expression doesn’t work properly.