AppSuite (Additional)

This is a detailed document for using the features of AppSuite.

Print Button

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)
Rich Text
Select User
Select Group
ID Column Width
User
Reference Part (Same as referring part)