Add Record in WPS on Windows: Introduction

Add Record in WPS on Windows is a database automation action for creating new rows in a target table; 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

Add Record is a database automation action in WPS Office for Windows. It is used to create a new record in a selected table and assign fixed or dynamic values to fields.

Core capabilities include:

Select the action: choose Database Table → Add Record in the automation editor.
Configure parameters: choose the target table, add field values, and insert dynamic values such as current time, trigger user, or the record from Step 1.

This feature is useful for automatically logging business data, writing new rows after a trigger condition is met, and filling structured fields during a workflow.

System Requirements

Item	Requirement
Operating system	A Windows PC that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Keep an internet connection available when opening database tables and automation settings
Other	You need access to the target database table and the required viewing or editing permissions

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open the database automation editor, and confirm that the Database Table → Add Record entry is available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In the automation editor, Add Record lets you choose a target table, set at least one field value, and insert dynamic values such as current time, trigger user, or the record from Step 1.	Microsoft Lists lets users add a new list item and also add or edit multiple items in grid view.	AppSheet can add one or more records to a table and pass field values in the request, with validation and automation handling.	Notion database buttons can add a page to a selected database and continue filling properties for the new entry.	Adobe Acrobat focuses on creating PDF forms and form fields for data collection, rather than a native table-record automation flow.
WPS Advantages	Advantage: the action is configured directly inside the automation editor for workflow-based table updates. Distinct: field values can directly reuse trigger-context data such as time, user, and the Step 1 record.	Compared with WPS: item creation is documented mainly as manual list entry or grid editing, with less emphasis on trigger-context field mapping in the same workflow editor.	Compared with WPS: structured record creation and validation are supported, but the official flow here is centered on API-based table actions.	Compared with WPS: database buttons can add pages and edit properties, but some button actions are limited by plan type.	Compared with WPS: Acrobat is better aligned with PDF form collection and field design than with table-based record insertion.
Official Source	—	Add or edit list items	Add records to a table	Database buttons	Create PDF forms from scratch

Overall Conclusion
If you want to write trigger data directly into a new database row during an automation flow, WPS provides a workflow-oriented setup path. Other products also support adjacent scenarios such as manual list entry, API-based row creation, or PDF form collection, but their focus is different.

Use Cases

No.	Scenario	Suitable for	Main challenge	How Add Record helps
1	Auto-log new leads	Sales and operations teams	New leads need to be entered repeatedly	Add a new row automatically and fill key fields
2	Update a register after a workflow	Project and admin teams	A completed process still requires manual registration	Write trigger data into the target table with dynamic values
3	Save time and owner details	Team managers	Operation time and responsible user need to be recorded	Insert current time and trigger user into fields
4	Reuse data across steps	Automation builders	Results from an earlier step are hard to reuse	Reference the record triggered in Step 1 directly
5	Collect structured business data	Business teams	New data is entered in inconsistent formats	Select a target table first, then configure fields one by one

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	✅	✅
Basic Add Record setup	✅	✅
Some advanced PDF features	Available based on in-product prompts	More advanced features available
Cloud storage and selected value-added services	Basic quota	Higher quota or more services

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
You only need to configure Add Record in database automation	Free	No membership limit is shown for this feature in the available instructions
You also need more advanced office or PDF features	WPS Premium	Suitable for users who need broader advanced features and added services

WPS membership center: Subscribe now