This is a detailed document for using the features of AppSuite.
Function Correspondence Table for Each Part
Part Types That Can Be Used as Filter Conditions
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
*1
Auto Calculation
Yes
Rich Text
Yes
Select User
Yes
Select Group
Yes
Table Part
*2
Reference List
No
Reference Part
Yes
ID
Yes
User
Yes
*1: Only files with the following extensions can be searched by "Include in file name or attachment": (html、htm、csv、xml、md、txt).
*2: 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
*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)
*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
*2
Select User
Yes
Select Group
Yes
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.
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
*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
Text (1 Line)
Yes
Text (Multi Line)
No
Check Box
*1
Radio Button
Yes
Pull Down
Yes
List Box
*1
Number
Yes
Date
Yes
Time
Yes
Date/Time
Yes
Attachment Files
No
Auto Calculation
Yes
Rich Text
No
Select User
*2
Select Group
No
Table Part
*3
Reference List
*4
Reference Part
*5
ID
No
User
Yes
*1: Check box and list box can only be used to check for CONTAINS().
*2: Only one user will be used in the actual calculation. If two or more users are selected, it will be treated as if no users were selected.
*3: Table part cannot be used in calculation formulas, but parts in table part can be used in statistical functions such as SUM() and COUNT() if their types can be used in calculation formulas.
*4: The reference list cannot be used in calculation formulas, but parts in the reference list can be used in statistical functions such as SUM() and COUNT() if their types can be used in calculation formulas.
*5: Same as the referenced part type.
Part Types That URL or Email Address Becomes Link
Text (1 Line)
Yes
Text (Multi Line)
*1
Check Box
No
Radio Button
No
Pull Down
No
List Box
No
Number
-
Date
-
Time
-
Date/Time
-
Attachment Files
-
Auto Calculation
*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 table part and 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
*1
Select Group
*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)
*1
Text (Multi Line)
Yes
Check Box
Yes
Radio Button
Yes
Pull Down
Yes
List Box
Yes
Number
*2
Date
*2
Time
Yes
Date/Time
*2
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: Can be replaced if it is not set to "Prevent duplicate entries". *: Can not be replaced if the part of the value is key part.
Part Types Whose Values Can Be Replaced (For Partial Replacement)
Text (1 Line)
*1
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". *: Can not be replaced if the part of the value is key part.
Part Types That Can Set Conditional Styles
Text (1 Line)
Yes
Text (Multi Line)
*1
Check Box
*1
Radio Button
Yes
Pull Down
Yes
List Box
*1
Number
Yes
Date
Yes
Time
Yes
Date/Time
Yes
Attachment Files
*1
Auto Calculation
Yes
Rich Text
*1
Select User
*1
Select Group
*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
*1
Yes
No
No
Attachment Files
No
Yes
No
No
Auto Calculation
*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 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
*1
*2
*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)