Conditional Styles using Expressions

Summary

  • Format Column Conditions can use an Expression (instead of a Predicate)
  • This is useful for more advanced scenarios or if AND / OR functionality is required

For more complicated scenarios there is an option to use an Expression.

This will be evaluated by AdapTableQL (as with Calculated Columns, Alerts etc).

Note

This is a Boolean Expression (as it has to evaluate to true / false)

The Expression can reference multiple columns and can contain AND and OR and more advanced logic.

Caution

If the Format Column's Scope is All (i.e. the whole Row) the Rule must be an Expression (rather than a Predicate)

Format Column - Expression Condition
Fork
  • This example shows a Column Format containing a style of Blue Background and Brown Font and a Scope of All
  • An Expression is also provided stipulating the Style only applies in Rows where Language is 'TypeScript' and License is 'MIT License'