FORMS

Question table

You can use a question table to create a table in which users can enter data such as numbers for a time period on Web.

You can customize each cell in the table by using labels, functions, input fields, and other elements.

Creating a Question table

To create a question table, right-click the form page for the form to include the table and choose Add -> Question table.

Properties

General

Question text – the header text for the question table. The header can be a question or a custom text. Corporater BMP supports regular text and dynamic (token) tags. To include a dynamic tag, click the Lookup button () and select one or more context variables from the list.
For the tag to be correct, it mustn't include white spaces, especially between '$' and '{'. For example, use '$ {this.object.id}' instead of '$ {this.object.id}'.
Name – the name of the question table. This field is empty by default.
If you leave the field blank, Corporater BMP uses the value in Question text as the name.

Configuration

Require answer – select for Corporater BMP to require users to answer the question in Question text to be able to submit the form.
Period type – the period type against which Corporater BMP registers answer data and displays it on Web.

Context

Node – the node against which Corporater BMP stores answer data. Click the Node button () to create a new node or to select an existing one from the list.
If the form's configuration includes Auto generate nodes as selected, Corporater BMP automatically creates a new node for the answer data.
Node type – the node type against which Corporater BMP stores answer data. Click the Node type button () to create a new node type or to select an existing one from the list. The default node type is 'Actual'.
Organization – the organization for which Corporater BMP stores answer data. Click the Organization button () to create a new organization or to select an existing one from the list.
If you leave the field blank, Corporater BMP uses the organization to which it distributes the form.

Audit

Modified by - the name of the last user to make changes to the object.
Last modified - the date and time when the object was last changed.
Created by - the name of the user who created the object.
Created - the date and time when the object was created.

Custom

Use the Custom tab to define the layout for the question table. By default, the table contains three rows and three columns. You can add more rows or columns, or delete them from the table.
Cells have individual configurations. You can configure each cell to be of the same type, or of a different type. Corporater BMP supports the following cell types:

Label
Input
Function
Status gauge
Trend

To configure a cell, right-click it and select Add -> [Type].

Label

A label cell includes a custom, predefined text. To configure it, double-click the cell and then click the Configuration button ().

Configuration

Alignment – the alignment of the text in the cell. The default alignment type is 'Left'. Corporater BMP supports the following alignment types:
- Center
- Left
- Right

Cells of 'Function' or 'Input' type are right-aligned by default.

To use the text as a column header, change its alignment to 'Right'.

Label – the text in the cell. The default text is 'Label'. You can change this to a text of your choice.
Click the Lookup button () and format the text. You can add context variables to make the text dynamic.

Input

An input cell allows users to enter data directly in the cell on Web. To configure it, double-click the cell and then click the Configuration button ().

Configuration

Date modifier – applies if the input is for a period other than the current one. The period that the input is for. Click the Date calculation button () and specify the period. For information, see Adjusting functions.
Min. value – the lowest value for the input data.
If you leave this field empty, Corporater BMP doesn't apply validation to the cell on Web. Click the Function button () and configure the value.
Max. value – the highest value for the input data.
If you leave this field empty, Corporater BMP doesn't apply validation to the cell on Web. Click the Function button () and configure the value.
For users to be able to enter '0' as the value of the data input cell on Web, leave Min. value and Max. value blank, or set a minimum - maximum value interval that includes the value '0'.

Context

Node – the node against which Corporater BMP stores the data in the cell. Click the Node button () to create a new node or to select an existing one from the list.
If you leave the field blank, Corporater BMP uses the node of the question table.
Node type – the node type against which Corporater BMP stores the data in the cell. Click the Node type button () to create a new node type or to select an existing one from the list.
If you leave the field blank, Corporater BMP uses the node type of the question table, if available.
Organization – the organization for which Corporater BMP stores the data in the cell. Click the Organization button () to create a new organization or to select an existing one from the list.
If you leave the field blank, Corporater BMP uses the the organization of the question table, if available.

Format

Format type – the format of the data in the cell. Corporater BMP uses it as an indicator for how to display the value in the cell in the custom table on Web. For more information, see Formatting.
- Normal — as a whole number.
- Percentage — in percentage form.
  Corporater BMP automatically attaches the necessary percentage symbol ('%'). For example, if you enter '0.50', Corporater BMP displays it as '50%'.
- Thousands — in thousands.
- Millions — in millions.
- Billions — in billions.
- Blank — use to prevent users to enter data in this cell.
- Date — as a date.
- Duration — as a time length.
  Corporater BMP calculates the value in milliseconds.
Prefix – the text or symbol to display before the value. For example, if you enter '$', Corporater BMP displays the value as '[value]$'.
Postfix – the text or symbol to display after the value. For example, if you enter 'liters', Corporater BMP displays the value as '[value] liters'.
Decimal places - the number of decimals to display for the value.
Color style – the color of the value.
- Normal – normal color (default).
- Positive in green & negative in red – green if positive and red if negative.
- Positive in green – green if positive and normal if negative.
- Negative in red – red if negative and normal if positive.

Duration type – available only if the Format type value is 'Duration'. The format type of the duration. Corporater BMP uses it as an indicator for how to display the value in the cell in the custom table on Web.
- Hours:Minutes – for example, '277:46'.
- Hours:Minutes:Seconds – for example, '277:46:40'.
- Minutes:Seconds – for example, '16666:40'.
- Weeks – for example, '1.65'.
- Days – for example, '11.57'.
- Hours – for example, '277.78'.
- Minutes – for example, '16,666.67'.
- Seconds – for example, '1,000,000.00'.

Function

A function cell includes the result of a custom, predefined function. To configure it, double-click the cell and then click the Function button ().

Configuration

Function – the function that determines the value in this cell. Click the Function button () and configure the function.

Format

Format type – the format of the data in the cell. Corporater BMP uses it as an indicator for how to display the value in the cell in the custom table on Web. For more information, see Formatting.
- Normal — as a whole number.
- Percentage — in percentage form.
  Corporater BMP automatically attaches the necessary percentage symbol ('%'). For example, if you enter '0.50', Corporater BMP displays it as '50%'.
- Thousands — in thousands.
- Millions — in millions.
- Billions — in billions.
- Blank — use to prevent users to enter data in this cell.
- Date — as a date.
- Duration — as a time length.
  Corporater BMP calculates the value in milliseconds.
Prefix – the text or symbol to display before the value. For example, if you enter '$', Corporater BMP displays the value as '[value]$'.
Postfix – the text or symbol to display after the value. For example, if you enter 'liters', Corporater BMP displays the value as '[value] liters'.
Decimal places - the number of decimals to display for the value.
Color style – the color of the value.
- Normal – normal color (default).
- Positive in green & negative in red – green if positive and red if negative.
- Positive in green – green if positive and normal if negative.
- Negative in red – red if negative and normal if positive.

Status gauge

A status gauge cell presents the result value of a status-related function as a status gauge or a status icon. To configure it, double-click the cell and then click the Configuration button ().

Configuration

Status – the status-related function that determines the value in this cell. Click the Edit button () to create a new function or to select an existing one from the list.
Status icon – the representation of that value.
- Bullet – a status bullet
- Status gauge

Trend

A trend cell presents the result value of a status-related function as a trend arrow. To configure it, double-click the cell and then click the Configuration button ().

Configuration

Trend – the status-related function that determines the value in this cell. Click the Edit button () to create a new function or to select an existing one from the list.

Advanced

ID - a unique ID for the object.

By default, Corporater BMP assigns consecutive numbers to new objects.

You can change the ID to a value of choice that can include either letters or letter and number combinations.

The ID mustn't contain only numbers, include special characters such as ) ( . * } { + < > [ ], or match the name of a default object type in Corporater BMP.

Storage

Storing period – the period against which Corporater BMP collects and stores the data in the question table. Click the Date calculation button () and specify an adjusting function based on the form's distribution date. For example, use '-1M' for the previous month.
The value that you specify overrides the value for Storing period for the form.

Access control

Read accessors - click the Edit button () and authorize one or more users and user groups to view the object on Web.
Add accessors - click the Edit button() and authorize one or more users and user groups to add new objects to the object on Web.
Write accessors - click the Edit button() and authorize one or more users and user groups to edit the object on Web.
Delete accessors - click the Edit button() and authorize one or more users and user groups to delete the object on Web.
Ownership - click the Edit button () and grant ownership of the object to one or more users and user groups.

Users and user groups who own the object have full access rights to it.
Override access profile - select for the object's access control setting to outrank the object's corresponding access settings in profiles.