Format rules being applied to all rows despite condition

I have this format rules to show an icon close to the name of a player in my app (name of the player represented by field jogador_nome) if the boolean fields (jogador_gold and jogador_capitao) are true. However, this is not working as intended and applying both icons to all rows (and sometimes just one of them to all rows) whereas it should be applied to a single row.

This is one my format rules as well as the resulting display with the little icon in all rows:

format rule for field jogador_goldformat rule for field jogador_gold

Here is the data...

DataData

...and the test of the expression (which seems to work correctly)

Testing conditionTesting condition

Interestingly, if I view the app with another user, the result is different (i.e, it applies just one of the rules to all rows instead of both rules)

Viewing app with other userViewing app with other user

Any hints on what am I doing wrong?

Thanks!

Solved Solved
0 8 321
1 ACCEPTED SOLUTION

For anybody who can be interested on it, I reached out to Appsheet support (which I didn't even know that existed, but turns out it is SUPER helpful and they replied in a matter of hours) and they looked at my app and told me what is wrong.

Basically my table where the rule was being applied (Equipes) had as a key something that was repeating for multiple lines (equipe_id). When I changed that to make it a combination of 2 fields in a way there would be no repetition, it worked.

View solution in original post

8 REPLIES 8
Top Labels in this Space