Can I set both the text value and color value of a formula field so it looks like a color formatted field?
T

Can I set both the text value and color value of a formula field so it looks like a color formatted field? 

I have a choice field with text and color value updated through an if statement that is triggered when another field is updated.

However I already have a number of records and I have to edit each field to get the value generated. 

I replicated the formula in a formula field but I only get the text value or color value. Can I create a formula to show both text and color values in the formula field.

Ninox Profile

Use the styled() function like this:

–––
styled(text, bgColor, color, icon)
–––

Birger

T

Got it!

Thanks

T

Is there a chart with the icon names?

H

Someone made some very good material somewhere, but I can not find it and put it back.

 

https://www.dropbox.com/s/tqhisec48gzup81/Iconset.ninox?dl=0

T

Great.

Thank you again!

Reply