Form Builder Control-Specific Properties

This section lists all of the Form Builder controls and describes the properties specific to each one. See Form Builder Common Control Properties for properties common to multiple controls.

Button

A push-button control that, when clicked, performs a pre-defined block of JavaScript code.

Property Description Sample Value Mandatory or Optional Notes
Type Determines the appropriate action to carry out when the button is clicked. The button inherits the characteristics and actions of the button Type. For example, if Type is Print, the end-user can click the button to send the current screen to print. Print Mandatory Options include:

Button (must specify On click property)

Submit

Submit & New

Cancel

Save

Print

Reload

Reset

If Type is Button, a custom JavaScript block, or a standard web function, must be specified in the On Click property. If the user reloads the page (that is, clicks the Next or Previous buttons with the type Reload), the value of the selected control changes from the time the form was loaded to the time the page changes (or reloads). In this case, the Datasource is refreshed from the database and displays the updated data.

Check Box

Displays a list of options. Users can select multiple options from the list. The values are a static set that are entered into the control via the control's Items property.

Use the Check Box control when the user is presented with a Yes or No, True or False option. For example:

Where did you hear about Infor (select all sources that apply)?

  • Newspaper
  • Radio
  • Friends
  • Clients
  • Consultants
  • Other. If other, please specify_____________.
Property Description Sample Value Mandatory or Optional Notes
Value Represents the control's default value. Two options: selected

cleared

Selected Optional Defaults to cleared.

Date Picker

Provides a calendar from which a date can be selected.

Property Description Sample Value Mandatory or Optional Notes
Mask A date string that provides the template against which input data is validated. The following strings (case-sensitive) can be used:

dd/MM/yyyy

dd MM yyyy

dd-MM-yyyy

Optional

Date Range

Allows users to select a date range on the form. This control uses specialized drop-down controls with predefined date range items (which are localizable) and links to Date Picker controls. The control allows for server-side resolution of dates for scheduled reports. If the Date Range is set to a value other than empty or Manual, dates for Date Pickers are calculated at the report run time, based on the current date and the Date Range selection.

Property Description Sample Value Mand-atory or Optional Notes
End DatePicker The date picker for the end date of the range. A Date Picker:

Mandatory This property links to a DatePicker control. You must first add the DatePicker control to the form and specify the control’s properties. See Date Picker.

If the End Date is changed to be less than the Start Date, then the Start Date is set to the End Date.

Start DatePicker The date picker for the start date of the range. A Date Picker:

Mandatory This links to a DatePicker control. You must first add the DatePicker control to the form and specify its properties. See Date Picker.

If the Start Date is changed to be greater than the End Date, then the End Date is set to the Start Date.

Items The list of values (types of date ranges) from which the user can select. Today Mandatory Options include:

Manual Date

Today

This Week

This Month

This Year

Yesterday

Previous Week

Previous Month

Previous Year

Tomorrow

Next Week

Next Month

Next Year

Last 3 Days

Last 7 Days

Last 30 Days

If the user selects Manual Date, then the user must enter (or use the Date Picker to select) the start and end dates in the range.

If the Start Date or End Date is modified, this setting automatically becomes Manual.

DB ListBox

Displays a list of values. Users can select multiple options from the list. Like the DB LookUp control, the values in the DB ListBox control are dynamically populated via a Data Source control. See Data Source. This control is ideal for smaller data sets that do not require search functionality. Conversely, use the DB LookUp control to display larger sets of data that require search capabilities.

Property Description Sample Value Mand-atory or Optional Notes
Lookup Display Determines the field that is displayed by the control. emp_name

The Employee Name, from the EMPLOYEE table, is displayed in the listbox and on the form when selected.

Mandatory See Lookup Source.
Lookup ID Determines the field that is actually retrieved. This property is the value against which all calculations can be run. emp_id

The emp_id field from the EMPLOYEE table, that is retrieved by the lookup.

Mandatory See Lookup Source.
Lookup Source Links the DBListBox to a data source. dsEmployee

Links to the dsEmployee datasource control which has already been added to the form and linked to the EMPLOYEE table.

Mandatory The data source you select determines the fields that can be selected from the Lookup Display and Lookup ID properties, so you must complete this property first.
Populate at Sender Node If selected, the control is pre-populated at the Sender Node with the first value from the associated data source. Otherwise, the control is blank when the form is rendered. A selected checkbox. Optional

DB DropDown

Displays a list of values. Users can select one option only from the list. Like the DB LookUp control, the values in the DB DropDown control are dynamically populated via a Data Source control. See Data Source.

The DB DropDown control is ideal for smaller data sets to do not require search functionality. Conversely, use the DB LookUp control to display larger sets of data that require search capabilities.

Property Description Sample Value Mand-atory or Optional Notes
Lookup display Determines the field that is displayed by the control. emp_name

The Employee Name, from the EMPLOYEE table, is displayed in the drop-down list and on the form when selected.

Mandatory See Lookup Source.
Lookup ID Determines the field that is actually retrieved. This is the value against which all calculations can be run. emp_id

(The emp_id field, from the EMPLOYEE table, is retrieved by the lookup.)

Mandatory See Lookup Source.
Lookup source Links the DBDropDown to a data source. dsEmployee

(Links to the dsEmployee datasource control which has already been added to the form and linked to the EMPLOYEE table.)

Mandatory The data source you select determines the fields that can be selected from the Lookup Display and Lookup ID properties, so you must complete this property first.
Populate at Sender Node If selected, the control is pre-populated at the Sender Node with the first value from the associated data source. Otherwise, the control is blank when the form is rendered. A selected checkbox. Optional

DB Lookup

Displays a list of values. Depending on how the control is set up (see the Multiple Selection property), users can either select one option or multiple options from the list of available options. See Data Source.

Like the DB DropDown control, the values in the DB LookUp control are dynamically populated via a Data Source control. Since the DB LookUp control provides built-in search functionality, the control is better suited for larger data sets.

Prop-erty Description Sample Value Mand-atory or Optional Notes
Lookup display Determines the field that is displayed by the control. emp_name

(The Employee Name, from the EMPLOYEE table, is displayed on the form.)

Mandatory At run-time, the Lookup window property determines the Data Source fields displayed in the DB LookUp, the Lookup ID determines the field that is actually retrieved, and the Lookup display determines which field is displayed by the control.
Lookup ID Determines the field that is actually retrieved. This is the value against which all calculations can be run. emp_id

(The emp_id field, from the EMPLOYEE table, is retrieved by the lookup.)

Mandatory See notes above and see Lookup Source.
Lookup popup Determines the Data Source fields displayed in the DB LookUp. emp_id

emp_name

(The Employee ID and Employee Name, from the EMPLOYEE table, is displayed in the DB Lookup, where the user selects the employee or employees to appear on the form.)

Mandatory See notes above and see Lookup Source.
Lookup source Links the DBLookUp to a data source. dsEmployee

(Links to the dsEmployee DataSource control which has already been added to the form and linked to the EMPLOYEE table.)

Mandatory
Multiple selection Determines whether one or multiple items can be selected A selected checkbox. Optional The data source you select determines the fields that can be selected from the Lookup Display, Lookup ID, and Lookup window properties, so you must complete this property first.
Populate At Sender Node If this check box is selected, the control is pre-populated at the Sender Node with the first value from the associated data source. Otherwise, the control is blank when the form is rendered. A selected checkbox. Optional
Resolve Source An alternative method to retrieve LookupID values from the Lookup Source.

Resolve source should return all of the data that Lookup Source does, but more quickly. In the case of SQL statements, Lookup Source might use multiple tables and WHERE clauses, whereas Resolve Source simply selects all the data from the corresponding table or tables.

When a form is rendered in nodes other than Sender, the system executes Lookup Source in the background in order to retrieve data required by the system. If there is a value for Resolve Source specified, the system retrieves the same data using that more efficient Resolve Source.

ResolveSource may seem to return more data then LookupSource (e.g. does not have restrictions imposed by joins). Actually the property does not. The system always appends a where clause to the property, returning only records with IDs that have previously been selected by Sender.

The source used when a user clicks on DBLookup button is always Lookup Source. Resolve Source is used exclusively by the system internally.

If Lookup Source itself does not present performance issues, using Resolve Source does not make a significant difference.

All Button If selected, an "All" button is added to the database lookup. The button enables the user to select all the items in the list. A selected checkbox. Optional
User Typeable If selected, the user can specify values in this field. A selected checkbox. Optional
Populate at Sender Node If selected, the control is pre-populated at the Sender Node with the first value from the associated data source. Otherwise, the control is blank when the form is rendered. A selected checkbox. Optional

Formula

Creates a non-editable field, which can perform calculations.

Property Description Sample Value Mand-atory or Optional Notes
Auto format If selected, automatically performs the formula calculation as values are being entered into the referenced controls. A selected checkbox. Optional Defaults to selected.
Calculation order Used when multiple formula fields appear on a form. Defines the order in which the formula fields are evaluated. 4 Optional Defaults to 0.
Data type Represents the type of data contained in the field or that can be accepted. Number Optional Options include:

Number

Date

Defaults to Number.

Decimal Formats the formula results according to number of decimal places specified in the Decimal places property value. A selected checkbox. Optional Decimal must be used in conjunction with the Decimal places property. Always rounds the number up.
Decimal places Formats the formula results according to a specified number of decimal places. 2 Optional If Decimal places are used, then the Decimal property value must be selected.

Rounds numbers up.

Formula Build expressions to perform calculations based on referenced controls. Formulas can be set to calculate automatically (Auto format property). Formula results appear in the field.

Formula results do not appear if referenced controls are not populated.

From the Formula Builder dialog box, select Fields, Operators, and Functions to build an expression for populating the Formula control.

textbox1+ textbox2 Mandatory The calculation to be performed and displayed by the Formula control.

Hidden

Stores a value that does not appear on the form. This value can be used elsewhere on the form; for example, as part of a calculation.

Property Description Sample Value Mandatory or Optional Notes
Data type Represents the type of data contained in the field or that can be accepted. Number Optional Options include:

String

Number

Date

Defaults to String.

Value Represents the control's default value Hidden Field Optional Defaults to blank.

Hyperlink

Creates a link to a pre-defined URL.

Property Description Sample Value Mandatory or Optional Notes
URL Represents the hyperlink Internet address to which the user is re-directed. For example, to create a hyperlink to the application Web site on the form, set the Caption property to "Home Page", and set the URL to

http://www.wfm.com/

Mandatory Must include the access protocol (for example, http).
Window Indicates whether the page to which the user is redirected, is displayed in a new window or in the same browser window. New Mandatory Options are:

New

Redirect

Html

Places HTML text in the report. Use HTML tags such as <b> and <i> to specify text formatting.

Property Description Sample Value Mandatory or Optional Notes
Html Places HTML text in the form. Specify the text in the dialog box, using HTML tags. <b> and <i> to specify text formatting Mandatory

Image

Places a *.GIF image onto the form. Typically used to place company logos onto the form.

Property Description Sample Value Mandatory or Optional Notes
Border Represents the thickness the control's border. 5 Optional Measured in pixels.
URL Represents the location of the image (*.GIF) file. /<application folder>/images/common-img/companylogo.gif Mandatory The forward-slash (/) should be used to begin the relative path of the image location.

Label

Displays descriptive text on the form.

Prop-erty Description Sample Value Mandatory or Optional Notes
Column Order Organizes columns in CSV and XLS reports. 1 Optional By default, this parameter is set to -1 (which represents relative positioning). This setting works for HTML and PDF reports always, as controls in these reports are positioned using absolute locations. XLS and CSV reports may or may not work using relative positioning, depending on the controls' alignment. Setting up and using this property from the 1st column (Column Order = 0) to the N column (Column Order = N-1) for all label or report summary controls in the headers or footers or details sections, forces the positioning to be correct in any CSV and XLS report.
Preserve Value Preserves the value of the label as the label moves through the workflow. A selected checkbox. Optional This must be selected in order to mark the control as Batch Approvable.
F.g. positive Color if the label is a number with a positive value. 0,0,0 (Black) Mandatory Defaults to Black.
F.g. negative Color if the label is a number with a negative value. 255,0,0 (Red) Mandatory Defaults to Black.
Display Zero Indicates whether 0 is displayed when the label is a number with a value of zero. If this property is not set, a dot (.) is displayed. A selected checkbox. Optional
Mask The Mask for the label value. Represents a character string that provides the template against which input data is validated. The mask $$$-$$-$$$$ is used to validate a social security number (for example, 123-45-6789) Optional The following special symbols can be used:

? = all letters

@ = any character

$ = digits, '-','+', and '.' signs

[ ] = represents a list of valid chars

All other characters are treated as literals.

Contains HTML Indicates whether the label contains HTML text. A selected checkbox. Optional

Mask Edit

Validates the data that is input by testing for conformance to a defined template.

Property Description Sample Value Mandatory or Optional Notes
Data type Represents the type of data contained in the field or that can be accepted. Number Optional Options include: String

Number

Date

Defaults to String.

Mask Represents a character string that provides the template against which input data is validated. The mask $$$-$$-$$$$ is used to validate a social security number (for example, 123-45-6789) Mandatory The following special symbols can be used:

? = all letters

@ = any character

$ = digits, '-','+', and '.' signs

[ ] = represents a list of valid chars

All other characters are treated as literals.

Password

An editable password text input field. The field hides the user's input with asterisks (*) to maintain password secrecy.

Property Description Sample Value Mandatory or Optional Notes
Max. length Maximum allowable number of characters that the user can enter into the field. 8 Mandatory Defaults to 50 characters.
Text Default text WFM Optional Defaults to "Text."

Password Text always is displayed as asterisks (*).

Radio Buttons

Displays a list of options. Users can select one option only from the list. The values are a static set that are entered into the control via the control's Items property.

Property Description Sample Value Mandatory or Optional Notes
Checked Indicates which radio button, if any, is selected by default. If Yes is selected, then radio button items appear as:

Optional Can only be specified after Items property is set. Choose one of the set items as the item that is selected by default.
Data type Represents the type of data contained in the field or that can be accepted. Number Optional Options include:

String

Number

Date

Defaults to String.

Items Radio Button items (options) from which users can choose. Yes

No

Undecided

Is displayed as the following:

Users can only choose one from the available list of Radio Button items.

Mandatory

Radio Buttons

Displays a list of options. Users can select one option only from the list. The values are a static set that is entered into the control via the control's Items property.

Property Description Sample Value Mandatory or Optional Notes
Checked Indicates which radio button, if any, is selected by default. If Yes is selected, then radio button items appear as:

Yes

No

Undecided

Optional Can only be specified after Items property is set. Choose one of the set items as the item that is selected by default.
Data type Represents the type of data contained in the field or that can be accepted. Number Optional Options include:

String

Number

Date

Defaults to String.

Items Radio Button items (options) from which users can choose. Yes

No

Undecided

Mandatory Users can only choose one from the available list of Radio Button items.

Rectangle

Used to create a rectangle shape that can visually group related items on a form.

Property Description Sample Value Mandatory or Optional Notes
Thickness Thickness of the control's border. 5 Optional Measured in pixels.

Table

Used to group form controls into a tabular or grid-like format for readability purposes. The control acts as a "container" for other controls such as TextBoxes, DropDowns, and other subordinate controls. The control automatically resizes to fit the controls that are dropped into the Table cells.

Property Description Sample Value Mandatory or Optional Notes
Border Thickness of the table frame border. 5 Optional Measured in pixels.
Bordercolor dark Color of the control's border. Specifically, the top and left borders of the table frame and the bottom and right borders of the cell frames. Black Optional Default color is Light Gray.
Bordercolor light Color of the control's border. Specifically, the bottom and right borders of the table frame and the top and left borders of the cell frames. Dark Gray Optional Default color is Gray.
Cell padding Thickness of the space between the subordinate control and the table line. 2 Optional Measured in pixels.
Cell spacing Spacing between the cells within the table. 2 Optional Measured in pixels.
Columns Represents the number of columns within the table. 5 Optional Cannot delete columns that contain subordinate controls.
Frame Appearance of the table frame border. LHS means frame border on the left hand side of the table only. Optional Options include:

Above

Below

Border

Box

Hsides (Horizontal sides)

LHS (Left-hand side)

RHS (Right-hand side)

Void

Vsides (Vertical sides)

Defaults to Box.

Rows Represents the number of rows within the table. 5 Optional Cannot delete rows that contain subordinate controls.

Text Area

An editable field that enables users to input text on a single line. This type of field is most commonly used to enter comments, notes, and so on.

Property Description Sample Value Mandatory or Optional Notes
Text Default text value. WFM Optional Defaults to "Text."

TextBox

An editable field that enables users to input text on multiple wrapping lines. This type of field is most commonly used to enter comments, notes, and so on.

Property Description Sample Value Mandatory or Optional Notes
Data type Represents the type of data contained in the field or that can be accepted. String Mandatory Options include:

String

Number

Text

Text Default text value. WFM Optional Defaults to "Text."
Max Length The maximum number of characters that can be entered in this field 8 Mandatory Defaults to 50.

TimeEdit

A group of fields, which enable users to specify the time.

Property Description Sample Value Mandatory or Optional Notes
Decimal Minutes If selected, measures time as fraction values. If not selected, measures time as actual time values. 4:50 Optional If time is measured in Decimal Minutes, then 4:50 equals 4½ hours.

If time is not measured in Decimal Minutes, then 4:50 equals 4 hours and 50 minutes.

Look Represents the control's appearance and input method.

Combo -

Spin -

Text -

Box -

Optional Defaults to Combo.
Mask A date string that provides the template against which input data is validated. dd/MM/yyyy Optional The following strings (case-sensitive) can be used:

dd/MM/yyyy

dd MM yyyy

dd-MM-yyyy

Max. Hour Controls the maximum hour value that can be entered. 24 Mandatory Defaults to 24
Max. Minutes Controls the maximum minute value that can be entered. 0 Mandatory Defaults to 0
Min. Hour Controls the minimum hour value that can be entered. 0 Mandatory Defaults to 0
Min. Minutes Controls the minimum minute value that can be entered. 0 Mandatory Defaults to 0
Standard How time is expressed, in 12-hour format or 24-hour format. For example, 3 o-clock in the afternoon in 12-hour format is 3:00 PM. In 24-hour format, the time is 1500. Optional If this value is not set, then the time format set in the SYSTEM_TIME_STANDARD application parameter is used.
Step Represents the control's minute increments. 5 means that time can be entered as five-minute increments. Optional Defaults to 1
Text Default time value that is displayed in the field. 1215 (equals 12:15 PM)

0015 (equals 12:15 AM)

Optional Must enter time in 24-hour format.
Type Specifies the type of Time field. Time Mandatory Options include:

Time (a specific time)

Interval (a time range)

User DropDown

Displays a list of values. Users can select one option only from the list. The values are a static set that is entered into the control via the control's Items property.

Property Description Sample Value Mandatory or Optional Notes
Data type Represents the type of data contained in the field or that can be accepted. Number Optional Options include:

- String

- Number

- Date

Defaults to String.

Items Drop-down list of items (options) from which users can choose. Candy

Bubble gum

Chocolate

Apple

Mandatory Users can only choose one from the available list of drop-down items.
Value Represents the control's default value Yes Optional Defaults to blank

User ListBox

This table lists properties specific to this control. See Form Builder Common Control Properties for common control properties.

Property Description Sample Value Mandatory or Optional Notes
Data type Represents the type of data contained in the field or that can be accepted. Number Optional Choose from:

- String

- Number

- Date

Defaults to String.

Items Scroll list of items (options) from which users can choose. Yes

No

Undecided

Mandatory Users can choose multiple items.
Value Represents the control's default value Yes Optional Defaults to blank.

Application User

Displays a dynamic list of active WFM users. This is particularly useful when forwarding forms or interactions to specific individuals.

Property Description Sample Value Mandatory or Optional Notes
Value Represents the control's default application User Name value Wendy Smith Optional Defaults to blank.