Defining Custom Columns Using Substitution

You can specify complex entries in a column by using column substitution. This feature works where all the entries in a column follow a specific pattern.

As an example, suppose all entries in a column use a comparison such as this, but with different values in each case: 

Math.maxInt(MyAlias.Value, MyAlias.MaxValue) < 50

Instead of typing such entries in each cell, you could use substitution.

Procedure

  1. In the column header, specify (right-click the column and select Field Settings) the pattern: Math.maxInt({0}, {1}) < {2}
  2. In each of the column cells, specify parameter values, using a semicolon delimiter:

    MyAlias.Value; MyAlias.MaxValue; 50

  3. Press Enter so that the cell contents are substituted with the pattern of the column name.
Related concepts
Related tasks
Related reference