# What means a different color in data base records?

**URL:** <https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956>\
**Category:** Ask for Help\
**Created:** [January 24, 2024, 7:57pm UTC](https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956 "2024-01-24T19:57:49Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Inspector1\_ColmenasM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/inspector1_colmenasm/32/64102_2.png) [@Inspector1\_ColmenasM](https://community.glideapps.com/u/Inspector1_ColmenasM)\
**Post date:** [January 24, 2024, 7:57pm UTC](https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956/1 "2024-01-24T19:57:49Z")

</div>

As you can see on the image 1, in my table, some records are in bold letter an others not.  
Image 1…

 ![diferencia color](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b9790ab23295f1023a8fb3b54e6ea73f100cfbdb.jpeg)

I think this is why I have an inconssitency in my table and my layout (image 2)

 ![inconsistencia](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a1bd06348c6fb83cf2d492655df0ad6baf89a1b4.jpeg)

real data is 15, but it displays 6!!!  
curiosly, only 6 records are in bold in the table…

---

<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:** [January 24, 2024, 7:59pm UTC](https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956/2 "2024-01-24T19:59:18Z")

</div>

When data is greyed out like that, it’s because you’ve got Row Owners enabled on the “Delegado” email column. This is showing you that only the data that is bolded will be downloaded to the device of the user you are currently viewing the app as (Frederico in this case).

Row Owners also affects things like relations and calculations. The row owner can only view the data that they “own” and have access to. In the builder, this can be tricky because the developer can see all information/data when they “view as” someone.

---

<div class="post-metadata">

**Author:** ![Inspector1\_ColmenasM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/inspector1_colmenasm/32/64102_2.png) [@Inspector1\_ColmenasM](https://community.glideapps.com/u/Inspector1_ColmenasM)\
**Post date:** [January 24, 2024, 8:32pm UTC](https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956/3 "2024-01-24T20:32:00Z")

</div>

ok, but, if you see close, its the same user. User have bold and greyed records…  
Wifi/Internet problem maybe??  
This calculation have its source from other table (image 1 table). And I have defined an “Action” when a new record its submitted.  
I can notice that sometimes this Action does not occurs when it be.  
I have this action:

 ![error 3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/c/dc467deae303501c770b86adff5ca7b84f211a66.jpeg)  
and I have noticed this: when “Set column values” not work, specially “admin”, calculation is bad.  
Real questions is why some times it works and sometimes does not.

---

<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:** [January 24, 2024, 8:53pm UTC](https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956/4 "2024-01-24T20:53:39Z")

</div>

Do you have any other row owner columns, or are you using Roles in your app?

It looks to me like your “Admin” column is a role column. Check to make sure it is populated in each row.

Quick note — you cannot assign roles in the published app. Check out the [Roles](https://www.glideapps.com/docs/essentials/security-and-user-data/roles) documentation for more information.

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

---

<div class="post-metadata">

**Author:** ![Inspector1\_ColmenasM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/inspector1_colmenasm/32/64102_2.png) [@Inspector1\_ColmenasM](https://community.glideapps.com/u/Inspector1_ColmenasM)\
**Post date:** [January 24, 2024, 9:56pm UTC](https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956/5 "2024-01-24T21:56:20Z")

</div>

> [@kyleheney](#):
>
> Do you have any other row owner columns, or are you using Roles in your app?

Yes.

> [@kyleheney](#):
>
> Check to make sure it is populated in each row.

thats the problem. SOmetimes “Action” works and sometimes not.  
Maybe that´s the “key”: why this “action” fails…

---

<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:** [January 24, 2024, 10:34pm UTC](https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956/6 "2024-01-24T22:34:00Z")

</div>

You can’t set column values on a new row if you are not the owner of the row. As soon as you added the row, you were no longer an owner, so you can’t change it to add Admin as an Owner. I would avoid using On Submit actions and instead add the appropriate Value components to the form, so those values are set immediately as the row is added instead of after the row is added.

---

<div class="post-metadata">

**Author:** ![Inspector1\_ColmenasM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/inspector1_colmenasm/32/64102_2.png) [@Inspector1\_ColmenasM](https://community.glideapps.com/u/Inspector1_ColmenasM)\
**Post date:** [January 25, 2024, 2:53pm UTC](https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956/7 "2024-01-25T14:53:04Z")

</div>

OK I understand. But let’s say that’s the minor of my problems.  
The first four values are inserted into columns that are not “row owner”. They should be inserted without any problem…  
Before, I tried another solution: Insert a USER value. But the same thing happened. Even though the USER has those values, sometimes it inserted them and sometimes it didn’t.  
Is there a way to put these default values in a component so that they are inserted but are invisible to the user?  
I don’t mean to remove the Visibility in Options, because that would cause no value to be inserted…

---

<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:** [January 25, 2024, 3:18pm UTC](https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956/8 "2024-01-25T15:18:41Z")

</div>

Go into your form and add a component. You will see a bunch of components that are directly linked to column values in the parent table and user profile table.

---

<div class="post-metadata">

**Author:** ![Inspector1\_ColmenasM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/inspector1_colmenasm/32/64102_2.png) [@Inspector1\_ColmenasM](https://community.glideapps.com/u/Inspector1_ColmenasM)\
**Post date:** [January 25, 2024, 3:19pm UTC](https://community.glideapps.com/t/what-means-a-different-color-in-data-base-records/69956/9 "2024-01-25T15:19:06Z")

</div>

> [@Jeff\_Hager](#):
>
> those values are set immediately as the row is added instead of after the row is added.

I think this is the key. You giveme another idea…
