WPS One-Way Linked Fields on Windows: Introduction

WPS One-Way Linked Fields is a multidimensional table field feature for creating one-way links between the current table and another table; 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
Version limit	No version limit	This field feature can be used directly

About This Feature

Overview

One-Way Linked Fields is a field feature in WPS Office for Windows multidimensional tables. It is used to create a one-way reference between the current table and another table so you can select and match records across tables.

Core capabilities:

Create a one-way linked field: Add a field that links to the current table or another table from the table header.
Link records manually: Choose a target table in field settings and select linked records in cells.
Match linked records automatically: Set matching conditions so eligible records are linked automatically.

Common scenarios include linking orders to product records, linking tasks to project records, and managing cross-table collaboration data. This feature helps reduce repeated entry and keeps cross-table references clearer. A practical advantage is that the same field can be configured for manual linking or automatic matching, and its settings can still be adjusted after creation.

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 field setup can be completed directly; if you need to sync online tables, keep the network connection stable
Other	You need access to multidimensional tables and edit permission for the current table

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, then open a multidimensional table and confirm that the add-field entry is visible on the right side of the header

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports creating one-way linked fields in multidimensional tables, linking to the current table or another table, with both manual linking and automatic matching.	Microsoft Lists supports lookup relationships between lists so one list can reference information from another list.	Google Sheets focuses on spreadsheet collaboration, analysis, and automation, and its official product page does not emphasize a native relational field model.	Notion databases support the Relation property, which links pages in one database to pages in another database.	Adobe Acrobat focuses on PDF viewing, editing, and signing rather than native linked-field capabilities for multidimensional tables.
WPS Advantages	Advantage: WPS combines field creation, manual linking, and automatic matching in one field setup flow for cross-table reference work.	Compared with WPS: cross-list reference is available, but the product is positioned more around list management and provides less direct emphasis on field-level automatic matching on the cited page.	Compared with WPS: better suited to general spreadsheet work; field-level relationship scenarios often rely on formulas or external workflows.	Compared with WPS: offers database relations, but its structure is more oriented to knowledge management and connected pages.	Compared with WPS: centered on PDF document workflows rather than multidimensional table relationships.
Official Source	—	Microsoft Lists product page	Google Sheets product page	Notion relations and rollups	Adobe Acrobat product page

Overall Conclusion
WPS One-Way Linked Fields is a closer fit for cross-table reference work inside multidimensional tables when you want to configure linking directly at the field level. Notion offers a comparable database relation model, while Google Sheets and Adobe Acrobat are oriented more toward spreadsheet processing or document workflows.

Use Cases

No.	Scenario	Suitable for	Main pain point	How this feature helps
1	Link orders to product records	Sales and operations teams	Order data and product data are stored in different tables	Create a one-way linked field and reference records from the product table
2	Link tasks to a project register	Project managers and contributors	It is hard to connect task rows to the main project record quickly	Use manual linking to select the target project record
3	Match business records automatically	Data maintenance staff	Linking large numbers of records one by one takes time	Set automatic matching conditions to complete linking
4	Create a unified cross-table reference entry	Team collaborators	Similar information is entered repeatedly and can become inconsistent	Reference target-table data directly from the current table through a linked field
5	Adjust field rules later	Table administrators	Existing linking rules may no longer fit after business changes	Update the linked range, record count, and matching conditions in field settings

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Create one-way linked fields	✅ Available	✅ Available
Link records manually	✅ Available	✅ Available
Match linked records automatically	✅ Available	✅ Available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Daily cross-table reference and basic collaboration	Free	This feature has no membership restriction, so you can create fields and configure links directly
You also need broader premium office benefits	WPS Premium	Suitable if you want this feature together with other premium benefits

WPS membership center: Subscribe now