You are here: Document Engine > Conditionals > Conditional Columns

Conditional Columns

OVERVIEW

Tables within the Document Engine can contain conditional columns. Use conditional columns to show or hide table columns based on conditions. You can also specify widths for each column.

ADMINISTRATION

ClosedCreating a Conditional Column

Use conditional columns within a table to show or hide table columns based on conditions. You can also specify widths for each column and create combinations by editing the table properties.

To show how conditional columns work, we’ll start with a table that has already been created.

  1. After you have created (or selected) a table, select the Table tab and click Properties.

    The Edit Table Properties dialog box appears.

  1. Select a column on which to write a condition (for this example, we are using the column Extended Price) and click the green Plus icon next to the column.

    The Expression Editor(Condition) dialog box appears.

  2. Enter a Name for the condition.
  3. Enter one or more filters on which the condition is based.

    For this example, enter Show Subtotal(showSubtotal_quote) in Data Field, = in Operator, and true in Attribute Value.

  4. Optional: Click Add Row to add additional filters for the condition.
  5. Enter 1 in the Row Grouping (Order of Operations): field. The default for one row is 1.
  6. Click Save to save the condition and close the window.

      The Condition Name column now has an entry and the green Plus icon is now a pencil. To edit the condition, click the Pencil. To delete the condition, click the red X.

ClosedCreating a Combination

The Edit Table Properties dialog box provides a visual UI to create combinations, so you can see which columns will appear where and when. It is possible to create multiple combinations.

  1. After you have created one or more conditional columns, click Add Combination under Specify Custom Widths. The Define column combination dialog box appears.

    The Define column combination dialog box appears.


    There is a green circle in column 5. This means that, whether or not the condition is met, column 5 will be displayed.

  1. Click the Green circle if you’d like to hide the column from the table when the condition is not met.

The circle will turn red to indicate the column will be hidden from view.

  1. Click Add Combination. The dialog will close and your new combination will be visible on the Edit Table Properties window.

  1. Edit the column widths for the columns that will be displayed so that they equal the total width of the table.

    In this example, the total table width is 8.00 in. The total that is displayed in the image above is 7.00, indicating that one or more columns can be adjusted to make up for the width of the hidden column 5.

  2. Click Update Table to save and close your changes.

NOTES

RELATED TOPICS

Related Topics Link IconSee Also