WPS Bidirectional Linked Field on macOS: Introduction

WPS Bidirectional Linked Field on macOS helps you create two-way links between the current table and a target table; 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 threshold is listed for this feature

About This Feature

Overview

Bidirectional Linked Field is a field type in WPS smart tables that creates a two-way relationship between the current table and a target table, so related records can be viewed and referenced from both sides.

Core tasks include:

Create a bidirectional linked field to add a new relationship field from the table header.
Link all records so users can choose from the full set of records in the target table.
Link specific records so the selectable range can be limited by conditions or a selected view.

This feature fits workflows such as project tracking, customer and order mapping, and task-to-resource relationships. It can also work together with lookup reference fields and summary fields for follow-up analysis.

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 requirement for local editing; keep a network connection when online sync or account-related features are involved
Other	You need access to an editable smart table and permission to change field settings

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office for Mac, open a smart table, and confirm that the field creation entry is available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Creates a two-way linked field between the current table and a target table, with options for all records or a limited record range.	Microsoft Lists uses Lookup columns to show source-list information in a target list and can display multiple source columns.	Google Sheets tables provide structure, column types, table references, and views, but the official page does not describe an equivalent two-way linked field.	Notion databases support Relation properties and can enable two-way relations between databases.	Adobe Acrobat focuses on PDF form field properties and form input management rather than relational table links.
WPS Advantages	Advantage: built for two-way table relationships directly inside the data table workflow. Distinct: supports both all-record and limited-record range settings in the same feature path.	Compared with WPS: focuses more on lookup relationships and showing source-list data in another list.	Compared with WPS: focuses more on structured tables and table references, without an equivalent two-way linked field in the cited page.	Compared with WPS: also supports two-way relationships, but the setup is centered on database relation properties.	Compared with WPS: does not provide an equivalent table relationship field in the cited Acrobat form workflow.
Official Source	—	Create list relationships by using lookup columns	Use tables in Google Sheets	Relations & rollups	Field properties for form components in Acrobat

Overall Conclusion
If your workflow depends on linking records across tables and controlling the selectable range in one place, WPS provides a direct setup path. Microsoft Lists and Notion both support related data workflows, but their official feature descriptions focus more on lookup lists and database relations. Google Sheets and Adobe Acrobat, based on the cited pages, focus on different table or form scenarios.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Customer and order linking	Sales teams, operations teams	Need to view customer records and order records from both tables	Create a bidirectional linked field to connect customer and order tables
2	Project and task linking	Project managers, team members	Tasks are scattered and hard to trace back to the parent project	Use all-record or limited-record linking to connect tasks with projects
3	Resource and request linking	Admin teams, procurement teams	Need to limit selectable records and reduce incorrect links	Use specific-record linking with conditions or a selected view
4	Follow-up data analysis	Data coordinators	Linked data often needs further reference or summary work	Combine the linked field with lookup reference fields and summary fields

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 AI features	May be limited	Usually includes broader access or higher usage allowances
Cloud storage and multi-user sharing benefits	Basic allocation	Higher allocation or expanded benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You mainly use smart tables for everyday linked data work	Free plan	The current feature description shows no membership restriction for this feature
You also need more PDF, AI, or expanded cloud benefits	WPS Premium	Better suited to users who need broader suite benefits beyond this table feature

Subscribe here: Get WPS Premium