Custom Field Type | Definition |
---|
Boolean | Any field that is represented by a yes/no response (radio button). |
Date | Any field that is represented by a date or calendar date. |
Date (calendar) | A calendar date field stores a date and time with no time zone information. The date and time will be displayed the same for all users, regardless of time zone. |
Decimal Number | Any field that is a number with a decimal/fraction. |
Integer | Any number field that is strictly a whole number. Note: can be used with conditions (i.e. if X﹥Y = Z). |
Money | Any field that should be identified as money or currency. Note: Currency Conversions can be used through this custom field. |
Percentage | Any number that is expressed as a percentage. |
Open Text | Any field that can be typed or that is considered to be free text. |
Text Single Choice | This is a field with a drop-down list of choices where only 1 value can be selected. |
The table above represents the different answer types for fields that can be created. The system will automatically format a value placed into the field into the appropriate format. For example, if the answer type is ‘Integer’, the field will only accept whole numbers. A value of 9.56 will be automatically rounded to the nearest whole number (10). If the field value will contain a number other than a whole number, select decimal number instead.
Open Text – This is a free text field for short text responses.
Text Single Select – This is the type of field you would create that would be controlled by an enumeration list. The field will only allow one value from the enumeration list to be selected.
Custom Field Type | Definition |
---|
Text Multiple Select | Also known as a "vector" field. It is a picklist in which multiple options can be selected. Note Only three multi-select (vector) fields are available per solution and are not hierarchical. |
Multiline Text | This is the same as a "text" field, but with unlimited character limitations. |
User | Any field that allows you to choose from the list of users that are loaded into your site. |
Flex Master Data | An FMD field can be single or multiple select and can also act like a mini database. The selected value becomes a hyperlink that can open a window displaying additional data fields. |
URL Link | Stores a user defined URL address and displays a text hyperlink. The link text is the URL. |
Text Multiple Select: This is the same as the text single select, except it allows users to choose more than one value from the list. You can only create three of these types of fields and once they’ve been used, you cannot add more.
Text Multiple Line: This is a free text field that allows for large blocks of text as the value for the field.
User: This field type will allow users to select from any user created with the site (includes enterprise users, third-party users and external users).
The most common use for a Flex Master Data (FMD) field is as an extended, dynamic picklist where the number of picks available exceeds what would be rational for a standard picklist (up to about 20 or 30). The reason for this is that the FMD field is searchable, user-maintained, and can literally accommodate tens of thousands of picks.
An FMD field can be single or multiple select, and can also act like a mini database. The selected value becomes a hyperlink that can open up a window displaying additional data fields (non-reportable). It's also possible to make the additional data reportable by auto-populating reportable custom fields that are bound to the FMD field. FMD lists are controlled through Data Import/Export rather than enumeration lists.
Note
When the FMD field acts as a mini-database each field (in addition to the FMD field) counts against your allotted number of custom fields for that solution.