How to Use WPS Advanced Development on macOS

Use WPS Advanced Development on macOS through 6 how-to topics in smart spreadsheet data tables; 6 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Open the AirScript Script Editor

Entry path: Script → Advanced Development → AirScript Script Editor

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

Success Criteria

• Interface result: The AirScript script editor opens successfully.
• What you can do next: You can view the script list and the code editing area.

Tips While Using

• Open a smart spreadsheet data table first, then enter the script-related menu.

2. Write a Script

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

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

Success Criteria

• Interface result: The script content is saved in the editor.
• What you can do next: You can continue editing or run the script.

Tips While Using

• Check the script name and content before saving so later management is easier.

3. Run a Script

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

1. Finish writing a script or open an existing one.
2. Click Run on the toolbar.
3. Review the output and error details in the Log panel at the bottom.

Success Criteria

• Interface result: The script starts running and the log panel shows results or error details.
• What you can do next: You can debug, edit, or run the script again based on the log output.

Tips While Using

• If the result is not as expected, check the log panel first.

4. Manage Scripts

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

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

Success Criteria

• Interface result: The selected management action takes effect.
• What you can do next: You can continue editing, running, or sharing the script.

Tips While Using

• Confirm that a script is no longer needed before deleting it.
• Review your collaboration scope before enabling edit access for everyone.

5. Open Scheduled Tasks

Entry path: Script → Advanced Development → Scheduled Tasks

1. Click the Script tab.
2. Click Advanced Development.
3. Select Scheduled Tasks from the drop-down menu.
4. Open the Scheduled Tasks panel on the right.

Success Criteria

• Interface result: The Scheduled Tasks panel appears on the right.
• What you can do next: You can review existing tasks or create a new one.

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 Tasks → Create Task

1. In the Scheduled Tasks panel, click Create Task.
2. In the create scheduled task dialog, choose a trigger time: once, daily, weekly, or monthly.
3. If you choose Daily, you can also skip weekends when needed.
4. Select the AirScript script to run. If you need to add or revise a script, click Open AirScript Script Editor.
5. In the drop-down list, select an existing Document Shared Script.
6. Click Confirm to finish creating the task.

Success Criteria

• Interface result: The task appears in the Scheduled Tasks panel.
• What you can do next: You can continue maintaining the task or return to the script editor to revise the script.

Tips While Using

• Before creating a task, make sure the script is saved and runs correctly.
• Match the trigger time to your business schedule.