WPS Bidirectional Linked Field on Windows: Introduction

WPS Bidirectional Linked Field is a relation feature for smart tables; 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	None stated	No version threshold is described for this feature

About This Feature

Overview

Bidirectional Linked Field creates a two-way relation between the current table and a target table, and it generates linked fields on both sides. It is suitable for workflows that need two-way reference and mutual visibility across records.

Core capabilities include:

Create a bidirectional linked field: add a new relation field from the table header.
Link all records: allow the field to connect to the full record range, with an option to allow multiple linked records.
Link specified records: limit the selectable range by conditions or a selected view.

This feature is useful for cross-table information sync, master-detail collaboration, and business tracking scenarios where related records need to be visible from both tables.

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 editing can work normally; for online collaboration or cloud-based tables, keep a network connection available
Other	You need access to open and edit a smart table data sheet

Source: System Requirements for WPS Office

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a smart table data sheet, and confirm that the + button and field type list 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 relation between two data tables and generates linked fields on both sides. It also supports linking all records or specified records, with an option for multiple linked records.	Microsoft Lists uses Lookup columns to show source-list information in a target list and can display additional source columns for list relationships.	Google Sheets uses `IMPORTRANGE` to import ranges from another spreadsheet for cross-sheet reference, but it is not a native two-way relation field.	Notion Relation connects two databases and supports two-way relations so linked items appear in both databases.	Adobe Acrobat focuses on PDF form fields and field properties rather than table-style bidirectional relation fields.
WPS Advantages	Advantage: WPS creates the relation directly at the field level, making it easier to view and maintain linked records from both tables. Distinct: It combines all-record, specified-record, and multi-record settings in the field workflow.	Compared with WPS: the official page focuses more on lookup-based list relationships and displaying source columns than on a field workflow for two-way record management.	Compared with WPS: it focuses on formula-based import and cross-sheet data retrieval, with permission and refresh considerations instead of field-level two-way linking.	Compared with WPS: it also supports two-way relations; WPS places more emphasis here on field creation entry points and selectable record range settings.	Compared with WPS: it is centered on PDF form editing rather than relational data-table linking.
Official Source	—	Create list relationships by using lookup columns	IMPORTRANGE	Relations & rollups	Work with form fields

Overall Conclusion
If your main goal is to build a directly visible two-way relationship between two data tables, WPS provides a field-oriented workflow that fits table management well. If your work is more focused on formula-based imports, database relations, or PDF form editing, the other products cover those adjacent needs in different ways.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Task and owner coordination	Project managers, collaborative teams	Task data and member data are stored separately	Use a bidirectional linked field to view related records from both tables
2	Customer and order tracking	Sales and operations teams	Customer and order tables need mutual lookup	Create linked fields on both sides for direct cross-table tracking
3	Asset and borrowing management	Admin and IT teams	Asset logs and borrowing logs are hard to sync	Control the selectable source with all-record or specified-record settings
4	Course and registration sync	Training and education teams	Duplicate entry across two tables causes inconsistency	Use two-way linking to reduce repeated maintenance
5	Multi-table business records	Data managers	The selectable record range needs control	Use specified records with conditions or a selected view

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	Available	Available
Basic use of Bidirectional Linked Field	Available for this feature based on the current feature description	Available
Some advanced PDF and extended tools	May be limited	Usually includes more available items
Cloud storage and additional value-added features	Basic allocation	Higher allocation or more benefits

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

Recommendations

Scenario	Recommended plan	Why
You only need to create and manage bidirectional linked fields in data tables	Free plan	The current feature description shows no membership restriction for this feature
You also need more PDF tools, cloud storage, or broader office benefits	WPS Premium	Better suited to users with broader cross-component office needs

Subscribe here: Get WPS Premium

Source: WPS Office pricing page