I am not sure what happened, I had a perfectly working app (albeit on the OG style, not the new style, yet) I will transition over, after I get this issue resolved, and app working 100% again
APP has data from multiple spreadsheets, that I want to create a search screen, that searches all sheets (I think there are 12 or 15 of them)
The search would be across all the fields for same SKU or description data. There will be multiple options to choose from, from the various sheets. (I would like the sheet label to be visible to chooses which data is needed )
I don’t understand how it quit working, over the weekend.
I only see one list on your screen, and your screen is using a list style layout. At most you can search only the one table that the screen is attached to. To be able to search multiple tables, you would have to use a Detail style layout and add lists for each table that you want to search. Are you sure that you didn’t change the screen layout over the weekend? A Detail style layout with multiple lists is the only possible way that you would have been able to have a global search across multiple tables.
That’s not possible.
The closest you can get to a global search is by following the method that Jeff outlined.
You can effectively get the same thing by adding as many inline lists as you need, and set the source of each inline list to a different sheet/table.