This section contains some examples of Python Scripts. The first three scripts are the same than in the JavaScript section.
Even if Python scripts are capable of checking if the base structure (tables and columns) needed exist and of creating it if necessary, we didn't implement this feature in the scripts so you can focus on the actual goal of each script.
{% include-markdown "includes.md" start="" end="" %}
This script demonstrates how to add rows to record monthly repetitive expenses in a ledger.
read more :material-arrow-right-thin:
This script computes an accumulated value (adds the value of the current row and the previous rows), similar to the Calculate accumulated value operation from the data processing menu.
read more :material-arrow-right-thin:
This script computes, from a list of clocking times, daily clock in (earliest clocking) and clock out (latest clocking) times for each day and staff member.
read more :material-arrow-right-thin:
This Python script demonstrates sending emails via SMTP using the smtplib module and constructing MIME objects to compose rich content emails within SeaTable.
read more :material-arrow-right-thin:
This Python script demonstrates the process of converting text slices into barcode images and storing them in an image column within SeaTable.
read more :material-arrow-right-thin:
This Python script is designed to generate QR codes and associate them with corresponding records in a SeaTable base. It uses the seatable_api library and qrcode library to accomplish this task.
read more :material-arrow-right-thin:
This Python script facilitates the synchronization of data from a MySQL database to a SeaTable table.
read more :material-arrow-right-thin:
Integrating data from the Twelve Data API with SeaTable facilitates the updating and maintenance of current stock prices within a designated table in the SeaTable environment.
read more :material-arrow-right-thin:
Merge PDF files and save the merged file into a new row in a SeaTable base.
read more: :material-arrow-right-thin:
Convert HEIC image files to PNG format and save the converted file into a new row in a SeaTable base.