# 🙋‍♀️ 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:** 4

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 6, 2020, 1:24pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/62 "2020-05-06T13:24:13Z")

</div>

You need to set up user Profiles in your app.

[https://docs.glideapps.com/all/reference/privacy-and-per-user-data/user-profiles](https://docs.glideapps.com/all/reference/privacy-and-per-user-data/user-profiles)

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [May 6, 2020, 1:41pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/63 "2020-05-06T13:41:31Z")

</div>

I set a sign in with email

---

<div class="post-metadata">

**Author:** ![Alex\_Wuerth](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_wuerth/32/180_2.png) [@Alex\_Wuerth](https://community.glideapps.com/u/Alex_Wuerth)\
**Post date:** [May 6, 2020, 4:12pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/64 "2020-05-06T16:12:46Z")

</div>

Thank you Mark!!

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [May 6, 2020, 7:17pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/65 "2020-05-06T19:17:19Z")

</div>

Is there a way to push the user profile data while filling a new form automatically? Just the way the User-email ID can be captured as a special value. This would help a lot! Specifically incase of dynamic values in the user profile form  
My use-case is where I want to capture the entry number which the user has done. In the user profiles, this number is a rollup field which counts his entries so it keeps increasing. I want to capture this number and push it while doing an entry.  
Currently it’s possible only if the open form button is on the user profile tab.

---

<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:** [May 6, 2020, 8:00pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/66 "2020-05-06T20:00:13Z")

</div>

Hm…haven’t tested this. Rollups columns don’t display in a user profile template column?

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [May 6, 2020, 8:07pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/67 "2020-05-06T20:07:38Z")

</div>

What I meant to say is, can we have a special field just like user’s email ID to capture other things from user profile on form submission. More special entry fields which includes data from user profile.

---

<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:** [May 6, 2020, 8:37pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/68 "2020-05-06T20:37:37Z")

</div>

Right. My thought is if you create the column first using template \> user profile column, then you could pass the value using the “columns” feature. So, can you create a template column that inserts a Rollup column from the user profile sheet?

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [May 6, 2020, 8:41pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/69 "2020-05-06T20:41:19Z")

</div>

Yes right. But I can pass the “columns” value only if I the form is on a tab which has the rollup column. If there’s another tab where I want to fill a form, I would probably have to create these rollup columns again in the data editor. Was thinking if Glide team could add the User profile fields as special entry components on form submission.

---

<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:** [May 6, 2020, 8:46pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/70 "2020-05-06T20:46:47Z")

</div>

> [@Manan\_Mehta](#):
>
> But I can pass the “columns” value only if I the form is on a tab which has the rollup column. If there’s another tab where I want to fill a form, I would probably have to create these rollup columns again in the data editor

Not necessarily recreate, but insert, yes. If my form is on a “listings” tab. [I can insert any user profile column into that tab using a template column](https://community.glideapps.com/t/insert-user-data-anywhere-in-your-app/8460). I haven’t tested a Rollup column. Is it available? If so, it would only be one additional column in your “listings” tab to pass the value automatically.

Though, yes, I see the appeal of having the convenience of having this info as a special value!

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [May 6, 2020, 8:49pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/71 "2020-05-06T20:49:13Z")

</div>

Yes I understand what you have shared. Let me try it with the rollup column and get back to you.  
I think I should create a feature request for the special entry field.

---

<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:** [May 6, 2020, 8:58pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/72 "2020-05-06T20:58:58Z")

</div>

Thanks @Mark, saw you’ve released this, thought it wasn’t too far away! You guys rock 🤟

---

<div class="post-metadata">

**Author:** ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)\
**Post date:** [May 8, 2020, 11:34am UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/73 "2020-05-08T11:34:30Z")

</div>

I have a similar request indeed.  
In my use case a user has a challenge ID in their profile.  
On the challenge sheet they log their proces so I’d like user profile columns available as special value ones (just like the email address currently).

–\> Is that something similar to what you are referring too? @Manan_Mehta?

(btw lookup won’t do it in the challenge post table, because the post belongs to the challenge, not to the challenge the user is currently in)  
I’ve currently solved it with a Google Script,… but a Glide solution is always preferred over Scripting. 😃

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 8, 2020, 12:12pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/74 "2020-05-08T12:12:14Z")

</div>

@Naos_Wilbrink couldn’t you create a template column with the user’s ID in the challenge sheet and pass that template into the form as column value? That’s what @Robert_Petitto mentioned above.

---

<div class="post-metadata">

**Author:** ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)\
**Post date:** [May 8, 2020, 12:20pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/75 "2020-05-08T12:20:50Z")

</div>

I’ve tried a few different things,…  
Doesn’t this mean though that when the user changes his / her challenge id in their profile this will change the value in the challenge sheet. And I need the value in the challenge sheet to not change when the user value changes.  
–\> Maybe I’m not ‘getting’ something. I’ll give it a go.

---

<div class="post-metadata">

**Author:** ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)\
**Post date:** [May 8, 2020, 12:37pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/76 "2020-05-08T12:37:02Z")

</div>

Thanks @Jeff_Hager & @Robert_Petitto’s video [Insert User Data ANYWHERE in your App!](https://community.glideapps.com/t/insert-user-data-anywhere-in-your-app/8460/6)

I see what you mean now,… So these value should then also be available in a form,… therefore it works. pretty neat.

THIS IS AMAZING 😃 A whole world just opened up.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 8, 2020, 12:59pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/77 "2020-05-08T12:59:55Z")

</div>

Yes it will dynamically change based on the current user and their current ID.

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [May 8, 2020, 1:39pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/78 "2020-05-08T13:39:46Z")

</div>

Yes this is exactly what I meant. It can be done by some workarounds but it would be so much simpler if we could push user data on form submission!

---

<div class="post-metadata">

**Author:** ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)\
**Post date:** [May 8, 2020, 5:55pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/79 "2020-05-08T17:55:17Z")

</div>

Great step towards Access Control use cases.

---

<div class="post-metadata">

**Author:** ![Alex\_Wuerth](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_wuerth/32/180_2.png) [@Alex\_Wuerth](https://community.glideapps.com/u/Alex_Wuerth)\
**Post date:** [May 13, 2020, 2:02am UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/80 "2020-05-13T02:02:45Z")

</div>

Hi Mark,  
Did this get fixed today? Its been causing lot of glitches in our app and I am looking forward to the fix!  
Thank you!  
Alex

---

<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:** [May 13, 2020, 2:05am UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/81 "2020-05-13T02:05:47Z")

</div>

This should be fixed. Are you still seeing it?

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

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