# Login events are wrongly recorded in a sheet

**URL:** <https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146>\
**Category:** Report a Bug\
**Created:** [April 16, 2020, 8:28am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146 "2020-04-16T08:28:39Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nir\_Hemed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nir_hemed/32/2996_2.png) [@Nir\_Hemed](https://community.glideapps.com/u/Nir_Hemed)\
**Post date:** [April 16, 2020, 8:28am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/1 "2020-04-16T08:28:39Z")

</div>

My app uses preauthorized email list.  
In some cases Glide logs the emails users who enter the app in a sheet of my app.  
See the bottom 3 entries in the screenshot:

 ![Screen Shot 2020-04-16 at 11.28.06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/54ad95785532483f4f80f182b853d657c45de5cc.jpeg)  
Notes:

1. The sheet is **not** the _App: Logins_ auto-generated sheet. This is one specific sheet that is used for data.
2. The users are not necessarily logging with a pin code - just opening the app is enough to trigger that.

The effect of this bug creates false categories that are later selected as part of the app flow.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [April 16, 2020, 9:53am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/2 "2020-04-16T09:53:11Z")

</div>

> [@User logins appear randomly on other parts of the app?](https://community.glideapps.com/t/user-logins-appear-randomly-on-other-parts-of-the-app/7104/4):
>
> Yup seems like a bug. The way I fixed it was to create a Users sheet and give it 3 columns (User, Name and Image). Change the User Profile sheet and assigned values (click menu, then the Sign in button in the Glide Editor). Set the sheet to the new Users sheet. If you already have a sheet that collects user information, just point to that sheet.

@Mark @david I think this needs to be looked at. This is the 3rd user (including myself) who has noted this. The issue is around apps that don’t have a sheet that collects user info (other than App: Logins). The User Profile seems to assign itself to the first sheet and without some instruction from Glide, users aren’t aware of this until they start to see email address entries in their first sheet, which can cause other issues with the rest of the columns in that sheet.

---

<div class="post-metadata">

**Author:** ![Nir\_Hemed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nir_hemed/32/2996_2.png) [@Nir\_Hemed](https://community.glideapps.com/u/Nir_Hemed)\
**Post date:** [April 16, 2020, 10:29am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/3 "2020-04-16T10:29:42Z")

</div>

Thanks @kyleheney! I don’t think I understood the workaround. Is this similar for the case of Email whitelist?

The bug is still reproducing: I’ve have a created a new “Users” sheet with the columns as you mentioned, redirected the Email whitelist sheet in Glide - logged in with a new email address - and that email has created an entry in my first sheet.

On that note - are any of these terms [“Users”, “User”, “Name”, “Image”] are reserved names in Glide?

---

<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 16, 2020, 11:01am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/4 "2020-04-16T11:01:38Z")

</div>

@kyleheney is referring to the new User Profiles feature. I believe, by default, it chooses your first sheet to store App Logins (@Mark has hinted that App: Logins might be going away altogether in lieu of the new User Profiles feature).

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

So, in this instance, you’ll need to define where you’d like to store your user login data. Though, I agree that clarification is needed. @Mark, is User Profiles turned on by default and does it automatically select the first sheet?

---

<div class="post-metadata">

**Author:** ![Nir\_Hemed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nir_hemed/32/2996_2.png) [@Nir\_Hemed](https://community.glideapps.com/u/Nir_Hemed)\
**Post date:** [April 16, 2020, 12:00pm UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/5 "2020-04-16T12:00:49Z")

</div>

That’s great - I didn’t know this feature exists.  
I will let you know if the workaround works.

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [April 16, 2020, 6:42pm UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/6 "2020-04-16T18:42:50Z")

</div>

We are fixing this today — it will not automatically assign.

---

<div class="post-metadata">

**Author:** ![JoshuaRiley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joshuariley/32/23639_2.png) [@JoshuaRiley](https://community.glideapps.com/u/JoshuaRiley)\
**Post date:** [April 18, 2020, 3:46pm UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/8 "2020-04-18T15:46:52Z")

</div>

Did this get fixed?

---

<div class="post-metadata">

**Author:** ![JoshuaRiley](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joshuariley/32/23639_2.png) [@JoshuaRiley](https://community.glideapps.com/u/JoshuaRiley)\
**Post date:** [April 18, 2020, 3:50pm UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/9 "2020-04-18T15:50:04Z")

</div>

I just tried creating a sheet but couldn’t assign the sheet manually as I think it only works on the initial sheets when you create the app. I still have this issue

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [April 18, 2020, 3:54pm UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/10 "2020-04-18T15:54:35Z")

</div>

It’s fixed. Your new sheet needs columns for name email and photo.

---

<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 18, 2020, 3:58pm UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/11 "2020-04-18T15:58:35Z")

</div>

Watch the video here. It explains how to assign the sheet and columns for user profiles. I think the problem is with existing apps before the features was added. I’m guessing it’s hard to back it out for everyone without messing up people who are using the feature now.

> [@User Specific Columns + User Profiles Demo](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097):
>
> call_me_hand Hey all! Wanted to create a quick and very rough demo of Glide’s two newest features: User Specific Columns and User Profiles. The video covers the process from sheet creation to feature implementation. Hope this helps until an official video comes out! [[Glide: User Specific Columns and User Profiles Demo] ](https://www.youtube.com/watch?v=9LLur9db8NM)

---

<div class="post-metadata">

**Author:** ![Baptiste\_Delannoy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/baptiste_delannoy/32/5839_2.png) [@Baptiste\_Delannoy](https://community.glideapps.com/u/Baptiste_Delannoy)\
**Post date:** [April 19, 2020, 8:17am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/12 "2020-04-19T08:17:38Z")

</div>

Started using Glide yesterday, and was struggling all day today with that issue, you saved my life! Was really getting crazy about it haha

---

<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 19, 2020, 4:37pm UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/13 "2020-04-19T16:37:55Z")

</div>

I am running into this same issue and I am not sure I am understanding the fix. I have a user profile sheet that stored all of the individuals users profile information. I originally connected this profile sheet to the user profiles in the app via the video Robert made, but noticed it logging the logins of users to that same sheet.

The fix says to use a separate sheet for the app logins, but the means that name, email, and profile avatar will not stay synced to my user profile sheet I have created. I am not sure that the use of user profile makes sense in this fashion, but rather login data. but I don’t really need avatar and name logged every time a user logs in.

Am I missing something?

---

<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 19, 2020, 5:25pm UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/14 "2020-04-19T17:25:11Z")

</div>

The new feature replaces the use of any methods you were using before to create profiles. I assume you are still requiring a user to submit a form to complete their profile, but glide is designed to create the record for you. That’s probably why you have duplicates. What you should be doing is let Glide add the record to the profile sheet when the user signs in. Then let the user edit their record instead of creating a new one with a form button. You can still use your existing profile sheet. It should only track unique emails.

---

<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 19, 2020, 7:27pm UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/15 "2020-04-19T19:27:36Z")

</div>

Correct. Don’t use a form button. Instead, on the user profile page, filter by signed in user and add text/image entry fields to complete the profile (or just enable Edit on this page…or both). Then, use visibility settings to hide the entry fields once their profile is complete (you’ll need to use an if then column in the data editor to determine this).

I should probably create a new video on onboarding using the new user profiles. Like this post if you agree.

---

<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 20, 2020, 1:50am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/16 "2020-04-20T01:50:19Z")

</div>

Got it! That will solve one of the problems. But I am seeing a new entry for each user every time they sign in. It doesn’t seem that the duplicate entries are causing any issues with the navigation of the app.

---

<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 20, 2020, 1:53am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/17 "2020-04-20T01:53:28Z")

</div>

Are you seeing duplicate entries for NEW users or existing ones?

---

<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 20, 2020, 3:14am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/18 "2020-04-20T03:14:26Z")

</div>

Existing. But not just one. It is creating a new entry every time a user logs in. Like historical login data.

---

<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 21, 2020, 4:50pm UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/19 "2020-04-21T16:50:34Z")

</div>

I don’t want to submit this as another bug report if it working as intended. I just need to understand if I should be disabling the user profile feature for now.

---

<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 23, 2020, 12:29am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/20 "2020-04-23T00:29:28Z")

</div>

Just to be clear, you’re not looking at the app: logins sheet or using it for anything, correct?

---

<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 23, 2020, 12:39am UTC](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146/21 "2020-04-23T00:39:05Z")

</div>

I have a video now on user profiles and onboarding. You’ll see that I don’t even touch the App:Login sheet  
[Our Chores v1.0: An app that lets you manage and track your child(ren)'s chores](https://community.glideapps.com/t/our-chores-v1-0-an-app-that-lets-you-manage-and-track-your-child-ren-s-chores/7536)

[Next page](https://community.glideapps.com/t/login-events-are-wrongly-recorded-in-a-sheet/7146.md?page=2)
