Cascading Dropdowns to 4 Levels
I am having an issue with the way the 4 level of a dropdown set and not filtering the level 4 list based on the level 2 AND level 3 dropdown selections. All dropdowns are from different tables and ...
Forum Discussion
If your users need to select options from both Level 2 and Level 3 before selection an option for Level 4, all the records on Level 4 will need to also have both a Level 2 and Level 3 option assigned. Then, you will need to construct a formula that combines these into a single value. Something like this:
[Level 2 Record ID#] & "-" & [Level 3 Record ID#]
Then you will need to construct a similar formula on the table where the users are making these selections. Once you've done that, you will use the two formula fields in your Conditional Drop-Down settings.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
[Level 2 Record ID#] & "-" & [Level 3 Record ID#]
Then you will need to construct a similar formula on the table where the users are making these selections. Once you've done that, you will use the two formula fields in your Conditional Drop-Down settings.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- Thank you for this quick response. It worked like a charm!
------------------------------
Phillip Lehman
------------------------------
