Field Data Types

The following data types are allowed for custom fields. The Valid for column indicates attributes that can use the data type.

Data Type

Explanation

Valid for
Alpha Numeric

  • Includes alphas, numbers, and spaces.

  • Symbols and punctuation not allowed.

  • The AlphaNumericRestriction element can be used to define minimum and maximum values or enumerations.

  • For example, 2 Riverside North is valid for data type AlphaNumeric, while 2 - Riverside North is not.

Enumerations, MinLength, MaxLength
Freeform Text Includes alpha, numerals, spaces, and special characters. The FreeformTextRestriction element can be used to define minimum and maximum length or to define enumerations.  

Text

  • Includes alpha and spaces.

  • Symbols, punctuation, and numbers not allowed.

  • For example, abc xyz is valid for data type Alpha, while abc - xyz is not.

Enumerations, MinLength, MaxLength
Decimal Includes numerals and period. The DecimalRestriction element can be used to define minimum and maximum values. For example, 54.687 is valid.  
Whole Number Positive or negative whole number or zero. The WholeNumberRestriction element can be used to define minimum and maximum values. For example, 8756 is valid.

MinValue, MaxValue

Percentage

Supports values that are whole number or decimals only. The "%" symbol should not be attached to the value. The data type indicates that this is a percentage value. The PercentageRestriction element can be used to define minimum and maximum values.

For example, 10 or 10.20 are a valid values for this data type, while 10.20% is not valid.

MinValue, MaxValue
True/False True or false  

Email address

Includes values conforming to email addresses. Supported values include:

  • Upper and lowercase English letters

  • Digits 0-9

  • Characters ! # $ % & ' * + - / = ? ^ _ ` { | } ~

  • Character . (dot, period, full stop) provided that it is not the first or last character, and provided also that it does not appear two or more times consecutively.

  • Must have at least one "@"

  • Max length of 128 characters

 

URL

Includes values conforming to a URL. Supported values include:

  • Upper and lowercase English letters

  • Digits 0-9

  • Characters @ ! # $ % & ' * + - / = ? ^ _ ` { | } ~

  • Character . (dot, period, full stop) provided that it is not the first or last character, and provided also that it does not appear two or more times consecutively.

  • Must have at least one "@"

  • Max length of 2048 characters

 

Date Formats

 

 

  • Date Year

Supports 4 digits for the year.

 

  • Date Month Year

Supports digits and "/" or "-" for the separator. For example, 01/2010 and 01-2010 represent January 2010 and are valid values for this data type.

 

  • Date Day Month Year

Support digits and "/" or "-" for the separator. For example, 20/01/2010 and 20-01-2010 represent 20th January 2010 and are valid values for this data type.

 

  • Date Day Month Year Time

Supports values confirming to day, month and year format along with time appended to it. For example 20/01/2010 18:50 and 20-01-2010 18:50 represents 6:50 PM of 20th January 2010 and are valid values for this data type.

 

Time Formats

 

 

  • Time in Minutes

Supports digits to represent minutes.

 

  • Time in Hour & Minute

Support values confirming to hour and minute in 24-hour format, where the separator is ":". For example, 18:50 represents 6:50 PM.

 

  • Time in Milliseconds with Time Zone

Supports values confirming to hour, minute, second format in 24-hour format along with the time zone appended to it. The separator for the time is ":". For example, 18:50:55 GMT represents 6:50:55 PM in GMT.