Field Setup Properties

General Section

Data Type

Defines the type of data the field will store (e.g., text, number, date).

Name

Internal name of the field (e.g., Date-DD/MM/YY).

Description

Information-only note; appears in batch setup.

Regular Expression

Used to validate field input based on a custom pattern.

Characters it holds

Maximum allowed characters (mainly for VARCHAR).

Values Section

Value Input

Enter allowed values.

Add / Remove

Manage the list of valid values.

Force Match

Field input must match one of the listed values.

Case Sensitive

Enforce case-matching rules for entries.

Supported Data Types

VARCHAR – Text input. Used for names, IDs, remarks. Max characters defined.
INTEGER – Whole numbers only. No decimals. Used for quantities, counts.
DOUBLE – Decimal numbers. Used for prices, rates.
EMAIL – Accepts only valid email addresses.
DATETIME – Accepts valid date/time formats. Often validated by regex.
TABLE – Used for line-item or multi-row fields. Requires table/column configuration.

Regular Expression Profiles

Accessed by clicking Re. next to the Regular Expression field. This window helps define and test regex rules for validating field data.

Type

Select the data type for which the regex is being created.

Regular Expression

The pattern that defines valid input.

Ignore Whitespace

If checked, spaces in the pattern are ignored.

Test Input

Enter a value to test the regex match.

Buttons

Save – Save changes.
Save As – Save as a new profile.
OK – Apply the profile and close the window.