Hi, I have calculated the distance within a distance column in a non-User table. I wanted to use this within a filter on the layout to show the results of a user search. The location will only appear if it’s under a certain distance. However it seems only basic columns are allowed to be referenced in filters in non-User tables.
The other way I thought to solve this would be to create a brand new table based on the results that only show under this distance, but an error occured saying the relation can’t be made.
Does anyone have any suggestions for how I can do this?
I think it is yes actually. Now that you mention it I’ve dug around in the docs and found that it shows Query on some columns and that’s a big table. It’s not my project you see so I didn’t think of it immediately. I noticed the icon for the table is different. It’s like the traditional one for a database than with the glide symbol. And I did notice a row count. I don’t use big tables so are all of these features of Big tables? If so, will just creating another normal glide table with the same data solve my problem?
Yes, it sounds like you have a big table.
A regular Glide Table should work as you expect. Big Tables have several restrictions when it comes to using computed columns.
Ok thanks. I’ll try and recreate that table as a normal table and see thanks
Thanks. It was the big table. Recreated everything and it worked immediately.