For example, let’s say I have a state list, and the city list, and want the dropdown list for city to only offer options that correspond to the state selected. Could anyone help me with this? Thank you.
Without knowing more about your doc and how it’s built, you might want to test a formula in the selectable items of the select list for your cities something like this :
But depending of your current doc, it might not be as simple
Link to my doc: https://coda.io/d/Excersises_datCRxQLBtO/su-_
Ok, so based on your doc, I recreated it and I think this is what you’re looking for .
In the Items settings of your
Lookup field, you just needed to add this formula :
Note that I used Matches() because it works well with external control
Hope this help
Super! Thank you very much! I have also noticed it works only when dropdown has multiselection off. How would it be if I would like to turn it on?
You’re welcome !
I’ve just tested this and it seems to works just fine with the control
State contr as a multi-select and the
Matches() formula in the items settings of your
Lookup field in
yep it works on mulit-select too. my bad. thank you very much!
You’re welcome again !