How to Use WPS Advanced Development on Windows

Use Advanced Development with 6 how-to topics, including 6 free topics and 0 membership-related topics; use the How-to Index to jump to each task.

How-to Index

How-to Guide

1. Open the AirScript script editor

Entry path: Script → Advanced Development → AirScript Script Editor

1. Open a Smart Spreadsheet data table.
2. Click the Script tab.
3. Click Advanced Development.
4. Select AirScript Script Editor from the drop-down menu.

Success Criteria

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

Tips While Using

• If the current file is not opened as a Smart Spreadsheet data table, the related entry may not appear.
• Make sure the current file allows script editing before you begin.

2. Write a script

Entry path: Script → Advanced Development → AirScript Script Editor → code editor

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

Success Criteria

• Interface result: The script content appears in the code editor.
• Next action available: After saving, you can run or manage the script.

Tips While Using

• Before saving, confirm that the script name and content match the task you want to complete.
• If you are editing a shared script, confirm the collaboration scope first.

3. Run a script and review logs

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

1. Open the target script in the script editor.
2. Click Run on the toolbar.
3. Wait for the script to finish.
4. Review output results and error details in the Log panel.

Success Criteria

• Interface result: The log panel shows run results or error messages.
• Next action available: You can revise the script and run it again.

Tips While Using

• If the script fails, review the log details before changing the code.
• Keep the network connection stable when the script depends on online requests.

4. Manage scripts

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

1. Open the AirScript script editor.
2. Find the target script in the script list.
3. Click the ... button next to the script.
4. Choose the action you need, such as Rename, Insert into Cell, Copy Script Webhook, Everyone Can Edit, No Service Authorization Required, or Delete.

Success Criteria

• Interface result: The selected management action takes effect.
• Next action available: The script can continue to be edited, run, or shared.

Tips While Using

• Before deleting a script, confirm that it is no longer needed by tasks or collaborators.
• Before enabling shared editing, confirm the editing scope for your team.

5. Open the scheduled task panel

Entry path: Script → Advanced Development → Scheduled Task

1. Open a Smart Spreadsheet data table.
2. Click the Script tab.
3. Click Advanced Development.
4. Select Scheduled Task from the drop-down menu.

Success Criteria

• Interface result: The Scheduled Task panel appears on the right.
• Next action available: You can review or create scheduled tasks.

Tips While Using

• Scheduled tasks are used to run AirScript scripts automatically, so prepare a runnable script first.

6. Create a scheduled task

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

1. Open the Scheduled Task panel.
2. Click Create Task.
3. Select a trigger time. Available options include one-time, daily, weekly, and monthly.
4. Select the AirScript script to run. If you need a new script, click Open AirScript Script Editor.
5. Click Confirm to finish creating the task.

Success Criteria

• Interface result: The task appears in the scheduled task list.
• Next action available: The task will run the selected script at the scheduled time.

Tips While Using

• Before creating a task, run the script manually to confirm that the logic works as expected.
• When selecting a script, make sure it is an available shared script for the current document.