Search multiple data sources in glide?

Ask for Help
1

How can users implement a search function within a glide app that filters through multiple data sources simultaneously?

2

Assuming that by multiple data sources you mean multiple tables, you can implement a custom search.

At a high level, something like the following:

  • Create a single row table to serve as the source of your search screen
  • Add a RowID column to the table, and a user specific text column to hold the search input
  • In each table that you want to be searched, add two columns:
    – A single value column, that takes the value in search input column of the helper table, and applies it to all rows
    – An if-then-else column:
    — If column to be searched contains search term, then true
  • On your layout, add a text input component to accept the search term, and target it at the user specific column
  • Now add a separate collection for each table to be searched. On each one, filter it so that only rows where the if-then-else column is checked are shown.
1 Like