WPS Bidirectional Linked Field on macOS: Introduction

WPS Bidirectional Linked Field is a multi-table relation feature in WPS on macOS; 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
Version limit	None stated	No version gate is described for this feature
Membership limit	None stated	The feature can be used directly in the current workflow

About This Feature

Overview

Bidirectional Linked Field is a database-style field in WPS that creates a two-way relationship between the current table and a target table, while generating linked fields in both tables at the same time. It is useful when you need linked records to stay visible from both sides and when you want to continue working with lookup references or summary fields after the relationship is created.

Core tasks include:

Create a bidirectional linked field: add the field from the table header.
Link all records: allow the field to connect to all records and optionally allow multiple linked records.
Link selected records: limit the available records by condition or by a specified view.

This workflow is helpful for project tracking, customer-order mapping, and other linked data scenarios in WPS on macOS.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office normally
App version	It is recommended to use the latest WPS Office for Mac
Network	No mandatory network connection is required for local field setup; sign-in, sync, and collaboration work more smoothly with network access
Other	You need access to the target table and enough permission to view or edit related records

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office for Mac, enter a table workspace, and confirm that the plus button and field type options are available near the table header

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Creates a two-way relationship between the current table and a target table, and generates linked fields in both tables. It also supports linking all records or selected records, with an option to allow multiple linked records.	Microsoft Lists uses Lookup columns to create list relationships between a source list and a target list, and can display additional source-list columns in the target list. The official page focuses on lookup-based list relationships rather than a field created as a two-way linked pair at setup time.	Google officially documents table relationships, lookup columns, and relationship filters in Google Tables. It can link data across tables and update linked rows automatically, but this is documented in Tables rather than as a native bidirectional field inside the standard Google Sheets grid.	Notion relation properties connect databases and support two-way relations when the corresponding relation is shown in the destination database, so edits can appear on both sides.	Adobe Acrobat documents form field properties and PDF form customization, but the official help page does not describe a cross-table bidirectional linked-record field.
WPS Advantages	Advantage: WPS creates the linked field on both sides during setup. Distinct: it combines all-record and selected-record range controls with an option to allow multiple linked records.	Compared with WPS: Microsoft supports list relationships and extra lookup columns, but the official workflow is centered on lookup columns and related lists instead of a paired bidirectional field created in one step.	Compared with WPS: Google can link tables and update related rows, but the documented capability belongs to Google Tables and follows a different product path from field setup in a WPS table.	Compared with WPS: Notion also supports two-way relations; WPS keeps field creation and record-range settings together in the table header and field settings flow.	Compared with WPS: Adobe focuses on PDF form fields rather than relational records across tables.
Official Source	—	Create list relationships by using lookup columns	How to use table relationships	Relations & rollups	Field properties for form components in Acrobat

Overall Conclusion
For linked-record work inside a WPS table, Bidirectional Linked Field fits a direct field-setup workflow on macOS. Notion is also strong for two-way database relations, while Microsoft and Google document adjacent list or table relationship models, and Adobe Acrobat is aimed at PDF form fields instead of relational table structures.

Use Cases

No.	Scenario	Suitable users	Main challenge	How this feature helps
1	Link projects and tasks	Project managers and teams	Project records and task records are stored in different tables	Create a bidirectional linked field so both tables can show related records
2	Connect customers and orders	Sales and operations teams	Order records need customer context, and customer records need order history	Link the customer table and order table with a two-way field
3	Limit available linked records	Data managers	Only records that match a condition or a view should be selectable	Use the selected-record setting to limit the available range
4	Maintain one-to-many relationships	Content and admin teams	One record may need to connect to several downstream records	Turn on the option to allow multiple linked records
5	Continue with lookup and summary analysis	Analysts and coordinators	Linked data often needs follow-up reference and aggregation	Combine the linked field with lookup references and summary fields

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic use of Bidirectional Linked Field	Available	Available
Basic PDF features	Available	Available
Advanced PDF editing and conversion	Limited or provided as listed on the pricing page	More advanced capabilities are available
Cloud storage and added services	Basic quota	Higher quota and more added services

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You mainly use bidirectional linked fields for daily table management	Free plan	The current feature workflow does not show a membership requirement
You also need broader PDF, cloud, or added office capabilities	WPS Premium	A better fit for users who need more advanced office features beyond this field setup

WPS membership page: Subscribe now