WPS Numbering Fields on Windows: Introduction

WPS Numbering Fields is an automatic record-numbering feature in WPS Bitable; this guide covers 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
Version limits	None stated	Use the feature in the currently available version

About This Feature

Overview

Numbering Fields is a field type in WPS Bitable that automatically generates a number for each record. If you are looking for how to create automatic record numbering in WPS on Windows, this feature lets you add a numbering field and set the numbering rule for task IDs, ticket numbers, and record tracking.

Core capabilities include:

Create a numbering field: Add a field with the Numbering type from the table header.
Configure the numbering type: Choose auto-increment numbers or custom concatenation in field settings.

This feature fits structured data management scenarios where you need consistent record identifiers, less manual entry, and easier tracking.

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 or cloud collaboration
Other	You need access to Bitable and permission to edit fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter Bitable, and confirm that you can see the Numbering field type in the field list

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Numbering Fields in WPS Bitable can automatically generate a number for each record and support auto-increment numbers or custom concatenation.	Microsoft Lists includes an automatic incremental ID column for list items, but the cited page does not describe the same level of configurable concatenation rules.	Google Sheets can continue a number series with autofill, which works for sequential numbering in spreadsheets, but it mainly depends on fill actions or formulas.	Notion databases include an ID property that automatically creates a numerical ID for each item and can include a prefix.	Adobe Acrobat form fields support calculated values and scripts, but the official page focuses on calculation settings rather than a native record-numbering field.
WPS Advantages	Advantage: WPS provides numbering setup directly at the field level, including both auto-increment numbers and custom concatenation for structured record management.	Compared with WPS: the automatic ID is more like a built-in system column, with less public detail about configurable numbering formats on the cited page.	Compared with WPS: number series can be created, but the workflow is better suited to general spreadsheet filling than a dedicated record-numbering field.	Compared with WPS: the ID property can generate numbers and prefixes, but the workflow is centered on database properties.	Compared with WPS: Acrobat is better suited to PDF form calculations, and numbering often depends on extra calculation or script setup.
Official Source	—	Microsoft Lists auto ID	Google Sheets number series	Notion database ID property	Acrobat calculated form fields

Overall Conclusion
If you want to create a numbering field directly in a structured table and adjust how the number is generated, WPS offers a more focused setup path. Other products can handle similar tasks through spreadsheet filling, database properties, or PDF form calculations, but their workflows and use cases differ.

Use Cases

No.	Scenario	Suitable for	Main challenge	How Numbering Fields help
1	Task list numbering	Project members	Manual task IDs can be duplicated	Create a numbering field and use auto-increment numbers
2	Ticket tracking	Operations and support teams	Tickets need consistent IDs for lookup	Assign a number automatically to each record
3	Business IDs with prefixes	Admin and business teams	IDs need fixed text or date information	Use custom concatenation in field settings
4	Post-import field cleanup	Data maintainers	Imported data may not use the right field type	Add a numbering field and reorganize record identifiers
5	Grouping and filtering records	Table collaborators	Large record sets are harder to locate quickly	Use numbering fields together with filters and groups

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Writer, Spreadsheet, and Presentation core apps	✅	✅
Create and configure Numbering Fields	✅	✅
Some advanced features such as advanced PDF editing	Limited in some areas	✅ More advanced features
Cloud storage and some value-added services	Basic quota	Higher quota or more benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday table records and basic numbering management	Free	Numbering Fields themselves are available without membership for regular data management
You also need more PDF tools, cloud storage, or added office features	WPS Premium	A better fit when your workflow depends on broader advanced office features

Membership page: Subscribe to WPS Premium