Auto fill with drop down box

%3CLINGO-SUB%20id%3D%22lingo-sub-3017199%22%20slang%3D%22en-US%22%3EAuto%20fill%20with%20drop%20down%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3017199%22%20slang%3D%22en-US%22%3E%3CP%3EIm%20trying%20to%20create%20a%20form%20where%20you%20select%20a%20product%20from%20a%20drop%20down%20list%2C%20which%20will%20auto%20fill%20cells%20with%20ingredients%20which%20make%20up%20that%20product%2C%20and%20show%20a%20total%20value%20of%20how%20much%20of%20each%20ingredient%20is%20needed%20to%20make%20up%20that%20product.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20problem%20im%20having%20is%20that%20some%20products%20are%20made%20of%20the%20same%20ingredients%20but%20at%20different%20%25%20so%20the%20values%20need%20to%20adjust%20based%20on%20what%20%25%20of%20each%20ingredient%20makes%20up%20the%20product.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20if%20i%20wanted%20to%20make%20500%20litres%20of%20product%201%20id%20select%20product%20one%20it%20will%20fill%20the%20cells%20with%20the%20ingredients%20needed%20and%20how%20much%20of%20each%20ingredient.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3017199%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3018076%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20fill%20with%20drop%20down%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3018076%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20a%20slightly%20different%20setup%20of%20your%20products%20table...%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Im trying to create a form where you select a product from a drop down list, which will auto fill cells with ingredients which make up that product, and show a total value of how much of each ingredient is needed to make up that product.

 

the problem im having is that some products are made of the same ingredients but at different % so the values need to adjust based on what % of each ingredient makes up the product.

 

For example if i wanted to make 500 litres of product 1 id select product one it will fill the cells with the ingredients needed and how much of each ingredient.

 

 

2 Replies

Using a slightly different setup of your products table...

This is exactly what i wanted, thank you so much!!

Theres no way i would of been able to get there without help.

many thanks