Permitted Value List

Permitted values are derived from the Permitted Values and Formats specified in the Database folder in Iron Speed Designer.  The permitted values instruct Iron Speed Designer to build a dropdown list of these values wherever the constrained fields are used in an input form, such as on an Add Record or Edit Record page.

Field Validation Type

Action

Numeric fields:

Currency
Number
Decimal Number

If a list of permitted values is specified, Iron Speed Designer automatically creates a dropdown menu for this field on Add Record and Edit Record pages built with Application Wizard.  The permitted value list must be specified as a list of comma-separated values.

Example:

            Permitted values: 1, 2, 3, 4

Note: if you add the permitted values after creating the pages, you will need to manually change the Control Type to a dropdown list, radio button list, or list box, for the affected field controls.  Use the Property Sheet to make this change.

String fields:

String
Country
Credit Card Number
Email
File
Password
URL
US Phone Number
US State
US ZIP Code

If a permitted value list is specified, Iron Speed Designer automatically creates a dropdown menu for this field on Add Record and Edit Record pages built with Application Wizard.  The permitted values must be specified as a list of comma-separated values enclosed in single quotes.

Example:

            Permitted values: 'blue' , 'green' , 'yellow' , 'black'

If a single quote needs to be specified, it should be quoted twice.  For example:

            Permitted values: 'fred''s shirt' , 'alan''s shirt' , 'harry''s shirt'

Note: if you add the permitted values after creating the pages, you will need to manually change the Control Type to a dropdown list, radio button list, or list box, for the affected field controls.  Use the Property Sheet to make this change.

Boolean

Iron Speed Designer automatically creates a dropdown menu for this field on Add Record and Edit Record pages built with Application Wizard with the two values in the permitted values list.

For Boolean fields, the values “T” and “F” are stored in the underlying database field.  The Display Format specifies two values to use for T and F.  The first value corresponds to True and the second value to False.  For example:

            Display Format: True,False

If the Display Format is not specified, the dropdown menu will show T and F for True and False.

Note:  these values should not be quoted, unlike the other Permitted Value values for other field validation types.  Please also note that you cannot specify a comma within these values; it will be interpreted as a separate value.

Note: if you add the permitted values after creating the pages, you will need to manually change the Control Type to a dropdown list, radio button list, or list box, for the affected field controls.  Use the Property Sheet to make this change.

Date fields:

Credit Card Exp. Date
Date

Enumerated values are not currently supported for Date fields.

Using Permitted Values

Once a permitted value list is specified, subsequent pages created in the Application Wizard automatically use dropdown lists for the constrained fields with the constraint values.  For pages created before applying the permitted value list, set the Dropdown List control type via the Property Sheet for each field you specify.  You can also set field properties from the Databases Property Sheet selected via the Application Explorer in Iron Speed Designer.