Sort Data by Distance

Ask for Help
1

hello everyone,
I’m having troubles with sort data by distance between current location and restaurant/business around me.

I saw a few similar topics but was like 6 years ago, not sure if Glide Team already add a way to sort data like that?

I don’t need the current location to be updated everysingle moment, my idea is when you enter the app you click a button and then your location is saved and you can see the places sort by how close you’re from them.

I did the computed columns and it “works” but I cannot select a computed colum to sort data :(.

Any idea? Thanks so much

2

Is your table a Glide Big Table or a regular Glide Table? Sorting shouldn’t be a problem with a regular Glide Table, but I could see it being an issue with a Glide Big Table since it can’t have all data loaded at one time to calculate the distance.

1 Like
3

If the issue is indeed related to to using a Glide Big Table, I wonder if you could get around that by using a separate single-row table and Query column filter and sort the results. In effect, you would be filtering and sorting in the data editor instead of the layout editor.

4

Doubt it since the distance column is still a computed column that needs to calculate on every row before even considering sorting. Big Tables don’t retrieve every row at once and the distance calculation does not happen server side. Still the same issue with Big Tables.

2 Likes
5

Correct.

2 Likes