A Jiffy table can be created using the existing schemas like Email, Email Attachments, File Explorer, etc, or using a new schema. The data in the Jiffy table can be updated manually or by automation.

The data in the table can be added or edited from the [Presentation](/developer_guide/presentations/about-presentations/) section using [Forms](/developer_guide/forms/).

Creating Jiffy Tables

Using New Schema

To create a Jiffy table with a new schema, do the following:

1. Click on the + icon on the Datasets listing page and choose the Jiffy Table option.

2. In the Create Jiffy Table dialog box that opens, specify the following details:

   1. Name: Name of the Jiffy table. The following messages are displayed for the below error scenarios:

      Error Messages	Description
      Please provide Jiffy Table name	When the user tries to create a Jiffy table without providing the name.
      ‘Jiffy Table’ name already exists, please provide a unique name	When the user provides a duplicate Jiffy Table name
      Invalid Name, use characters [(a-z), (A-Z), (0-9), _, -, space ]	If a user provides the Jiffy table name that contains characters other than [(a-z), (A-Z), (0-9), _, -, space]
      Please input up to 25 characters	If the length of the Jiffy table name exceeds 25 characters

   2. Schema: Select the New Schema option in this drop-down.

   3. Column: Name of columns. Default columns - UUID, Created By, Created Date, Updated By, Updated Date, Execution State are displayed by default.

      Use the drag handle to re-order the columns.

      • Add new column: Click on the + icon (1) next to the last column to add another column.
      • Delete column: Click on the x icon (2) next to the required column to delete a column.

   4. Field Type: A drop-down to assign a visual type to the respective columns. The options available are:

      • Singleline: Text in a single line.
      • Numeric: Numeric fields will support decimal values up to 3 numbers.
      • Select: If the field type for a column is set as Select,
        • The values for the select options must be given.
          • Click on the + icon (1) to add more options.
          • Click on the x icon (2) to remove the existing options.
            
      • Image Cell: This field is used to upload various types of image files.
      • Attachment: This field is used to attach multiple files at once.
      • URL: This field is used to attach URLs to the field.
      • Date: A calendar popup is displayed to select the date and the system stores the date value in the default format recognized by the system.
      • Table: This is used to add inline tables to the existing Jiffy table. If the field type for a column is set as Table,
        • Click on the Edit icon (1) to add an inline table. When the Edit icon is clicked, the table name is shown on the top, and the UUID column will be auto-populated.
        • Click on the + icon (1) to columns inside the inline tables.
        • Inside the inline tables, columns of the Table type can be added up to four levels.
        • The bread crumbs at the top (2) indicate the current level of the column.
      • Datetime: A calendar popup is displayed to select the date and time. The system stores the date value in the default format recognized by the system.

3. Click on the CREATE button to create the Jiffy table.

4. The newly created Jiffy table is displayed in the Datasets listing screen.

Using Existing Schema

Existing schemas are the predefined formats of tables 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.

To create a Jiffy table with any of the existing schemas, do the following:

1. Follow steps 1, 2 (i) from the Create Jiffy table with a new schema section.
2. Select any one of the existing schemas from the Schema drop-down. For example, Invoice.
3. The columns that were pre-defined for the existing schema appear automatically.
4. Click on the CREATE button to create the Jiffy table.
5. The newly created Jiffy table is displayed in the Datasets listing screen.

View Jiffy Tables

The newly created Jiffy tables will be listed in the Datasets listing page. To view the Jiffy table schema with the details of the columns, click on the name of the Jiffy table in the Datasets listing screen.

The following actions can be performed on this page:

• Adding data into the table: Click on the + icon (1) to add data into the table. A dialog box appears with the created / selected schema. Type the data into the respective fields and click on the SAVE button to save the data.
  

• Editing the data: Click on the Edit icon (2) next to the required row to edit the data in that row. Edit the details and click on the SAVE button to save the data.
  

Use the highlighted arrow buttons to navigate to the previous and the next row of data.

• Duplicating the data: Click on the Duplicate icon (3) next to the required row to duplicate that row. Another row with the same details is added to the table.

• Deleting the data: Click on the checkbox icon (4) next to the required row to select that row. Click on the DELETE button (6) at the bottom of the page to delete the select the row. In the Are you sure you want to delete the row permanently option, click on the YES button.

This can be done for one row at a time or multiple rows at once.

• Unlocking the data: When a task is being executed using the rows in the Jiffy table, the rows will be locked. The rows need to be unlocked to modify the data, if required. To do this, click on the checkbox icon (4) next to the required row to select that row. Then click on the UNLOCK button (6) at the bottom of the page to unlock the rows. This can be done for one row at a time or multiple rows at once.

• Editing the table schema: To edit the schema of the table, click on the More icon (7) at the top of the screen. Click on the Table Properties option. In the Migrate Jiffy Table dialog box that appears, do the required modifications. Click on the MIGRATE button to migrate the data in the table to the updated schema.

• Sorting the data: The rows in the table are arranged in the last modified first order by default. They can be rearranged in alphabetically Ascending or Descending order for each column by clicking on the More icon (8) against the name of the column.

The following nodes can be used to insert/update the data: Dataset, Jiffy Select, Jiffy Insert/Update, Delete Row, Unlock Row