Manage Table
Overview¶
This is a function for customizing the settings of "Table". You can customize various things according to your business, such as adding "Column" to the "Editor" and changing the display content of the "List Screen".
Limitations¶
- The site type cannot be changed.
- There is no read-only screen. The viewing screen and editing screen are the same.
Prerequisites¶
- "Site Administration Permission" is required.
Operation Procedure¶
- Open the target site.
- Click "Manage Table" from the "Manage" menu.
Table Customization¶
Tables can be customized in various ways. See below for details.
- Change to Default API Version 1.1 and Compatibility with Previous Versions
- Correspondence of Column name and Name in the system in the Database
- Manage Table: HTML
- Manage Table: Aggregation
- Manage Table: Analysis Chart
- Manage Table: Editor: Column Advanced Settings: Option List: Department Settings
- Manage Table: Editor: Column Advanced Settings: Option List: Login User Settings
- Manage Table: Export: Access Control Tab
- Manage Table: Export
- Manage Table: Screen Index: Column Advanced Settings: Wrap text by cell width
- Manage Table: History
- Manage Table: Import
- Manage Table: Link
- Manage Table: Email
- Manage Table: Move
- Manage Table: Editor: Import / Export of Multilingual Label Settings
- Manage Table: Editor: Column Advanced Settings: Multilingual
- Manage Table: Notification
- Manage Table: Notification
- Manage Table: Notification
- Manage Table: Information Disclosure Function
- Manage Table: Reminders
- Manage Table: Reminders
- Manage Table: Editor: Heading (Section)
- Managing Table: Site Integration
- Manage Table: Summary
- Manage Table: Editor: Tab
- Manage Table: Calendar
- Manage Table: Screen Index
- Manage Table: Guide
- Manage Table: Style
- Manage Table: View
- Manage Table: Crosstab
- Manage Table: Script
- Manage Table: Control by Status
- Manage Table: Gantt Chart
- Manage Table: Screen Index: Screen Index Column Settings
- Manage Table: Server Script
- Manage Table: Screen Index: Column Advanced Settings
- Manage Table: Screen Index: Column Advanced Settings: Cell width
- Manage Table: Time Series Charts
- Manage Table: Screen Index: Column Advanced Settings: Sticky on left edge
- Manage Table: Kanban
- Manage Table: Image Library
- Manage Table: View: Create New
- Manage Table: Formula
- Manage Table: View: Advanced Settings: Filters Tab: Keep Filter State
- Manage Table: View: Advanced Settings: Sorter Tab: Keep Sort State
- Manage Table: View: Advanced Settings: Index Tab: Index Settings
- Manage Table: Formulas (Default)
- Manage Table: View: Advanced Settings: List tab: Filter And Aggregation Settings
- Logical Expression Used in Formula (Extended) Function
- Manage Table: Formula (Extended)
- Manage Table: View: Advanced Settings: List Tab: Command Button Settings
- Manage Table: View: Advanced Setting: Default Display
- Manage Table: View: Advanced Settings: Filters tab: Setting Filters
- Manage Table: View: Advanced Settings: Access Control Tab
- Formula (Extended) Function List
- Manage Table: Screen Index: Column Advanced Settings: Name Displayed on Screen
- Manage Table: Items
- Manage Table: Screen Index: Column Advanced Settings: Grid Format
- Manage Table: Screen Index: Column Advanced Settings: Cell CSS
- Manage Table: Screen Index: Column Advanced Settings: Use Custom Design
- Overview Of Access Control
- Manage Table: Process
- Manage Table: Items: Basic
- Manage Table: Editor
- Manage Table: Filter
- Manage Table: Editor: Editor Settings
- Manage Table: Process
- Site Access Control
- Manage Table: Filter: Check Column Filter Control Type
- Manage Table: Items: ID
- Manage Table
- Manage Table: Screen Index: Number of Items Displayed per Page
- Manage Table: Screen Index: Default View
- Manage Table: Screen Index: Allow View Reset
- Manage Table: Screen Index: Index Edit Type
- Manage Table: Screen Index: Display History on the Index
- Manage Table: Screen Index: Always Request Search Conditions
- Manage Table: Screen Index: Bulk Update of Multiple Columns
- Manage Table: Screen Index: Disable Link to Edit Screen
- Manage Table: Screen Index: Open Editing Screen In New Tab
- Manage Table: Screen Index: Open Editing Screen In New Tab
- Manage Table: Process
- Site Access Control: Do Not Inherit on Site Creation
- Manage Table: Filter: Numeric Value Column Filter Mode Selection
- Manage Table: Items: Version
- Manage Table: Process
- Site Access Control: Do Not Display On Screen If Read-Only
- Manage Table: Filter: Minimum, Maximum, Step for Numerical Value Column Filter
- Manage Table: Items: Title
- Manage Table: Process
- Manage Table: Items: Body
- Manage Table: Filter: Date Column Filter Mode Selection
- Manage Table: Process
- Manage Table: Filter: Date Column Filter Min, Max, Year, Half Year, Quarter,
- Manage Table: Record Access Control
- Manage Table: Items: Start Time
- Manage Table: Process
- Manage Table: Items: Completion
- Table Function: Record Access Control
- Manage Table: Process
- Column Access Control
- Manage Table: Items: Work Volume
- Manage Table: Filter: Search Type
- Manage Table: Items: Progression Rate
- Manage Table: Filter: Days Before and After "Due Soon"
- Manage Table: Items: Remaining Work Volume
- Manage Table: Search: Search Settings: Search Type
- Formula (Extended): $DATE Function
- Formula (Extended): $DATEDIF Function
- Formula (Extended): $DATETIME Function
- Formula (Extended): $DAY Function
- Formula (Extended): $DAYS Function
- Formula (Extended): $EOMONTH Function
- Formula (Extended): $HOUR Function
- Manage Table: Filter: Use Filter Button
- Formula (Extended): $MINUTE Function
- Formula (Extended): $MONTH Function
- Formula (Extended): $NOW Function
- Formula (Extended): $SECOND Function
- Formula (Extended): $TODAY Function
- Manage Table: Filter: Use Delay Filter
- Manage Table: Filter: Use Filters Area
- Manage Table: Filter: Use Incomplete Filter
- Manage Table: Filter: Use Near Time Of Completion Filter
- Manage Table: Filter: Use Negative Filters
- Manage Table: Filter: Use Overdue Filter
- Manage Table: Filter: Use Own Filter
- Manage Table: Filter: Use Search Filter
- Manage Table: Items: Status
- Formula (Extended): $WEEKDAY Function
- Formula (Extended): $YEAR Function
- Formula (Extended): $ASC Function
- Formula (Extended): $CONCAT Function
- Formula (Extended): $FIND Function
- Formula (Extended): $JIS Function
- Formula (Extended): $LEFT Function
- Formula (Extended): $LEN Function
- Formula (Advanced): $LOWER Function
- Formula (Extended): $MID function
- Manage Table: Filter: Use Filter On Grid Header
- Manage Table: Items: Manager
- Formula (Extended): $REPLACE Function
- Formula (Extended): $RIGHT Function
- Formula (Extended): $SEARCH Function
- Formula (Extended): $SUBSTITUTE Function
- Formula (Extended): $TEXT Function
- Formula (Extended): $TRIM Function
- Formula (Extended): $UPPER Function
- Formula (Extended): $VALUE Function
- Formula (Extended): $AND Function
- Formula (Extended): $IF Function
- Formula (Advanced): $IFERROR Function
- Formula (Extended): $IFS Function
- Manage Table: Items: Owner
- Formula (Extended): $NOT Function
- Formula (Extended): $OR Function
- Formula (Extended): $ISBLANK Function
- Formula (Extended): $ISERROR Function
- Formula (Extended): $ISEVEN Function
- Formula (Extended): $ISNUMBER Function
- Formula (Extended): $ISODD Function
- Formula (Extended): $ISTEXT Function
- Formula (Extended): $ABS Function
- Formula (Extended): $MOD Function
- Formula (Extended): $POWER Function
- Formula (Extended): $RAND Function
- Formula (Extended): $ROUND function
- Formula (Extended): $ROUNDDOWN Function
- Formula (Extended): $ROUNDUP Function
- Manage Table: Items: Locked
- Formula (Extended): $SQRT Function
- Formula (Extended): $TRUNC Function
- Formula (Extended): $AVERAGE Function
- Formula (Extended): $MAX Function
- Formula (Extended): $MIN Function
- Manage Table: Filter: Relating Column
- Manage Table: Search: Fulltext Settings
- Manage Table: Items: Class
- Manage Table: Items: Numeric Value
- Manage Table: Items: Date
- Manage Table: Items: Description
- Manage Table: Items: Check
- Manage Table: Items: Attachments
- Manage Table: Editor: Column Advanced Settings
- Manage Table: Editor: Advanced Settings for Other Columns
- Manage Table: Editor: Column Advanced Settings: Name Displayed
- Manage Table: Editor: Column Advanced Settings: Alignment
- Manage Table: Editor: Column Advanced Settings: Maximum Number of Characters
- Manage Table: Items: Comments
- Manage Table: Editor: Column Advanced Settings: Input Column Style
- Manage Table: Items: Created By
- Manage Table: items: Updated By
- Manage Table: Items: Created On
- Manage Table: Items: Updated On
- Manage Table: Editor: Column Advanced Settings: Viewer Switching Test
- Manage Table: Editor: Column Advanced Settings: Input Required
- Manage Table: Editor: Column Advanced Settings: Editor Format
- Manage Table: Editor: Column Advanced Settings: Time Interval (Minutes)
- Manage Table: Editor: Column Advanced Settings: Allow Bulk Update
- Manage Table: Editor: Column Advanced Settings: Duplication Prohibited
- Manage Table: Editor: Column Advanced Settings: Copy with Default Value
- Manage Table: Editor: Column Advanced Settings: Import Key
- Manage Table: Editor: Column Advanced Settings: Input Guide
- Manage Table: Editor: Column Advanced Settings: Read-only
- Manage Table: Search: Operations: Rebuild Search Index
- Manage Table: Editor: Column Advanced Settings: Default Value
- Manage Table: Editor: Column Advanced Settings: Format
- Manage Table: Editor: Column Advanced Settings: Nullable
- Manage Table: Editor: Column Advanced Settings: Anchor
- Manage Table: Editor: Column Advanced Settings: Unit
- Manage Table: Editor: Column Advanced Settings: Decimal Places
- Manage Table: Editor: Column Advanced Settings: Rounding Type
- Manage Table: Editor: Column Advanced Settings: Control Type (Classification)
- Manage Table: Editor: Column Advanced Settings: Control Type (Numerical Value)
- Manage Table: Editor: Column Advanced Settings: Min, Max, Step
- Manage Table: Editor: Column Advanced Settings: Storage Destination
- Manage Table: Editor: Column Advanced Settings: Allow Delete Attachment
- Manage Table: Editor: Column Advanced Settings: Do Not Delete Files in History
- Manage Table: Editor: Column Advanced Settings: Overwrite File with Same Name
- Manage Table: Editor: Column Advanced Settings: File Quantity Limit
- Manage Table: Editor: Column Advanced Settings: Size Limit (MB)
- Manage Table: Editor: Column Advanced Settings: Total Size Limit (MB)
- Manage Table: Editor: Column Advanced Settings: Local Folder Size Limit (MB)
- Manage Table: Editor: Column Advanced Settings: Local Folder Total Size Limit
- Manage Table: Editor: Column Advanced Settings: Description
- Manage Table: Editor: Column Advanced Settings: Option List
- Manage Table: Editor: Column Advanced Settings: Option List: Link
- Manage Table: Editor: Column Advanced Settings: Option List: Department
- Manage Table: Editor: Column Advanced Settings: Option List: Group
- Manage Table: Editor: Column Advanced Settings: Option List: User
- Manage Table: Editor: Column Advanced Settings: Option List: Filter (narrow
- Manage Table: Editor: Column Advanced Settings: Option List: Filter, Sort,
- Manage Table: Editor: Column Advanced Settings: Option List: Lookup
- Manage Table: Editor: Column Advanced Settings: Option List: Copy Child Records
- Manage Table: Editor: Column Advanced Settings: Option List: Delete Child
- Manage Table: Editor: Column Advanced Settings: Option List: Set Parent Record
- Manage Table: Editor: Column Advanced Settings: Use Search Function
- Manage Table: Editor: Column Advanced Settings: Multiple Selections
- Manage Table: Editor: Column Advanced Settings: Do Not Insert Blanks in Choices
- Manage Table: Editor: Column Advanced Settings: Auto post back
- Manage Table: Editor: Column Advanced Settings: Columns returned when automatic
- Manage Table: Editor: Column Advanced Settings: No Wraparound
- Manage Table: Editor: Column Advanced Settings: Hidden
- Manage Table: Editor: Column Advanced Settings: Field CSS
- Manage Table: Editor: Column Advanced Settings: Control CSS
- Manage Table: Editor: Column Advanced Settings: Fulltext Types
- Manage Table: Editor: Column Advanced Settings: Input Validation
- Manage Table: Editor: Column Advanced Settings: Allow Adding Images
- Manage Table: Editor: Column Advanced Settings: Thumbnail Size
- Manage Table: Editor: Column Advanced Settings: Title Combination
- Manage Table: Editor: Column Advanced Settings: Automatic Numbering
- Manage Table: Editor: Column Advanced Settings: Extended HTML
- Manage Table: Editor: Allow Record Locking
- Manage Table: Editor: Relating Column
- Manage Table: Editor: Automatic Version Upgrade
- Manage Table: Editor: Allow editing comments
- Manage Table: Editor: Allow Copy
- Manage Table: Editor: Allow Reference Copy
- Manage Table: Editor: Characters to Add When Copying
- Manage Table: Editor: Allow Dividing
- Manage Table: Editor: Allow Table Locking
- Manage Table: Editor: Hide Link
- Manage Table: Editor: Use Ajax for Record Transitions
- Manage Table: Editor: Toggle Command Button on Auto Postback
- Manage Table: Editor: Delete Image on Delete
How to Use Tables¶
"Table" can be operated in the same way as "Site". See below for details.
- Site Functions: Breadcrumb list
- Site Function: Creating New Business Applications (Custom App)
- Site Function: Delete Site
- Site Function: Site Copy
- Site Function: Delete Site from Recycle Bin
- Site Function: Restore Site From Recycle Bin
- Site Function: View And Change Site Settings
- Site Function: Guide Settings
- Site function: Simple Mode
- Site Function: Set and Delete Site Images
- Site Function: Toggle Display of Site Information
- Site Function: Export Site Package