Override default validation properties

When selected, the default Text validation properties are overridden.
When cleared, the default Text validation properties are used. When Override default validation properties is selected, the Validation option must be set to either Use Validation lengths and values or Use Allowable values.

Validation

Select the Validation by selecting an option from the drop-down list:

Use allowable values – a window is displayed enabling you to enter a list of values. The validation process ensures the Custom Field Type has values from this list only. See Table 54.
Use validation lengths and values – a number of additional settings are displayed. See the options described below.

Minimum length

When selected, enter the minimum number of characters in the text string. This defines the minimum length of a valid text string for this field.
When cleared, a text string has no minimum length defined.

Maximum length

When selected, enter the maximum number of characters in the text string. This defines the maximum length of a valid text string for this field.
When cleared, a text string has no maximum length defined.

None

Leading zeroes are not removed and leading spaces are not converted to zeroes.

Strip Leading Zeroes

When selected, if the text string starts with one or more zeroes, these are removed.
When cleared, no action is taken when the text string starts with one or more leading zeroes.

Convert Leading Spaces to Zeroes

When selected, if the text string starts with one or more spaces, these are converted to zeroes.
When cleared, no action is taken when the text string starts with one or more leading spaces.

Regular Expression mask

When selected, enter a regular expression in the text box provided. Or click the icon to display the Regular Expression Generator window. See “Custom Field Type for Postcodes” for an example showing the Regular Expression Generator.

When cleared, regular expressions are not used to define a valid string. Any entered regular expressions are removed from the box when this option is cleared.

Test Validation Settings

Click to open the Test Validation Settings window and test the validation settings you have entered are correct. See “Test Validation Settings” for details of the available options.

Index Field Value Transformation

Index Field Value Transformation is provided to enable you to manipulate data that might not pass validation. See “Index Field Value Transformation” for details.

Override default validation properties

When selected, the default Currency validation properties are overridden.
When cleared, the default Currency validation properties are used. When Override default validation properties is selected, the Validation option must be set to either Use Validation lengths and values or Use Allowable values.

Validation

Select the Validation by selecting an option from the drop-down list:

Use allowable values – a window is displayed enabling you to enter a list of values. The validation process ensures the Custom Field Type has values from this list only. See Table 54.

Use validation lengths and values – a number of additional settings are displayed. See the options described below.

Minimum value

When selected, enter the minimum value for the Currency that is valid.
When cleared, the Currency has no minimum value defined.

Maximum value

When selected, enter the maximum value for the Currency that is valid.
When cleared, the Currency has no maximum value defined.

Non zero

When selected, only non-zero values are valid.
When cleared, the value zero is valid (as well as non-zero values).

Test Validation Settings

Click to open the Test Validation Settings window and test the validation settings you have entered are correct. See “Test Validation Settings” for details of the available options.

Index Field Value Transformation

Index Field Value Transformation is provided to enable you to manipulate data that might not pass validation. See “Index Field Value Transformation” for details.

Override default validation properties

When selected, the default Whole Number validation properties are overridden.
When cleared, the default Whole Number validation properties are used.
When Override default validation properties is selected, the Validation option must be set to either Use Validation lengths and values or Use Allowable values.

Validation

Select the Validation by selecting an option from the drop-down list:

Use allowable values – a window is displayed enabling you to enter a list of values. The validation process ensures the Custom Field Type has values from this list only. See Table 54.

Use validation lengths and values – a number of additional settings are displayed. See the options described below.

Minimum value

When selected, enter the minimum value Whole Number that is valid.
When cleared, there is no defined minimum value for the Whole Number field.

Maximum value

When selected, enter the maximum value Whole Number that is valid.
When cleared, there is no defined maximum value for the Whole Number field.

Non zero

When selected, only non-zero values are valid.
When cleared, the value zero is valid (as well as non-zero values).

Test Validation Settings

Click to open the Test Validation Settings window and test the validation settings you have entered are correct. See “Test Validation Settings” for details of the available options.

Index Field Value Transformation

Index Field Value Transformation is provided to enable you to manipulate data that might not pass validation. See “Index Field Value Transformation” for details.

Override default validation properties

When selected, the default Date and Time validation properties are overridden.
When cleared, the default Date and Time validation properties are used.
When Override default validation properties is selected, the Validation option must be set to either Use Validation lengths and values or Use Allowable values.

Validation

Use validation lengths and values – a number of additional settings are displayed. See the options described below.
Use allowable values – enables you to enter a list of values. The validation process ensures the Custom Field Type has values from this list only. See Table 54.
Use an expression – enables you to enter date and time keywords and operators to ensure the date falls within a specified range. See the option described below.

Minimum date and time

When selected, click the … button and select the earliest Date and Time that is valid.
When cleared, no minimum Date and Time is defined.

Note: This option is used only when Use validation lengths and values is selected.

Maximum date and time

When selected, click the … button and select the latest Date and Time that is valid.
When cleared, no maximum Date and Time is defined.

Note: This option is used only when Use validation lengths and values is selected.

Expression to be used for validation (Indexing keywords, for example)

Enter an expression, using date and time keywords, to be used to validate the date and time field. For example, for a day accuracy field, to ensure the date is only today’s date or yesterday’s date enter:

#today [OR] #yesterday
Alternatively, for a year accuracy field, to limit dates to no earlier than 10 years ago, enter:
>#now (-10 years)
A full list of valid date and time keywords, see “Date and Time: Keyword Syntax”.

Note: This option is used only when Use an expression is selected.

Test Validation Settings

Click to open the Test Validation Settings window and test the validation settings you have entered are correct. See “Test Validation Settings” for details of the available options.

Index Field Value Transformation

Index Field Value Transformation is provided to enable you to manipulate data that might not pass validation. See “Index Field Value Transformation” for details.

Enter the values to test

Enter the values you want to test in the text box. To enter multiple values, put each new value on a new line.

Test Validation

Click the Test Validation button to test whether the values entered in the text box pass or fail the configured validation settings.

Values

Lists each of the values entered in the text box. An icon is displayed which indicates whether the value passed (a green icon) or failed (a red icon) validation.

Validated

Failed – the value failed validation. The value does not meet the configured validation requirements.
Passed – the value passed validation. The value meets the configured validation requirements.

Close

Click Close to close the Test Validation settings window and return to the Custom Field Type Editor.

Add Value. Type the Allowed value in the text box and click the

Add Value button.

Edit Value. Select the Allowed value in the Allowed Values list, edit the value and click the Edit Value button.

Delete Value. Select the Allowed value in the Allowed Values list and click the Delete Value button.

Import Allowable Values.

Select From a text file to import the Allowable Values from a text file. Browse to the text or CSV file containing the list of Allowable Values and click Open. Select the Delimiter used in the selected file (the Delimiter is the character used to separate the individual values in the file) then click OK.

Select From the clipboard to import the Allowable Values from the contents of the clipboard. Select the Delimiter used to separate individual values and then click OK.

Valid values are imported to the list. Invalid values, that is, values which do not match the Base Field Type for the current field, are not imported.

Export Allowable Values. Click Export to open a Windows directory navigation pane. Enter a name for the text file in which you want to save the allowable values and select a folder in which to save the text file. Click Save the text file, or Cancel to exit without exporting the allowable values to a text file.

Click once to move selected value up one position in the list.

Click once to move selected value down one position in the list.

Sort the Allowable Values entries alphabetically. Use this button if you want the entries to be sorted alphabetically. However, if you want the entries to remain in the order in which you entered them (for example, days of the week) then do not use this button.

New Format

Click to create a new Custom Format. The Custom Format Editor is opened.

Edit

Click to edit the selected Format. The Custom Format Editor is opened.

Delete

Click to delete the selected format.

Test Format

Enter a string in the text box beside the Test Format button. Click the Test Format button to test how the string is transformed with the transformation mask. A window is displayed indicating whether the transformation was successful. If the transformation was successful, a window is displayed showing the output string.

Mask to match index field

Enter a Regular Expression mask to define how the string should be split in to components. In the above date example, this would be (\d{2})(\d{2})(\d{4}).

Format to transform value

Enter the order of the components and any separators you want to use. In the above date example, this would be {0}/{1}/{2}.

String to be tested

Enter the string to be tested. In the above date example, this would be 05072005.

Test Custom Format

Click the Test Custom Format button. A window is displayed indicating whether the transformation was successful. If the transformation was successful, the output string is displayed.