# 🔴 Glide Data Editor showing wrong values

**URL:** <https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169>\
**Category:** Ask for Help\
**Created:** [July 9, 2022, 9:59am UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169 "2022-07-09T09:59:49Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [July 9, 2022, 9:59am UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/1 "2022-07-09T09:59:49Z")

</div>

As shown In the below images, the **User Profile** sheet consists in total of 112 rows, in which 111th and 112th rows consists of two emails. On the other hand in the **Employee dashboard** sheet both the emails from the User Profile sheet appears in 111th and 112th rows, but the 113 row shows duplicate email of 112th row which is wrong as there are no 113th row in the User Profile sheet.

FYI: I have used single value feature to extract emails from **User Profile** sheet to the **Employee Dashboard** sheet.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/328b5294e263e935b667fbe8c939235392134e28.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5a02c7652457381f0e158f63673dbe4178b33e06.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8b989cf28e0b6a01af441190e87a9520b6d97a10.png)

---

<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:** [July 9, 2022, 10:13am UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/2 "2022-07-09T10:13:50Z")

</div>

That’s odd, I can’t explain that.

Which row in your user profiles table does that extra one (`...@gmail.com`) correspond to? The first row, maybe?

---

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [July 9, 2022, 10:16am UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/3 "2022-07-09T10:16:00Z")

</div>

@Darren_Murphy No to the last now which doesn’t exists. i.e 113th

---

<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:** [July 9, 2022, 11:33am UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/4 "2022-07-09T11:33:09Z")

</div>

That email value must be coming from somewhere. Are you saying that email address doesn’t exist in your User Profiles table? But you said it was a duplicate…

---

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [July 9, 2022, 12:55pm UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/5 "2022-07-09T12:55:37Z")

</div>

Yes that email is the duplicate of the upper row one, I had intentionally hidden it for confidential reasons.

---

<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:** [July 9, 2022, 1:02pm UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/6 "2022-07-09T13:02:41Z")

</div>

So it comes from the very first row?  
Is this a Pages project, or an App?

I’m asking lots of questions, because I can’t explain what’s happening, and so I’m searching for clues.

---

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [July 9, 2022, 1:04pm UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/7 "2022-07-09T13:04:43Z")

</div>

What do you mean by the first row ? The first row of every sheet on our project consists of different email id than this one,

It is an App project.

> [@Darren\_Murphy](#):
>
> I’m asking lots of questions, because I can’t explain what’s happening, and so I’m searching for clues.

No worries

---

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [July 9, 2022, 1:05pm UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/8 "2022-07-09T13:05:57Z")

</div>

As you can see that the first row contains different email than this one

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bbd3c23a5eac5d5e64246d8a919ae83d46f69bbb.png)

---

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [July 9, 2022, 1:07pm UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/9 "2022-07-09T13:07:10Z")

</div>

Without hiding the email id it looks like this

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/2/2268bcef861de8382b90bddea1c4e0913f0b2819.png)

and this

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7afc265c49e8a64b4fd8e037032ed672c3f9c666.png)

---

<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:** [July 9, 2022, 1:18pm UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/10 "2022-07-09T13:18:29Z")

</div>

This is different from your very first screen shot - have you changed the data in your User Profiles sheet?

Anyway, it makes more sense now. But still, I can’t explain it. I tried to replicate it, and what happened when I tried - and what I would expect - is an empty value in that last row (Index 113).

Maybe @Jeff_Hager might be able to spot something here that I’m not.

---

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [July 9, 2022, 1:21pm UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/11 "2022-07-09T13:21:56Z")

</div>

> [@Darren\_Murphy](#):
>
> This is different from your very first screen shot - have you changed the data in your User Profiles sheet?

No I haven’t, i have just changed the email content for confidential reasons to some [xyz.com](http://xyz.com), except that no change in row or else. One thing you should notice is that even though I have changed the 112th row email for confidential reasons, the lower i.e. 113th row email shows the real email.

---

<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:** [July 9, 2022, 1:25pm UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/12 "2022-07-09T13:25:54Z")

</div>

Yeah, I get it. But I can’t explain it. Have you tried refreshing the data editor (reloading the browser)?  
It could be something as simple as the Data Editor being out of sync with the Glide back end. If that’s the case, reloading should resolve that.

---

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [July 9, 2022, 1:38pm UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/13 "2022-07-09T13:38:05Z")

</div>

Have tried multiple times but nothing happened ☹

---

<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:** [July 9, 2022, 11:15pm UTC](https://community.glideapps.com/t/glide-data-editor-showing-wrong-values/44169/14 "2022-07-09T23:15:36Z")

</div>

Any chance it’s related to this? There have been some visual glitches in the data editor in the past week.

> [@When I change the user view it creates a row with the user I selected](https://community.glideapps.com/t/when-i-change-the-user-view-it-creates-a-row-with-the-user-i-selected/43994/):
>
> Dear colleagues! Does anyone know what the following behavior can be attributed to? When I change the user view it creates a row with the user I selected Thank you!
