2022-08-29 / Data Items
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.

Configs: Common
  • Item Name
  • Field Name *
  • Data Type
  • Description
    • Correct Errors and Format
  • Note
Configs: Table (Table-Type)
  • Required
  • Minimum Rows
  • Maximum Rows
  • Table Columns
  • Add Table Column
    • String
      • Item Name
      • Field Name
      • Required
      • Minimum Length
      • Maximum Length
      • Regular expression to be satisfied
    • Numeric
      • Item Name
      • Field Name
      • Required
      • Number Format
        • 1234567.89
        • 1,234,567.89
        • 1234567,89
        • 1.234.567,89
      • Range of decimal places
      • Prefix
      • Suffix
      • Minimum Value
      • Maximum Value
      • Show calculated value (appears only when two or more numeric columns are set)
        • (select numeric column)
        • (operator)
          • * (multiplication)
          • + (addition)
        • (type a fixed Number/select numeric column)
      • Show total value at the bottom of list
    • Select
      • Item Name
      • Field Name
      • Required
      • Choices
        • Choice ID
        • Label
      • Edit in CSV format
    • Date
      • Item Name
      • Field Name
      • Required

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 Modeler
    • 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
  • The Task Operator can add table rows and can input table contents
    • The number of rows that can be added depends on the limits set in the Modeler
  • Formulas can be set to automatically calculate cell values between numeric columns
  • Select-type columns will present a dropdown menu displaying the options set in the Modeler
  • In Date-type column, a number that can be entered as a year is between 1900 and 2100
  • From version 14.1 onwards the input interface on the Task Operating screen has been changed
    • Double-click on the desired line to start typing
    • The buttons on the top left respectively have the function that is; (add a row to the end), (insert a row above the checked row, invalid if unchecked), (delete checked rows), (copy to clipboard)
      • (copy to clipboard) will copy the entered value to the clipboard in TSV format
        • 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: standard format (period as the decimal point, no thousand delimiter)
          • Select-type: 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, Google Spreadsheets, etc.
      • You can batch insert values copied from Google Sheets or Excel into a Table-type Data Item
        • Click a cell to be the first (upper left) to focus it, and press Ctrl+V to insert
        • Values already entered in the table will not be overwritten

See also

%d bloggers like this: