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

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

MyAlias.Value; MyAlias.MaxValue; 50
Press Enter so that the cell contents are substituted with the pattern of the column name.