Databases

A database is an organized data collection that can be accessed, managed, and updated. It stores and retrieves data for various purposes, such as storing customer information, tracking inventory, and managing employee records.

You can find Databases by clicking the database icon in the Left Toolbar.

Databases

Selecting the database table icon opens the database menu, where you'll see all your existing databases. This is where you can create a new database table:

Create a New Database Table

After you've clicked 'New table', you'll see the following options:

Create an Empty Table Or Import a File

Creating a Database Table from an Empty Table

To create a new table, click on 'Empty Table'.

1. Add a name for your database table:

Creating a Database Table from an Empty Table

1. Add the names of the columns you need, specifying the type of column (eg. text, number, image, icon). Then, select 'Finish'.

Add Columns to the Table

1. Start adding your data to the columns you've created. To add new rows, click the '+' button.

Add Data to the Columns

You can sort the columns as needed using the up/down arrow next to the title of each column:

Sort the Columns

Creating a Database Table By Importing an .xlsx file

If you've already got your data in an .xlsx file, click on 'Import Excel File' and you can upload the file from your device.

Once you've uploaded the file, you'll see it in your list of tables.

Displaying The Contents of Your Database Tables on the Canvas

The data in your database can easily be displayed on your canvas. You can display the data in a table, as a row of cards, or as an input form.

The process to add your database table to the canvas is as follows:

1. Select the part on the canvas where you want to add your data

2. Go to the list of tables by clicking on the database icon

3. Select your table

4. Click 'Add to page'

5. Choose the columns you want to be displayed by unchecking those columns you do not want displayed

6. Make sure the column order is how you want to see the data appear in the table, under the heading 'Choose your column order'

7. Choose the layout for your data - either a row of cards, a table, or an input form, then click add.

8. Your data will appear on the canvas in your preferred format.