Hi everyone,
I have a Glide Big Table, I store multiple user IDs in a single column (sometimes more than two). I then use Split Text, Relations, and Lookup columns for various purposes. However, I’m struggling with the filtering part — I want to display and filter these users separately in the built-in filters of the Table or Inline List component.
Right now, the filter seems to treat them as one combined value instead of separate users. Is it possible to make them appear and filter individually? If so, I’d really appreciate it if someone could guide me on how to achieve this.
In normal Glide Table I can perform same task with straightforward lookup through relation, but in big tables how to achieve same thing?
Any help would be a great support. Thanks in advance!
I’m not sure if it works differently for Glide Big Tables, but in a Glide Table, I added another column to ‘Make Array’ of my Split List (in your case, ‘Make Array’ of the User Split ID) and then used the Array field to filter on. It then shows the items one by one in the Filter.
No computed columns, only user ID and split user ID appears for the filtering. Everything else looks impossible in big tables, its so frustrating.
I’ve encountered several limitations while working with Glide’s Big Tables that are making development more time-consuming and, in some cases, seemingly impossible—especially when compared to the flexibility of standard Glide Tables.
I’m currently developing a task management app using Big Tables. In my setup, I have a column where multiple user IDs (For single user id’s it works) are stored for tasks assigned to more than one user. However, I’ve noticed that I cannot filter data using the default filter action, nor can I search through the default search box when referencing this column. This severely limits the usability of the collected data within Big Tables.
Here’s what I’ve tried:
I split the user ID column to create multiple values.
I created a relation from the split values to the user ID column in the Users table.
I used a lookup column to retrieve and display user names in the frontend.
Despite this setup, the lookup results can’t be used in filtering or searching. I also tried using a template column and a joined list column to make the data searchable or filterable, but nothing seems to work—even for date columns, I’m facing similar restrictions.
Am I doing something wrong, or are these limitations just part of how Big Tables currently function? I’d really appreciate any suggested workarounds for this situation.
