Template (Role Excel Column Control) H

Template (Role Excel Column Control) V

Use this page to:

To access this page:

  1. Click dspCompose > Team on *Navigation *pane.
  2. Click Templates for a team.
  3. Click Roles for a template.
  4. Click Excel Column Control for a role.

Template (Role Excel Column Control) V (All Tabs)

Template (Role Excel Column Control) H

This page contains the following tabs:

General tab

Use this tab to Add List Boxes to an Excel File.

Field

Description

Column

Column Name

Displays name of column within the Excel file generated by dspCompose™ for data entry purposes.

Column Format

Displays the format required when populating the column name with data in the generated Excel file.

Colors

Background Color

Displays background color of cell containing the column in the Excel file.

Text Color

Displays text color for column in the Excel file.

List Settings

List Data Source ID

Displays the data source that contains the view or table used in a list box within the generated Excel file.

List Source

Displays the view or table that contains the values used in a list box within the generated Excel file.

List Value

Displays the column that contains the list value used in a list box within the generated Excel file.

List Display

Displays the column that contains the display value used in a list box within the generated Excel file.

Advanced Validation tab

Use this tab to Create Validations for List Boxes.

Field

Description

List

Named Range Only

If enabled, the Name Range Only custom validation rule for the selected column is used. A “Name Range Only” list box allows a Template Administrator to set up and use advanced list boxes that reference other list boxes and validations within the generated Excel file generated by dspCompose™ to control what data users enter on the spreadsheet.

Custom List Formula

Displays formula used in the custom validation for the selected column. A custom list formula allows a Template Administrator to create advanced, custom list boxes, especially when combined with Name Range Only list boxes.

Custom Validation

Custom Validation Formula

Displays the formula used in the custom validation for the selected column. The Custom Validation Formula is written for the formula field for the validation and allows for dynamic substitution of column names, such that the column name is replaced with the column index.

Custom Validation Message

Displays message sent to the user if the validation used by the custom validation formula fails.