Create and manage columns in the Markups list

The data displayed in the Markups list is highly customizable. You have control over which columns are shown and in what order and can create custom columns, including columns that perform user-defined calculations.

You can control which columns appear in the Markups list and in what order.

  1. On the Markups List toolbar, go to Markups List > Columns > Manage Columns. The Manage Columns dialog appears.

  2. Select the Display Order tab.
  3. To determine which columns are shown in the columns list, Select or uncheck the desired columns. Selected columns are shown, and unchecked columns are hidden.
  4. To determine the order in which columns appear in the columns list, select a column and use the Up or Down button to move it into the desired position. Columns are shown in the order found here.

Six types of custom columns are supported. You may add as many of each type as desired.

The Checkmark custom column is a column with a check box.

  1. On the Markups List toolbar, go to Markups List > Columns > Manage Columns. The Manage Columns dialog appears.

  2. Select the Custom Columns tab. Any custom columns are listed.

  3. Select Add.

  4. In the Add Column dialog, enter a display name for the column in the Name field.

  1. Select Checkmark from the Type list.

  2. Set the Default value as Unchecked (default) or Checked, as desired.
  3. Select OK.

The Choice custom column is a column with a list of defined values from which users can select.

  1. On the Markups List toolbar, go to Markups List > Columns > Manage Columns. The Manage Columns dialog appears.

  2. Select the Custom Columns tab. Any custom columns are listed.

  3. Select Add.

  4. In the Add Column dialog, enter a display name for the column in the Name field.

  1. Select Choice from the Type list. All current choice items are listed in the Options list.

  2. You can either import choice items from a CSV file or create and modify them manually:

    1. Select Import.
    2. Navigate to and select the desired CSV file, and select Open.

      CSV data should be arranged in the following order:

      • Column A = The name of the item. This is the name that will appear in the list for selection in the Markups list. (Required)
      • Column B = The subject for the item. This links to the Subject property of a markup, allowing for selective filtering of the list based on the markup. (Optional)
      • Column C = Numeric value of the choice, if applicable. (Optional)
    3. To set one of the imported choice items as the default selection for the column, select it and select Modify, then select Default.

    1. Select Add.

    2. Set the choice item's details:

      • Item The name of the item. This is the name that will appear in the list for selection in the Markups list. (Required)
      • Subject The subject for the item. This links to the Subject property of a markup, allowing for selective filtering of the list based on the markup. (Optional)
      • To give the choice a numeric value (required if it is to be used in a formula), select Assign Numeric Value and enter the value in the number field to the right.
      • If this choice should be the default selection for the column, select Default.
    3. Select OK.
    1. Select the desired choice item and select Modify.

    2. Change the choice item's details as desired:

      • Item The name of the item. This is the name that will appear in the list for selection in the Markups list. (Required)
      • Subject The subject for the item. This links to the Subject property of a markup, allowing for selective filtering of the list based on the markup. (Optional)
      • To give the choice a numeric value (required if it is to be used in a formula), select Assign Numeric Value and enter the value in the number field to the right.
      • If this choice should be the default selection for the column, select Default.
    3. Select OK.

  3. To format the choice items, select Format.

  4. In the Choice Format dialog, set the formatting options as desired:
    • Allow Custom Text: When selected, you can select from choice items or manually enter custom text in the Markups list. When not selected, only defined choice items can be selected.
    • Format: Defines the display of numbers in Normal, Currency, or Percentage mode.
    • Decimal Places: Defines the number of decimal places (between 0 and 8) of numeric values.
    • Currency Symbol: Defines the currency type (if Currency has been selected as the Format).
  5. Select OK.

The Date custom column is a date-format column.

  1. On the Markups List toolbar, go to Markups List > Columns > Manage Columns. The Manage Columns dialog appears.

  2. Select the Custom Columns tab. Any custom columns are listed.

  3. Select Add.

  4. In the Add Column dialog, enter a display name for the column in the Name field.

  1. Select Date from the Type list.

  2. Select a date format from the Format list.
  3. Select a default value for the column from the Default list:
    • None: No date will be added when the markup is created.
    • Current: The current date will be added by default when the markup is created.
    • Custom: A specific predefined date will be added when the markup is created. To define the custom date, enter it in the Custom field or select to select a date from the calendar.
  4. Select OK.

The Formula custom column is a column with a defined mathematical operation that is performed on values from other columns in the Markups list. Both standard and custom columns can be used in this mathematical operation.

  1. On the Markups List toolbar, go to Markups List > Columns > Manage Columns. The Manage Columns dialog appears.

  2. Select the Custom Columns tab. Any custom columns are listed.

  3. Select Add.

  4. In the Add Column dialog, enter a display name for the column in the Name field.

  1. Select Formula from the Type list.

  2. Enter the formula in the Expression field. Formulae can consist of the following elements:

    When you start typing in the Expression field, a list of available Variables, Constants, Functions, and Operators appears. Select the desired elements, one at a time, to build your formula.

    You can also manually manipulate your formula, if necessary. For example, adding parentheses changes the order of operations, as in this formula: ( [Price] - [Discount] ) * [Quantity].

    See Tutorial: Custom Columns for Takeoffs and Estimations for a thorough walkthrough detailing the creation of some common kinds of formula.

  3. Select the display characteristics of the numerals from the Format list. The options are: Normal, Currency, or Percentage.
  4. Select the number of decimal places (between 0 and 6) of numeric values from the Decimal Places list.
  5. Select the currency type (if Currency has been selected as the Format) from the Currency Symbol list.
  6. Select Include In Totals to include the result of the formula when calculating the section divider in the Markups list.
  7. Select OK.

About the Measurement column in formulae:

  • Measurement is a default column in Revu that is important when defining formulas. The Measurement column contains only the numeric value of the primary measurement of a markup and does not contain the unit descriptor.

  • The measure markups like Length, Width, and Area contain an unit descriptor like in, cm, or sq ft. This makes these columns more readable in the Markups list, but also makes them unusable in a formula. The Measurement column removes the unit so only the value remains.

  • The Measurement column also contains the value no matter what type of measure markup was used. The Measurement column will automatically contain the value of a Length, Area, or Count.

The Number custom column is a numeric-format column.

  1. On the Markups List toolbar, go to Markups List > Columns > Manage Columns. The Manage Columns dialog appears.

  2. Select the Custom Columns tab. Any custom columns are listed.

  3. Select Add.

  4. In the Add Column dialog, enter a display name for the column in the Name field.

  1. Select Number from the Type list.

  2. Select the display characteristics of the numerals from the Format list. The options are: Normal, Currency, or Percentage.
  3. Select the number of decimal places (between 0 and 6) of numeric values from the Decimal Places list.
  4. Select the currency type (if Currency has been selected as the Format) from the Currency Symbol list.
  5. Select Include In Totals to include the result of the formula when calculating the section divider in the Markups list.
  6. Enter the minimum allowable value in the Min field. (Optional) 
  7. Enter the maximum allowable value in the Max field. (Optional) 
  8. Enter a default value in the Default field. (Optional) 
  9. Select OK.

The Text custom column is a text-format column.

  1. On the Markups List toolbar, go to Markups List > Columns > Manage Columns. The Manage Columns dialog appears.

  2. Select the Custom Columns tab. Any custom columns are listed.

  3. Select Add.

  4. In the Add Column dialog, enter a display name for the column in the Name field.

  1. Select Text from the Type list.

  2. To wrap text so that it appears on multiple lines if it is longer than the available space in the Markups list, select Multiline.
  3. Enter default text to be added with every new markup in the Default field.
  4. Select OK.

Custom columns can be removed and reordered from the Manage Columns dialog. Additionally, custom columns can be added to all documents using the column template. On the Markups List toolbar, go to Markups List > Columns > Manage Columns. The Manage Columns dialog appears.

  • Reordering the List: Select a column name then use the Up or Down buttons to reorder custom columns.

  • Deleting a Custom Column: Select the Custom Column tab, then select a column name and select Delete to delete it.

  • Automatically Adding Custom Columns to All Documents with the Column Template: Select the Custom Column tab, then select Save to Profile to add the currently defined custom columns to all PDFs opened or created in Revu. The columns will not be added to the PDF until data is actually entered into one of the columns. This is intentional, so that a save is required only if data has been added into one of the newly added columns (or some other change is made) and not simply because the PDF was opened. Select Delete from Profile to remove the template from future PDFs.

Related topics

Markups List

Creating a Custom Status

Markups List Filters

Tutorial: Custom Columns for Takeoffs and Estimations