
Data Item: Table-Type
Displays a table that allows input to String, Numeric, Select or Date-type Data Item formats. Any number of rows can be added when entering data.
Capture
Settings Screen

Input Screen

Notes
- To input / edit data items, the editing authority in the task must be set to “Editable”
- Columns must be configured in the Table Columns section on the property screen of the Data Item
- Item Name is displayed in the title row of the column
- Field Name is used for reference from other Data Items, etc
- Specify an arbitrary single-byte alphanumeric character string
- Required if [Show total value] is checked in “numeric” column, optional for other columns
- Formulas can be set to automatically calculate cell values between numeric columns
- The number of rows that can be added depends on the limits set in the property
- The Task Operator can add table rows and can input table contents
- Double-click on the desired line to start typing
- Select-type columns will present a dropdown menu displaying the options set in the property
- In Date-type columns, the possible values for the years that can be entered are between 1900 and 2100
- The buttons on the top left respectively have the following functions
- (add) : A row is added to the bottom
- (insert) : A row is inserted above the checked row (invalid if unchecked))
- (delete) : Checked rows are deleted
- (Copy to clipboard) : The values of all cells in the table except for the summary row are copied to the clipboard (TSV format)
- (Paste from clipboard) : The contents of the clipboard are pasted expanding from the focused cell
- In the clipboard, values are handled in the following format according to the type of sub-data item
- String-type: character string as it is
- Numeric-type: character string of the standard format (period as the decimal point, no thousand delimiter)
- Select-type: character string of the Choice ID
- Date-type: string in the format yyyy-MM-dd
- The copied content can be pasted to other Table-type Data Items with equivalent column definitions
- Click a cell to be the first to focus it, and click to insert
- Values already entered in the table will not be overwritten
- You can batch insert values copied from Google Sheets or Excel into a Table-type Data Item
See also
- Tutorial: Let’s Calculate the Total Amount Automatically
- Tutorial: Who Can View Business Data of the Issue, and Who Can’t?
- R2131: HTML Tags Available for Operation Form
- M205: Business Data Items
- M206: Mandatory Check and Input Format Check on Each Data Item
- M213: Guidance Descriptions on the Operating Screen (HTML/JavaScript)
- Download: New Record to Google Sheets (TSV)
- Download: Row Addition to Google Sheet (Table)
- Download: Converter (Options to Table)
- Download: Diff (Table and Table)
- Download: Email a Excel-CSV (Table) sjis
- Download: Data Duplicator (Table)