WPS Last Modified By Field is an auto-record field for smart table records; it includes 2 core tasks, with 2 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 2 | Matches the number of rows in the How-to Index |
| Available without membership | 2 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
Last Modified By Field is a field type in WPS Office for Mac smart tables that automatically records the most recent editor for each record. After you create the field, you can define its update scope so the field refreshes when any field changes or only when selected fields change.
Core capabilities include:
- Create a Last Modified By field to display the latest editor for each record.
- Set the update scope to All Fields or Selected Fields.
This feature is useful for accountability tracking, change review, collaboration records, and routine table maintenance.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Mac computer that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office for Mac |
| Network | Local editing can be used normally; an internet connection is recommended for account sync or collaboration |
| Other | Open a smart table data sheet and make sure you have permission to edit the table |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Launch WPS Office for Mac, open a smart table, and confirm that the add-field entry is available in the table header |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS smart tables can add a Last Modified By field and let you set the update scope to All Fields or Selected Fields, so each record can show its latest editor automatically. | Microsoft Lists can show Modified and Modified By information, and version history can show who changed an item and when. | Google Sheets can show the last editor for a file and version history, and it can show edit history for a cell, but it does not present a native row-based last modified by field in the same way. | Notion databases include Last edited by and Last edited time properties that update automatically for each database item. | Adobe Acrobat mainly exposes document metadata such as author and modified date for PDFs, rather than a row-based last editor field for table records. |
| WPS Advantages | Advantage: WPS presents the latest editor directly as a field in each record and supports update scope control by selected fields. | Compared with WPS: Microsoft provides built-in tracking and version history, but its public guidance is centered more on list views and item history. | Compared with WPS: Google focuses more on file-level or cell-level edit history than a dedicated row field for table records. | Compared with WPS: Notion includes built-in last editor properties, but the public page does not describe update scope control by selected fields. | Compared with WPS: Adobe focuses on PDF document properties instead of table collaboration fields. |
| Official Source | — | Microsoft Lists modification record | Find what changed in a file | Database properties | How to find out when a PDF was created |
Overall Conclusion
WPS Last Modified By Field is designed for table collaboration workflows where the latest editor needs to appear directly in each record. For teams that want field-level update scope control inside a smart table, this setup is straightforward for daily review and traceability.
Use Cases
| No. | Scenario | Suitable for | Main issue | How it helps |
|---|---|---|---|---|
| 1 | Team task tracking | Team members, project owners | It is hard to tell who updated a record most recently | Add a Last Modified By field to show the latest editor automatically |
| 2 | Data review records | Operations, admin, managers | A reviewer needs to confirm responsibility quickly | Check the latest editor for each row directly in the table |
| 3 | Key-field monitoring | Table maintainers | Only important field changes should refresh the editor record | Set the update scope to Selected Fields |
| 4 | Multi-user maintenance | Collaborative teams | Multiple editors make it hard to identify the latest handler | Keep the latest editor visible in each record |
| 5 | Process review | Reviewers and approvers | Review work needs a quick way to identify the latest editor | Use the field together with other columns to inspect changes |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Core Writer, Spreadsheet, and Presentation apps | ✅ Available | ✅ Available |
| Basic use of Last Modified By Field | ✅ Available | ✅ Available |
| Some advanced PDF editing features | Varies by feature | ✅ More advanced options available |
| Cloud storage | 1 GB | 20 GB, depending on plan |
Source: Why do I need to pay for WPS Office? ; WPS Office pricing page
Recommendations
| Use case | Recommended plan | Why |
|---|---|---|
| Everyday table records and basic collaboration | Free | The Last Modified By Field itself has no membership restriction in this feature guide |
| Broader PDF, cloud, or advanced office needs | WPS Premium | A paid plan is more suitable when you also need more advanced office capabilities |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page