Configure the Score Control
-
In WebAdmin, select Forms.
-
Select an existing form, or select Add New Form to create a new one.
-
Navigate to an existing element within your form or select Insert a new Element
. -
Select Maintain Element Settings
. -
In the Update Element Details dialog:
-
Select the Score control.
-
Select the Text field, and enter a description for the new control.
-
Select the Decimal Places field, and enter a limit to control how the value is displayed. For example, if the form is displaying the total cost of materials, you would want to display a value with no more than two decimal places.
-
In the Expression field, select Edit Expression
. -
In the Expression dialog, build a scoring expression using the following options:
-
Operands - select the required form elements that will be used as part of the calculation for the Score control. These elements must precede the Score control in the form.
All operands used as part of the calculation must be populated, otherwise the calculation will not be performed. To ensure the required fields are populated, set Mandatory to On in the form elements used as operands.
-
Functions - select one or more functions to use with selected operands.
The following functions are available:
-
AVG - takes the total of the values entered within the related brackets and outputs an average.
-
COUNT - counts up the number of instances of operands selected within the related brackets.
-
SUM - provides a total based on the operands within the related brackets.
-
IF - allows you to insert a condition as part of the expression.
-
ISNOTNULL - specifies that the values in the related brackets cannot be null.
-
NULL - specifies that the values in the related brackets must be null.
-
MIN - allows you to use the minimum value from a group of operands within the related brackets as part of your expression.
-
MAX - allows you to use the maximum value from a group of operands within the related brackets as part of your expression.
A selected function appears in the Expression field in the following format: AVG(). Click within the brackets and then select operands as required.
-
-
Operators - select to formulate the mathematical expression required for the Score control.
-
-
Select OK.
-
Configure other control options as required. For more details refer to Form Sections and Controls.
-
Select Save.
-
-
Save
and Publish
the form. -
Ensure the form is assigned to an application or visit task within a solution.