Can a cascading list sub-list be auto-populated?

Hi, I'd like to know if the following functionality exists in Forms:

I have a cascading list with four tiers. For certain selections, if I populate the second tier with some value (e.g. A), there is only one selection for the third and fourth tier. I would like to auto-populate the third and fourth tier in such situation, so that user does not have to click multiple times to fill up the third and fourth tier.

I tried writing a script to check the value of the binding in the second tier matches some value (e.g. A), then "Change a Value" for the bindings of the third and fourth tier to the intended value, but this script was unsuccessful.

Thanks!

Parents Reply Children