WPS Creation Time Field is a system timestamp field in WPS Office for Mac databases; 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
Creation Time Field is a built-in field type in WPS Office for Mac databases that automatically records when each record is created. The value is filled in by the system and cannot be edited manually, which makes it useful for approval tracking, ticket history, and activity logs.
Core capabilities include:
- Add a Creation Time Field when creating a new field.
- Change the date and time display format for the whole column.
This feature fits approval records, task tracking, and audit-style logs. It helps reduce manual time entry and keeps record creation times consistent.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Mac device that can run WPS Office for Mac normally |
| App version | The latest version of WPS Office for Mac is recommended |
| Network | No mandatory network connection for local field editing; sign-in, sync, or collaboration features require internet access |
| Other | You need access to a database and permission to edit fields |
Download & Installation
Install WPS Office for Mac before using Creation Time Field, then sign in and open a database.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office → open a database → add a field and confirm that Creation Time appears in the field type list |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS databases can add a Creation Time field that records when each row was created and supports different date-time display formats. | Microsoft Lists includes auto-generated metadata such as Created, which can be shown in list views. | Google Sheets officially documents the NOW() function for current date and time, but it recalculates and does not stay fixed as a row creation timestamp. | Notion databases include a Created time property that stores when each row was created, and the value is read-only. | Adobe Acrobat supports date and time fields in PDF forms with configurable formats, but this is for form input rather than row creation metadata. |
| WPS Advantages | Advantage: WPS offers this as a direct field type in databases and lets you change the display format for the whole column. | Compared with WPS: Microsoft documents system metadata display, but the cited page focuses on showing existing metadata columns rather than the same field-creation flow. | Compared with WPS: Google's official page is about a dynamic time function, not a fixed built-in created-time field for rows. | Compared with WPS: Notion also supports automatic created-time tracking, with an official read-only property for database rows. | Compared with WPS: Adobe focuses on PDF form date fields instead of database record timestamps. |
| Official Source | — | List and library column types and options | NOW | Data source properties | PDF form fields |
Overall Conclusion
For record-level timestamp tracking, WPS and Notion are the closest matches in this comparison. Google Sheets officially highlights a recalculating time function, while Adobe Acrobat focuses on form fields, so WPS is a practical fit for database-style record history on macOS.
Use Cases
| No. | Scenario | Suitable for | Main issue | How this feature helps |
|---|---|---|---|---|
| 1 | Approval tracking | Admin and operations teams | Need to know when each record was created | Add a Creation Time field to record the timestamp automatically |
| 2 | Ticket history | Support teams | Hard to identify when a ticket was opened | Show the creation time in one dedicated field |
| 3 | Activity logs | Project teams | Manual time entry can be missed | Let the system fill in the timestamp |
| 4 | Data review and archiving | Data managers | Need to review records by creation time | Use the field for viewing and sorting |
| 5 | Shared data entry | Collaborative teams | Entry times vary across users | Keep timestamps consistent with a system field |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Writer, Spreadsheet, and Presentation basics | ✅ Available | ✅ Available |
| Basic use of Creation Time Field in databases | ✅ Available | ✅ Available |
| Some advanced PDF, AI, and extended tools | Limited or unavailable depending on the feature | More advanced access is available |
| Cloud storage and template benefits | Basic quota and basic templates | Higher quota or more advanced benefits |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| You only need record creation timestamps in databases | Free | The feature itself has no membership restriction |
| You also need more PDF, AI, or extended office tools | WPS Premium | Better for broader advanced office needs |
How to Subscribe
- WPS membership center: Subscribe to WPS Premium
Source: WPS Office pricing page