Is there a way to search across all fields I specify?

Ask for Help
1

I’d like to be able to find Purchase Order records from my sheet by several search fields so I can edit them.
Search Box - I want to type in either Name, PO Number, Amount Paid, item description, etc.
and have Glide provide the records meeting that search criteria.

Possible?

2

Yes. Turn on the search bar for that inline list and those records will appear. Make sure, all those records are stored in that sheet in different columns.

3

The search bar should work individually with each field, but if you have an item with the name “Glide” and the “PO Number” being 1234, then what I expect is:

  • “Glide” search term works
  • “1234” search term works
  • “Glide 1234” doesn’t work, unless you concatenate everything into a template column and display that in the details view of the item
1 Like
4

Thanks a lot for the details here. I have been trying to make partial multiple search work but cannot find a solution.

In the example above, where we have Glide and 1234 in two different columns, I would like to pick the item, even if I only search for “Gli 123” or “Glide 1” or “123 Gl”. Is there a special formatting I can use to instruct Glide to realize multiple partial searches at once? Like two text strings should be considered individually?
My use case is “first name” and “last name” where I’d like to find “Joseph Karam” by typing “Kar Jo” or “Joseph Ka” or “Karam J”.

Thanks