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](/en/manual/table-management-class)", "[Numeric Item](/en/manual/table-management-num)", "[Date Item](/en/manual/table-management-date)", "[Check Item](/en/manual/table-management-check)", "[Description Item](/en/manual/table-management-description)" 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.