Custom Data

The Custom Data form allows you to specify additional fields for the data you want to see for the task in the Calendar view mode. Additional data is visible when you hover over a task and a pop-up window appears.
To access the Custom Data tab, open the Task form and double click the Task Type field. This opens the Task Type form where you select the Custom Data tab.

The elements of the form are described below.
Table of contents
- Task
- Notification
|
You can set custom data to display data on the task. In the Task section, you can define other – custom fields instead of the predfined fields Title, Location, Content.
Field
|
Enter the desired name of the field for which data will be shown instead of the data from the Title field (displayed by default).
 |
Hint
You can enter more fields to display the data by separating their names with a semicolon (;).
|
|
SQL
|
Enter the desired 'select' syntax. The key you want is denoted by 'c'.
Example: select acname2 from the_setsubj s where s.acSubject=c.acSubject
|
Title
|
In the task pop-up window in the Calendar view, the default field displayed is Title. You can replace it with the data you enter in the Field field.
|
Location
|
In the task pop-up window in the Calender view, the default field displayed is Location. You can replace it with the data you enter in the Field field.
|
Content
|
In the task pop-up window in the Calender view, the default field displayed is Content. You can replace it with the data you enter in the Field field.
|
Caption
|
Enter the title of the information to be displayed.
|
Field
|
Enter the name of the field to call from the table: #lPA_CalnedarTasks
|
SQL
|
Enter the 'select' syntax. The key you want is denoted by 'c'.
Example: select acname2 from the_setsubj s where s.acSubject=c.acSubject
|
Date Data
|
Field for calling the data type is Data.
|
Data
|
Field for calling the data type is Data.
|