Format rule not working

Hi everyone,

Im trying to apply the next format rule:
AND([Recámara]=SI, [Baño]=SI, [Sala]=SI, [Puertas y ventanas]=SI, [Cocina]=SI, [Herramientas]=SI)
Where if all columns checked “SI”, it should apply a green checkmark to the row.

The test for this expression brings back the correct results,

but in the UX, the green checkmark is being applied to all rows even if they don´t match the “SI” condition.
Captura de Pantalla 2020-07-06 a la(s) 16.15.17
I´ve even set the Initial Value to be “NO”, but not working either.

Any ideas? I have the exact same expression working on another app, I don´t know why its not working here. The only difference is that the other app has Yes/No Column Types, this app has Text Colum type with “Si” and “No” Options.

Thanks!

UPDATE! Possible bug.
In the table view when I choose a Row, it takes me to a different Row Detail View, not the one I select.
i.e.: I Select Room 21, it takes me to room 32 detail or form view.
Captura PAntalla

Solved. I was having duplicate values in the Key Column. :sweat_smile:

Captura de Pantalla 2020-07-06 a la(s) 18.23.36

1 Like