What is Jiffy Table

A Jiffy table is used to store data that is populated by automation tasks or added by the user through forms. The stored data is referenced/manipulated in the later stages of the automation process. Frequently changing data is stored in the Jiffy Table.

Presentations and Dashboards are built on the data in Jiffy Tables for quick decision and Inferences.

In a Purchase Order HyperApp, the purchase orders are stored in a Jiffy Table before sending out the Request for Quotation to the multiple Vendors. Quotes received from Vendors are updated in the Jiffy Table.
Presentations are created on the purchase order data in the table which helps in shortlisting the Vendor.

Columns

Default columns in the Jiffy Tables are UUID, Created By, Created Date, Updated By, Updated Date, and Execution State.

UUID: Universal unique identifier that identifies each record of the table

Execution State: State of the record. Default options are New, In Progress, and Completed. You could also add more values as needed.

Field Types

Visual types for the respective columns are selected from the Field Types.

• Singleline: Text in a single line.
• Multiline: Text in multiple lines.
• Numeric: Numeric values. 
• Select: To create a drop-down list. You can add options based on the requirement.
• Image Cell: To upload various types of image files (For example, PNG, JPEG). 
• Attachment: To upload various types of files (For example, PDF, doc). 
• URL: To enter the URLs. 
• Auto Generated: This field value will be automatically generated when a record is added.
• Datetime: A calendar popup is displayed to select the date and time. The system stores the date value in the default format that is, dd/mm/yyyy hh:mm:ss.
• Table: If multiple rows and columns of data related to one record in the parent table need to be added, a table is used.