User Variables in Glide Page Without Login

[anthonygusmao]

Hi Glide Fam! First of all I would like to express my gratitude for being part of this community. Glide changed my career for the better!

I’m creating a map directory of Coaches around the world. I’m using Glide Pages with a Map component. The page is set to public.

Coaches Map

My challenge right now is: I need to create different filters for coach level, specialisation, audience, sport, etc. Also, I would like the search to return all the results that are within a 50 miles distance of the place searched. But I’m feeling lost on how to accomplish this. Is it even possible to use user-specific variables with a public page? How do I set it up to make work?

Thank you so much!

[Uzo]

yes USC works in any setting, you can get distance from two locations latitude and longitude.

[anthonygusmao]

Thanks for the reply Uzo!

How do I set up my users spreadsheets to make USC work? I’m having a hard time trying to use a choice component to write into the users spreadsheet, when I do so, the component disappears or does not work properly.

[Uzo]

is hard to tell without seeing your app… to make the column user-specific, you need to checkmark that option when creating a column… when you are writing values to the USC column, keep in mind, that value is only visible to that specific user… you need to be login as that user or in the editor view as that user…

[ThinhDinh]

@anthonygusmao

I need to create different filters for coach level, specialisation, audience, sport, etc.

Multi Filters using Relations: a new way

Thanks so much for this “tutorial” to solve an important challenge! For my own records, to save time next time I want to create multi-filters like these, I’ve created this short step-by-step document on creating “AND” multi-filters using your method. I share it here in case it may be useful to others:

@anthonygusmao

I would like the search to return all the results that are within a 50 miles distance of the place searched.

This will be hard, but I think what you can do is have a text entry writing to a user-specific column, then geocode the entry, and pitch that coordinates against all your existing data to find the distance, and filter out only ones that are within 50 miles.

[anthonygusmao]

@ThinhDinh and @Uzo , thanks for the help!

My challenge is not on creating the filters. My challenge is that my page is public, with no required login and it seems like I can’t store visitors input in a User Specific Column.

Page settings

I created this spreadsheet to store the value in the text field when visitors are searching

When I select the above spreadsheet as the users table, it shows none:

When I add a text entry field writing into the User Specific Column “searchKey” it does not work.

So, my question is: can I have user specific columns for visitors on a page that does not have login?

[Jeff_Hager]

User specific columns work on any table. I would almost never use user specific columns in a user profile table because each row is already specific to a user. In your case you can’t use a user profile table to store values, since it’s a public app, but you can place user specific columns in any other table where appropriate to get the functionality you need.

[Uzo]

You are using Pages… I do not have experience with pages… in Apps, you can do that… pages are very limited that’s why I do not bother to dive into it.