Advanced Operation: Column Types
## Overview
Among the data columns that store data in the "Table", in addition to the columns that are set by default, you can freely arrange "[Class Column](/en/manual/table-management-class)", "[Numeric Value Column](/en/manual/table-management-num)", "「Date Column」", "「Check Column」", "[Description Column](/en/manual/table-management-description)", and "「Attachment Column」" in the "[Editor](/en/manual/table-management-editor)".
## Classification
Used as a free text input and option input column. The maximum number of characters is 1024. You can choose drop-down list format or radio button format when used as option input. You can also set the options in JSON format to use filters, sorts, "[Display format](/en/manual/table-management-choice-json)" settings, and automatic transcription using "[Lookup](/en/manual/table-management-lookup)". You can use the "[Automatic Numbering](/en/manual/auto-numbering)" function to assign numbers in a specified format automatically.
#### Display image

## Numeric Value
Used as a column to input numeric value. In addition to free text, you can select "Spinner", which allows you to change the numeric value with the up and down buttons.
### Handling when no input is made
By default, 0 is automatically registered and is also displayed as 0 on the screen, but you can register NULL by checking "[Nullable](/en/manual/table-management-nullable)" to ON.
#### Display image

## Date
Used as a column to input date and time from free text or the calendar.
### About time
If you select "Year/Month/Date" as the editor format, it will automatically be registered as "00:00:00" when registering and updating from the editing screen. However, if you intentionally specify a time when registering and updating with the API or server script, it will be registered with the specified content.
#### Display image

## Check
Used as a checkbox. It has two states: checked ON and unchecked.
#### Display image

## Description
Used as a column to enter a string in free text. You can enter text using "[Markdown](/en/manual/markdown)" and register "[Image](/en/manual/table-record-upload-picture)".
### Differences from class columns
The differences from class columns are as follows. Use them according to your requirements.
|Column|Class Column|Description Column|
|:---|:---|:---|
|Maximum number of characters|1024 characters|Practically unlimited|
|Configurable style|Normal<br>Wide|Normal<br>Wide<br>Markdown|
|Use as selection column|Possible|Impossible|
|Automatic numbering|Available|Available|
#### Display image

## Attachment
Used as a column to attach various files. You can specify the number of files that can be attached and the file size. There are no restrictions on file types. If the "「Attachment File」" can be displayed in the browser, clicking the magnifying glass icon will display a preview in a separate tab. If you want to display an image on the screen, use the "[Description Column](/en/manual/table-management-description)" instead of the "「Attachment Column」".
#### Display image

## Related information
<div id="ManualList"><ul><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-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-description">Manage Table: Column: Description</a><span>09.09.2025 up</span></li></ul></article>
<ul><li><a href="/en/manual/auto-numbering">Table Management: Editor: Item Detail Settings: Automatic Numbering</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-editor">Manage Table: Editor</a><span>06.20.2025 up</span></li>
<li><a href="/en/manual/table-management-nullable">Table Management: Editor: Item Detail Settings: Nullable</a><span>08.13.2024 up</span></li>
<li><a href="/en/manual/table-management-choice-json">Manage Table: Editor: Column Advanced Settings: Option List: Filter, Sort, Display Format</a><span>10.02.2024 up</span></li>
<li><a href="/en/manual/table-management-lookup">Table Management: Editor: Item Detail Settings: Choice List: Lookup</a><span>08.13.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="" />