WPS Last Modified Time Field on macOS: Introduction

WPS Last Modified Time Field on macOS automatically records the latest edit time for each record; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	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

The Last Modified Time Field is a time-based field in Smart Table data tables on Mac. It automatically shows the most recent time when each record was edited. After you create the field, you can decide whether updates are triggered by changes in any field or only in selected fields, and you can also adjust how the date and time are displayed.

Core capabilities include:

Create a Last Modified Time Field to add an automatic update column to a data table.
Set the update scope so the timestamp changes after edits in any field or only in selected fields.
Change the date format with multiple display styles and an optional time display.

This feature works well for change tracking, task follow-up, record review, and data auditing. The timestamp is generated automatically and cannot be edited manually.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office for Mac normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	Local table editing does not require a constant connection; sign-in, sync, or collaboration scenarios work better with network access
Other	You need access to a Smart Table data table and permission to edit field settings

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office for Mac, open a Smart Table data table, and confirm that the add-field entry is available on the right side of the header

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports a Last Modified Time Field in a data table to automatically record the latest edit time for each record. You can set updates to trigger from all fields or only selected fields, and you can choose different date formats.	Microsoft Lists includes built-in metadata such as Modified, and Microsoft Support explains that created and modified date metadata can be shown from hidden auto-generated columns.	Google Sheets lets you check Last edit, version history, and cell edit history. The official workflow focuses on file-level or cell-level change review rather than a native row-level last-modified field.	Notion databases include a Last edited time property that records the timestamp of an item's last edit automatically and is not editable manually.	Adobe Acrobat provides document properties and metadata, including modified information for PDF files, but it does not provide a row-level field for structured data tables.
WPS Advantages	Advantage: WPS provides a row-level last modified field directly inside a data table, supports selected-field update triggers, and lets you unify the display format in one place.	Compared with WPS: Microsoft focuses on built-in metadata display in lists, and the official page does not describe selected-field trigger settings for the modified timestamp.	Compared with WPS: Google focuses on version history and edit-history review, not a native data-table field configuration for each record.	Compared with WPS: Notion auto-updates the last edited timestamp, but the official page does not describe selected-field trigger control for update scope.	Compared with WPS: Adobe focuses on document-level PDF metadata rather than structured record-level timestamp fields.
Official Source	—	List and library column types and options	Find what's changed in a file	Database properties	Document properties and metadata overview in Acrobat

Overall Conclusion

WPS is a practical fit when you want record-level tracking directly inside a structured data table. If your workflow depends on controlling which fields trigger timestamp updates and keeping one consistent display format, WPS offers a more direct setup for this scenario.

Use Cases

No.	Scenario	Suitable for	Main issue	How this feature helps
1	Task progress tracking	Project members, team leads	You need to see when a record was updated most recently	Add a Last Modified Time Field to show the latest change time for each task
2	Audit trail review	Operations teams, reviewers	It is hard to tell whether a record was changed recently	Add the field to the view and sort by time to review recent changes
3	Selected-field monitoring	Table admins, business owners	You only want key fields to trigger timestamp updates	Set the update scope to selected fields to reduce unrelated changes
4	Consistent time display	Data maintainers	Team members may read timestamps in different formats	Use field settings to apply one date format and optionally show time
5	Periodic record review	Finance, admin, sales support	You need to identify records that have not been updated for a while	Filter older timestamps in the Last Modified Time Field and schedule follow-up reviews

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Create and configure the Last Modified Time Field	✅ Available	✅ Available
Basic spreadsheet and data-table editing	✅ Available	✅ Available
More PDF tools, templates, cloud storage, and advanced benefits	Depends on the current account benefits	Includes broader advanced benefits and storage support

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Daily record tracking and basic data maintenance	Free	The Last Modified Time Field itself has no membership restriction and is enough for basic use
Broader cloud storage, templates, or additional office benefits	WPS Premium	Suitable if you also need more extended office benefits beyond this field

WPS membership center: Subscribe now