Cascading Dropdowns to 4 Levels

Question

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 tables are linked I feel is correct.&nbsp; I do that the have them working for the 1 through 3 levels, but when adding the fourth level based on the selection of level 2 and 3. At this time when I change the settings for level 4 I get a list in the fourth level dropdown based on either level 2 or level 3 selections. LEVEL 1 --&gt; LEVEL 2 --&gt; LEVEL3&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|___________|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEVEL 4Please let me know if more detail is needed.------------------------------Phillip Lehman------------------------------

blakeharrison · Answer

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

philliplehman · Answer

Thank you for this quick response. It worked like a charm!------------------------------Phillip Lehman------------------------------

Forum Discussion

Cascading Dropdowns to 4 Levels

2 Replies

Related Content

Managing record access for multiple data levels

Conditional Dropdowns, Cascading Dropdowns and Cascading Permissions

Cascading Dropdown

cascading field creation

Conditional & Cascading Drop Downs

Recent Discussions

Question about relationships

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.