Databases
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
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:
After you've clicked 'New table', you'll see the following options:
To create a new table, click on 'Empty Table'.
Add a name for your database table:
Add the names of the columns you need, specifying the type of column (eg. text, number, image, icon). Then, select 'Finish'.
Start adding your data to the columns you've created. To add new rows, click the '+' button.
You can sort the columns as needed using the up/down arrow next to the title of each column:
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.
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:
Select the part on the canvas where you want to add your data
Go to the list of tables by clicking on the database icon
Select your table
Click 'Add to page'
Choose the columns you want to be displayed by unchecking those columns you do not want displayed
Make sure the column order is how you want to see the data appear in the table, under the heading 'Choose your column order'
Choose the layout for your data - either a row of cards, a table, or an input form, then click add.
Your data will appear on the canvas in your preferred format.
