Store app records in AppStruct
Create tables, add typed fields, and connect data to your app.
AppStruct Database is the built-in backend available from the app editor. It stores the records your published app needs; it is separate from workspace Sheets.
Create a database and table
- Open Backend → AppStruct.
- Choose Create Database if the project does not have one yet.
- Choose Create table and enter a name.
- Use Column to add the fields you need.
- Add a Row with sample values before connecting the interface.
The current column-type menu includes Text, Number, Boolean, Date & time, and Image. Choose types that match the information you will write from the app.
Manage records
The table view supports row editing, column management, relations, data import, and export controls. Import options include CSV, Excel, and a Google Sheet URL. The Google Sheet import dialog asks for a sheet available to anyone with its link; an import is different from a live integration workflow.
Review access
Column permissions expose separate view and edit choices, including Everyone, Only Logged In Users, Only the Record Creator, and Nobody. Review the appropriate rules before using private or user-specific data.
Connect the table to Add row, Get row, Update row, and Delete row actions, then verify the actual records after testing.