0

Adding colour to records

Dear forum

I have set up a table and everything is functioning just perfect, only, I would like to mark some of the records in colours according to their content. I know that you can add a colour to fields, but my trouble is that I would like my colourfield to contain text at the same time. Is there any way to do this?

Kind regards and thank you in advance

Ideally it would look something like in the attached screenshot.Skærmbillede 2020-03-13 kl. 16.37.00

1 reply

null
    • Nick
    • 4 yrs ago
    • Reported - view

    Create a formula field and try this code:

    ---

    styled(text(YourField), if YourField like "1-A" then
    "red"
    else
    if Text2 like "2-B" then
    "blue"
    else
    if Text2 like "3-C" then "yellow" end
    end
    end, "")

    ---