How to Make Related Values Searchable in Big Table

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!

1 Like

This seems like a limitation with Big Tables and how they do calculations with it. This has been brought up before in the forum, but no changes thus far.

This is not an exhaustive list, but should give you an idea on what features are limited.