How to Use WPS Advanced Development on macOS

Use WPS Advanced Development through 6 how-to topics, all available from the Efficiency tab and related panels in spreadsheet collaboration mode.

How-to Index

How-to Guide

1. Open the AirScript Script Editor

Entry: Efficiency → Advanced Development → AirScript Script Editor

1. Click the Efficiency tab.
2. Click Advanced Development.
3. Select AirScript Script Editor from the drop-down menu.

Success Criteria

• The script editor window or panel opens.
• You can view the script list and enter the code editing area.

Tips While Using

• This entry is used within spreadsheet collaboration-related workflows.

2. Write a Script

Entry: Efficiency → Advanced Development → AirScript Script Editor → Code editing area

1. Open the AirScript Script Editor.
2. Select an existing script from the list, or create a new one.
3. Enter your script in the code editing area.
4. Click Save on the toolbar.

Success Criteria

• The script content appears in the editor.
• After saving, the script is ready for further editing or execution.

Tips While Using

• If you close the editor before saving, your latest changes may not be available for reuse.

3. Run a Script

Entry: Efficiency → Advanced Development → AirScript Script Editor → Toolbar

1. Open the target script in the editor.
2. Click Run on the toolbar.
3. Review the output and error details in the Log panel at the bottom.

Success Criteria

• The log panel shows output or error information.
• You can continue editing and run the script again if needed.

Tips While Using

• Confirm that you are running the intended script version before execution.

4. Manage Scripts

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

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

Success Criteria

• The selected management action takes effect.
• You can continue editing, sharing, or cleaning up scripts.

Tips While Using

• Confirm before deleting a script that may still be needed.
• Collaboration-related options usually depend on the current shared document environment.

5. Open the Scheduled Task Panel

Entry: Efficiency → Advanced Development → Scheduled Task

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

Success Criteria

• The Scheduled Task panel appears on the right.
• You can create or review tasks from the panel.

Tips While Using

• Automated tasks usually depend on the document and script remaining accessible.

6. Create a Scheduled Task

Entry: 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 specific date, time, or recurrence rule.
4. Select the shared document script to run. If needed, click Open AirScript Script Editor to prepare the script first.
5. Click Confirm to finish creating the task.

Success Criteria

• The task appears in the scheduled task list.
• The task is ready to run according to the configured schedule.

Tips While Using

• Save the target script before creating the task.
• Scheduled tasks depend on an existing AirScript script.