# Table and screen showing different data

**URL:** <https://community.glideapps.com/t/table-and-screen-showing-different-data/23805>\
**Category:** Report a Bug\
**Created:** [March 5, 2021, 8:11am UTC](https://community.glideapps.com/t/table-and-screen-showing-different-data/23805 "2021-03-05T08:11:12Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [March 5, 2021, 8:11am UTC](https://community.glideapps.com/t/table-and-screen-showing-different-data/23805/1 "2021-03-05T08:11:12Z")

</div>

![screen-recorder-fri-mar-05-2021-10-04-02](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/a/facb56ccad9619a7bbfc176a21e950985802dfb3.gif)

Can someone please enlighten me? What is happening?  
The data was changed using a SET COLUMN single relation.  
screen shown correct data but table is not.  
Definitely same user same column check sheet also showing different data from screen.  
Refreshed whole tab then screen showed old data as if was not updated.  
Is set column doesn’t update value in table? only on screen?

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

---

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [March 5, 2021, 9:54am UTC](https://community.glideapps.com/t/table-and-screen-showing-different-data/23805/2 "2021-03-05T09:54:37Z")

</div>

Few things to check maybe are:

1. Which action does the Set Column?
2. What happens after that action? Something that reverses the value back to its orginal value?

Since when you refresh, the values goes back to the original value, either the table value reverts back and it takes time to update on screen.

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [March 5, 2021, 10:13am UTC](https://community.glideapps.com/t/table-and-screen-showing-different-data/23805/3 "2021-03-05T10:13:58Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b92a092bd17c2ca1229205c4cbeea2dc9c98d02f.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/ebf2666da5cae40d7a9cc1fa75a93e11baaf1ea3.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/01d3fd76a3f036160e5acd35c683d2b7c7121bcf.png)  
That’s It

---

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [March 5, 2021, 10:29am UTC](https://community.glideapps.com/t/table-and-screen-showing-different-data/23805/4 "2021-03-05T10:29:28Z")

</div>

Is there something in the google sheet which does some calculation on this value, which may be reverting its value back? Or, is the data only in the glide table?

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [March 5, 2021, 11:41am UTC](https://community.glideapps.com/t/table-and-screen-showing-different-data/23805/5 "2021-03-05T11:41:27Z")

</div>

No calculations… only this action is connected to the column

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [March 5, 2021, 12:25pm UTC](https://community.glideapps.com/t/table-and-screen-showing-different-data/23805/6 "2021-03-05T12:25:41Z")

</div>

> **[screen-recorder-fri-mar-05-2021-14-21-48.webm (video)](https://drive.google.com/file/d/120glupAfajaz88oD25YmjSosRoWbm3vq/view?usp=sharing)**
>
> Google Drive file.

Ok I understand the logic of this bug.  
Its a form that needs to update a relation from a row that still hasn’t been created, because only after the submit action the row will appear.  
So the set column relation option should not even be there, or need to fix it somehow?

---

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [March 5, 2021, 3:36pm UTC](https://community.glideapps.com/t/table-and-screen-showing-different-data/23805/7 "2021-03-05T15:36:26Z")

</div>

I find that the field which shows 2 after your submit the form is in “Forms” Sheet as the submit of form is linked to the Forms sheet. But, the sheet which you are showing where the data is 1 is in the “Users” Sheet. The field which you are displaying on the screen and which gets updated to 2 is in the Forms Sheet, but then you are checking the Users sheet and seeing it as 1. Would that be the cause for the issue?

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [March 5, 2021, 3:41pm UTC](https://community.glideapps.com/t/table-and-screen-showing-different-data/23805/8 "2021-03-05T15:41:48Z")

</div>

No, The field is in users sheet only. The form submittion to the table Form is the trigger to update the cell in the users table that is a relation from forms to users on the user ID.
