# 🙋‍♀️ User Profile columns in conditions and columns

**URL:** https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093
**Category:** General
**Created:** [April 29, 2020, 2:51pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093 "2020-04-29T14:51:48Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 29, 2020, 2:51pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/1 "2020-04-29T14:51:48Z")

</div>

If you’re using [User Profiles](https://docs.glideapps.com/all/reference/privacy-and-per-user-data/user-profiles), you can now use columns from the currently signed-in user in visibility conditions as well as in computed columns in the Data Editor.

Here’s an example where we enable the Edit screen only if the signed-in user is an “editor”:

 ![2020-04-29 07.47.10](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0d4e3a8bbb4c29ad55b215e9ade3ad1285a247f6.gif)

You can read more about it [in our docs](https://docs.glideapps.com/all/reference/privacy-and-per-user-data/user-profiles).

As always, we love to hear your feedback!

---

<div class="post-metadata">

### Author: ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)
#### Post date: [April 29, 2020, 3:23pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/2 "2020-04-29T15:23:16Z")

</div>

Nice! I can see this making so many options far easier to implement.

---

<div class="post-metadata">

### Author: ![McJagger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjagger/32/18616_2.png) [@McJagger](https://community.glideapps.com/u/McJagger)
#### Post date: [April 29, 2020, 3:26pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/3 "2020-04-29T15:26:23Z")

</div>

Love it! Especially the premium user idea. This will be very helpful.

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 29, 2020, 3:35pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/4 "2020-04-29T15:35:31Z")

</div>

Neat…so basically, this saves app developers the trouble of creating this functionality using the good ol’ relation/lookup/is signed in user combo?

---

<div class="post-metadata">

### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 29, 2020, 3:43pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/5 "2020-04-29T15:43:19Z")

</div>

Yes, what used to require ugly hacks at best is now easy.

---

<div class="post-metadata">

### Author: ![Aristide\_Salvatore](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aristide_salvatore/32/5099_2.png) [@Aristide\_Salvatore](https://community.glideapps.com/u/Aristide_Salvatore)
#### Post date: [April 29, 2020, 3:58pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/6 "2020-04-29T15:58:38Z")

</div>

Greatt!!!1

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 29, 2020, 4:01pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/7 "2020-04-29T16:01:17Z")

</div>

Nice! I like the flexibility of it all.

**Use case:**  
In a form/edit screen, I like to use visibility settings to show/hide components based on other values the user has already filled out/selected. For example, I could hide a choice component once the user selected an option…but that means the user couldn’t change their mind once they selected it.

Now they can, I can point to the user profile column rather than the identical sheet column to keep the choice component visible until the value actually writes to the sheet.

 ![Screen_Shot_2020-04-29_at_11_46_29_AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d11e0bfda5e7a1847d8bddce44d6e51212352d66.png)

**Proof of concept:**

 ![ScreenFlow](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3f44cc88d7cdff14e73ddcca27eea93a002ecd17.gif)

---

<div class="post-metadata">

### Author: ![Mrinal\_Chakraborty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrinal_chakraborty/32/5239_2.png) [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)
#### Post date: [April 29, 2020, 5:33pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/8 "2020-04-29T17:33:42Z")

</div>

Great ! It will certainly reduce number of column and relations.

---

<div class="post-metadata">

### Author: ![Ben\_Reynolds](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben_reynolds/32/4638_2.png) [@Ben\_Reynolds](https://community.glideapps.com/u/Ben_Reynolds)
#### Post date: [April 29, 2020, 5:45pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/9 "2020-04-29T17:45:25Z")

</div>

Hey Robert!

I love what you are doing here! I am curious, when I have set up my user profiles to a sheet, I am getting repeating data every time a user logs in. like the app:logins and and user profiles sheet have become one. No matter what sheet I use and what app I have enabled this for, this is the behavior I see. Are you seeing this same behavior when using the user profiles?

We had an exchange about this in another thread, but I am trying to understand how others are dealing with this weird duplication of users issue.

---

<div class="post-metadata">

### Author: ![Mrinal\_Chakraborty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrinal_chakraborty/32/5239_2.png) [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)
#### Post date: [April 29, 2020, 6:09pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/10 "2020-04-29T18:09:13Z")

</div>

Yes this is correct. When you are using user profile option, every time a new user log in one new line will be added automatically and this will eat your row count, which is not favourable for free user under 500 row limit.

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 29, 2020, 6:40pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/11 "2020-04-29T18:40:41Z")

</div>

Hi Ben,

With User Profiles enabled, you’ll still get new rows in App: Logins. Glide has mentioned that they might eventually phase this out. There’s no longer any need, though, to reference this sheet with Unique formulas or scripts, etc.

---

<div class="post-metadata">

### Author: ![louisdv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/louisdv/32/5723_2.png) [@louisdv](https://community.glideapps.com/u/louisdv)
#### Post date: [April 29, 2020, 6:51pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/12 "2020-04-29T18:51:15Z")

</div>

Whaou, that’s great! You are shipping really fast new features, but that also mean I need to re-make all my current app now 😅

---

<div class="post-metadata">

### Author: ![Ben\_Reynolds](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben_reynolds/32/4638_2.png) [@Ben\_Reynolds](https://community.glideapps.com/u/Ben_Reynolds)
#### Post date: [April 29, 2020, 8:26pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/13 "2020-04-29T20:26:31Z")

</div>

Hi Robert,

Thanks fore the quick reply. I apologize. I must not be explaining my situation well. I think that logging individual logins in a separate sheet like app:logins is still fine. The situation I am facing is that the sheet I set as the table to store users in the “User Profile” settings is not only recording each user once, but every single time the user logins in. Like you would expect to see in the app:logins sheet, but not a user profile table.

In this screenshot, every “b” email and “g” email are the same users being logged to the sheet I have set up as my profile sheet.

 ![Screenshot 2020-04-29 at 2.16.38 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/16c990860fa6c65c1eb3314d6d263483a42c5b4b.png)

---

<div class="post-metadata">

### Author: ![Dan\_Liebeschutz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_liebeschutz/32/3393_2.png) [@Dan\_Liebeschutz](https://community.glideapps.com/u/Dan_Liebeschutz)
#### Post date: [April 29, 2020, 8:34pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/14 "2020-04-29T20:34:58Z")

</div>

This is amazing!

Can you please add the timestamp of the first login as a column in the profiles sheet? Like there is a timestamp in the App:Login. I’m now using a workaround with google apps script because it helps in users data analytics.

---

<div class="post-metadata">

### Author: ![George\_Lewis1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_lewis1/32/5517_2.png) [@George\_Lewis1](https://community.glideapps.com/u/George_Lewis1)
#### Post date: [April 29, 2020, 8:53pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/15 "2020-04-29T20:53:10Z")

</div>

Haha this is awesome, this makes my life easier! Well done guys 😃

---

<div class="post-metadata">

### Author: ![George\_Lewis1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_lewis1/32/5517_2.png) [@George\_Lewis1](https://community.glideapps.com/u/George_Lewis1)
#### Post date: [April 29, 2020, 9:19pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/16 "2020-04-29T21:19:39Z")

</div>

Hi, with the new functionality, is there a way to bring the ‘signed in user’ into the data editor? i.e. a ‘signed in user profile’ column, that you can then do lookups to bring in other user profile into the data editor on different sheets? I can do this with a workaround now, but would be great to use this functionality instead. Thanks

---

<div class="post-metadata">

### Author: ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [April 29, 2020, 10:13pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/17 "2020-04-29T22:13:14Z")

</div>

This would go so well with conditional tab visbility

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 29, 2020, 11:01pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/18 "2020-04-29T23:01:39Z")

</div>

Hm…yeah, that’s unexpected behavior. You don’t happen to have a script running in this sheet?

---

<div class="post-metadata">

### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 29, 2020, 11:49pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/19 "2020-04-29T23:49:47Z")

</div>

> [@George\_Lewis1](#):
>
> is there a way to bring the ‘signed in user’ into the data editor? i.e. a ‘signed in user profile’ column, that you can then do lookups to bring in other user profile into the data editor on different sheets?

Could you give an example of what you would do with that?

---

<div class="post-metadata">

### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 29, 2020, 11:50pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/20 "2020-04-29T23:50:18Z")

</div>

> [@Ben\_Reynolds](#):
>
> The situation I am facing is that the sheet I set as the table to store users in the “User Profile” settings is not only recording each user once, but every single time the user logins in. Like you would expect to see in the app:logins sheet, but not a user profile table.

@Ben_Reynolds could you share your app, please?

[Next page](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093.md?page=2)
