I have a repeating group where a user may have selected/stored several items in a multi-drop down field. I would like to create a filter (via standard dropdown) that will return any one of those items.
For example, let’s say I have a form with a multi-dropdown field where the user can select any number of colors ranging from blue, green, red, yellow, etc. Once those values are saved to the database I would like a separate dropdown filter where the user can select only ONE of those colors, and all records where that color was selected will show.
What’s the best way to do this?
If you want to load the values to the database first (as you suggest) then on the 2nd dropdown, simply reference the dropdown values dynamically.
Alternatively, you could store the selected colors as a state (e.g., page’s list-of-colors). Then in the 2nd dropdown, include the page’s list-of-colors as the dynamic value choices.
What I need is 2 separate actions. I have a form on the page that accepts the values and instantly displays them in the repeating group below. Then, on the left, I have filters set up.
In the screenshot below - the field in question is the ‘job type’ - when the user clicks the ‘Add Client’ button, a popup with the form appears. One of the fields is a multi-select field where the user can select the types of jobs they will accept from the client - there can be up to 20. When they save the form, the data appears in the repeating group below. Using the ‘job types’ filter on the left, I want them to be able to select any one of the job types they previously indicated, and all clients with those kinds of jobs appears in the repeating group.
