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.