Setting Up Table Row Colors

SCM Mobile provides six standard colors that you can use to highlight rows of Data Table elements: blue, green, orange, purple, red, and yellow. You can choose up to three colors to set up on a single table. When a table has highlighted rows, you can group together rows with the same color or filter rows based on a color.

To set up a color, provide a condition that specifies the data to which you want to apply it. The app highlights entire rows that contain data that meet your condition to distinguish them from other rows.

To set up table row colors:

Access the Data Table element through mobile configuration or customization:
- Configuring Mobile Page Elements
- Customizing Mobile Page Elements
On the Row Colors subtab, click Add Color for configuration or New Mobile – Row Color for customization.
On the Row Color page, set values in the following fields:
1. Name - Enter a unique name for the color setting.
2. Priority – Enter a number greater than zero that indicates the priority of the color with regard to other colors that you set up for the same table.
  
  If multiple colors apply to a row based on their conditions, the app chooses the color with the first or highest priority.
3. Column Condition – Enter a conditional statement or expression based on data from one or more table columns. To reference a column, use the column keyword followed by the name from the column’s record.
  
  Tip:
  To view names of columns that you can use in your condition, click Show Column Response Keys. The list may include custom columns that you add to the table.
  
  If a table references or sources data from a NetSuite record, you can use the same NetSuite record data for your column condition. Use the record keyword to reference a NetSuite record and the state keyword to specify the path to a state key. To use state paths, see Accessing Data Stored in the State.
  
  Examples:
  - column:quantity > 12 – Highlights rows that have a Quantity column value greater than 12
  You can use the DateValue() API to specify, calculate, or compare dates in your condition. For information and examples, see DateValue() API for Column Conditions.
4. Color – Select the color that you want to set up for the table.
5. Color Description – Enter a brief description of how or when the color is used. You can provide details about conditions that you apply to a color.
6. On the app, you can click the info icon for a table to view the descriptions on a popup window.
Click Save.

To set up table row colors:

Related Topics