When using Advanced Development, the most common questions fall into 3 areas: script capability scope, script error handling, and scheduled task setup. This section includes 4 common questions and answers.
FAQ
What can AirScript scripts do?
- AirScript scripts can add, delete, query, and modify spreadsheet data.
- They can also modify cell styles, adjust properties, and support automation tasks.
- You can continue expanding logic through the script development workflow in the editor.
What should I do if a script returns an error?
- Run the script and review the Log panel at the bottom.
- Check the error details in the log for syntax or logic issues.
- Save the corrected script and run it again.
What trigger times are available for scheduled tasks?
- Open the Scheduled Tasks panel and click Create Task.
- In the trigger options, choose Once, Daily, Weekly, or Monthly.
- Set the required time and confirm the task.
How do I automate spreadsheet tasks on macOS with scheduled tasks?
- Scheduled tasks are used to run AirScript scripts automatically.
- Before creating a task, write the script in the AirScript Script Editor.
- When creating the task, choose the script from shared document scripts and confirm.
Glossary
| Term | Definition |
|---|---|
| AirScript Script Editor | The script development interface in AirSheet for writing, saving, and running scripts. |
| Log panel | The area that shows output results and error details after a script runs. |
| webhook | A type of address that can be copied from the script management menu for external calling scenarios. |
| Scheduled task | A task configuration that runs an AirScript script automatically at a specified time or recurrence. |