Use WPS Last Modified Time Field through 3 topics: create the field, set the update scope, and set the date format; 3 topics are free and 0 are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Create a Last Modified Time Field | Free |
| 2 | 2. Set the Update Scope | Free |
| 3 | 3. Set the Date Format | Free |
How-to Guide
1. Create a Last Modified Time Field
Entry: + button on the right side of the header → Field Type list → Last Modified Time
- Click the
+button on the right side of the header. - Select
Last Modified Timefrom the field type list. - Enter a field name.
- Click
OKto finish.
Success Criteria
- Interface result: A new Last Modified Time field column appears in the data table.
- Next action available: You can open field settings and continue with update scope and date format settings.
Tips While Using
- Use a clear field name such as
Last UpdatedorLast Modified Time.- After creation, the field records time automatically and does not require manual input.
2. Set the Update Scope
Entry: Right-click the field title → Field Settings → Update Scope
- Right-click the Last Modified Time field title.
- Select
Field Settings. - Find the
Update Scopeoption. - Choose
All FieldsorSelect Fields. - If you choose
Select Fields, select the fields that should trigger the timestamp update.
Success Criteria
- Interface result: The selected update scope is saved in field settings.
- Next action available: When the related fields are edited, the timestamp updates according to the rule you set.
Tips While Using
- If you choose
All Fields, any field change updates the timestamp.- If you choose
Select Fields, only the selected fields can trigger the update.
3. Set the Date Format
Entry: Right-click the field title → Field Settings → Date Format
- Right-click the Last Modified Time field title.
- Select
Field Settings. - Open the
Date Formatarea. - Choose a display format such as
yyyy/mm/dd HH:mm,yyyy-mm-dd HH:mm, oryyyy年mm月dd日 HH:mm. - Select
Show Timeif needed. - Save the setting.
Success Criteria
- Interface result: The timestamp display style is updated consistently in the field.
- Next action available: New and updated records continue to use the current format.
Tips While Using
- Changing the date format affects the display of all records in that field.
- If you only need the date, clear the time display option.