How to Show/Hide Fields in a Form Based on List of Results from a Query

[vaishnaray]

HI,

I'm building a form that dynamically hides certain fields based on query results. Right now, I have the results of the query in a table and I want to show only the fields whose name matches the names in the table.

When I use the Conditional UI feature, it only allows me to selected the SelectedRows in the table rather than all the rows in the table. I want to see if the field name exists in the table, if it does not, then I want to hide it.

As an example, I want to show this field in red because the name exists in the table above. Has anyone solved this before? Any help would be much appreciated!

[ConorWebb96]

Hey @vaishnaray,

So in this case you only want likelihood to appear in the table when this is checked is that correct?

This will require filtering of the table's data provider. Hopefully you have the table and picker nested in 2 different data providers. Otherwise when you select the pickers option it will only show the one selected in the picker as well.

In the above screenshot this is how i've configured my components in the component tree. Additionally you will notice that there are 2 different data providers both are loading the same table. (You could do this with the custom option's source if you know the options, it will eliminate an extra data provider thus improving performance.)

The filter itself you will use your form thats the parent of both data providers and then select your options picker's value to be used as the binding that it checks against. (In my case im using the field gender to run this, in your case it would be label_name)

Output

I hope all of this makes sense and is helpful for you.

[vaishnaray]

Thank you! It's the other way. I want the likelihood field to show since likelihood is in the table and I want it hidden if it's not in the table. I'm not trying to filter the table, but rather show the options picker if it exists in the table.