Field Properties

Field Type (read only)
Displays the type of field.

Caption
The name of the field that will be displayed as the title of a hit-list column when a search is performed. If the caption is changed this change is automatically reflected in the Field ID field.

Field ID
A human readable ID that serves as a reference for the index field. The Field ID is used as the column name in the Therefore™ database. Field IDs can not start with a numeric character or contain special characters or spaces.

Length
The length can be defined for Text and Numeric fields only.

  • Text string length can only be set when the field is first created. The default length is 50 characters, maximum is at least 2000 (dependent on database type).

  • Number fields are implemented as signed 32 bit integers. Their values can range from: -2,147,483,648 to 2,147,483,648.

Database Index
None
The field is not indexed (default value). No database index is created.

Normal
A database index is created to speed up searching with this field. Creating a database index requires additional database resources. For that reason, it should only be used if a field is frequently used for searching.

Unique
The index is constrained to hold only unique values. This means that documents saved must have a unique index field value. Using a Unique index forces the field to be mandatory.

Default
The index data field is set to this value by default.

A fixed value can be entered into the field: in this case, the field will display this pre-populated value. However, this value can be overwritten by the user during data entry.

It is also possible to enter a dynamic run-time variable. Right-click on the 'Default' field to see a list of available default values. These default values differ dependent on the field type:

Default Values for Text fields Description

<User>

Username of the user saving the document

<User Display Name>

Display the name of the user saving the document

<Domain\User>

Domain and username of the person saving the document

<User E-mail Address>

Displays the e-mail address of the user saving the document

<File Name>

The filename of the file being saved

<File Title>

File title (filename excluding extension) of the file being saved

<File Extension>

File extension of the file being saved

<File Path>

File location of file being saved

<Folder Path>

Folder location of file being saved

<E-mail: Subject>

If an e-mail (*.msg) is saved, this passes the e-mail subject

<E-mail: To>

If an e-mail (*.msg) is saved, this passes the e-mail recipient display names

<E-mail: To (SMTP)>

If an e-mail (*.msg) is saved, this passes the e-mail recipient addresses

<E-mail: Cc>

If an e-mail (*.msg) is saved, this passes the e-mail CC recipient display names

<E-mail: Cc (SMTP)>

If an e-mail (*.msg) is saved, this passes the e-mail CC recipient addresses

<E-mail: From>

If an e-mail (*.msg) is saved, this passes the sender display name

<E-mail: From (SMTP)>

If an e-mail (*.msg) is saved, this passes the e-mail sender address

<Guid>

A globally unique ID for the document
Default Values for Date fields Description

<Date>

The date the file is saved to Therefore™

<File Created>

The date the file being saved to Therefore™ was originally created

<File Modified>

The date the file being saved to Therefore™ was last modified

<E-mail: Sent date>

If an e-mail (*.msg) is saved, this passes the e-mail sent date
Default Values for Date and Time fields Description

<Timestamp>

The date and time the file is saved to Therefore™

<File Created>

The date the file being saved to Therefore™ was originally created

<File Modified>

The date the file being saved to Therefore™ was last modified

<E-mail: Sent date>

If an e-mail (*.msg) is saved, this passes the e-mail sent date
Default Values for Table fields Description

<First row>

Sets the first row of the table as default for this field.

<Previous row>

Sets the previous row of the table as default for this field.

Index Data Fields*

Set the value of a category index data field as default for this field.

*Please refer to the following tutorial for a use case:

Configuring Table Fields

Mandatory (checkbox)
A mandatory field must have a value assigned.

Create Label Field (checkbox)
This option is only visible for new index data fields. It automatically creates a label to the left of the index data field using the value defined in the Caption field.

Included in full-text search (checkbox)
By default, index data fields are included in the full-text search. Uncheck this checkbox to exclude an index data field from showing up in the full-text search. For example, index data fields can be excluded from the full-text search if the information contained is confidential.

Any changes to this setting do not apply retroactively to documents added to the category.

Visible (checkbox)
Determines whether the index data field is displayed in search dialogs.

Case Sensitive (checkbox)
This checkbox is only available when working with an Oracle database.

By default, index data field values are case sensitive. This setting will not work if the complete Oracle database is set up to be case insensitive.

This checkbox is not supported for SQL Server and DB2. On these platforms, behavior depends on how the database was set up.

Drop-down box (checkbox)
This option applies to keyword fields, primary fields, and dependent fields.

  • For keyword fields it is activated by default. The field is displayed as a drop-down list.

  • For primary and dependent fields it is deactivated by default and the fields can be displayed in a table by clicking a browse button (for desktop and web applications). On all other clients, the values will still be displayed in a drop-down list.

Drop down during typing
When checked, the drop-down list will expand as soon as the user starts typing and will highlight the first match that is found.

Sort Descending
When checked, the list is sorted in descending order.

For reference, the Field Number in the Therefore™ database is displayed.