WPS Advanced Field Types on macOS: Introduction

WPS Advanced Field Types is a set of advanced fields in multidimensional tables on macOS; it includes 10 core tasks, with 10 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	10	Matches the number of rows in the How-to Index
Available without membership	10	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	Available in the current macOS experience for multidimensional tables

About This Feature

Overview

Advanced Field Types is an advanced field set in WPS Office multidimensional tables on macOS. It helps you connect tables, pull data from related records, summarize linked data, and automatically record people and time information.

Main capabilities include:

Two-way Link: Build a two-way relationship between two tables for connected data management.
One-way Link: Link the current record to another table for one-sided reference.
Lookup: Pull a specified field from a related table to reduce repeated entry.
Statistics: Summarize related data for quick review.
Auto Number: Generate record numbers automatically with customizable rules.
Created By: Record who created each record automatically.
Last Modified By: Record who last edited the record automatically.
Created Time: Record when the record was created, down to the second.
Last Modified Time: Record the latest update time automatically.
Automation: Run preset actions such as notifications or status updates when conditions are met.

This feature fits project tracking, customer and order management, asset records, workflow follow-up, and cross-table data organization.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	A network connection is recommended for automation, collaboration, or online sync
Other	You need access to multidimensional tables and permission to add fields or edit table structure

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download the Mac installer, complete setup, and sign in to open multidimensional tables
Post-install check	Open a multidimensional table, click the + button to add a field, and check the Advanced Fields section in the field type list

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides Two-way Link, One-way Link, Lookup, Statistics, Auto Number, Created By, Last Modified By, Created Time, Last Modified Time, and Automation in one advanced field area for multidimensional tables.	Microsoft Lists supports lookup columns, date and time columns, person columns, auto-generated modified information, and rules for automation. Related capabilities are spread across lookup columns, calculated columns, and rules.	Google Sheets tables support column types such as numeric, date, dropdown, smart chip, and checkbox. It also supports extracting some metadata from smart chips, with a stronger focus on table column structure.	Notion database properties include Relation, Rollup, Formula, Person, Created time, Created by, Last edited time, Last edited by, Button, and ID for connected data, summaries, metadata, and button-based automation.	Adobe Acrobat mainly supports PDF form fields, date and time fields, and calculated values. It fits form filling and calculations rather than relational table management.
WPS Advantages	Advantage: WPS groups linking, lookup, summaries, numbering, people and time tracking, and automation in one advanced field area for multidimensional tables.	Compared with WPS: similar capabilities are distributed across different column and rule settings and are oriented to list management.	Compared with WPS: Google Sheets emphasizes table column types and smart chips, while native relational field combinations are less centralized.	Compared with WPS: Notion covers a broad set of database properties, but the workflow is centered on the Notion workspace and page-style databases.	Compared with WPS: Adobe is better aligned with PDF forms than with cross-table business data management.
Official Source	—	Create list relationships by using lookup columns	Tables in Google Sheets	Database properties	PDF form fields and calculated values

Overall Conclusion
WPS Advanced Field Types is well suited to workflows that need linking, lookup, summaries, and automatic record tracking inside one multidimensional table. For cross-table business management, its field organization is more direct. If your work is centered on workspace databases or PDF forms, Notion and Adobe are closer to those specific scenarios.

Use Cases

No.	Scenario	Suitable for	Main pain point	Recommended approach
1	Project task linking	Project managers and execution teams	Tasks and project master tables are separated and hard to review together	Use Two-way Link, Lookup, and Statistics to connect task and project tables
2	Customer and order management	Sales and operations teams	Customer and order data is entered repeatedly	Use One-way Link and Lookup to reduce repeated entry
3	Workflow tracking	Admin and collaboration teams	It is hard to see who created or edited a record	Use Created By, Last Modified By, Created Time, and Last Modified Time to track changes
4	Standardized numbering	Finance, procurement, and legal teams	Manual numbering is easy to mismanage	Use Auto Number to generate consistent record IDs
5	Automatic reminders and status updates	Team leads	Repeated notifications and status changes are handled manually	Use Automation to trigger notifications or updates based on conditions

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Writer, Spreadsheet, and Presentation core apps	✅ Available	✅ Available
Basic PDF features and PDF reading	✅ Available	✅ Available
Advanced PDF editing, conversion, and more advanced tools	Some limits apply	✅ More complete access
Cloud storage	1 GB	20 GB or more depending on plan
AI tools and advanced templates	Some limits apply	✅ More advanced access

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Mainly using advanced fields in multidimensional tables and everyday document editing	Free	This feature is described without a membership limit, so you can use it directly
Need more PDF, AI, template, and cloud storage capabilities	WPS Premium	Suitable for users who also need more advanced office features
Team collaboration and multi-user sharing	Sharing or membership plan	Suitable for teams that need multiple accounts and more cloud storage

WPS membership center: Subscribe now