The database: tables and records

See every table of your app, add, edit and delete rows, see how tables link, and export to CSV or JSON.

Everything your app saves, such as bookings, leads, customers or orders, is kept in tables. Each table holds one kind of thing, and each row is one record: one booking, one customer. You can see and fix the data yourself, without asking the builder.

Screen recording: Settings, Database: picking a table and adding a row.

1. Open the database: In the Studio, open Settings and choose Database (in the group Data and security).

2. Pick a table: The list shows each table and how many rows it has.

3. Add a row: Press Add row, fill in the fields and Save.

4. Edit a value: Double-click a cell, change it and save.

5. Delete: Tick rows and press Delete selected, or delete one row from its own button.

See the whole picture

Database schema shows all tables with their fields and the links between them, for example that each booking points to one class. Click a table there to open it.

Export

Change the shape with words: To add a field or a new table, ask in the chat in Build mode, for example "add a birthday field to members". To fill in or fix data in bulk, use Action mode.

Restoring a version replaces data: Restoring a saved version brings back the records as they were at that time. See Saved versions.

Questions

Q: Where did the form submissions go?

A: Into the table the form saves to. Open it here; new rows appear at the top after a refresh.

Q: Can I import a spreadsheet?

A: Attach the file in the chat and ask the builder in Action mode to add the rows.

Q: Who can see this data?

A: You, and whoever the app rules allow. See Users and security.

Q: Can I get a message when a new row is added?

A: Yes, in Settings, Notifications. See Studio settings.

Related: Approving changes to your data, App users, login and security, Saved versions and restore, The chat: Build, Action and Talk, Automations: tasks your app does by itself