I have built a search for my repeating group but its getting complicated. It works but there must be a better way. I have 4 fields that can be searched. You can search as many as you want to. There are 15 possible search combinations (I think). Is there a way to build this that doesn’t require 15 different combinations? The data consists of financial transactions. The fields being searched can be: Payee - text Date - will be a range Bank - text Category - text I’m aware of the search any field but that can give me unwanted results. Also, I prefer to have each search provide instant results as they are being searched - as opposed to asking user to pick the ones they want then hit search. And I want everything presented when there is no search.

OK finally got it. Here is what I had to do. On page open set the custom state for accounts to be all of them. Then as the search changes I update that state. If the multisearch box is empty I put the state back to all accounts. Thanks eli and SerPounce for helping me think through this. Just goes to show there is an answer out there if you poke at it long enough.

Better way to search RGs

Need help

Topic		Replies	Views
One Search; Multiple Two Repeating Groups Questions	4	369	September 6, 2020
Search Filter in repeating group Need help	16	2975	August 29, 2018
Repeating group filtering from a custom state's selection list Need help	12	6571	March 26, 2021
How to Search Any Text in Repeating Group? Need help	1	342	November 25, 2022
Search with multiple fields Need help	4	1838	August 5, 2020

Better way to search RGs

Related topics