WPS Find Reference Field on macOS: Introduction

WPS Find Reference Field on macOS helps you pull target values from related tables through a linked field; this guide covers 2 core tasks, with 2 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	2	Matches the number of rows in the How-to Index
Available without membership	2	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	Use the current feature entry on macOS

About This Feature

Overview

Find Reference Field is a field type in WPS multi-dimensional tables on macOS. It lets you use a related field to pull matching values from another table, so cross-table information can stay visible in the current table.

Core capabilities include:

Create a Find Reference Field from the add-field entry in the table header.
Configure field settings by choosing the related field, target field, and lookup conditions.

This feature fits scenarios such as order and product linking, customer information display, and project record coordination.

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	An internet connection is recommended when opening online multi-dimensional tables and syncing data
Other	You need access to the target table and permission to edit fields

Source: WPS system requirements

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download WPS Office for Mac, complete setup, and sign in to your account
Check after installation	Open a multi-dimensional table, click the plus button on the right side of the header, and confirm that Find Reference Field is available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Pulls target field values from a related table through a linked field, with field settings for the referenced field and lookup conditions.	Microsoft Lists uses Lookup columns to show source list information in a target list and can display multiple source columns.	Google Sheets can reference data from another sheet or use IMPORTRANGE to pull ranges from another spreadsheet.	Notion databases use Relation to connect databases and Rollup to pull or aggregate related properties.	Adobe Acrobat supports calculated PDF form fields, which fit form workflows rather than table-based reference fields.
WPS Advantages	Advantage: Cross-table reference setup is handled directly at the field level in a multi-dimensional table. Distinct: The create-field entry and field settings are close together for ongoing maintenance.	Compared with WPS: More focused on list relationships and displayed columns in Microsoft Lists.	Compared with WPS: Often depends on formulas or import functions instead of a field-level relationship setup.	Compared with WPS: Relation and rollup modeling is flexible, but the setup path is more database-oriented.	Compared with WPS: This is a PDF form calculation workflow, not the same type of table reference field.
Official Source	—	Create list relationships by using lookup columns	Reference data from other sheets	Relations & rollups	Configure form field calculations in Acrobat

Overall Conclusion
WPS Find Reference Field is a practical fit when you want to build cross-table field linkage directly inside a multi-dimensional table on macOS. If your work is centered on list relationships, formula-based references, or database modeling, Microsoft, Google, or Notion may also fit specific workflows.

Use Cases

No.	Scenario	Suitable for	Main issue	How this feature helps
1	Link orders with product details	Sales teams, operations teams	Order tables may require repeated product entry	Pull target fields from a product table with a Find Reference Field
2	Show synced customer details	Support teams, sales support	Business tables can drift from the main customer table	Reference contact or status fields from a customer table
3	Coordinate project tasks	Project managers, collaborators	Task tables need key project attributes nearby	Show owner or stage fields from a related project table
4	Map assets to categories	Admin teams, IT teams	Asset records need standardized category details	Display category attributes through a reference field
5	Prepare data before summaries	Data coordinators	Cross-table information is scattered before reporting	Build a related field first, then use Find Reference Field to complete display columns

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Writer, Spreadsheet, and Presentation basics	Available	Available
Basic use of Find Reference Field	Available on this feature page with no membership limit shown	Available
Advanced PDF editing and broader advanced services	May vary by feature	More advanced capabilities are typically included
Cloud space and template benefits	Basic allocation	Higher allocation or more benefits

Source: WPS Office pricing page

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

Recommendations

Usage scenario	Recommended plan	Why
Daily use of multi-dimensional tables with Find Reference Field	Free version	The current feature shows no membership limit for basic setup and use
Need more PDF, template, cloud, or broader office benefits	WPS Premium	Better suited for users who want expanded office benefits

Membership page: Subscribe to WPS Premium