WPS Advanced Field Types on Windows: Introduction

WPS Advanced Field Types are advanced field capabilities in multi-dimensional tables for linking tables, pulling related data, and auto-recording key metadata; 6 core tasks are covered, with 6 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	6	Matches the number of rows in the How-to Index
Available without membership	6	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	Available in supported WPS environments that include multi-dimensional tables

About This Feature

Overview

Advanced Field Types are built-in field capabilities in WPS Office for Windows multi-dimensional tables. They are designed for linking business tables, pulling values from related tables, summarizing related data, and automatically recording record IDs, creators, editors, and timestamps.

Key capabilities include:

Relation fields: support two-way and one-way relations between tables.
Lookup fields: pull selected values from a related table to reduce repeated entry.
Statistic fields: summarize related data for quick review.
ID fields: automatically generate record numbers and support custom numbering rules.
People fields: automatically record the creator and last editor.
Time fields: automatically record created time and last edited time.

These capabilities fit scenarios such as project tracking, customer management, order follow-up, asset records, and cross-table data organization.

System Requirements

Item	Requirement
Operating system	A Windows device that can run the current WPS Office desktop app
App version	It is recommended to use the latest version of WPS Office with access to multi-dimensional tables
Network	A network connection is recommended when opening, syncing, or collaborating on tables
Other	Signing in to a WPS account is recommended, and at least two tables are helpful for relation-based workflows

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download the Windows installer and complete setup with the installation wizard
Check after installation	Open WPS Office, enter a multi-dimensional table, and confirm that the Advanced Fields area appears when you add a field

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides two-way relation, one-way relation, lookup, statistic, ID, and auto-record fields such as created by, last edited by, created time, and last edited time inside multi-dimensional tables.	Microsoft Lists supports lookup columns to create list relationships and display source-list information in target lists.	Google Sheets supports in-cell dropdown lists, chip display, and multiple selections for structured entry and status marking.	Notion databases support Relation and Rollup properties, plus Created by, Created time, Last edited by, Last edited time, and ID properties.	Adobe Acrobat focuses on PDF editing, conversion, signing, and document workflows rather than table-based relational field systems.
WPS Advantages	Advantage: WPS combines relation, lookup, summary, and auto-metadata fields in one multi-dimensional table workflow. Distinct: it is suited to cross-table organization and tracking without switching to a separate database product.	Compared with WPS: Microsoft focuses on list relationships and lookup-based display in list workflows.	Compared with WPS: Google focuses more on spreadsheet entry and dropdown selection than on relational field structures with auto metadata.	Compared with WPS: Notion also supports relations and summaries, but its workflow is centered on database pages.	Compared with WPS: Adobe centers on PDF document tasks rather than advanced table field management.
Official Source	—	Create list relationships by using lookup columns	Create an in-cell dropdown list	Database properties	Adobe Acrobat

Overall Conclusion
If your main goal is to manage table relationships, referenced values, and auto-recorded metadata inside a multi-dimensional table, WPS Advanced Field Types are a close fit for that workflow. Other products offer related capabilities, but their emphasis is different across lists, spreadsheets, database pages, or PDF documents.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Customer and order linking	Sales teams, operations teams	Customer and order data are stored in separate tables	Use two-way or one-way relation fields to connect customer and order tables
2	Cross-table value filling	Project managers, data maintainers	The same related values must be entered repeatedly	Use lookup fields to pull selected values from related tables
3	Summary tracking	Managers, analysts	Related records need quick totals or summary results	Use statistic fields to summarize related data
4	Automatic numbering	Admin teams, finance teams, warehouse teams	Manual numbering can become inconsistent or duplicated	Use ID fields to generate record numbers automatically
5	Audit and traceability	Team leads	It is hard to tell who created or edited a record	Use created by, last edited by, created time, and last edited time fields to record changes automatically

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Advanced Field Types	Available	Available
Basic PDF features	Available	Available
Cloud storage	1 GB	20 GB or more depending on plan
Templates	Limited	More advanced templates
AI tools	Limited access for some tools	More AI access with plan-based usage limits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You mainly use Advanced Field Types for daily table management	Free plan	The feature information shows no membership limit for Advanced Field Types
You also need more cloud storage, more templates, or broader AI access	WPS Premium	A paid plan is more suitable for users with higher storage and extended office needs

Membership page: Subscribe to WPS Premium