How can I create colored backgrounds, pictures and stoplight graphics in my forms and reports?

[The Quick Base Knowledge Base is your library of frequently-asked questions that help you better customize your apps to solve your business problems.]

You can use the HTML function of Rich Text field to produce background colors and even graphics in your forms, tables and reports.

Below are a few examples:

 

Colored Status and Icons: Example of using Rich Text fields with HTML to produce fields that have background colors and graphics.

 

Colored Groups: Example of using Rich Text fields with HTML to display background color by grouping.

 

Steps:

So long as your applications contains a field with the name [Status] you can follow the steps below:

1. Create a Rich Text field and paste this into the formula section of the field's properties (This is called Colored Status above):

Case([Status],
"Not Started","Not Started",
"In-Progress","In-Progress",
"Completed","Completed",
null)  

2. Create another Rich Textt field and paste this into the formula section of the field's properties (This is called Icon Status above):

Case ([Status],
"Not Started",
"",
"In-Progress",
"",
"Completed",
"",
null)

 

3. Select your graphic icons or pictures from the list of images we make available HERE and copy the URL. Alternatively you can also use your own images by uploading them into a table in your Quick Base application and copying the URL of that specific image.

4. Copy their URL location and insert them into the formula above for the respective locations for the various status settings.

5. Include the new fields on your reports.

 

Additional Resources

- To learn more, please see our About Row Highlighting help topic.

- You can customize the perfect color for your field at Color Picker.