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. | Mandatory | Options
include:
Button (must specify On click property) Submit Submit & New Cancel Save 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. |