Forum Discussion

Quickbase Staff

8 years ago

How do you highlight a field based on text value?

I have a table with requests for an Audit. I have a column with QB Status as the title and the field either says Open, In Progress, or Closed. I want Open to be highlighted in a light green, In Pr...

App builders

Ask about Quickbase functionality

Formulas and functions

ChrisChris

Qrew Assistant Captain

8 years ago

See if you like this a little better:

If([qb status]="Open", "<div style=\"width:70px;padding:3px;background-color:green;color:white\"> Open</div>", [qb status] )

ChrisChris

Qrew Assistant Captain

8 years ago

OOHH, I made a formula field. I had assumed you were on a form.

Forum Discussion

How do you highlight a field based on text value?

Related Content

Jinja If statement equals field value

Grabbing value between 2 fields

Color Coding based on field value

Address Field - Set default value?

Snapshot Fields