Create a table with records

Learn how to create your table and add records to it.

Let's imagine a scenario where a bot is helping users book their favorite yoga or Zumba class. You want to use table to check available class and then help customers to book their favourite class. Follow these steps to get started using Table.

Create a table

To add a table to your Tables:

1. Navigate to the Tables section in the main menu.

Tables on the side bar menu

2. Click the + button at the top of the screen.

3. Give the table a descriptive name and provide a brief explanation of its purpose. In this example, our table serves to store info about the dates, names and times of a yoga/zumba class booking system.

4. Define your table columns. Specify the name of each column and select the appropriate type of variable for your column. For this example, we'll only have text columns for:

   • className

   • classDay

   • classTime

   • classTeacher

   • isBooked

Create a Table and give it columns.

5. Click Create.

Learn more about the columns types in the dedicated article 👇

pageColumn types

You've successfully created a table! For now, it's still empty.

Created empty Table.

Let's now add records to the Table.

Create a new record

A record is a line of data on your table.

To populate your table with data, you can either:

• Insert record manually.

• Import data that already lives somewhere else.

Add a new record manually

1. From your table, click on Insert record at the top-right corner of your screen.

2. Fill the value for each column.

Insert a record to your table manually.

3. Click Add.

You can now see your record inside the table!

Table filled with one record.

Import a record

1. From your table, click on the arrow next to the Insert record button.

2. Select Import data.

Import data button

3. Drag and drop CSV file.

4. If your data is incompatible, you will get a red alert next to Preview data to be imported. Click on this section.

Check that your data is valid before importing records to your table.

5. The details unfold so that you can review the issues that need to be solved. In this example, the problem is that we have some columns headers incompatibilities.

Review data before it's imported to your table.

6. After figuring out all the issues, go to Configure import data to solve those. In this example, as it mentioned that some columns are not present in the table, deselect the columns that shouldn't be imported.

The columns selected in gree will be imported, whereas the white ones won't be imported.

Deselecting columns to be imported

7. Once you have resolved the issues, the Data incompatible tag will disappear, indicating that the data is now ready for import.

8. Click Import as the last step.

Your table is now filled with the data that was in your .csv file!

Table filled with a CSV importation.

---

Looking for a quick and easy bot template to play with Tables? The Gym bot is a representative use case.