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?