WPS Find Reference Field on macOS: Introduction

WPS Find Reference Field on macOS helps you display matching values from another data table through a related 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

About This Feature

Overview

Find Reference Field is a field type in Smart Table data tables on Mac. It lets you use a related field to display matching values from another data table, so linked information can appear across tables without repeated manual entry.

Core tasks include:

Create a Find Reference Field when adding a new field from the table header.
Configure field settings by choosing the related field, target field, and lookup conditions.
Display linked values for scenarios such as order-product summaries and related record display.

This feature is useful when multiple data tables need to reuse connected information while keeping displayed values aligned with related records.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office for Mac
App version	It is recommended to use the latest version of WPS Office for Mac
Network	No mandatory network connection is required for local field setup; a connection is recommended for sign-in, sync, or collaboration
Other	You need an editable Smart Table data table and an available related field in the target data table

Source: System requirements for WPS Office

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office for Mac, open a Smart Table data table, and confirm that Find Reference Field appears in the field type list

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In Smart Table, WPS can display field values from another data table through a related field, with field settings for the reference field and lookup conditions.	Microsoft Lists supports Lookup columns that show information from a source list in a target list and can bring in additional columns.	Google Tables supports Lookup columns that show information from linked rows in another table and can reuse one relationship for more fields.	Notion uses Relation and Rollup properties to connect databases and display related properties across databases.	Adobe Acrobat focuses on collecting, importing, and exporting PDF form data rather than cross-table reference fields in a table workflow.
WPS Advantages	Advantage: WPS keeps field creation and field configuration in one table workflow, which is convenient for building cross-table display fields directly from the current table.	Compared with WPS: Microsoft Lists provides lookup columns in a list-management workflow.	Compared with WPS: Google Tables provides lookup columns through relationship configuration.	Compared with WPS: Notion emphasizes database relations and rollups for broader database organization and aggregation.	Compared with WPS: Adobe Acrobat is oriented to PDF form data workflows instead of the same kind of table field setup.
Official Source	—	Create list relationships by using lookup columns	How to use Lookup columns	Relations & rollups	Collect and manage PDF form data

Overall Conclusion
If your main goal is to show related values across Smart Table data tables during daily data maintenance, WPS Find Reference Field fits a direct field-creation workflow on Mac. Other products also provide related or lookup-style capabilities, but their focus is more on list management, database organization, or PDF form processing.

Use Cases

No.	Scenario	Suitable For	Main Challenge	How It Helps
1	Order and product information linking	Operations teams, sales support	Order tables require repeated product entry	Use Find Reference Field to display product fields from a product table
2	Customer and contact synchronization	Customer management teams	Contact details across tables can become inconsistent	Use a related field to display target fields from a contact table
3	Project and member information display	Project collaboration teams	Project tables need member details from another table	Add a Find Reference Field to show member information
4	Asset and category summary	Admin and IT teams	Asset records need category information from another table	Use Find Reference Field to bring in category fields automatically
5	Related record display	General data maintenance users	It takes time to open related tables repeatedly	Show key fields from the related table directly in the current table

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Writer, Spreadsheet, and Presentation core components	✅	✅
Basic use of Find Reference Field	✅	✅
Advanced PDF editing and some advanced tools	Limited or feature-dependent	✅ More advanced capabilities available
Cloud storage and some value-added services	Basic quota	Higher quota and more value-added services

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

Recommendations

Scenario	Recommended Plan	Why
You only need to create and configure Find Reference Field in Smart Table	Free	The feature information shows no membership restriction for this workflow
You also need more PDF tools, advanced tools, or more cloud storage	WPS Premium	Suitable for users who need broader office capabilities

WPS membership center: Subscribe now

Source: WPS Office pricing page