In the screen designer, you can conditionally format the background color of a table cell by following these steps. This example covers the scenario when you have a Data Model that defines a color code - typically something like a record status.

Instructions

1. Navigate to the Screen Designer
2. Locate the Table Screen that you wish to modify (open or create a new one)
3. within the canvas area - select the column that you wish to have formatted with a color
   
1. Our example below is an “Inventory Status” table - however, you can also use similar logic to apply these colors to the reference models - for example in the Inventory Table, you can display the color of its related status.
   
4. After you have selected the column - navigate to the options panel on the right
   
5. In the Data Path field - if you want ONLY the color, replace the path with double ““ marks
1. If you want the color code (#ccccc) displayed, then leave the data path attached to the color field on the model
   
6. Move to the “display” options to set the property for the background formatting
   
1. In this example, the code example is {"background": data.color}
2. you can replace ‘data.color’ with a path not on the model, but could be a referenced model as well - as described, if you wanted to add color to the background of the ‘status’ column on the ‘inventory’ model for example.
7. Scroll down until you see the ‘additional fields’ option in the options panel - in the “general” section
8. Add the reference column here - so they system will query the field (since it was removed from the data path in this example)

End Result (with data.path = ““):

End Result (with data.path = color):

Adding {“background”:data.color} to another column in the table:

Example of a “Related” Data model - in this example we format the background of the ‘status’ column on the inventory table - which references back to the data.color object on the inventory status table shown above:

Formatting the “background”:

Add the additional query field: