0

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

null
    • Cloud DevOps Fullstack Engineer
    • Martin_Mueller
    • 2 yrs ago
    • Reported - view

    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 :)

      • Ninox partner
      • RoSoft_Steven.1
      • 2 yrs ago
      • Reported - view

      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)>1

       

      Then you can use the conditional Styling in the header of your IdentificationNummer using the f(x) where you put 

       

      Double = true

       

      Steven

      • Cloud DevOps Fullstack Engineer
      • Martin_Mueller
      • 2 yrs ago
      • Reported - view

      RoSoft_Steven Super elegant and works like a charm thanks :)

Login to reply

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 3Replies
  • 61Views
  • 2 Following