WPS Bidirectional Linked Field is a two-way linked field capability in WPS 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 limits | None stated | Use the feature when the entry is available in your current client |
About This Feature
Overview
Bidirectional Linked Field creates a two-way relationship between the current table and a target table, and it generates linked fields in both tables at the same time. It is useful when you need two-way references and mutual visibility across related records.
Core capabilities include:
- Create a bidirectional linked field from the table header.
- Link all records by setting the available record range to all records.
- Link specific records by limiting the range with conditions or a selected view.
This feature fits project tracking, customer record management, asset logs, and other cross-table workflows where related records need to stay visible from both sides.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest WPS Office version so the WPS Tables entry is available |
| Network | A stable internet connection is recommended when opening online tables, syncing data, or loading linked records |
| Other | You need an editable table file and permission to change field settings |
Download & Installation
Before using Bidirectional Linked Field, install WPS Office for Windows and sign in with an account that can access WPS Tables.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Open WPS Office, enter a table, and confirm that the add-field entry is visible on the right side of the header |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Creates a two-way linked field in WPS Tables, generates linked fields in both the current and target tables, and supports all-record or specific-record ranges. | Microsoft Lists provides lookup columns to pull information from another list, with official guidance focused more on list lookups and list relationships. | Google Sheets focuses on cell references, ranges, and formulas across sheets, rather than a native record-level two-way field generated in both tables. | Notion databases support Relation properties that connect two databases and let users view related records from both sides. | Adobe Acrobat focuses on PDF forms and document workflows, and its official materials do not describe an equivalent native table relationship feature. |
| WPS Advantages | Advantage: WPS can create the two-way relationship during field creation and offers both all-record and specific-record range settings. | Compared with WPS: official guidance supports cross-list lookup scenarios, but it does not emphasize a matching workflow that creates peer linked fields on both sides in the same way. | Compared with WPS: better suited to spreadsheet formulas and references; record-level two-way relationships usually require formulas or manual structure design. | Compared with WPS: also supports database relations; WPS documentation here places more emphasis on limiting the available linked record range in field settings. | Compared with WPS: focused on PDF workflows and does not provide the same type of table relationship feature. |
| Official Source | — | Use a lookup column in a list | Create and use named ranges | Relations and rollups | Acrobat desktop help |
Overall Conclusion
WPS Bidirectional Linked Field is a practical fit when you want a direct two-way relationship between records in two tables. Google Sheets is more formula-oriented, while Notion offers a comparable database relation model with a different setup path. Adobe Acrobat serves a different document-focused use case.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How the feature helps |
|---|---|---|---|---|
| 1 | Link tasks with team members | Project managers and teams | Task data and owner data are stored in separate tables | Create a bidirectional linked field between the task table and the member table |
| 2 | Connect customers with follow-up records | Sales and support teams | Customer details and follow-up logs are hard to review from both sides | Use all-record or specific-record linking to view connected data quickly |
| 3 | Manage assets and borrowing logs | Admin and IT teams | Asset records and borrowing records need cross-table visibility | Build a two-way link between the asset table and the borrowing table |
| 4 | Connect orders with shipping records | Operations and warehouse staff | Order status and shipping data are maintained in separate tables | Limit available records with specific-record settings to reduce noise |
| 5 | Connect courses with student records | Training coordinators and educators | Course tables and student tables need mutual lookup | Use a bidirectional linked field so both tables show related records |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Basic use of Bidirectional Linked Field | ✅ Available | ✅ Available |
| Standard table field settings | ✅ Available | ✅ Available |
| Other premium benefits across WPS | Depends on the account plan | Depends on the purchased plan |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Everyday creation and maintenance of bidirectional linked fields | Free | The feature description states that there is no membership restriction for this feature |
| Broader office workflows that also need extra member benefits | WPS Premium | Suitable if you also want access to other premium features or account-level benefits |
How to Subscribe
- WPS membership center: Subscribe to WPS Premium
Source: WPS Office pricing page