Database Page

Introduction#

The database page is where you will find all the records of a database displayed in an interactive table. From here, you can manage and edit the database as a whole, and all records inside of it.

img

At the top of the database, you will see a toolbar with various actions you can take:

img

Edit Records#

To edit values in a record, simply double click on the value or "cell".

img

Remember to click "Save Edits" after you are done to push those changes to the database.

note

The Record ID and Session ID columns cannot be edited.

Edit Columns#

This allows you to change the name of a column. Note that you cannot change the data type of a column once it is set.

img

Add Record#

Add a new record by clicking the "+ Add Record" button at the bottom of the table.

img

Add new column#

To add a new column, click the + on the right hand side of the table:

img

You will need to set the name of the column, and its data type.

img

warning

Once set, the column data type cannot be changed, so make sure you choose the correct data type when creating that column.

Import records#

This feature allows you to import data into your database via uploading a .csv file.

The column names in the .csv file must match the existing column names in your database. The column names are case sensitive, so "Email" will be treated as different to "email".

img

important

Keep the following in mind when importing records via this method:

  • If an error is encountered, the entire import operation will be abandoned (called an "all or nothing" approach). This error will need to be fixed and the file re-uploaded.
  • If a column exists in the uploaded .csv file but not in the database, it will not be imported. You can only import data into columns that already exist in the database.
  • If the data type in the uploaded file does not match the data type of the column in the database, this will result in an error.

Filter#

Clicking this turn on a filter for each column. You can use this filter to search through and filter the records being displayed.

img

Delete records#

To delete records from the database, select the records you want to delete:

img

Then click Delete Records. You will be asked to confirm this action.

warning

This action cannot be undone - once records have been deleted, they cannot be recovered.

img

Delete columns#

Clicking this will allow you to delete columns and all data contained within them.

warning

This action cannot be undone - once records have been deleted, they cannot be recovered.

img