WPS Modify Records on Windows: Introduction

WPS Modify Records helps you update records in a selected data table within Windows automation flows; it includes 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

Modify Records is a multidimensional table action in the Windows automation editor. It is used to update records in a selected data table by range. After you add the action, you can choose the target table, define the record scope, and assign one or more field values with fixed or dynamic content.

Core capabilities include:

Select the Modify Records action and open its parameter panel to start a record update flow.
Configure the target data table, record scope, and field values, with support for dynamic values such as current time, trigger user, and the record triggered in Step 1.

This feature is useful for workflow automation, status updates, field backfilling, and batch corrections that would otherwise require repeated manual edits.

System Requirements

Item	Requirement
Operating system	A Windows computer that can run WPS Office and related automation features
App version	It is recommended to use the latest version of WPS Office
Network	An internet connection is recommended when signing in, syncing settings, or accessing online data
Other	You need access to the target multidimensional table and permission to edit the related records and fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, enter the automation editor, and confirm that Modify Records appears under the Multidimensional Table category

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In the automation editor, Modify Records lets you choose a data table, define the record scope, and set one or more field values, including dynamic values.	Microsoft Lists supports editing single or multiple list items and changing values in columns.	Google Sheets supports writing values to one or more cell ranges and also supports batch updates.	Notion databases support editing properties and property values for database entries.	Adobe Acrobat mainly works with PDF form fields and field properties, focusing on form filling and field setup.
WPS Advantages	Advantage: WPS combines table selection, record scope, and field value setup in one automation action. Distinct: It supports dynamic values such as current time, trigger user, and the record triggered in Step 1.	Compared with WPS: the official page focuses on editing list items and grid-view changes, with less emphasis on dynamic values inside an automation flow.	Compared with WPS: the official page focuses on API-based cell value updates for spreadsheets.	Compared with WPS: Notion supports editing database properties and values, but the official page focuses more on database structure and property management.	Compared with WPS: Acrobat is better aligned with PDF form field editing than table record updates in an automation workflow.
Official Source	—	Add or edit list items	Read and write cell values	Database properties	Work with form fields

Overall Conclusion
WPS Modify Records is well suited to updating multidimensional table records directly inside an automation flow on Windows. Other products also support data editing, but their official documentation emphasizes list editing, spreadsheet APIs, database property management, or PDF form handling rather than the same workflow-centered record update setup.

Use Cases

No.	Scenario	Suitable For	Main Challenge	How Modify Records Helps
1	Batch status updates	Project collaborators	Multiple records need the same status update	Select the target table, define the record scope, and update the status field in one action
2	Writing back trigger details	Workflow administrators	Trigger time or trigger user needs to be written back to the table	Insert dynamic values such as trigger user and current time into field values
3	Correcting a selected record range	Data maintenance staff	Only part of the table should be updated	Use the record scope setting to limit which records are changed
4	Syncing process results	Operations teams	Flow results need to be written back to the original table	Map the result to one or more target fields during configuration
5	Filling missing fields in bulk	Table administrators	Many records are missing the same field content	Add the needed field value once and apply it to the selected records

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic use of the Modify Records action	✅ Available	✅ Available
Core WPS Office productivity features	✅ Available	✅ Available
Advanced PDF tools, more cloud storage, and additional advanced benefits	Depends on plan	✅ Typically includes broader advanced benefits
AI and some advanced features	May be limited	Depends on plan, with broader access in eligible plans

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Occasional automation setup and record updates	Free	This feature itself has no membership restriction in the source content and fits everyday use
Ongoing need for advanced office, PDF, or cloud benefits	WPS Premium	A better fit for users who also need broader advanced benefits beyond this feature

WPS membership center: Subscribe now