What means a different color in data base records?

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

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

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

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.

1 Like

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:


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.

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 documentation for more information.

Yes.

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

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.

1 Like

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…

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.

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