Budibase DB

This data source is the one that is native to Budibase. Any data you add here is stored directly on your Budibase instance.

Creating a table

You can create a table when you're in the data section in your application.

The recommended flow is to go to your Budibase DB instance from the sidebar, and then click the Create Table button. A shortcut to this is when you press the + button on the top left and choose Budibase DB.

Create a new table using this buttonCreate a new table using this button

Create a new table using this button

When creating a new Budibase DB table you can choose which built-in (auto types) columns you want to have. Each of these will be automatically maintained, created and updated based on the properties. You can choose to omit as you see fit. These can be added post-creation too through the "Create Column" method.

Name

Description

Auto ID

An automatically generated ID

Created by

The user who created the row

Created at

When this row was created

Updated by

The user who updated the row last

Updated at

The time when the row was updated last

CSV upload

When you already have existing data, you can import this using a CSV file when creating a table. This will automatically identify columns and create them for you, after which you can specify data types per column.

In the example below I imported a CSV with 4 columns representing a table of countries. After the file uploaded the screen below was shown.

As you can see, it automatically identified the 4 columns and allowed me to pick the data types for each column.

Adding columns

To add new columns to an existing Budibase DB table, navigate to the table you want to edit, then click the Create Column button on top of the table. This will display a dialog where you can configure the column you want to add.

Editing columns

  1. Step into the table through the sidebar
  2. Hover over the column name you want to edit
  3. Click the pencil icon

Selecting the display column

The display column is an important aspect when you're setting up relationships in tables. The column you select as a display column will be the one visually displayed inside a relationship column in another table.

Selecting a column during the table creation is only possible if you import data using a CSV file. To select a display column in any other situation, edit the column you want to make the display. This will give you the Use as table display column option as shown below.


Data Types

Within Budibase DB there are several data types to choose.

Name

Description

Text

Storage of (relatively) short text

Long Form Text

Allows you to store large amounts of texts, also supports markdown

Options

Predefined list of options of which one can be selected

Multi-select

Predefined list of options of which multiple can be selected

Number

Storage of number

Boolean (True/False)

Storage of true/false

Date/time

Storage of a date with a time

Attachments

Storage of a file. Limited to 20MB per file

Relationships

Creates a link between this table and another table

Formula

Allows you to set a formulated column, which will be calculated based on what you define. You can use handlebars or JavaScript

JSON

Allows you to store JSON within a row, with the option to define a schema

Auto Column

Auto columns can be added post-creation of the database by selecting data type.

Column Definitions

Most of the columns defined below are available for all data types

Property Name

Description

Name

The name of the column, used for querying and displaying

Type

The type of data you want to store.

Required

Enabling this requires this field to be filled for all rows

Use as table display column

Enabling this will make the newly created column the display column. This will also automatically make the field required

Primary index

Enabling this allows you to search in this field

Secondary index

When primary index is in use, you can enable a second index for searching

Most of the columns below are limited to a single type of data.

Property Name

Description

Data Types

Maximum Length

The maximum length that can be stored in this column

Text

Enable Rich Text Format Support

Enabling this will allow you to store markdown

Long Form Text

Options

The select-able options available for this column, one per line.

Options, Multi-select

Min Value

When set, any value entered in the database lower than this number will be rejected

Number

Max Value

When set, any value entered in the database higher than this number will be rejected

Number

Earliest

When set, any date before the specified date is rejected for new rows

Date/time

Latest

When set, any date after the specified date is rejected for new rows

Date/time

Table

Allow a relationship to the specified table

Relationship

Column name in other table

The relationship created will also be visible in the related table, this will set the new column name on the related table

Relationship

Formula

Allows you to set a formulated column, which will be calculated based on what you define. Allows you to define handlebars and JavaScript

Formula


Did this page help you?