0

Field styling query

Hello,

Please can someone help me with something that is either too complex for me to work out, or too simple for me to realise...

I would like the date in the field 'Date In / Received' to have the text appear red in a certain list view if that date is more than 3 working days ago. The idea being that I need to draw attention to the entries that have been waiting in the system for more than 3 working days.

For example;

if the date in this field...

Date In Field

is more than 3 working days ago, I want...

the dates in this list to turn red (which is the same field just in the list view)

Date In List

Many thanks, Anna

3 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    It's only possible to dynamicaly style a date by using a formula field containing the date and style this formula field depending on your conditions.

    Steven

    • Anna_Wenlock
    • 3 yrs ago
    • Reported - view

    Thanks Steven, I created a formula field and figured a way around to do this. I had a feeling that I was trying to do something that couldn't be done!

    • CISOFT_Sarl
    • 3 yrs ago
    • Reported - view

    create a field formula and show this only id your date field is not null.

    in formula field a little script llike that :

     

    let displayText:=format(myDateField,"YYYY.MM.DD");

    let displayBackground:="white";

    if (today() - myDateField)>3 then  

    displayBackground:= "red"

    end;

    let displayColor:="my display color";

    let displayIcon:="my display icon";

    styled(displayText, displayBackground, displayColor, displayIcon)

     

    et voila!

Login to reply

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 660Views