Referenced list of results based on another field (Multi-Row)

Question

Hello,

I have a reference table with two column. The first column is Area (for example A,B, C) and the secound column are Cities (for Example Cologne, Frankfurt. The table looks like:

Area Cities

A      Cologne

A      Bonn

B      Frankfurt

In a form definition I have defiend two fields Area and Cities as Smart Dropdown with the reference on the page where the confiforms form is fefined.

For the field cities I use the confiforms Rules field definition to filter the sities based on the area, if I choise the area A in a form I only see two rows of cities in the dropdown field cities as a selection list in the form.

This scenario works with the configuration, but it doesn't work in the multirow configuration.Is this a bug or a feature? Is there another solution for this case?Hopefully there is a solution. Thank you in advance.

Dieter Hoppek · Answer

Thanks for the reply.

Korea_c67l7f · Answer

I ran into the same limitation, it’s not really a bug, more like multi row just doesn’t fully respect those dynamic filters the same way single fields do.

What worked for me was avoiding the built in rule for that case and instead splitting the logic a bit. Either pre filter the reference data into separate lists per area, or use a script based approach if Confiforms allows it in your setup. Multi row fields tend to ignore dependent dropdown rules unless you handle it more manually.

Not the cleanest solution, but right now that’s kind of how the plugin behaves.

Alex Medved _ConfiForms_ · Answer

Hi

This is by design. Only form’s local rules work. Rules for sub forms are not executed

Alex