You can define items such as registered user, registration time, update user, and update time that are automatically set for each data.

Here, I will explain how to add four items of "registered user" "registration time" "updated user" "update time".
The intention of each is as follows.

item Type Description
Registered user String Record the logon account for which this data was newly registered.Values ​​are set only once at registration, and will not be changed thereafter.
Registration time Date and time Record the date and time when this data was newly registered.Values ​​are set only once at registration, and will not be changed thereafter.
Update user String Record the logon account that updated this data.The value is overwritten each time it is updated.The last logon account that was updated is recorded.
Update time Date and time Record the date and time when this data was updated.The value is overwritten each time it is updated.The last updated date and time are recorded.

Figure 1 shows the screen where the new registration screen is opened.Initial value of each item is set and it is changeable (read only).At this stage, no values ​​are stored in the database.

Fig. 1 Open new registration screen

Figure 2 shows the screen right after registration.The registration time and update time have been changed.The values ​​are saved in the database at this stage.In other words, the state shown in Fig. 1 is display only, the state shown in Fig. 2 (registered) is confirmed.

Figure 2 Immediately after registration

Figure 3 shows the screen where another user made an update.Registration time and registered users have not been changed.Update time and update user are overwritten.

Figure 3 Immediately after updating

, "Registered user", "registered time", "updated user", "updated time"As a templateIt is prepared. You can add it by selecting a template from the gear icon.(FIG. 4, FIG. 5)

Figure 4 Selecting a template
Figure 5 Add "registered user" "registration time" "update user" "update time"
Templates can also be defined by developers.For details, refer to "Function of Designer/Other tools> Prepare an item templatePlease read.

Item Details

The name of the added item can be changed.The standard settings are as follows.

The type of "registration time" and "update time" items is "date and time".

Figure 5 Type Details - Date and Time

Model item details - common

"Read-only" is set for all four items added

Figure 6 Read only is set

Initial value of registration time

"Now" is set as the initial value of the "registration time" item in "When registering screen is displayed" and "When registering".This is a special notation that returns the current date and time.

Now can be specified only by setting the initial value.

now
Figure 7 Setting now

Initial value of registered user

"Logon ID" is set in "Registration screen display" and "Registration" as "Initial value" of "Registered user" item.This will return the current logon account.

Figure 8 Logon ID setting

Initial value of update time

"Now" is set as "Initial value" of "Update time" item, "When registering screen is displayed" "When registering" "Updating".This is a special notation that returns the current date and time.

Now can be specified only by setting the initial value.

now
Figure 9 Setting now

Initial value of update user

"Logon ID" is set as "Initial value" of "Update user" item, "When registration screen is displayed" "When registering" "When updating".This will return the current logon account.

Figure 10 Logon ID setting
The same as now specification, there is a NOW function.However, when operating as a fixed value, please do not use the NOW function.If you specify now, recalculation processing /Upload update· It becomes possible to set individually whether or not to overwrite the update date with the mail transmission job function.When using the NOW function, it is updated uniformly.
The same as the "Logon ID" specification, there is the USERNAME function.However, do not use the USERNAME function when operating as a fixed value.When "Logon ID" is specified, recalculation processing /Upload update· It becomes possible to individually set whether to overwrite the updating person with the mail transmission job function.When USERNAME function is used, it is updated uniformly.

The repository key is the same as "initial value".