WPS One-Way Linked Fields on Windows: Introduction

WPS One-Way Linked Fields help you create one-way relationships between the current data table and other data tables, with 3 core tasks in total, 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	None	Available directly from the current feature entry

About This Feature

Overview

One-Way Linked Fields are a field feature in WPS Office on Windows for smart spreadsheet data tables. They are used to create a one-way reference relationship between the current data table and another table. This is useful for orders, tasks, projects, products, and other workflows that need cross-table references.

Core capabilities include:

Create a linked field: Add either Link This Table Field or Link Other Table Field from the header area.
Set up manual one-way linking: Choose a target data table, define the record range, and decide whether multiple linked records are allowed.
Set up automatic matching: Link records automatically based on matching conditions.

This helps reduce repeated data entry and keeps cross-table references clear while preserving independent management of the current table.

System Requirements

Item	Requirement
Operating system	A Windows device in a currently supported environment
App version	The latest version of WPS Office is recommended
Network	No mandatory connection for local editing; keep a network connection available when online tables or sync are involved
Other	You should be able to open smart spreadsheet data tables normally and have permission to view or edit the related tables

Source: System Requirements for WPS Office

Download & Installation

Before using One-Way Linked Fields, install the WPS Office desktop app for Windows and confirm that you can open smart spreadsheets or related data tables normally.

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a smart spreadsheet data table, and confirm that you can create a linked field from the header area

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports one-way linked fields in the current data table, including linking to the same table or another table, with both manual linking and automatic matching.	Microsoft Lists supports Lookup columns that show source-list information in a target list and can display multiple source columns.	Google Sheets supports tables and table references, mainly through structured references and formulas rather than a dedicated linked-field setup flow.	Notion databases support Relation properties to connect databases, and relations are created as one-way by default.	Adobe Acrobat focuses on collecting, importing, and exporting PDF form data rather than table-style linked fields across data tables.
WPS Advantages	Advantage: WPS provides both manual linking and automatic matching in the same field setup flow for direct cross-table reference work.	Compared with WPS: Microsoft focuses more on lookup-column display from a source list, with less emphasis on a matching-condition workflow in the cited page.	Compared with WPS: Google relies more on formulas and table-reference syntax instead of a dedicated linked-field configuration flow.	Compared with WPS: Notion relation setup is clear, but showing the relation on both sides usually requires turning on the corresponding relation.	Compared with WPS: Adobe centers on PDF form data handling rather than spreadsheet-style field relationships.
Official Source	—	Create list relationships by using lookup columns	Use table references in Google Sheets	Relations & rollups	Collect and manage PDF form data

Overall Conclusion
If your main goal is to reference records across data tables and configure the relationship from the field itself, WPS One-Way Linked Fields fit that workflow directly. Microsoft and Notion also support cross-table relationships, but they are presented more as list relationships or database relations, while Adobe’s official workflow is centered on PDF form data.

Use Cases

No.	Scenario	Suitable For	Main Pain Point	Solution
1	Reference product information in an order table	Sales teams, operations teams	Product names and specifications are entered repeatedly in order records	Create a linked field and connect it to the product table
2	Link tasks to project records	Project managers, execution teams	Task records and project records are separated and hard to track together	Use manual one-way linking to connect tasks to the project table
3	Match customer records automatically	Service teams, business teams	New records require repeated customer lookups	Use automatic matching conditions to complete the link
4	Reference records inside the same table	Data coordinators	Different records in one table need structured references	Create a Link This Table Field to manage internal references
5	Manage multiple linked records	Purchasing teams, warehouse teams	One record may need to connect to multiple source records	Allow multiple linked records in field settings

Membership & Benefits

Free vs WPS Premium

The feature description shows that One-Way Linked Fields do not require membership. WPS membership is generally used for broader PDF, template, AI, and extended office capabilities. Check the official pages for the latest plan details.

Capability	Free Users	WPS Premium
Basic use of One-Way Linked Fields	✅ Available	✅ Available
Core Writer / Spreadsheet / Presentation apps	✅ Available	✅ Available
Some advanced PDF, AI, and extended tools	Partially limited	Broader access available
Cloud storage and multi-user sharing options	Basic allocation	Higher allocation or more plan options

Source: Why do I need to pay for WPS Office?

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Why
You only need One-Way Linked Fields and everyday spreadsheet collaboration	Free plan	This feature is available directly without a membership requirement
You also need broader PDF, AI, or extended office tools	WPS Premium	Suitable when you want a wider set of office capabilities in one subscription
Your team needs shared subscription access	Sharing plan	Suitable for multi-user collaboration and centralized management

Membership page: Subscribe to WPS Premium