Cascading Dropdowns to 4 Levels

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/
------------------------------