Display the 'last updater' and 'last modified date' information on the Header Information List Screen

This page explains how to display the 'last updater' and 'last modified date' on the Header Information List Screen.

By displaying these two, you can quickly see when and who last updated this data.

Attention

About App modification will initialize the header information list screen.

Please note that any corrections you make on this page will also be deleted.

Edit the Header Information List Screen

1. Login to CELF and click the "Manage" button to open the administration screen.

   

   Tip

   The "Manage" button appears when you are logged in as an administrator.

2. Double-click the app.

   

3. From the sheet, select the Header Information List Screen and double-click it.

   

   Tip

   In this case, the "Notification of childcare leave_Header Information List Screen" sheet becomes the Header Information List screen.

   

4. Display the hidden column on the right side of the screen. Place your mouse pointer over the rightmost column heading, hold down the left mouse button and move the pointer to the white column name and release the left mouse button.

   

5. Right-click on the column heading at the far right of the column and click on "Unhide" in the menu that appears.

   

6. Click the gear icon on the top ribbon.

   

7. Increase the number of rows by 3 and click the "OK" button.

   

8. Enter "Last Updater" in the cell to the right of "Last Modified Date".

   

9. Adjust the width of the "Last Modified Date" and "Last Updater" columns.

   

   Hint

   If you hover the mouse over the right side of the column heading, the cursor will change to "↔".

   If you hold down the left mouse button and move the mouse left or right, the width of the row will change.

10. Change the font. Along with the other items, the font should be "MeiRyo" and the size should be 10pt.

Tip

You can change the formatting of the entire sheet by selecting the entire sheet and changing the font and size.

11. Extend the rules. Select from the two columns to the left of "Last Modified" to the one column to the right of "Last Updater".
12. Right-click on a cell in the selected range.
13. Select "Cell format settings" from the menu that appears.

14. Select the tab "Borders" and select green for the "Colors" selection.

15. Select "Style" and underline for "Border" and click the "Confirm" button.

That’s all you have to do to edit the screen. Now we can change the content of the action.

See also

If you want to change the position of the button, cut the button (Ctrl + X) and paste it to the location you want to move it to (Ctrl + V).

If it is above the list, you can move the button anywhere you want.

For details, refer to "Customize Header Information List Screen".

Edit the action (logic) in the Header Information List Screen

Modify the "List view" action in the Header Information List Screen to display the last updater and last modified date.

The figure below shows the process flow of the "List view" action.

The modifications are as follows.

[1] Clear the data in the list

Extend the range in which the displayed data is cleared.

The range will be modified to include cells that display "Last Updater" and "Last Modified Date".

[2] Clear the formatting of the listed cells

Extend the range in which the cell formatting is cleared.

The range will be modified to include cells that display "Last Updater" and "Last Modified Date".

[3] Get multiple items from a table and set them in a cell in the list section

Add "Last Updater" to the items to be retrieved from the table and set the destination for the display.

[4] Set the format of cells in the list section

Extend the range of cells for formatting.

The range will be modified to include cells that display "Last Updater" and "Last Modified Date".

Tip

In [3], "Get multiple records from table" but the "Last Modified Date" item has already been obtained.

Therefore, the only modification here is the addition of "Last Updater".

Now, the steps below will show you how to actually modify the action set.

Open the action set

1. Click the "Action set settings" button in the upper right corner of the screen.

   

2. Double-click the action name "List view".

   

Extend the clearing range of the list section

1. Change the range of initialization (reverting to the initial state) of the first and second lines in the action set on the right side of the action settings screen.

   

   Tip

   Here, the range up to the AQ column is changed to be up to the AV column.

   The column you added when you edited the screen is the AV column in this example.

Adjust the width of the "Last Modified Date" and "Last Updater" columns.

1. Look for the orange action "Acquire data that matches the conditions and set it to the screen" and click the button to edit the "Columns to display anddisplay destination settings".

   

2. Scroll to the bottom of the "Please select column to show" bar.

   

3. Click "(Select Column)" at the bottom and select "LAST_UPDATER" from the list displayed.

   

4. For the column of the added item, set the column two columns to the right of the one specified in the row above and click the "OK" button.

   

   Hint

   Here, the "AT" column is set one row up, so we’ll set the column "AV"that is two columns after AT.

Extend the formatting range of a list section cell

1. Look for the green action "Set the format of the search results list" and change the scope of the formatting.

   

   Hint

   Include the columns you just added in the formatting range.

   Now that we have added 'AV' column, we will change the last column of the formatting range to 'AV'.

This completes all the settings.

This page explains how to display the 'last updater' and 'last modified date' on the Header Information List screen.