You can do something like this:
- Create a separate single row table to drive your main search screen
- Add a RowID column, and a user specific text column to hold the search text.
- Then in every table that you want to search, add the following columns:
– A single value column that takes the value of the user specific column in your search table and applies it to all rows
– An if-then-else column that returnstruefor any row that matches.
– If you want to match several columns, then you’ll need a separate if-then-else column for each column to be matched, and then a final it-then-else column that returnstrueif any of the others are checked.
– Alternatively, you could create a template column that concatenates all the values in the columns that you want to match, and then use a single if-then-else column to compare to that. Either way will work. - In the layout on the search screen, you’ll need a text entry component to accept the search text, which should be targeted at the user specific column.
- You’ll then need a separate collection component for each table to be searched. Each collection should use a separate table as the source, and be filtered where the if-then-else matching column is checked.
- For navigation from the search results, the default action will be to show the details screen of the selected item. If instead you want to show the parent screen of the selected item, you’ll need to change that. What you’ll need depends how your screens/tabs are laid out, but it’ll probably be either a Go To Tab or Show Details Screen->Table action.