Budibase DB

Budibase DB is the native datasource for your workspace.

Use it when you want data stored directly in Budibase and shared across apps and automations in the same workspace.

Create a table

1. Open the Data section
2. Click Add source
3. Choose Create new table
4. Enter a table name
5. Save the table

Add columns

Add columns from the table grid.

1. Open the table
2. Click the + button
3. Choose the column type
4. Set the column name and options
5. Save the column

Choose a display column

The display column is the value shown in relationship fields and other linked views.

Set a display column when you want records to appear by name instead of ID.

Use auto columns

Budibase DB supports system-managed auto columns such as:

• Auto ID
• Updated By
• Updated At

Use these when you need values generated by Budibase instead of entered by a user.

Data types

Common Budibase DB column types include:

• Text
• Long Form Text
• Options
• Multi-select
• Number
• Boolean
• Date/time
• Attachments
• Relationships
• Formula
• JSON
• Barcode/QR

Constraints

Use constraints to validate values in Budibase DB tables.

Common constraints include:

• Required
• Maximum length
• Minimum value
• Maximum value
• Earliest date
• Latest date

Constraints on external tables are used for form validation only.

Development and production data

Budibase DB keeps separate development and production data.

• Development data is what you see in the builder
• Production data is what your app users see

When you publish an app, development changes are pushed to production.

Related pages

• CSV Import
• Text
• Number
• Boolean (True/False)
• Options