Datatables are used to store the data that is being used while executing tasks. There are two types of datatables in Jiffy:

1. Default datatables
2. Custom datatables

Default Datatables

Default Datatables are the predefined formats of table that are readily available for the user to use. The column names of these data tables are not editable. The data type of all the columns is set to String by default and cannot be changed by the user.

Types of Default Datatables

The following are the Default Datatables available in Jiffy:

1. EmailAttachments: This table has the following columns:

   • FileName
   • FileExtension
   • FileSize
   • FileServerID
   • FileServerURL

2. FileExplorer: This table has the following columns:

   • FileName
   • FileExtension
   • FileSize
   • FileServerID
   • FileServerURL
   • LastUpdatedOn
   • FilePath

3. EmailResponse: This table has the following columns:

   • EmailID
   • Message

4. UUID: This table has a UUID column.

Apart from these, there are SingleColTable (a table with one column), TwoColsTable (a table with two columns), ThreeColsTable (a table with three columns) upto TwentyColsTable (a table with twenty columns) that can be used as required.

How to use Default Datatables

1. Click on the Table Definition tab of the attritubes pane of a node.
2. Select the Default Datatables radio button to select it.
3. Choose the required type of datatable.
4. Click on the SAVE button.

Custom Datatables

The user can create a datatable according to the requirements of the task.

Creating a Custom Datatable:

1. Click on the Table Definition tab of the attritubes pane of a node.
2. Select the Custom Datatables radio button to select it.
3. Click on the + icon to create a custom datatable.

4. Type the name of the datatable to be created. A default name Table1 appears in the Table Name field, which the user can change according to the requirements.

   Click on the + icon to add another custom datatable and the x icon to delete the required table.

5. Type the name of the columns to be created. A default name Col1 appears in the Column Name field, which the user can change according to the requirements.

   Click on the + icon to add more columns to the table and the x icon to delete the required columns.

6. Click on the SAVE button.