Hi, it seems that I can only use the is/is not empty options when using a lookup column. Is there another way to do this?
Do you mean something like this?
Well not exactly. I want to do something similar but using a column with the userās first name.
Can you describe more about your use case using the userās first name instead of the email which will be unique?
I am trying to set the property to hide elements when the user hasnāt entered their first name, last name, workplace, and etc. I want to figure out how to do this with the first name column so I can apply it to the rest. I also I had problems with the relations. Whenever I related two sheets it only took as many rows as it could fit, versus taking all of the rows.
Just to confirm, are you setting your app to be a public or a public with email?
Have you set your relation to be single instead of multiple?
What do you mean by this? Do you have a screenshot?
Public with email
I figured out the row problem, but I still canāt get the filter to work.
Can you elaborate more on your āfilterā, or do you mean visibility?
Sorry I meant visibility.
So what logic do you want to use here for your visibility? Can you describe more about the flow?
Iām not sure that I did it correctly, but first I created a template column in the Computer Science Sheet with the value ātrueā. Then, I created a relation with the if-then-else column in the Sign-In Info Sheet. Finally, I created a lookup column that retrieved the first names.
So I take it you want to check if the signed-in user has filled in their first name or not?
That is correct
So what you can do is:
- Setup āUser profilesā for the app, using the āSign-in Info Sheetā
https://docs.glideapps.com/all/reference/privacy-and-per-user-data/user-profiles
- In the visibility condition, use the āUserā menu in the dropdown, point that to your āFirst nameā column and set visibility to āFirst nameā is not empty.
1 Like
Thank you so much!
1 Like