Function Correspondence Table for Each Part Type

Part Types That Can Be Used as Filter Conditions

Part Type	Input Validation	Conditions	Access Rights (Data)	Add/Update Action	Periodic Action	Filter Settings for Data from Other Apps *	Other Features *
Text (1 Line)	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Text (Multi Line)	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Check Box	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Radio Button	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Pull Down	Yes	Yes	Yes	Yes	Yes	Yes	Yes
List Box	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Number	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Date	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Time	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Date/Time	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Attachment Files	Yes *1	No	Yes *2	Yes *1	Yes *1	Yes *2	Yes *2
Auto Calculation	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Rich Text	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Select User	Yes	Yes	Yes *3	Yes	Yes *3	Yes	Yes
Select Group	Yes	Yes	Yes *3	Yes	Yes *3	Yes	Yes
Table Part	*4	No	*5	*5	*5	*5	*5
Reference List	No	No	No	No	No	No	No
Reference Part	No	No	No	No	No	No	Yes
ID	Yes	Yes	Yes	Yes	Yes	Yes	Yes
User	Yes	Yes	Yes *3	Yes	Yes *3	Yes	Yes

*: The following features are included in "Filter Settings for Data from Other Apps".

• App Settings > Screen Design > edit > Part Settings > Detailed Settings of Reference List > Data Filter
• App Settings > Screen Design > edit > Part Addition > Parts from Other App > Settings of Selection Dialog > Default Filter

*: The following features are included in "Other Features".

• Data Reference Screen > Filter Conditions
• Aggregation Settings > Aggregation Range
• App Settings > Screen Design > Detailed Screen Settings > Data Filter / Default Filter

*1: "Include in file name or attachment" cannot be used.
*2: Only files with the following extensions can be searched by "Include in file name or attachment": (html、htm、csv、xml、md、txt).
*3: "Login User" and "Login User's Default Group" cannot be used.
*4: Only when "Target" is set to a table part, parts in it can be used.
*5: Parts in the table parts can be used. However, you cannot use attachment files or next operations: "Not match", "Doesn't contain", "Not equal", "Not match any", "Do not contains any of these words", "Without value", and "Without selection value".

Part Types to Be Searched by Keyword

Text (1 Line)	Yes
Text (Multi Line)	Yes
Check Box	Yes
Radio Button	Yes
Pull Down	Yes
List Box	Yes
Number	No
Date	No
Time	No
Date/Time	No
Attachment Files	Yes *1
Auto Calculation	Yes
Rich Text	Yes
Select User	Yes
Select Group	Yes
Table Part	No
Reference List	No
Reference Part	*2
ID	No
User	Yes

*1: In Keyword Search, only the attachment file name is the target of Search (text in file is outside target of search)
*2: Same as the referenced Part type

Part Types That Can Be Specified by Sorting Data

Text (1 Line)	Yes
Text (Multi Line)	No
Check Box	No
Radio Button	Yes
Pull Down	Yes
List Box	No
Number	Yes
Date	Yes
Time	Yes
Date/Time	Yes
Attachment Files	No
Auto Calculation	Yes
Rich Text	No
Select User	Yes
Select Group	Yes
Table Part	No
Reference List	No
Reference Part	Yes
ID	Yes
User	Yes

Part Types That Can Be Displayed on a List or Calendar Screen

Text (1 Line)	Yes
Text (Multi Line)	Yes *1
Check Box	Yes
Radio Button	Yes
Pull Down	Yes
List Box	Yes
Number	Yes
Date	Yes
Time	Yes
Date/Time	Yes
Attachment Files	Yes
Auto Calculation	Yes
Rich Text	Yes *2
Select User	Yes *3
Select Group	Yes *4
Table Part	No
Reference List	No
Reference Part	Yes
ID	Yes
User	Yes

*1: Up to 200 characters can be displayed.
*2: Up to 200 characters can be displayed as plain text instead of rich text.
*3: Up to 100 users can be displayed.
*4: Up to 100 groups can be displayed.

Part Types That Can Display Aggregated Values on a List Screen

Text (1 Line)	No
Text (Multi Line)	No
Check Box	No
Radio Button	No
Pull Down	No
List Box	No
Number	Yes
Date	No
Time	No
Date/Time	No
Attachment Files	No
Auto Calculation	Yes *1
Rich Text	No
Select User	No
Select Group	No
Table Part	No
Reference List	No
Reference Part	*2
ID	No
User	No

*1: If "Display Format of Calculation Result" is Date or Date/Time, the aggregation result will not be displayed (only the title will be displayed). Calculation results for characters are excluded from the aggregation even if they can be converted into numerical values.
*2: Same as the referenced part type.

Part Types That Can Be Added to Table Part

Text (1 Line)	Yes
Text (Multi Line)	Yes
Check Box	Yes
Radio Button	Yes
Pull Down	Yes
List Box	Yes
Number	Yes
Date	Yes
Time	Yes
Date/Time	Yes
Attachment Files	Yes
Auto Calculation	Yes
Rich Text	Yes
Select User	Yes
Select Group	Yes
Table Part	No
Reference List	No
Reference Part	Yes
ID	-
User	-

Part Types That Can Be Used in Formulas for Auto Calculation Parts

Part Type	Available	Type on Formula	Value Treatment
Text (1 Line)	Yes	Characters
Text (Multi Line)	No	Characters
Check Box	Yes *1	Multi-choice
Radio Button	Yes	Characters
Pull Down	Yes	Characters
List Box	Yes *1	Multi-choice
Number	Yes	Number
Date	Yes	Date	Treat as a number on actual calculation, which is a time as second since January 1, 1970.
Time	Yes	Time	Treat as a number on actual calculation, which is a time as second since 12:00:00 AM.
Date/Time	Yes	Date/Time	Treat as a number on actual calculation, which is a time as second since January 1, 1970 at 12:00:00 AM UTC
Attachment Files	No	-
Auto Calculation	Yes	Any Type	Treat as characters or a number corresponds its result on actual calculation.
Rich Text	No	-
Select User	Yes	Characters	Treat as characters which is a user's name on actual calculation if only the user is selected. Treat as a blank if otherwise.
Select Group	No	-
Table Part	*2	(See right)	Treat each part in the table part as followings. The auto calculation of the formula is not in the table part: Treat as a collection of number, characters or any type corresponds its part type. The auto calculation of the formula is in the table part: Treat as a value in the row which is treated as its part type.
Reference List	*3	(See right)	Treat each part in the reference list as a collection of number, characters or any type corresponds its part type.
Reference Part	*4	*4
ID	Yes	Number
User	Yes	Characters	Treat as characters which is a user's name on actual calculation.

*1: The check box and the list box can only be used to check for CONTAINS().
*2: The table part cannot be used in calculation formulas, but parts in the table part can be used.
*3: The reference list cannot be used in calculation formulas, but parts in the reference list can be used.
*4: Same as the referenced part type.

Part Types That URL or Email Address Becomes Link

Text (1 Line)	Yes
Text (Multi Line)	Yes *1
Check Box	No
Radio Button	No
Pull Down	No
List Box	No
Number	-
Date	-
Time	-
Date/Time	-
Attachment Files	-
Auto Calculation	Yes *2
Rich Text	-
Select User	-
Select Group	-
Table Part	*3
Reference List	*3
Reference Part	*4
ID	-
User	-

*1: Links are displayed only on the balloon of the list screen and the detail screen except in reference list.
*2: When "Display Format of Calculation Result" is "Character", a link is displayed.
*3: Same operation as the part type in each column.
*4: Same operation as the referenced part type.

Part Types That Can Be Used for Aggregation Items

Text (1 Line)	Yes
Text (Multi Line)	No
Check Box	Yes
Radio Button	Yes
Pull Down	Yes
List Box	Yes
Number	Yes
Date	Yes
Time	Yes
Date/Time	Yes
Attachment Files	No
Auto Calculation	Yes
Rich Text	No
Select User	Yes *1
Select Group	Yes *1
Table Part	No
Reference List	No
Reference Part	Yes
ID	No
User	Yes

*1: When multiple items are selected, only the top data is subject to aggregation.

Part Types That Can Be Referenced from Other Apps

Text (1 Line)	Yes
Text (Multi Line)	Yes
Check Box	No
Radio Button	Yes
Pull Down	Yes
List Box	No
Number	Yes
Date	Yes
Time	Yes
Date/Time	Yes
Attachment Files	Yes
Auto Calculation	Yes
Rich Text	Yes
Select User	Yes
Select Group	Yes
Table Part	No
Reference List	No
Reference Part	Yes
ID	Yes
User	Yes

Part Types Whose Values Can Be Replaced (For Non-partial Replacement)

Text (1 Line)	Yes *1 *2 *3
Text (Multi Line)	Yes
Check Box	Yes
Radio Button	Yes
Pull Down	Yes
List Box	Yes
Number	Yes *2 *3
Date	Yes *2 *3
Time	Yes
Date/Time	Yes *2 *3
Attachment Files	No
Auto Calculation	No
Rich Text	No
Select User	Yes
Select Group	Yes
Table Part	No
Reference List	No
Reference Part	No
ID	No
User	No

*1: Values can be replaced when "Type" is "Set manually".
*2: Values can be replaced when the part is not set to "Prevent duplicate entries".
*3: Values can not be replaced when the part is key part.

Part Types Whose Values Can Be Replaced (For Partial Replacement)

Text (1 Line)	Yes *1 *2
Text (Multi Line)	Yes
Check Box	No
Radio Button	No
Pull Down	No
List Box	No
Number	No
Date	No
Time	No
Date/Time	No
Attachment Files	No
Auto Calculation	No
Rich Text	No
Select User	No
Select Group	No
Table Part	No
Reference List	No
Reference Part	No
ID	No
User	No

*1: Values can be replaced when "Type" is "Set manually".
*2: Values can not be replaced when the part is key part.

Part Types That Can Set Conditional Styles

Text (1 Line)	Yes
Text (Multi Line)	Yes *1
Check Box	Yes *1
Radio Button	Yes
Pull Down	Yes
List Box	Yes *1
Number	Yes
Date	Yes
Time	Yes
Date/Time	Yes
Attachment Files	Yes *1
Auto Calculation	Yes
Rich Text	Yes *1
Select User	Yes *1
Select Group	Yes *1
Table Part	No
Reference List	No
Reference Part	*2
ID	No
User	No

*1: Only "with value" and "without value"
*2: Same as the referenced part type

Part Types to Add Event to the Schedule

Part Type	Date/Time	Event	Add To	Recipients
Text (1 Line)	No	Yes	No	No
Text (Multi Line)	No	Yes	No	No
Check Box	No	Yes	No	No
Radio Button	No	Yes	No	No
Pull Down	No	Yes	No	No
List Box	No	Yes	No	No
Number	No	Yes	No	No
Date	Yes	Yes	No	No
Time	No	Yes	No	No
Date/Time	Yes *1	Yes	No	No
Attachment Files	No	Yes	No	No
Auto Calculation	Yes *2	Yes	No	No
Rich Text	No	No	No	No
Select User	No	Yes	Yes	Yes
Select Group	No	Yes	Yes	No
Table Part	No	No	No	No
Reference List	No	No	No	No
Reference Part	*3	*3	*3	*3
ID	No	Yes	No	No
User	No	Yes	Yes	Yes

*1: System parts (Date/Time Added, Date/Time Updated, Date/Time Applied) can not be specified
*2: Can be specified if "Display Format of Calculation Result" of the part is "Date" or "Date/Time"
*3: Same as the referenced part type

Part Types for the Schedule in the Other Feature Integration

Part Type	Date/Time	Event	Details	To
Text (1 Line)	No	Yes	Yes	No
Text (Multi Line)	No	No	Yes	No
Check Box	No	No	No	No
Radio Button	No	Yes	Yes	No
Pull Down	No	Yes	Yes	No
List Box	No	No	No	No
Number	No	No	No	No
Date	Yes	No	No	No
Time	No	No	No	No
Date/Time	Yes	No	No	No
Attachment Files	No	No	No	No
Auto Calculation	Yes *1	Yes *2	Yes *2	No
Rich Text	No	No	No	No
Select User	No	No	No	Yes
Select Group	No	No	No	No
Table Part	No	No	No	No
Reference List	No	No	No	No
Reference Part	*3	*3	*3	*3
ID	No	No	No	No
User	No	No	No	Yes

*1: Can be linked only when "Display Format of Calculation Result" is "Date" or "Date/Time"
*2: Can be linked only when "Display Format of Calculation Result" is "Character"
*3: Same as the referenced part type

Applied Settings in Application Content of Portal

Part	Applied AppSuite Settings
Text (1 Line)
Text (Multi Line)
Check Box
Radio Button	Column Width
Pull Down	Column Width
List Box
Number	Decimal Places, Unit, Use Comma Separators, Column Width
Date
Time
Date/Time
Attachment Files
Auto Calculation	(Same as part which type is display format of calculation result)
Rich Text
Select User
Select Group
ID	Column Width
User
Reference Part	(Same as referring part)