I would like to search and filter an entire repeating group by what I type into an input or search field. I have been able to get it to work by filtering the repeating group for “any field” that contains the input. The only thing it won’t search is the “thing” that I have l linked to my database.
For Example:
The Invoice database have the following fields with the corresponding data types in parentheses:
Invoice No. (number field) Vendor. (vendor) Date (date) Billed (number)
The Vendor field has the following fields:
Vendor Name. Vendor Address Vendor Phone Number
When I search the Invoice data base I would like to search and filter by any field including Vendor name. Is this possible or is there a work around?
Thanks!