WPS Last Modified By Field on macOS: Introduction

Last updated:July 21, 2026

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

MetricValueNotes
Core tasks2Matches the number of rows in the How-to Index
Available without membership2Matches the number of Free rows in the index
Membership-related items0Matches 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

ItemRequirement
Operating systemA Mac computer that can run WPS Office normally
App versionIt is recommended to use the latest version of WPS Office for Mac
NetworkLocal editing can be used normally; an internet connection is recommended for account sync or collaboration
OtherOpen a smart table data sheet and make sure you have permission to edit the table

Download & Installation

ItemDetails
Official downloadWPS Office Free Download
Check after installationLaunch 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

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryWPS 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 AdvantagesAdvantage: 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 SourceMicrosoft Lists modification recordFind what changed in a fileDatabase propertiesHow 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.ScenarioSuitable forMain issueHow it helps
1Team task trackingTeam members, project ownersIt is hard to tell who updated a record most recentlyAdd a Last Modified By field to show the latest editor automatically
2Data review recordsOperations, admin, managersA reviewer needs to confirm responsibility quicklyCheck the latest editor for each row directly in the table
3Key-field monitoringTable maintainersOnly important field changes should refresh the editor recordSet the update scope to Selected Fields
4Multi-user maintenanceCollaborative teamsMultiple editors make it hard to identify the latest handlerKeep the latest editor visible in each record
5Process reviewReviewers and approversReview work needs a quick way to identify the latest editorUse the field together with other columns to inspect changes

Membership & Benefits

Free vs WPS Premium

CapabilityFree usersWPS Premium
Core Writer, Spreadsheet, and Presentation apps✅ Available✅ Available
Basic use of Last Modified By Field✅ Available✅ Available
Some advanced PDF editing featuresVaries by feature✅ More advanced options available
Cloud storage1 GB20 GB, depending on plan

Source: Why do I need to pay for WPS Office? ; WPS Office pricing page

Recommendations

Use caseRecommended planWhy
Everyday table records and basic collaborationFreeThe Last Modified By Field itself has no membership restriction in this feature guide
Broader PDF, cloud, or advanced office needsWPS PremiumA paid plan is more suitable when you also need more advanced office capabilities

How to Subscribe

Source: WPS Office pricing page