How to Use WPS Advanced Development on Windows

Use Advanced Development through 6 how-to topics, including 6 free topics and 0 membership-related topics; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Open the AirScript editor

Entry path: Efficiency → Advanced Development → AirScript Script Editor

1. Open a spreadsheet file in WPS Office.
2. Click the Efficiency tab.
3. Click Advanced Development.
4. Select AirScript Script Editor from the drop-down menu.

Success Criteria

• Interface result: The AirScript editor window or panel opens.
• Next action available: You can see the script list and the code editing area.

Tips While Using

• Common mistake: If no spreadsheet is open first, you may not enter the intended spreadsheet development workflow.
• Environment note: Staying signed in and connected to the internet is recommended.

2. Write and save a script

Entry path: Efficiency → Advanced Development → AirScript Script Editor → code area

1. Open the AirScript editor.
2. Select an existing script from the list or create a new one.
3. Enter or edit script content in the code area.
4. Click Save on the toolbar.

Success Criteria

• Interface result: The current script content is saved.
• Next action available: You can run the script or continue managing scripts.

Tips While Using

• Common mistake: Running a script before saving changes may execute an older version.

3. Run a script and review logs

Entry path: Efficiency → Advanced Development → AirScript Script Editor → toolbar

1. Finish writing a script or select an existing one.
2. Click Run on the toolbar.
3. Wait for the script to finish.
4. Review output and error details in the Log panel at the bottom.

Success Criteria

• Interface result: The log panel shows output, status, or error details.
• Next action available: You can revise the script and run it again.

Tips While Using

• Common mistake: Ignoring the log panel makes troubleshooting harder.

4. Manage scripts

Entry path: Efficiency → Advanced Development → AirScript Script Editor → script list

1. Find the target script in the script list.
2. Click the ... button next to the script.
3. Choose the action you need, such as rename, insert into a cell, copy script webhook, allow everyone to edit, run without service authorization, or delete.

Success Criteria

• Interface result: The selected management action takes effect.
• Next action available: You can continue editing, running, or sharing the script.

Tips While Using

• Common mistake: Deleting a script before confirming whether it is still needed.

5. Open the scheduled task panel

Entry path: Efficiency → Advanced Development → Scheduled Task

1. Click the Efficiency tab.
2. Click Advanced Development.
3. Select Scheduled Task from the drop-down menu.
4. Check the scheduled task panel on the right.

Success Criteria

• Interface result: The scheduled task panel is visible.
• Next action available: You can review existing tasks or create a new one.

Tips While Using

• Environment note: Automatic task execution usually works more reliably when your account status and network connection are available.

6. Create a scheduled task

Entry path: Efficiency → Advanced Development → Scheduled Task → Create Task

1. In the scheduled task panel, click Create Task.
2. Choose a trigger type: one time, daily, weekly, or monthly.
3. Set the date, time, or recurrence details you need.
4. Select an existing document shared script.
5. If needed, click Open AirScript Script Editor to prepare or update the script.
6. Click Confirm to create the task.

Success Criteria

• Interface result: The task appears in the scheduled task list.
• Next action available: The selected script can run automatically based on the schedule.

Tips While Using

• Common mistake: Creating a task before preparing a usable script.
• Environment note: Scheduled tasks depend on an existing script being available first.