WPS Last Modified Time Field is an automatic timestamp field in multi-dimensional tables on Windows for tracking the latest edit time by row; it includes 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
Last Modified Time Field is a system field in WPS multi-dimensional tables that automatically records the most recent edit time for each row. After you create the field, you can decide whether updates are triggered by all fields or only selected fields, and you can also adjust the date display format for easier review. This setup is useful when you need a last modified timestamp field for table records in WPS on Windows.
Core capabilities include:
- Create a last modified time field for row-based edit tracking.
- Set the update scope to all fields or selected fields.
- Change the date format for a consistent time display.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | Local editing can work normally; keep an internet connection for cloud collaboration or sync |
| Other | You need access to an editable multi-dimensional table or online table |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, open a multi-dimensional table, and confirm that you can add a field from the table header |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In a WPS multi-dimensional table, you can add a Last Modified Time field to automatically record the latest edit time for each row, with update triggers based on all fields or selected fields. | Microsoft Lists includes a built-in Modified column that shows the latest modified date for a list item, and version history can provide more detailed change records. | Google Sheets official documentation describes developer metadata that can be associated with rows, columns, sheets, or a spreadsheet, but it does not present a built-in row-level last modified field for regular spreadsheet use. | Notion databases include a Last edited time property that automatically records the latest edit timestamp and is not manually editable. | Adobe Acrobat mainly provides document-level metadata such as creation time and related properties, rather than a row-level field for table records. |
| WPS Advantages | Advantage: WPS provides a direct table field for row-level tracking and supports both all-field and selected-field update scopes. | Compared with WPS: Microsoft shows the latest modified date through a built-in column, but the public guidance is centered more on the column itself and version history than on configurable field-level trigger scope. | Compared with WPS: Google's official guidance is more API-oriented, so the row-level field experience is less direct than WPS for everyday table management. | Compared with WPS: Notion also auto-updates edit time, but the official help does not show a selected-field trigger setting like the one available in WPS. | Compared with WPS: Adobe focuses on PDF document properties instead of a table-record field workflow. |
| Official Source | — | Microsoft Lists Modified column | Google Sheets metadata | Notion database properties | Adobe Acrobat document metadata |
Overall Conclusion
If you need a row-level field that directly shows the latest edit time in a table workflow, WPS offers a more direct setup. Notion provides a comparable auto-updated property for database items, while Google and Adobe publish guidance that is more focused on developer metadata or document-level properties.
Use Cases
| No. | Scenario | Suitable for | Main issue | How this feature helps |
|---|---|---|---|---|
| 1 | Task progress tracking | Project members | It is hard to tell when a record was updated last | Add a last modified time field and review update times by row |
| 2 | Data auditing | Operations and managers | Recent changes need to be identified quickly | Filter records by the latest update time |
| 3 | Selected-field monitoring | Form maintainers | Only key fields should trigger a time update | Set the update scope to selected fields |
| 4 | Consistent time display | Team collaborators | Team members read time values in different formats | Standardize the date format in field settings |
| 5 | Lifecycle review | Data administrators | Creation time and later edits need to be separated | Use last modified time together with created time |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Use Last Modified Time Field | ✅ Available | ✅ Available |
| Basic PDF features | ✅ Available | ✅ Available |
| Cloud storage | 1 GB | 20 GB |
| Templates | Limited downloads | More advanced templates and content |
| AI features | Limited access to some features | More AI features and higher usage allowance |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Daily record maintenance and basic table tracking | Free | The Last Modified Time Field itself has no membership restriction and fits routine data management |
| More cloud storage, templates, or AI support | WPS Premium | Suitable when you also need expanded content and broader office capabilities |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page