# Possible bug in Login/User profile

**URL:** <https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699>\
**Category:** Ask for Help\
**Created:** [March 15, 2022, 10:43pm UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699 "2022-03-15T22:43:18Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [March 15, 2022, 10:43pm UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/1 "2022-03-15T22:43:18Z")

</div>

Occasionally a new row with only users email is added at the bottom of the user profile (google sheet), which creates problem.

The user already exists in the user profile.  
Allow user to edit is not on.  
It is not a Google account.  
I have noticed in the App:Logins that the user has logged in several times within same hour.

What do you think?

---

<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:** [March 16, 2022, 12:26am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/2 "2022-03-16T00:26:34Z")

</div>

> [@Ralf](#):
>
> The user already exists in the user profile.

Was the original row added by Glide when the user logged in the first time or was it added by a Glide form?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 16, 2022, 12:48am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/3 "2022-03-16T00:48:46Z")

</div>

I saw this in one of my apps yesterday!

In my case, it’s a Google Sheet. I took a screen shot before I deleted the extra rows.

 ![Phantom User Rows](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e10cf7296c0a47c524b3c7ebf00f340563afb05b.png)

The names shown there (that’s the email column) are all duplicates of existing users.  
There are no formulas anywhere in the Google Sheet.  
I was trying to find a correlation between this and App: logins, but couldn’t see anything obvious. It’s a little difficult because these “phantom rows” have no timestamps.  
I also did a “Find all uses” on the email column. There is only one action in the whole app that adds a row to the table - when a new user is created (it’s a Private Pro app).

Weird, huh?

@Jeff_Hager any thoughts on this one?

---

<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:** [March 16, 2022, 4:59am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/4 "2022-03-16T04:59:55Z")

</div>

That is weird. My first though for @Ralf would be to double check to make sure that there are no other actions in the app that may be adding a row. Probably not the case here, but always good to double check.

My only other thought, is that I wonder if for some reason the data isn’t completely synced between glide and google when the user signs in, and for some reason glide didn’t know an existing row existed, so it created a new one.

Maybe a temporary glitch with the connection between glide and google??? I think I’ve seen some other post with people having issues signing in, but it didn’t seem to be widespread, so maybe something was going on.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 16, 2022, 5:13am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/5 "2022-03-16T05:13:37Z")

</div>

Yeah, it is weird. I’ve never seen anything like this before.

In my case, this is an app I built for a client and they went live with it a couple of weeks ago. Prior to going live, there was at least about a month of quite intensive testing and I never saw anything like this. And the app hasn’t been touched since they went live, so I was quite surprised to find this yesterday. The good news is that there didn’t appear to be any negative impact on the app performance, and there were no issues reported from users. Row Owners are applied to the User Profiles table, so I suspect these extra rows were just being ignored. I did a scan of the generated RowID’s, and couldn’t find them being referenced anywhere else.

> [@Jeff\_Hager](#):
>
> Maybe a temporary glitch with the connection between glide and google??? I think I’ve seen some other post with people having issues signing in, but it didn’t seem to be widespread, so maybe something was going on.

Yeah, that seems the most likely explanation. For now, I’'ve just removed the extra rows and will keep an eye on it for a few days.

Actually @Jeff_Hager - just another thought. In recent times I’ve been finding that occassionally when I open an app in the builder all data will load, _except_ for the User Profiles table, which remains empty. When this happens, I usually have to exit the app and then open it again and then it loads. Have you noticed this behaviour? I wonder if it’s related… 🤔

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [March 16, 2022, 5:19am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/6 "2022-03-16T05:19:45Z")

</div>

Was the original row added by Glide when the user logged in the first time or was it added by a Glide form?  
Yes, added from Glide!

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [March 16, 2022, 5:24am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/7 "2022-03-16T05:24:32Z")

</div>

> [@Darren\_Murphy](#):
>
> The good news is that there didn’t appear to be any negative impact on the app performance, and there were no issues reported from users.

It has also happened in an app where the user profile is an importrange array, which caused a disaster!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 16, 2022, 5:27am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/8 "2022-03-16T05:27:30Z")

</div>

> [@Ralf](#):
>
> It has also happened in an app where the user profile is an importrange array, which caused a disaster!

Yeah, that’s not good at all.  
I’m not sure if you do this, but when using importrange it’s always a good idea to keep your column headers static, and start the importrange from the second row. This helps to minimise the damage if the importrange ever breaks, as any Glide computed columns will remain intact.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [March 16, 2022, 5:54am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/9 "2022-03-16T05:54:42Z")

</div>

Could it be a strange user behaviour? In my case it has happened to two of my users several times!

---

<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:** [March 16, 2022, 11:26am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/10 "2022-03-16T11:26:22Z")

</div>

Hard to say. If you see a bunch of App: login records, then it’s possible that they were having problems signing into the app at the time, or something wasn’t working for them when they attempted to sign in. Might be worth reaching out to the users to see if they experienced any problems.

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [March 16, 2022, 2:15pm UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/11 "2022-03-16T14:15:03Z")

</div>

@Darren_Murphy and @Ralf

Could you share a copy of this app where we can see the same behavior? You can send it to you in private as we might need to copy them.

Also, you can delete any functionality that is not related to this issue.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [March 16, 2022, 3:06pm UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/12 "2022-03-16T15:06:48Z")

</div>

> [@Darren\_Murphy](#):
>
> I saw this in one of my apps yesterday!
> 
> In my case, it’s a Google Sheet. I took a screen shot before I deleted the extra rows.

@SantiagoPerez It is exactly the same problem as @Darren_Murphy’s, I think it is better that you collaborate with him!

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [March 16, 2022, 11:20pm UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/13 "2022-03-16T23:20:11Z")

</div>

Today same user for the 3rd time!  
Logged in days ago.

It is a simple members register. The user can see his own data and can do nothing but upload photo.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 17, 2022, 12:35am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/14 "2022-03-17T00:35:31Z")

</div>

@Ralf - is your app Private or Public?

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [March 17, 2022, 12:42am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/15 "2022-03-17T00:42:39Z")

</div>

Private!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 17, 2022, 12:47am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/16 "2022-03-17T00:47:27Z")

</div>

okay, and is your Email Whitelist sheet the same sheet as your User Profiles, or do you have a separate sheet?

I’m asking, because I have a theory and I’m looking for similarities between your setup and my setup.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [March 17, 2022, 12:49am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/17 "2022-03-17T00:49:37Z")

</div>

Same sheet!

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [April 1, 2022, 7:48pm UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/18 "2022-04-01T19:48:28Z")

</div>

@Jeff_Hager

It seems to be a bug!

I have two apps:

1. Members register where the user profile is the register.
2. A sub register where the user profile is a query to an importrange from the members register.

In the members register occasionally a new row with only users email is added at the bottom of the members register which also is the user profile.

Since queries of importranges do not dynamically add new rows I have limited the range to 1500 rows although the current content is about 1000 rows.

Today I found these inputs from row 1501!

 ![Bokningsregister - Google Kalkylark 2022-04-01 14-54-41](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7cf1cd7eff38cca83e16946df130c632a4193c1e.png)

What do you think?

---

<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:** [April 1, 2022, 11:45pm UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/19 "2022-04-01T23:45:26Z")

</div>

Have you submitted your issue to glide support or made a copy for @SantiagoPerez?

So the app that creates the row is the Members Register app? And that is the app that does NOT use the importrange to load the user profile table?

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [April 2, 2022, 2:56am UTC](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699/20 "2022-04-02T02:56:25Z")

</div>

No, both apps creates these rows.  
Members Register app creates the rows at the end of the sheet, the sub app creates the rows below the the importrange, which ends at row 1500.

[Next page](https://community.glideapps.com/t/possible-bug-in-login-user-profile/39699.md?page=2)
