I need to create an app that filters data similar to excel. I have tried multiple ways of creating relations and it seems to only let me do exact matches. I need to select 3 values that then link back to 1 number.
Red House/Red Door/Blue Knob/1010
If I select Red House/ Red Door/Blue Knob the 4th dropdown should show only 1010 as a selection
Can anyone help?
Queries can match multiple items, but…are you applying filters to your choice components?
I have been using the relations function, but it only relates exact match. Where would I apply filters? I am not seeing that option.
A query column is is more powerful than a relation because it has built in filtering (although it runs a bit slower than a relation).
Are you talking about a query column or a choice component? The query column is self explanatory when you add it, but a choice component has filters in the right hand panel (Options tab) when the component is selected in the left hand panel. You can filter by Screen Values or whatever else.