# Data not displayed in app

**URL:** <https://community.glideapps.com/t/data-not-displayed-in-app/41535>\
**Category:** Ask for Help\
**Created:** [May 2, 2022, 11:53am UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535 "2022-05-02T11:53:53Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gregory\_Desomer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory_desomer/32/35213_2.png) [@Gregory\_Desomer](https://community.glideapps.com/u/Gregory_Desomer)\
**Post date:** [May 2, 2022, 11:53am UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535/1 "2022-05-02T11:53:54Z")

</div>

Hi,  
I have problems displaying values in the app itself.  
The values are coming through as 0 for some reason.

Situation:  
1 sheet, 2 pages (tables).

Page 1:  
Raw data: item/date/amount  
Glide columns: template (year/month) / ifthenelse (positive numbers) / ifthenelse (neg. numbers)

Page 2:  
irrelevant raw data  
Glide columns:  
Date input (from date input from date picker) / template (year/month) / Relation on template with page 1 / Rollup - relation-positive numbers (sum of)

The rollup sum is showing correctly in the sheet but in the app it’s returning as 0.  
What am i doing wrong of how do i fix this?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e702975c1616c70eb5d8108aa6a5fb01ae24db5.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/de8fa35cdc3fc47db75996b527fc4bda9f1ec65d.png)

---

<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:** [May 3, 2022, 12:04am UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535/2 "2022-05-03T00:04:09Z")

</div>

Do you have any filters for that screen/powering the chart by a relation/use a row owner setup anywhere in your data?

---

<div class="post-metadata">

**Author:** ![Gregory\_Desomer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory_desomer/32/35213_2.png) [@Gregory\_Desomer](https://community.glideapps.com/u/Gregory_Desomer)\
**Post date:** [May 4, 2022, 8:53am UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535/3 "2022-05-04T08:53:51Z")

</div>

There is no filter or user specific columns.

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

Neither any filters.

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

---

<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:** [May 4, 2022, 12:27pm UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535/4 "2022-05-04T12:27:26Z")

</div>

What about row owners?

---

<div class="post-metadata">

**Author:** ![Gregory\_Desomer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory_desomer/32/35213_2.png) [@Gregory\_Desomer](https://community.glideapps.com/u/Gregory_Desomer)\
**Post date:** [May 4, 2022, 2:46pm UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535/5 "2022-05-04T14:46:02Z")

</div>

Hi Jeff,  
No idea how I even setup row owners, how can i check this?

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [May 4, 2022, 3:54pm UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535/6 "2022-05-04T15:54:44Z")

</div>

Gregory here’s the Docs about Row Owners :

> **[Row Owners](https://docs.glideapps.com/all/topics/security-and-user-data/row-owners#:~:text=If%20a%20sheet%20has%20Row,available%20for%20all%20Glide%20apps)**
>
> A secure way to restrict access to certain rows

If you still see this issue I think we might need to look at your app!

Thank you

---

<div class="post-metadata">

**Author:** ![Gregory\_Desomer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory_desomer/32/35213_2.png) [@Gregory\_Desomer](https://community.glideapps.com/u/Gregory_Desomer)\
**Post date:** [May 5, 2022, 10:51am UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535/7 "2022-05-05T10:51:17Z")

</div>

Hi, I do not have Rown Owners setup.

I have here the link to access the app, is this how you want to look at it?  
[https://go.glideapps.com/support/fc80cd75-c946-4a0d-9810-b4864f66e369](https://go.glideapps.com/support/fc80cd75-c946-4a0d-9810-b4864f66e369)

---

<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:** [May 5, 2022, 11:41am UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535/8 "2022-05-05T11:41:14Z")

</div>

Only glide staff can view support links, so it’s not useful to the rest of us users.

I have suspicions with how you are working with the date. It may not be splitting the way you think it is on the front end. Date formats are very regional and can change depending on a user’s browser and device settings.

Instead of a split column and two single value columns, replace those three columns with two math columns.

First math column like this:  
`YEAR(date)`

Second math column like this:  
`MONTH(date)`

Then put the math year and month together with your template column.

See if that works.

---

<div class="post-metadata">

**Author:** ![Gregory\_Desomer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory_desomer/32/35213_2.png) [@Gregory\_Desomer](https://community.glideapps.com/u/Gregory_Desomer)\
**Post date:** [May 5, 2022, 6:44pm UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535/9 "2022-05-05T18:44:17Z")

</div>

Hi Jeff,

Yes that worked, thank you!  
Strange that the data is shown correctly in the data editor but not in the app tho.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 6, 2022, 6:44pm UTC](https://community.glideapps.com/t/data-not-displayed-in-app/41535/10 "2022-05-06T18:44:18Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
