Article - CS306141

Configuring Grid or Advanced Grid to perform a comparison between two columns and proceed to set cell formatting in ThingWorx Platform

Modified: 07-Jul-2022   


Applies To

  • ThingWorx Platform 8.1 to 9.0

Description

  • Would like to compare ColumnA to a value in ColumnB then proceed to change the Grid formatting based on the result
  • Comparing two integer columns from a Data Table, would like the text color to be set a certain way depending on the result of the comparison
  • Having trouble setting State Based Formatting for a column in a Grid in that comparing two integer values and would like one column to have red text if it is not equal to another column
  • Dynamic State Formatting on one of the column/cell of Advanced Grid Widget
This is a printer-friendly version of Article 306141 and may be out of date. For the latest version click CS306141