Database & Server Settings

Overview

Connection status and the sheets stored for each app.

PostgreSQL connection

Address of your PostgreSQL server (self-hosted, Supabase, Neon, AWS RDS, …). Tables are created automatically in the chosen schema. This connection is shared by every app on this server.

Import from Google Sheets

In Google Sheets choose File → Download → Microsoft Excel (.xlsx), then upload the file here. A backup of the current data is saved on the server first.

Data tools

Maintenance for the workbook.

Initialize structure

Creates all sheets with their default rows. Existing sheets are kept; missing columns are added.

Edit data manually

Fix individual cells or rows, like editing the Google Sheet by hand. Changes take effect immediately.

Open data editor

Copy files from Google Drive

Copies invoice photos and files from Drive to this server. Old links keep working, and files already copied are skipped, so you can run it again at any time.

and paste it into a new project at script.google.com.
Deploy → New deployment → Web app. Execute as Me, Who has access Anyone. Allow access when Google asks.
Paste the web app URL below and press Start.

Backup

Download all data as an Excel file.

Export .xlsx

Server options

Settings for on this server.

Change admin password

The admin password protects these settings for every app on this server.

Create admin password

Admin login