WPS Numbering Fields is an automatic numbering feature for smart 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
Numbering Fields is a field type in WPS smart tables that automatically generates a number for each record and supports different numbering rules and display formats.
Core tasks include:
- Create a numbering field: Add a Numbering field to a data table for task IDs, ticket numbers, and other records that need continuous identifiers.
- Configure the numbering type: Choose either auto-increment numbers or custom concatenation in field settings to match business naming rules.
This feature fits task tracking, work order management, record archiving, and post-import data cleanup. With numbering fields, records are easier to filter, group, and locate.
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 | No mandatory network connection is required for local field creation and setup; keep a connection available for sign-in, sync, or collaboration |
| Other | You need to work in a smart table data sheet and have permission to edit fields |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, then open a smart table data sheet and confirm that Add Field and Field Settings are available |
Source: WPS download center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Numbering Fields can automatically generate a record number for each entry and support both auto-increment numbers and custom concatenation. | Microsoft Lists includes an automatic ID column with incremental values; the public page does not describe a native rule in the same column for combining the number with text or dates. | Google Sheets can create number series with autofill, which works for continuous numbering in spreadsheets; users often extend the series manually or with formulas. | Notion databases provide an ID property that automatically creates a numerical ID for each item, and the ID cannot be changed manually. | Adobe Acrobat tutorials focus on calculations, submit buttons, and form field setup rather than a native table-style numbering field for data records. |
| WPS Advantages | Advantage: WPS provides numbering-type settings directly at the field level, so teams can use automatic increments or custom concatenation in one field workflow. | Compared with WPS: It is more focused on showing a system-generated ID, with less field-level numbering format control described on the official page. | Compared with WPS: It can produce continuous numbering, but it relies more on autofill or formulas than on a dedicated field type. | Compared with WPS: It can generate a numerical ID automatically, but it offers less flexibility for numbering format customization. | Compared with WPS: It is better aligned with PDF form handling than with structured data-table field management. |
| Official Source | — | Microsoft Lists automatic ID column | Automatically create a series or list | Notion database properties | Advanced form fields in Acrobat |
Overall Conclusion
WPS Numbering Fields is more closely aligned with structured data-table management because it combines automatic numbering with field-level numbering type settings. For teams that maintain task IDs, ticket numbers, or business serial numbers over time, this field-based setup is easier to manage consistently.
Use Cases
| No. | Scenario | Suitable For | Main Challenge | How Numbering Fields Help |
|---|---|---|---|---|
| 1 | Task ID management | Project members | Manual numbering can become repetitive or inconsistent | Create a numbering field so each task gets an automatic identifier |
| 2 | Work order tracking | Operations and support teams | Work orders need a consistent number for search and follow-up | Use a numbering field to generate continuous work order numbers |
| 3 | Record archiving | Administrative and finance teams | Exported or filtered records need a stable identifier | Keep records in clear order with auto-increment numbers |
| 4 | Custom business codes | Team administrators | Pure numeric IDs may not be descriptive enough | Use custom concatenation in field settings |
| 5 | Post-import cleanup | Data maintenance staff | Imported Excel data may need a unified numbering column | Add a numbering field and adjust the numbering type as needed |
Membership & Benefits
Free vs WPS Premium
| Capability | Free Users | WPS Premium |
|---|---|---|
| Create and use numbering fields | ✅ Available | ✅ Available |
| Core office components | ✅ Available | ✅ Available |
| More advanced PDF, template, and extended tools | Some features are limited | ✅ More advanced tools are available |
| Cloud storage and multi-user sharing benefits | Basic quota | ✅ Higher quota or broader benefits |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| Daily numbering in data tables and light record management | Free | Numbering Fields itself has no membership restriction and supports basic numbering needs |
| Broader advanced office features, templates, or extended services | WPS Premium | Suitable for users who also need more advanced features and added benefits |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page