Use WPS Last Modified By Field with 2 how-to topics on Windows smart table data sheets; all 2 topics are available without membership and 0 are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Add a Last Modified By Field | Free |
| 2 | 2. Set the Update Scope | Free |
How-to Guide
1. Add a Last Modified By Field
Entry path: + on the right side of the table header → Field type list → Last Modified By
- Open the smart table data sheet that you want to edit.
- Click the + button on the right side of the table header.
- Select Last Modified By from the field type list.
- Enter a field name.
- Click OK to finish creating the field.
Success Criteria
- Interface result: A new Last Modified By column appears in the table.
- Next action: You can continue to open field settings and adjust the update scope.
Tips While Using
- Common mistake: If the table is not in an editable state, you may not be able to add a new field.
- Environment note: You need edit permission for the data sheet.
2. Set the Update Scope
Entry path: Right-click the field title → Field Settings → Scope
- Find the Last Modified By field that has already been created in the data sheet.
- Right-click the field title and select Field Settings.
- Choose the update condition in the scope settings.
- To update the editor when any field changes, select All Fields.
- To update the editor only when key fields change, select Selected Fields, then choose the target fields.
- Save the settings and return to the data sheet.
Success Criteria
- Interface result: The selected update scope is shown in field settings.
- Next action: After editing the related fields, you can check whether the Last Modified By value updates as expected.
Tips While Using
- Common mistake: If no target fields are selected in Selected Fields mode, the update behavior may not match your expectation.
- Environment note: You need permission to change field settings.