LinkedIn
Twitter
Hi,
I am in process of developing small app for inventory/production tracking. I have two issues with it and would really appreciate some hints of what to do.
Data model:
Problem 1:
I would like to store a recipe/formula for product in Product Formula table. Then when i want to manufacture it i would like to add new manufacture to Manufacture table and in this form i would like to choose Proudct from Product table (this works fine) but also see view/form from Product Formula that i could also modify (e.g i would set number of batches to 5 and this would multiply quantities in formula would *5).
Then when i hit save the values from Formula would be saved in Manufacture Details table (so nothing is changed in Product Formula table it serves as a template for manufactures).
Problem 2:
In this added view i would like to also add material batch number that is stored in Invoice Details table - this could work as a dropdown to choose available numbers. Would i need to have this field added to Product Formula table and then fill it using some Appsheet formula or this would work using virtual column?
Is there some way to achieve this?
