# Tables

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FSyAW1RXTkax5G6uPg4Kp%2Fimage.png?alt=media&#x26;token=68f9f5d3-ed65-4ace-aac6-50bbf389fa0c" alt=""><figcaption></figcaption></figure>

The Tables section allows you to create and manage database tables that can be used across all your workflows. The screen below shows the interface for managing your tables.

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FK4SChi6jp2xu0C81PwPO%2Fimage.png?alt=media&#x26;token=98b66a78-829c-473a-946d-13e21c3246bb" alt=""><figcaption></figcaption></figure>

**Table List**

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2F9QpueErePebapPaBEx15%2Fimage.png?alt=media&#x26;token=5289ffa3-2a69-4276-a397-df64e4da2d56" alt=""><figcaption></figcaption></figure>

**Table Detai:**

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FhbuekmHreTswTzykEO99%2Fimage.png?alt=media&#x26;token=af0feebf-0083-4a40-ab4d-09a5ccb85e1e" alt=""><figcaption></figcaption></figure>

## 1. Create a Table

When you click on "**+**" you can create a table by differents ways.

* Create a blank table
* Import from CSV
* Use sample data

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FNMkrdMEJd5pq6x4sriv6%2Fimage.png?alt=media&#x26;token=1b05fc39-7050-4048-9ae6-6a85d9c87a69" alt=""><figcaption></figcaption></figure>

The screen below appears when you click the arrow to the right of your table name. It provides options to create a table using a CSV file, add a row, and export tables as CSV files. Additionally, you can rename, duplicate, or delete your table.

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FJqR1BO1ubCbl5d6SKXGq%2Fimage.png?alt=media&#x26;token=d132bd55-f439-4bd0-b6ef-93ac33734544" alt=""><figcaption></figcaption></figure>

## 2. Filter data

You can filter your table by enter a field name and choose an operator (Equal to, Not equal to, Contains).

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2Fm5B0LrGXrdznE7O10omF%2Fimage.png?alt=media&#x26;token=23b850f0-d7f9-4a3b-8d9c-2ed31c92dc23" alt=""><figcaption></figcaption></figure>

## 3. Sort data

You can sort your table by entering a field name and choosing ascending or descending.

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FgLF1FOGLcKAC6Xbhh1VL%2Fimage.png?alt=media&#x26;token=0bba8bac-d42c-4eec-8fd7-5b6d7a488649" alt=""><figcaption></figcaption></figure>

## 4. Show data

This tool allows you to hide or show fields to have a better view on your table.                                                                        &#x20;

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FLanPuRtu4T6FFUGw8ttM%2Fimage.png?alt=media&#x26;token=abb66ffb-3c9e-4c77-9086-cced47ede4a2" alt=""><figcaption></figcaption></figure>

These elements show differents things. First of all "6 records" mean that the table contains 6 rows. When you click on the first icon it refresh the table. The second icon can download the table in a CSV file.&#x20;

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FjvhKP2HKXm2A0WSwTxlf%2Fimage.png?alt=media&#x26;token=0d75ea6c-88e8-4bf6-9695-89e7f8c56d66" alt=""><figcaption></figcaption></figure>

## 5. Share table to other members on Workspace&#x20;

When you click on the share icon it appears the screen down below. You can share the table via email.

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FE0BlzSKQDmn9QLwj52J7%2Fimage.png?alt=media&#x26;token=905e97ed-d47c-46d1-a673-11c627e1f1cb" alt=""><figcaption></figcaption></figure>

## 6. Create a column on the table

Can create a column on the table by click button **+**&#x20;

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FDc7P2TDWR8eidNHErrkp%2Fimage.png?alt=media&#x26;token=b772b790-2087-4c17-a310-f0872545a771" alt=""><figcaption></figcaption></figure>

Need input field:

* **Field name**: Input the field name, The column name must not duplicate an existing one in the table.
* **Field type**: Choose one of the options:
  * Single line text
  * Long text
  * Checkbox
  * Multiple select
  * Single select
  * Date
  * Duration
  * Number
  * Currency
  * Rating
  * Created time
  * Last modified time
* **Is required**&#x20;

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2Fy6ogsZp6g9HBcgMdd1JS%2Fimage.png?alt=media&#x26;token=bba5a59f-8aed-425d-9c50-51f4ad253f3c" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FdUinvGvbPtxk39erlKmJ%2Fimage.png?alt=media&#x26;token=4fe1b196-5d3a-45e6-aa13-ccf753d5857c" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2F7hI2UThUcd7wmOeBUDnv%2Fimage.png?alt=media&#x26;token=1ad1ca76-c2c9-4937-9a52-24e5c84bd8be" alt=""><figcaption></figcaption></figure>

## 7. Add a row on the table

Can add row on the table by click button **+ Add row**&#x20;

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FxE4QzkfV9poA644ZtuHJ%2Fimage.png?alt=media&#x26;token=459d8f7a-b545-4408-998f-ef8ddd83249f" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FKhkzwxMq9I1dnu0Plf0t%2Fimage.png?alt=media&#x26;token=e4a35842-4ffa-4980-bfc5-80892b9c25a6" alt=""><figcaption></figcaption></figure>

## 8. Delete/bulk delete row on the table

Can delete or bulk delete rows on the table

**Step 1:** Check the rows you want to delete&#x20;

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FAlv8tUowVG9baH9IFTaA%2Fimage.png?alt=media&#x26;token=abfe66a4-3dd2-45db-bfa2-1717a94f71d5" alt=""><figcaption></figcaption></figure>

**Step 2:** Click button "<mark style="color:red;">Delete</mark>" at "**Action options**"

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FPiwlp5FhbVurk2F5SHZ7%2Fimage.png?alt=media&#x26;token=f4c38996-7a67-4cd5-b95a-c6adfa4923a5" alt=""><figcaption></figcaption></figure>

## 9. Diaflow Tables Assistant

You can directly retrieve information from the table you are pointing to by chatting with the Diaflow Tables Assistant.

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FPVq0lq6VtStNJLUGiAT0%2Fimage.png?alt=media&#x26;token=9edcb8d5-9b7e-48a8-a25a-04fecd18b96a" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3864624312-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRdo1pkMnofwxf3lpWftw%2Fuploads%2FtM7jr1L0eljzczcg1ioK%2Fimage.png?alt=media&#x26;token=5185a758-2a0a-438e-9fba-3b8d13e6b514" alt=""><figcaption></figcaption></figure>
