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.
|