I’m struggling to get the search functionality to work properly with Big Tables in Glide.
I have a simple setup: a Tasks table (Big Table) that has a relation to a Customers table. I want to be able to search for customer names that are associated with each task or work order. I’ve tried using Lookup, Joined List, and Single Value columns to bring in the customer name, but none of these seem to make the customer name searchable in the app.
Am I missing something, or is this a known limitation with Big Tables? It almost feels like Big Tables are only useful for storing data and not for dynamic features like search or filtering.
Also, even filtering using the default table component seems very limited or non-functional with Big Tables.
Would really appreciate if someone could share how they’re managing this or if there’s a workaround. Thanks!