Support > Repository > Screen function > List update
ja | en

Update the data in list format. You can add new data or delete it.

A button for transitioning from the search screen to the list update screen is prepared.

Figure 1 "To update list" button

On the list maintenance screen, you can update, newly register and delete data in tabular form.

Figure 2 List update screen

update

Each row corresponds to one piece of data.Correct the input field in the line.The data being modified is managed with the status "being modified" and locked.In the save process, only the data being modified is updated.

Copy registration/new registration

Press the "copy" or "new" button provided on the left side of each line.

Delete

In the "Delete" column prepared on the left side, check the data you want to delete.You can delete it by pressing save button.

Save

Save the current edit state.The lock will be released after saving.Error lines are ignored.For example, if you are editing 10 rows and there is an input error (eg mandatory missing input) on one line, nine are saved by pressing save button.

Cancel

Cancels all editing status and returns to the original screen (list display screen).Edited values ​​are not saved.

Check the input

Performs the current data input check processing.If there is an error, "Error" is displayed.You can perform checking before pressing the save button.

Correction across multiple pages

When the number of cases is large, it is divided into multiple pages and displayed.Even if you move the page, the content of the editing work is memorized.When you return to the original page, the data being edited is restored.

Screen example

Here is an example of changing the page title to "updated collectively at your discretion".

Figure 3 Change page title

Definition method

Open the Search/List display tab in the screen tab.Enter a character in the "Page Title" column.

Figure 4 Setting the page title

Screen example

An example of setting descriptive text is shown below.

Fig. 5 Display description

Definition method

Open the Search/List display tab in the screen tab.Enter a letter in the "Description text" field.

Figure 6 Setting description

Add HTML tag

HTML tags can also be added to the description.Detail is"Search/List display> Explanatory text - Add HTML tagPlease read.

Screen example

You can set that you do not allow update processing.The operation will be as follows.

  • New registration can be done.
  • Update/delete processing can not be performed.

In other words, it becomes update mode in which "record that can be input" and "record which can not be input" are mixed in the list update screen.

Figure 7 List update screen for which updating is not permitted

If you press the "New" button on the line, a record for new input will be prepared.

Figure 8 You can add new records

Definition method

Release the "Allow update processing" setting.(It is enabled by the standard.)

Figure 9 Setting to allow update processing

It is also possible to hide the check box for deletion.Disable deletion function.

Fig. 10 Deletion check box Hidden example

Definition method

Uncheck "Display deletion check box" setting.(It is enabled by the standard.)

Figure 11 Setting to display deletion check box

On the list update screen, the displayed data is locked.

If you move to "next page" or "previous page", the modified data retains the lock as it is, and unlocked data is unlocked.

If the lock acquisition fails when moving the page, locking failure is displayed at the left end of the data and it can not be edited.

Screen example

It can be divided into left and right sides with a specific column as the axis.(This is an image of "fixing the window frame" in Excel.)
Figure 12 shows an example of dividing the "name" item on the left side and the rest on the right side.The right part is evenly allocated automatically even if there are many items.

Figure 12 Screen with fixed columns

Definition method

On the "Screen> Update list" tab, specify "Fix column" as "Scroll type of list display part". In this case, you need to specify "fixed item name" and "table width at column fixed". The former specifies the item ID (English name), the latter specifies the ratio of the left side and the right side part with a comma break.

Figure 13 Column fixed setting

Specify the label width

In the display example shown in Fig. 12, even when the number of items increases, it becomes evenly allocated, so each column width decreases and it becomes hard to enter.
Scroll bars can be displayed as shown in Fig. 14 by specifying the label width of each item.

Figure 14 Using the scroll bar

For the items used for list display, specify the label width as pixel value.(FIG. 15)

Figure 15 Specifying label width of list display

If you omit the label width specification, the web browser automatically adjusts the width.When there are many items, it may not necessarily be the optimum layout.In this case, please set the label width.

Screen example

Fix the item name part (header row) of the column.(This is an image of "Fixing the first line of Excel".)
Figures 16 and 17 show an example in which the header row is fixed and the height of the display area is 300 pixels.Header rows are fixed even if you scroll the display.

Figure 16 Header row fixed (1)
Figure 17 Header row fixed (2)

Definition method

On the "Screen> Update list" tab, specify "header row fixed" as "scroll type of list display part". In this case, it is necessary to specify "height of table when header row is fixed".The initial value when blank is "240px".

Fig. 18 Header row fixed setting

For the items used for list display, specify the label width as pixel value.(Similar to FIG. 15 of "row fixing")

If you omit the label width specification, the web browser automatically adjusts the width.When there are many items, it may not necessarily be the optimum layout.In this case, please set the label width.

When return does not work

"Output control (style)> CSS class name/style specification> Example Specify the return width of the list display itemPlease read.

Screen example

You can specify a separate text area for list update.

Figure 19 Using Text Area

Definition method

"Type of input item" of the target item (here, "remarks" item) is set as the text area.

Figure 20 Specifying the type of input item

In the text area setting in the input control tab, specify the "number of lines" and "number of characters per line" for the list update screen.

Figure 21 "Number of lines" and "Number of characters per line" for the list update screen

This setting works the same as list display.Detail is"Search/list display> Number of simultaneous display of list display screenPlease read.

This setting works the same as list display.Detail is"Search/List display> Pagination of list display screenPlease read.

You can control that the list update button is displayed only when search results are found. Write the following formula in the display control field of the list update button.

RESULTSIZE()>0
Figure 22 Example of display control of list update button

RESULTSIZE functionIs effective only on the search/list display screen.

Explain the buttons (functions) that can be prepared on the list update screen.

Figure 23 Button provided on the update list screen

Definition method

Activate "button display" provided on the list maintenance tab in the screen tab.

Figure 24 Button display setting
Classification initial state Description
Save
Cancel It returns to the list display screen.
Check the input Check the data in the middle of input.
sign up It is necessary to have prepared a new registration screen.
Copy registration It is necessary to have prepared a new registration screen.

Display control of buttons

"Display in bulk delete/bulk mail transmission/bulk report/bulk update/print format" button is displayed only when search result exists.If there is no search result, the button is also hidden.

For details of display control by developers, see "Customize button name and display conditionsPlease read.

Items that can not be handled

Items that can not be edited (display only)

  • Reference linkage
  • file name
  • Item with foreign key specified
  • Hidden items
  • Read-only item

Check the input

Warning designation does not work on the list update screen (including parent child model simultaneous update screen).

Execution of list update for results narrowed down by search conditions

On the list update screen, there is no column for setting search conditions.

Figure 1If you use the button to move to the list update screen on the search/list display screen, only the data narrowed down on the search screen will be subject to the list update.(That is, you can update the list against the narrowed down data.)

If you switch directly from the menu screen to the list maintenance screen, all data will be subject to list update.

When default search conditions such as initial values ​​are set as search conditions of the target model, the data narrowed down according to the condition is subject to list update.

Setting narrowing down between items

"Reference to other models> Refine choices by relationship between reference models> Troubleshooting> Refresh screen does not work on list update screenPlease read.

Other constraints

  • When copying is registered in the model (parent model) specified as a foreign key, the model (child model) that specifies the foreign key is also copied, but in the copy registration in the list update, the model with the foreign key specified (Child model) will not be copied.
  • The function of finding an address from a zip code and address normalization processing (option) are not performed.
  • It is not possible to specify the scroll type (column fixed, header row fixed) of the list display part and multilevel layout at the same time.Please use one of the layout designs.
  • It is not possible to override the "Ignore Error Line and Save" setting.(We are currently in the process of fixing it.)
  • Items that are mandatory must be set to display in list form or set initial values ​​("When registering" or "When registering screen").(However, if you do not create a new registration screen/copy registration screen (detail screen, list display screen), this restriction does not apply.)