Public App / Component's visibility based on user

Is there a way to manipulate a component’s visibility in a public app without requiring anything more than a phone number from the user?

Using “public with email” is out of the question for my client so I was hoping to use a “row id” column and enable user profiles to make a form appear to anyone whose phone number is empty but it either doesn’t work that way or I have overlooked something.

Make a user-specific column to store those phone numbers, because if you don’t want to record emails then it doesn’t make sense to have a user profiles setup I think.

Let the user write an entry to that column. Show components based on phone number is not empty. However when they close the app and open it again they have to retype the number if they want to see things.

So my issue is that my phone column was created in google sheets and not as a user specific column in glide!?

If you create it in the Sheets, then every new entry via the form will be a new row. With a user-specific column you can get it done with 1 row.

This is kinda close … maybe … it may give you an idea what @ThinhDinh is saying …

1 Like

I’m probably not doing a good enough job of explaining.

My app is a waiting list for my County’s probate office. We have 4 locations with 1 supervisor at each location managing the waiting list and a single admin over the entire app.

I’m trying to allow Joe Smith to open the app and enter his phone number as an agreement to terms, then choose 1 of the 4 locations and choose wether he would like to be called or texted when he’s next in line.

I’m also needing each supervisor and the admin to log in and have a user profile (with email).

I’m not fully wrapping my head around how the single row for ALL users (minus the ones that manually log in) works when submitting a form to join the line of a single location.

I have 4 supervisors and an admin that need to log in with email addresses and the general public that won’t need to log in. Is that possible?

I can’t seem to pull the user’s phone number into the form when they choose a location.

So set up a user profiles sheet for that, prepopulate it with an email column and a type column (Supervisors or Admin). When they login via the left menu panel, they will see what only they can see based on their user type.

For the phone number, make the user-specific column as I said, then show the form when number is not empty. In the form, catch all other pieces of info you need, get the number in via a Columns component.


Trying now! Literally just started that on my own. I’m used to working off of one users sheet so this is new territory!!

1 Like

Let me know if I can help :wink:

1 Like