# User Profiles & User Specific Columns

**URL:** https://community.glideapps.com/t/user-profiles-user-specific-columns/9921
**Category:** Community Resources
**Created:** [May 28, 2020, 6:25am UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921 "2020-05-28T06:25:15Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [May 28, 2020, 6:25am UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/1 "2020-05-28T06:25:15Z")

</div>

We’ve had user profiles & user specific columns for a little while now, but I just finished a couple of new tutorials on them. They are really powerful so if you’re not sure what they are about - check out the videos below. 🙂

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/faf4c9f395a26207fb46809dfa83dc9f45eb718e.jpeg "Create User Profiles | Glide Apps Tutorial | No Code Tutorial") ](https://www.youtube.com/watch?v=5lQdJn-bHto)

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a0d8a6edf9ca9a2c288a5057e0e590528f32bd3.jpeg "Unlock Personalized Data with User Specific Columns | Glide App Tutorial") ](https://www.youtube.com/watch?v=PK5eovZGne0)

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [May 28, 2020, 7:06am UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/2 "2020-05-28T07:06:09Z")

</div>

Top @JackVaughan 👍🏻

---

<div class="post-metadata">

### Author: ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)
#### Post date: [May 28, 2020, 4:55pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/3 "2020-05-28T16:55:22Z")

</div>

Great tutorials.  
I’m beginning an app that has several hundred users with different levels, so I’ll be using this feature quite heavily!

---

<div class="post-metadata">

### Author: ![Kevyn\_Levine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kevyn_levine/32/7902_2.png) [@Kevyn\_Levine](https://community.glideapps.com/u/Kevyn_Levine)
#### Post date: [May 28, 2020, 4:58pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/4 "2020-05-28T16:58:29Z")

</div>

@JackVaughan thanks for this! Does the user specific column setting for checkbox relate to some other identifier that I can make a relation to?

---

<div class="post-metadata">

### Author: ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [May 29, 2020, 4:57pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/5 "2020-05-29T16:57:57Z")

</div>

Hey Kevyn, sorry I’m not totally sure what you mean. What are you trying to do?

---

<div class="post-metadata">

### Author: ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)
#### Post date: [June 2, 2020, 2:49pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/6 "2020-06-02T14:49:11Z")

</div>

Hi Jack,

I have an issue with the user profile which makes me go banana soon…

When a user is logged in to the app his email appear automatically in the user tab in the data on glide but is not going to the users sheet in the Google sheets file.  
It’s even worth, when I edit the users data (i.e. adding info like name, image and other fields) it’s being written to the data ok but not going to sheet at all.  
Even worth, to test it, I’ve created a form to the same sheet and when submitting it, again the data is written in the data duplicating the user (his email appears twice) but the new row is not being added to the sheet.

Is this the expected behavior?

---

<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: [June 2, 2020, 3:17pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/7 "2020-06-02T15:17:20Z")

</div>

Did you scroll down to the bottom if the sheet? Are you using arrayformulas?

---

<div class="post-metadata">

### Author: ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)
#### Post date: [June 2, 2020, 4:09pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/8 "2020-06-02T16:09:40Z")

</div>

Yes. it was not there. yes to Arrayformula.  
what I did now is actually delete all users data, then re-enter it and delete all empty rows and it works now so go fegure. Thanks for the help brother

---

<div class="post-metadata">

### Author: ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [June 2, 2020, 5:42pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/9 "2020-06-02T17:42:16Z")

</div>

Glad it’s sorted. Let us know if you experience it again and please record a video if poss.

---

<div class="post-metadata">

### Author: ![M\_Rom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m_rom/32/340_2.png) [@M\_Rom](https://community.glideapps.com/u/M_Rom)
#### Post date: [June 2, 2020, 6:56pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/10 "2020-06-02T18:56:50Z")

</div>

Hi Jack, thanks for the videos, very helpful.  
I’m still very new to Glide but extremely impressed with the work you’ve done, thank you for all of your work! It’s proving to be exactly what we need as an MVP for the startup I’m working on getting going on increasing access to healthcare in Cote d’Ivoire.  
I’ve actually had a similar experience to what yinon\_raviv has experienced (if I understand correctly). One of the apps I’m working on is supposed to allow individuals to pre-screen themselves for COVID-19. However, when I’ve tested adding a new “pre-screening” it appears in the spreadsheet with hundreds of rows between it and the previous pre-screening which also means it doesn’t appear in the application as having been filled out. Has happened multiple times and not sure what’s causing it. Any thoughts on how to prevent this from happening?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 2, 2020, 10:01pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/11 "2020-06-02T22:01:12Z")

</div>

You can delete all the empty rows from that sheet and try adding a new record again.

---

<div class="post-metadata">

### Author: ![M\_Rom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m_rom/32/340_2.png) [@M\_Rom](https://community.glideapps.com/u/M_Rom)
#### Post date: [June 3, 2020, 9:57am UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/12 "2020-06-03T09:57:33Z")

</div>

Hi ThinhDinh,

That has worked as a temporary fix but seems to be repeating when I try to add a new entry. Thoughts on how to prevent it from occurring?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 3, 2020, 10:09am UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/13 "2020-06-03T10:09:52Z")

</div>

Did you delete all the empty rows? Let’s say I have row 1 as header, row 2 as the first entry. If you have empty rows it will write to write 501 or 1001, something like that. Normally when I keep it to just the rows where I have data and nothing else, it works.

Or it has something to do with your formulas. If you can share the formulas you used for that sheet it would help.

---

<div class="post-metadata">

### Author: ![M\_Rom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m_rom/32/340_2.png) [@M\_Rom](https://community.glideapps.com/u/M_Rom)
#### Post date: [June 3, 2020, 10:19am UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/14 "2020-06-03T10:19:01Z")

</div>

Yes, I deleted all of the empty rows and still seem to be having the problem.

Currently, the only formulas I have in the sheet are standard array formulas checking to see if other data points exist and then either calculating Age or resulting in a “0” or “1”.  
Ex: =ARRAYFORMULA(IF(LEN(A2:A) = 0, “”,"" & IF(E2:E = “”, “”, DATEDIF(E2:E, TODAY(), “Y”))))  
The other formulas are almost identical.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 3, 2020, 10:36am UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/15 "2020-06-03T10:36:59Z")

</div>

Can you try changing the checking of data points to.

```
IF(A2:A<>"",...)

```

instead of using LEN?

I don’t know if it’s the source of the problem, just want to try a new approach without changing the output of your sheet.

---

<div class="post-metadata">

### Author: ![M\_Rom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m_rom/32/340_2.png) [@M\_Rom](https://community.glideapps.com/u/M_Rom)
#### Post date: [June 3, 2020, 2:00pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/16 "2020-06-03T14:00:55Z")

</div>

Thanks for working through that with me ThingDinh!

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 3, 2020, 2:04pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/17 "2020-06-03T14:04:44Z")

</div>

No worries Mario, if you need me to help again just leave a message!

---

<div class="post-metadata">

### Author: ![Kishan](https://avatars.discourse-cdn.com/v4/letter/k/e95f7d/32.png) [@Kishan](https://community.glideapps.com/u/Kishan)
#### Post date: [June 21, 2020, 3:48am UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/18 "2020-06-21T03:48:26Z")

</div>

Hi, I am following this video ([https://www.youtube.com/watch?v=B8ivh42ZqVA](https://www.youtube.com/watch?v=B8ivh42ZqVA)) to create user profiles, first by asking few details and then changing visibility to show a welcome screen.  
The problem is I dont see a **filter rows by signed-in user** option as shown at 19:44 in the video. If I continue to skip this, I happen to receive new user data into my google sheet but the visibility conditions dont work. [https://testingcoach.glideapp.io/](https://testingcoach.glideapp.io/)

---

<div class="post-metadata">

### Author: ![Biboy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biboy/32/9295_2.png) [@Biboy](https://community.glideapps.com/u/Biboy)
#### Post date: [June 21, 2020, 3:56am UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/20 "2020-06-21T03:56:53Z")

</div>

Nice! I love how you executed the review section will try this approach as well on my app great idea!

---

<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: [June 26, 2020, 10:26pm UTC](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921/21 "2020-06-26T22:26:09Z")

</div>

That’s an old video (by Glide standards). The filter by signed in user was moved to the Filter option awhile back.

[Next page](https://community.glideapps.com/t/user-profiles-user-specific-columns/9921.md?page=2)
