Create and manage tables

Define structured data for your app using tables with rows and columns.

Tables are where your data lives. Think of them like spreadsheets: each row is a record, each column is a field. You can use this data to populate your interface and control exactly who can access what data.

Table vs View

• Table — Here is where you store your data and configure its columns
• View — A saved configuration on top of a table. Views don't store data themselves, they simply show filtered/sorted sets of data from a table

Create a table

1. Go to Data & API > Tables
2. Click + Add table
3. Choose your data source
4. Enter a Name and optional Description
5. Keep Create API actions enabled to auto‑generate CRUD (common data actions) API Endpoints
6. Click Add table

Choosing a data source

• Project tables — Creates a native table in WeWeb. You'll define columns and add data from scratch
• Any other data source (for example, Airtable, REST API, etc.) — Connects your table to an external data source. This lets you use external data inside WeWeb without importing it

To learn more about our available data integrations, check out the dedicated integrations documentation →

HOW EXTERNAL DATA WORKS

When you choose a data source outside of WeWeb, WeWeb does not copy or import your data. Instead, WeWeb creates a connection to your integrated data source and retrieves the data on demand whenever your app needs it. No data is ever actually copied into WeWeb’s servers.

Managing columns

To create a column:

1. Click the + in the header to add a new column
2. Enter a Name for your column (when possible, use words separated by _, like first_name, for better compatibility when you use the column in bindings, formulas, and API Endpoints)
3. Choose a Column Type (see Columns and relationships for a full list of column types →)
4. Set a Default Value — This will be the value used in the column for newly created records if this column is not given a value at creation
5. Define if the Value must be unique — This will not allow multiple records in the table to have the same value for this column
6. Define if the Value is required — This will not allow new records to be created if no value is given for this column

DON'T SEE THE + BUTTON?

If you do not see the + button, it is likely because you are currently in a view of the table. You are only able to add columns to the root table itself – not a view of the table.

To return to the root table, click this part in the sidebar:

Work with records

You can add and/or edit records directly from the UI.

• Insert — Use the Insert menu or your generated endpoint

• Edit — Click a row to open the record panel and update fields

• Delete — Select one or more rows, then delete

• Bulk actions — Use the row checkboxes to act on many records

PROGRAMMATICALLY UPDATING DATA

To let users create, edit, or delete records from your app, use API Endpoints.

Learn how to create an API Endpoint →

CONTINUE LEARNING

Next, learn about defining the right column types and relationships.

Columns and relationships →