Dynamic coloring of a number field
Hi folks,
On a number field, I would like to highlight if the number exists already by coloring it red. I tried different approaches with functions and conditional coloring. It seems that the select state, I am using can not grab the items from the current Table I am in.
let komponentenNummer := KomponentenNummer;
let identifikationsNummer := IdentifikationsNummer;
let anlagenbauer := Anlagenbauer;
if count(select 'ProjektStückliste') > 1 then
true
else
false
end
Copy
Copy
So here, I am already in the 'ProjektStückliste'. True is never the result which is weird as I definitely have objects in that list. So I might violate the select as I kind of try to grab from a table that I currently edit.
3 replies
-
As you can see, I just managed to create an additional column that highlights the duplication but I would like not to need that additional column :)
-
Martin Mueller
Create a formula field (which you can hide) and name it Double for example:
let n := IdentifikationsNummer; cnt(select 'ProjektStückliste' where IdentifikationsNummer = n)>1Then you can use the conditional Styling in the header of your IdentificationNummer using the f(x) where you put
Double = true
Steven
-
RoSoft_Steven Super elegant and works like a charm thanks :)
-
Content aside
- Status Answered
- 2 yrs agoLast active
- 3Replies
- 107Views
-
2
Following