AnsweredAssumed Answered

Progressive PopDown Value Choices

Question asked by HB on Oct 5, 2018
Latest reply on Oct 9, 2018 by philmodjunk

I would like to have a user select from one box on a form in progressive steps, to narrow down an exact product and save that product to a field.


Here is a sample of the table data (there will be around 100 items) the user will select from (dash for fields delimeter):

Tools - Hand Tools - 120 V - Drills - Makita - 1/2

Tools - Hand Tools - 9.5 V - Flashlight

Food - Perishable - Fruit - Apples - Macs

Food - Non-Perish - Cookies - ValuePak

Food - Non-Perish - Cookies - Ginger

Condiments - Salt

Condiments - Sauce - Spicey


I would like the user to be able to select from 1 box, ie a popdown menu, the first step in the case above would allow for the options: Tools,Food, & Condiments only, then if Food is chosen, the options would change to Perishable & Non-Perish, then if selecting Non-Perish, the value options would change to Cookies, and then when selecting Ginger, since there are no further Cookie options, would set the desired field to  "Food - Non-Perish - Cookies - Ginger"


What would be the best way to approach the above!


Thanks so much in advance!