I have a drop down list which I need to highlight any properties which have been accessed 2 or more times, I have created a virtual column that counts the number of vists [count of na] however when I goto the drop down all the properties are highlighted red as shown below.
Column type of [COunt NA]?
[count na] is the virtual column that counts the number visits to a property
But it’s column type?
I have created a new ux view to demonstrate what i am looking for in a drop down, this works fine like this but not when you try applying the format rule to a drop down.
I’m sorry but we still have no idea what’s the column type of [COunt NA] and it’s config
There is a list of properties, this references the visit table. The [Count na] is the number of visits to each property by counting the entries in the visit table with the same site id
Is [COunt NA] of column type “Number”?
Is it a Virtual Column or a normal one?
Can you post here the AppFormula?
The [_THISROW] qualifier is not needed. In fact, in some places where it is used it causes problems. Remove [_THISROW] and try it again.
3 Likes
Tried that but makes no difference
The only way to format items in a dropdown differently from each other, is for that dropdown column to be a Ref to another Table, and then you apply the formatting rules to the label column of that other Table.
4 Likes
Yep, missed that tidbit!!
1 Like