WPS One-Way Linked Fields on macOS: Introduction

WPS One-Way Linked Fields is a linked-record feature in multidimensional tables; this guide covers 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

About This Feature

Overview

One-Way Linked Fields is a field type in WPS Office for Mac multidimensional tables. It lets you create a one-way relationship between the current table and the same table or another table. After setup, you can reference records from the target table in the current table. This is useful for scenarios such as linking orders to product records, linking tasks to project records, or linking business records to a master data table.

Core capabilities include:

Create a linked field: add a field for linking to the current table or another table from the header area.
Manually link records: choose the target table, record scope, and whether multiple records are allowed.
Auto-match linked records: create links automatically based on matching conditions.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office normally
App version	The latest version of WPS Office for Mac is recommended
Network	A stable internet connection is recommended for online tables, syncing, and cross-table collaboration
Other	You need access to the target multidimensional table and the required viewing or editing permissions

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download the Mac installer and complete the setup as prompted
Post-install check	Open WPS, enter a multidimensional table, and confirm that linked field options are available when adding a field

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports one-way linked fields in multidimensional tables, including links to the same table or another table, with both manual linking and auto-matching.	Microsoft Lists uses Lookup columns to show source-list information in a target list and can display additional source columns.	Google Sheets supports cross-sheet and cross-file references through IMPORTRANGE and table references, but not a native relational field for this workflow.	Notion database Relation properties are created as one-way by default and can be turned into two-way relations when needed.	Adobe Acrobat focuses on collecting, importing, exporting, and merging PDF form data rather than relational table fields.
WPS Advantages	Advantage: combines field creation, manual linking, and auto-matching in one multidimensional table workflow. Distinct: suitable for maintaining business record references directly inside a working table.	Compared with WPS: focuses more on lookup-column configuration and displaying extra source columns.	Compared with WPS: relies more on formulas, references, and access authorization steps.	Compared with WPS: offers stronger database relation modeling, but the workflow is centered on database pages.	Compared with WPS: focuses on PDF form data handling rather than a comparable table-linking field.
Official Source	—	Create list relationships by using lookup columns	IMPORTRANGE	Relations & rollups	Collect and manage PDF form data

Overall Conclusion
If your main goal is to build one-way record references directly inside a multidimensional table, WPS keeps the setup path more concentrated. If your team already depends on database-style relations or formula-based cross-sheet references, Notion or Google Sheets may fit those workflows better.

Use Cases

No.	Scenario	Suitable For	Main Challenge	How It Helps
1	Link orders to product records	Sales and operations teams	Product details are entered repeatedly in order tables	Link to records in a product table through another-table linked fields
2	Link tasks to a project table	Project managers and contributors	Tasks and projects are separated and hard to review together	Create a one-way link from the task table to the project table
3	Reference a master customer table	Service and implementation teams	Base records are maintained repeatedly and become inconsistent	Use manual linking to select standard records
4	Auto-match records by condition	Data administrators	Selecting records one by one is inefficient at scale	Use auto-matching to create links based on conditions
5	Link records inside the same table	Teams with lightweight process tracking	Records in one table need internal references	Create a linked field that points to the current table

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic use of one-way linked fields	✅ Available	✅ Available
PDF and advanced office tools	Basic tools available	More advanced tools available
Cloud storage and templates	Basic quota	Higher quota and more resources
AI-related features	Some limits apply	More features available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You only need basic linked-field workflows in multidimensional tables	Free	Suitable for everyday collaboration and basic table linking
You also need more PDF tools, templates, cloud storage, or AI features	WPS Premium	Better for frequent office work across multiple feature areas

WPS membership center: Subscribe now