Cascading Dropdown Between Two Connection Fields Not Working

Ask the Community Get Answers
1

Hi everyone,

I’m trying to set up a very simple cascading dropdown in a form, and after hours of trying every known method, the child dropdown still remains permanently greyed out. I believe I’ve hit a bug or an undocumented limitation.

My Data Model:

  • JMC_List (parent)

  • County_List

    • Each County_List record links to one JMC_List (Many→One)

  • CFVacancies

    • Each CFVacancy record links to one JMC_List (Many→One)

    • Each CFVacancy record links to one County_List (Many→One)

This is the standard parent → child → record structure used for cascading.

What I Want to Achieve:

When the user selects a JMC, the County dropdown should activate and show only counties connected to that JMC. But its greyed out and if I hover over the greyed out field, it says “Options appear after JMC_List selection”, even if I have selected something.
I’ve been around in circles with AI bots for literal hours to try and solve this simple task.

image
image274×143 7.64 KB

Edit: Amazing. In desperation I tried Grok and it solved it. turns out the preview doesn’t work well with cascading menus. So for hours now I’ve torn my app apart trying to figure out why. Soon I tried the view live app option, it worked. Bug?

2

Wow - I feel your pain. I don’t think I would have ever have throught to ask you if you were using Preview or the Live App :thinking:

Personally, I’ve never used the Preview option. I use two screens - Live App on one screen, builder on the other.

Glad that you got to the bottom of it. :man_technologist:

Definitely a bug, please let Knack support know - save others from the heartache. :cry: