Last Updated: Mar 8, 2023
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.
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.
Visual types for the respective columns are selected from the Field Types.
The alias name provided for the Jiffy tables/Document tables, its columns (including the Inline table) is displayed in the presentations, filters and forms.
If no alias names are provided for table name or its columns, then the original names are displayed.
Original names to be used in tasks.