User Manual

10.07.2024

MANUAL

Manage Table: Column

## Overview These are data items that store data from a "[Table](/en/manual/table)". There are various types of "「Column」", such as "[Class Column](/en/manual/table-management-class)", "[Numeric Value Column](/en/manual/table-management-num)", "「Date Column」", "「Check Column」", "「Description Column」", and "「Attachment Column」". To create input forms, you can freely combine and place these columns in the "[Editor](/en/manual/table-management-editor)". You can also freely select the "「Column」" to display on the "[Screen Index](/en/manual/table-grid)". ## Edit Screen Columns The columns to be set on the edit screen are as follows. |Name|Overview|Notes |:---|:---|:---| |ID|Column that stores the unique ID of the "Record". Read-only|Default setting in time-limited tables and recorded tables| |Version|Column that stores the "Record" version number. Read-only|Default setting in time-limited tables and recorded tables| |Title|"Input Column" that stores the "[Title](/en/manual/tenant-logo)" to identify the "Record". Can be automatically set from the contents of multiple "Input Column" with "[Title Merge](/en/manual/table-management-title-combination)"|Default setting in time-limited tables and recorded tables| |Body|"Input Column" that allows you to enter the content of the "record" as free text. You can enter data using "[Markdown](/en/manual/markdown)" and register "[Image](/en/manual/table-record-upload-picture)"|Default setting in time-limited tables and recorded tables| |Start|"Input Column" that stores the "Start Date and Time" of the "Record"|Default setting in time-limited tables, cannot be set in recorded tables| |Complete|"Input Column" that stores the completion date and time that indicates the deadline of the "Record"|Default setting in time-limited tables, cannot be set in recorded tables| |Work volume|"Input Column" that stores the "Work volume" of the "Record"|Default setting in time-limited tables, cannot be set in recorded tables| |Progression Rate|"Input Column" that stores the "Progression Rate" of the "Record" as a percentage between 0 and 100%|Default setting in time-limited tables, cannot be set in recorded tables| |Remaining Work Volume|"Input Column" that automatically calculates the "Remaining Work Volume" from the "Work volume" and "Progression Rate" of the "Record". Read-only|Default setting in time-limited tables, cannot be set in recorded tables| |Status|"Input Column" that stores the status of the "Record"|Default setting in time-limited tables and recorded tables| |Manager|"Input Column" that stores the "Manager" of the "Record"|Default setting in time-limited tables and recorded tables| |Owner|"Input Column" that stores the "Owner" of a record|Default setting in time-limited tables and recorded tables| |Lock|"Input Column" for "[Lock Record](/en/manual/table-record-lock)"|Default setting in time-limited tables and recorded tables| |Category|"Input Column" that can be selected from "[Option List](/en/manual/table-management-choices-text)" or in free text format|| |Numerical value|"Input Column" that allows you to enter the numerical value as free text|| |Date|"Input Column" that allows you to enter date and time from free text or the calendar|| |Description|"Input Column" that allows you to enter a string as free text. You can enter text using "[Markdown](/en/manual/markdown)" and register "[Image](/en/manual/table-record-upload-picture)"|| |Check|Checkbox "Input Column"|| |Attachment|"Input Column" where you can download/upload "[Attachment](/en/manual/table-record-attachment-upload)"|| |Comment|"Input Column" where you can enter free text for comments on records. You can enter text using "[Markdown](/en/manual/markdown)" and register "[Image](/en/manual/table-record-upload-picture)". Cannot be repositioned|Default setting in time-limited tables and recorded tables| |Creator|Column that stores the creator of the "Record". Read-only. Cannot be repositioned|Default setting in time-limited tables and recorded tables| |Updater|Column that stores the updater of the "Record". Read-only. Cannot be repositioned|Default setting in time-limited tables and recorded tables| |Creation Date and Time|Column that stores the creation date and time of the "Record". Read-only. Cannot be repositioned|Default setting in time-limited tables and recorded tables| |Update Date and Time|Column that stores the updated date and time of the "Record". Read-only. Cannot be repositioned|Default setting in time-limited tables and recorded tables| ## Prerequisites 1. "Site Administration Permission" is required to configure settings. ## Operate Method 1. To create an input form, refer to "「Editor Column Settings」" 1. To customize the list screen, refer to "[Screen Index Column Settings](/en/manual/table-management-grid-columns)" ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table">Table Function</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-grid">Table Function: Record Screen Index</a><span>10.02.2024 up</span></li> <li><a href="/en/manual/table-record-lock">Table Function: Lock Record</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-attachment-upload">Table Function: Upload Attachment To Record</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-attachment-download">Table Function: Download Record Attachments</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-upload-picture">Table Function: Register Image to Record</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-start-time">Manage Table: Column: Start</a><span>10.02.2024 up</span></li> <li><a href="/en/manual/table-management-progress-rate">Manage Table: Column: Progression Rate</a><span>10.02.2024 up</span></li> <li><a href="/en/manual/table-management-remaining-work-value">Manage Table: Column: Remaining Work Volume</a><span>10.11.2024 up</span></li> <li><a href="/en/manual/table-management-status">Manage Table: Column: Status</a><span>10.02.2024 up</span></li> <li><a href="/en/manual/table-management-manager">Manage Table: Column: Manager</a><span>10.02.2024 up</span></li> <li><a href="/en/manual/table-management-owner">Manage Table: Column: Owner</a><span>10.11.2024 up</span></li> <li><a href="/en/manual/table-management-class">Table Management: Item: Classification</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-management-num">Manage Table: Column: Numerical Value</a><span>10.02.2024 up</span></li> <li><a href="/en/manual/table-management-creator">Manage Table: Column: Creator</a><span>10.11.2024 up</span></li> <li><a href="/en/manual/table-management-updator">Manage Table: Column: Updater</a><span>10.02.2024 up</span></li> <li><a href="/en/manual/table-management-updated-time">Manage Table: Column: Update Datetime</a><span>10.11.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-editor">Table Management: Editor</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-management-choices-text">Manage Table: Editor: Column Advanced Settings: Option List</a><span>01.15.2025 up</span></li> <li><a href="/en/manual/table-management-title-combination">Manage Table: Editor: Column Advanced Settings: Title Combination</a><span>10.11.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-grid-columns">Manage Table: List Screen: Screen Index Column Settings</a><span>10.07.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/tenant-logo">Tenant Management Function: Logo, Title, Logo Image</a><span>10.08.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/markdown">Common Function: Markdown</a><span>10.30.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" /> ## In Case There Are Not Enough Columns If 26 items from A to Z such as "「Class Column」", "「Numeric Item」", "「Date Item」", "「Check Item」", "「Description Item」" are not enough, the number of items can be expanded to 27 or more by using the "Enterprise Edition". For more information on the "Enterprise Edition", please refer to "「[Here](/support)(Japanese text only)」" . For information on how to obtain a trial version of the "「Enterprise Edition」", please contact us at [Contact](https://implem.co.jp/contact) (Japanese text only).
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.