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.
Hi *** Yi Koh,
Here is an example that works:
I created 2 dropdown controls: first one with A,B,C,D values to choose from; second with E,F
With the following action(script) when I select value B in first dropdown, the second is auto-populated with value E:
This is a sample for 2 tiers, but similarly you can populate the other tiers, just add more line in "to do" actions. Let me know how it goes.
Understand that this script works with dropdown control. I am referring to using the "Advanced Control: Cascading List", for which it doesn't work.
Here is your particular example using Cascading List:
1. Created the following list group. On this example selecting Tier 1 ->A and Tier 2 -> F, Tier 3 should get I and Tier 4 should get J
2. Created the form using Cascading List:
3. Added the following script:
I hope this helps.
Thank you for the detailed explanation! Somehow I can't get it to work:The following is my script:
and it does not auto-fill. Perhaps I am doing something incorrectly?
Check the bindings on each cascading list. Here is how they look in my example.
Could you share a snap shoot of your excel list group?
Please see my sample screenshots. I'm not sure what I'm doing wrong, appreciate the advice. Thanks!
Hi *** Yi,
As I have access to your testing project.
I found that there is a space in the "Design Issue " in the condition in the action.
So you must remove the space, make only "Design Issue"
It should work, I tried in your project. Can you check it?
Hi Indrawan and Alexandru,
Ah I see, silly me. Thanks so much both for your help!