Bulk Entry for Table and Order Items

There are two ways to enter tabular data: one is to open a dialog and enter the data one row at a time, and the other is bulk entry which allows entering multiple rows at once. On this page, we will explain the bulk entry function.

 

The Bulk Entry function provides the following entry methods.

 

 

How to Enable Bulk Entry

Bluk Entry can be used in inputtable tables and Order Items in Sales Order Poster.

Table

In the case of a table, please make sure that Section Editablity is set to Editable and that the following JSON is set in the Variant Options.

 

{
    "enableBulkEntry": "true"
}

 

 

 

 

Tables with this setting will display a Bulk Entry button in addition to the New button.

 

 

 

Order Items

For Order Items, press the Variant Options button and enable Bluk Entry in the dialog.

 

 

Order Items with this setting will have a Bulk Entry button in addition to the Add button.

 

 

 

Method

 

Entering onto Table (Bulk Entry)

When you click the Bulk Entry button, a dialog box like the one below will appear. You can select the input method by switching the tabs in the dialog.

 

In Bulk Entry Mode, you can enter the data in the following way.

First, add a row using the Add button, and then enter data in each cell. If the field has been set as required in the component builder, an input error will be displayed if the field is empty, and the Save button will be disabled.
On this screen, functions such as Picklist and Lookup are not available.

 

When all problems are solved, the Save button will be activated and you can save the data to Order Items or Table.

 

 

Copy-paste From CSV

 

When inputting from CSV, you can set whether to use the CSV Delimiter and the first line as the Header. After that, paste the CSV into the Textarea. The parsed data will automatically be displayed in the table below the Textarea.

 

After confirming that the data has been parsed successfully, do the column mapping between the data displayed in the table and the destination.

 

After completing the mapping, the data will be copied to the table in the Bulk Entry tab by clicking the Copy to Bulk Entry table button.

 

The data will be saved by making a final check in the Bulk Entry tab and clicking the Save button. The required field will also be checked here.

 

Copy-paste column by column

 

To bulk enter data by column, go to the Bulk Entry by column tab, select Destination Column, and then enter and paste the data into the Column data textarea.

When you enter data, the values are automatically entered into the table on the right.

 

The other columns are entered in the same way.

 

When you have finished entering all the data, the data will be copied to the table in the Bulk Entry tab by clicking the Copy to Bulk Entry table button.

 

The data will be saved by making a final check in the Bulk Entry tab and clicking the Save button. The required field will also be checked here.