Scripting¶
Supported scripting languages and requirements¶
Scripts are used to interact with the data in a base. SeaTable supports scripts written in JavaScript and Python. Both languages have different requirements and abilities. Let's try to summarize these to help you make the right choice depending on your needs.
| JavaScript | Python | |
|---|---|---|
| Requirements | None | Eventually seatable-api library or Python Pipeline (see Execution environment) |
| Data operations | Simple (mainly tailored for single-line operations) | More complex (more available operations, possibility of using external libraries) |
| Execution environment | In SeaTable | - In SeaTable (self-hosted with the Python Pipeline installed, or Cloud) - Locally or on a server (need to install seatable-api library) |
| Authentication | Not needed | Needed |
| Main advantage | - Ready to use (no requirement, no authentication) - Rather simple (both advantage and disadvantage) | - Local execution convenient for development and debugging purposes - Easily integrated into larger projects |
How to start?¶
Both JavaScript and Python scripts can be composed and executed directly in a SeaTable base.
Here are some additional help articles from the User Manual's scripts section explaining how to create, execute and monitor a script in SeaTable:
- Creating and deleting a script
- Run script manually, by button or by automation
- The execution log of scripts
You'll find in this manual a JavaScript and a Python section. For both of them, each chapter provides you with explanations about the available objects and methods (description with the eventual arguments and one or more simple use cases).
Multiple JavaScript and Python examples should help you to start immediately and get a feeling about the possibilities.