Navigation:  Admin Panel > Forms > Field List >

Edit Field : Drop down

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

When the type of Field is set to 'Drop-down', users can only select 1 value from a drop down list (by selecting a field of the type 'Grid' more values can be shown).
 

Settings

clip0257

Source : Set the Source to be a Datastore Parameter or a Webservice.
Select Parameter: Select a Parameter from the DataStore , or a WebService from the created WebServices.
Max entries to be shown : set the max number of values to be shown. We adise for dropdown to have no more than 30 entries. If more, please use a Searchable listbox. Default value is 1000.
Filter out duplicate values : Option to only show unique values. Please note that the combination of the fields sent to the workflow are used to define what are unique values. When for example Name and Country are sent to the workflow and Country is displayed; the list will still show duplicate country names in case there are multiple Names (sites) in a country. In that case remove Name from the values to send to the workflow, and only unique countries are displayed.
Preselect: If you want to preselect entries.
- Nothing: no values are preselected
- First value : the first value is preselected. Sorting is alphabetically, or as set in the field 'Sort Field'
- All values : select all values
Set display field per language: Per Language, select the Parameter field that should be displayed for the language.
Sort Field: Select the field to be sorted upon. The default is the display field of the primary language (first language option).
Value Fields to send to workflow: Select one or more fields from the selected Parameter. The selected values will be sent to the workflow. Only values that are sent can be used in Processes. Linked values can be de-selected by clicking the X before the name of the value. At least 1 value needs to be selected.

Default Answer

Dynamic answer & Calculations

To give a field a default answer, multiple options are available. Also multiple default values are supported, which can be concatenated into 1 default answer. This can be configured under the section Translations: Label & Default answer & help text.

defautlvalues

Default answer : Select what kind of default answer should be displayed

 Fixed Value: When this option is set, the field always contains the same default answer that is defined in free text

 Person field : Select this option when user data should be used as default answer. User variables can be edited in the Admin | Adapter menu.

 Form field : Use this option when the default answer should be derived from another question. The first drop down list, shows all fields of the current form that show DataStore Parameters (selection fields). In the second drop down list, the column from the parameter can be selected. In the example below, the default answer is the Name of the Group chosen in the earlier question "Select Group":

 Main/Sub-Form field: Use this option when the default answer is provided by another form than the current form. This may occur when sub forms are used.

 Process Instance Variable: Use this option when a form is used in a process as an external form. The variable is listed as <variable name>(<process name>)

 Repeatable section index : when using repeated sections, you might want to know the sequence number of that section. use this option to implement it in your form (for example to show the number of entries).

Calculation Fields

SSP allows to make basic calculations, using default values. If you want for example to sum up 2 values, entered previously in the form in 2 other Fields, you can make that using calculation fields.
You can make complex calculations by using brackets.

To activate the calculation engine, first check the field : 'Dynamic value contains calculations':

calcfield01

The second checkbox allows to hide calculation errors for end user.

clip0408

For example, if you want the sum of 2 fields that are in text fields:

calcfield02

As long as the 2 Fields are not filled in, the calculation can not be made. This will result in an error message on-screen:

clip0407

When the option 'Hide calculation info from user' is checked, the errors will no longer appear.

 

Supported Operators and examples of calculation fields.

Supported operators:

+
-
*
/

These operators have been extended and continue to. We refer to the WIki for more information & examples on Calculations in Forms: http://wiki3.smt-x.com/index.php?title=FormTips

Examples:

Sum of 2 fields : #REPLACE-FORMFIELD-Numbers example||number1||# + #REPLACE-FORMFIELD-Numbers example||number 2||#
Divide Field 1 by Field 2 : #REPLACE-FORMFIELD-Numbers example||number1||# / #REPLACE-FORMFIELD-Numbers example||number 2||#

alert_1818 To avoid issues, you can choose to replace an empty value by set value, as shown in this example:  use : ToNumber('#field reference here#',0), Example:

ToNumber('#REPLACE-FORMFIELD-Numbers example||number1||#',0) + #REPLACE-FORMFIELD-Numbers example||number 2||#

In this case, the first value is replaced by '0', as long as nothing is entered in the source field called 'number1'.

alert_1818 You can also set the number of digits after the separator, using  : Format('{0:Fx},   <<value here  >> ), where Fx stands for the number of values behind the comma-separator.

Examples:

Format('{0:F2}',#REPLACE-FORMFIELD-Numbers example||sum||#) -> result : 5.00
Format('{0:F5}',#REPLACE-FORMFIELD-Numbers example||sum||#) -> result : 5.0000

 

 

 

Filters

Filters

With dynamic filtering it is possible to filter the content of selection lists, based on values in the current form, fixed values, or user variables. This functionality is very convenient to show people only subsets of lists, based on their personal situation or answers given earlier. On top of that, the maintenance in the Datastore is reduced, as single lists can be used with different forms and in various situations.

Please note that dynamic filtering of lists only becomes available after a new field has been saved. When the field has not been saved yet, the dynamic filtering looks like this.

clip0258

After saving the field, the following is displayed in the Selection field settings area:

clip0259

- Connector : how to connect the different rules. SSP handles subfilters as wel.
- Parent Filter: if a Subfilter is created, it can be selected here.
- Field to be filtered: To define a dynamic filter on the selected Datastore parameter, choose the column from the parameter ('Field to be filtered') that should be filtered .
The column can now be used to define a condition via:
- Operator: these operators are available:

 - clip0260

- Value : Enter a fixed text, or make a dynamic entry, based on the selection below this field.

  Options:
 Person Field: Any information from the Requestor or the Requested For can be selected. These fields are defined under Admin > Adapters > Person Data.

 Form Field: The drop down list shows all questions. By selecting a question, all fields of the parameter become available. The selected column will be used as default answer of the current question.

       Main/Sub Form Field: When Subforms are used in a form, use this option to select it, and see the Fields belonging to it. This can be used both when defining the main form, as well as the sub form.

 Base Form Field : When a form is used in a process, you might want to use a field from the form that was used to start the process. This is where you can select those fields.

 Process Instance Variable: when a form is used in a process, you have access to the Variables that are defined in that process. Select the process and the variables are presented for selection.

 Repeatable section index : when using repeated sections, you might want to know the sequence number of that section. use this option to implement it in your form (for example to show the number of entries).

Multiple Filters can be defined, by choosing another (or the same) field in the menu "Add Field to be Filtered" and clicking add button. Conditions can be combined with AND, OR, AND Subfilter, OR Subfilter connectors. Although there is no restriction enforced by the application, it is not advised to use AND and OR connectors mixed.

Filltering4

In case the filtering condition is using fields that are part of a section, the dynamic filtering will ignore the value in these field when they are currently not displayed in the form. Only fields visible in the form are considered in the condition, with the exception of Hidden fields.

 

Use the SAVE button to save the changes and remain on this screen, or use the OK button to save your changes and return to the Overview screen, or use the CANCEL button to discard any changes.