WPS Last Modified By Field on macOS: Introduction

WPS Last Modified By Field is an auto-updating field in WPS data tables; 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	All listed tasks are available directly

About This Feature

Overview

Last Modified By Field is a system field type in WPS Office for Mac data tables that automatically records who last edited 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: Add the field directly from the field type list in the table header.
Set the update scope: Choose All Fields or Selected Fields to control when the last editor is refreshed.

This field is useful for accountability tracking, change review, and collaboration records. When used together with a Created By field, it helps you see both who created a record and who edited it most recently.

System Requirements

Item	Requirement
Operating system	A macOS device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	An internet connection is recommended when opening or collaborating in online data tables
Other	You need access to the data table and permission to add fields or adjust field settings

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download WPS Office for Mac, complete the setup flow, and sign in to your account
Post-install check	Open a data table and confirm that the “+” entry for adding a field is visible in the header

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS data tables let you add a Last Modified By field and define whether updates are triggered by all fields or only selected fields.	Microsoft Lists can show the Modified column for the latest editor and use version history to review who changed an item and when.	Google Sheets shows the last editor at the file level and provides version history and cell edit history, but it does not provide a built-in row field that automatically displays the last editor for each record.	Notion databases include a Last edited by property that automatically records the person who edited an item last.	Adobe Acrobat focuses on shared PDF review tracking and document status, rather than a row-based last modified by field in a structured table.
WPS Advantages	Advantage: It works as a native table field and supports update scope control by selected fields, which is useful for structured record tracking.	Compared with WPS: It shows the latest modifier and version history, but the public guidance used here does not describe a selected-field trigger scope for automatic updates.	Compared with WPS: It is centered more on file-level or cell-level history than on a native row-based auto field.	Compared with WPS: It also provides an auto-updating last editor property, but the public guidance used here does not describe selected-field trigger settings.	Compared with WPS: It is designed more for PDF review workflows than for table record fields.
Official Source	—	Microsoft Lists modification record	Google Docs Editors version history	Notion database properties	Adobe shared file tracking

Overall Conclusion
If you want a field that directly shows the latest editor inside each table record and also lets you control which field changes trigger updates, WPS is a practical fit for structured collaboration. Other products provide version history, document tracking, or auto properties, but their focus is different from a configurable row-based field.

Use Cases

No.	Scenario	Suitable for	Main issue	How it helps
1	Task collaboration tracking	Project members and team leads	It is unclear who updated a record most recently	Add a Last Modified By field to record the latest editor automatically
2	Audit trail review	Operations and reviewers	Responsibility checks take time	Use the Last Modified By field together with filters
3	Key-field change monitoring	Table admins	Only important field changes should refresh the editor	Set the scope to Selected Fields and choose trigger fields
4	Separate creator and editor tracking	Collaborative teams	The creator and later editor need to be distinguished	Use both Created By and Last Modified By fields
5	Periodic review	Managers	It is hard to identify the latest operator during review	Check recent changes by the Last Modified By field

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Use Last Modified By field in data tables	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Advanced PDF editing and more advanced tools	Limited or provided as listed on the pricing page	More available features are provided
Cloud storage	1 GB	20 GB or more depending on plan
AI tools	Some capabilities are limited	More availability, subject to plan details

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You only need to track the last editor in data tables	Free	This field is available directly for everyday collaboration records
You also need more PDF tools, cloud storage, or AI features	WPS Premium	It is suitable for individuals or teams that need broader office capabilities

WPS membership center: Subscribe now
To compare plan coverage, open the pricing page and review the listed feature details.