Table
Last Updated: Mar 8, 2023
Last Updated: Mar 8, 2023
The following functions can be used for Table operations:
| Functions | Description |
|---|---|
| Get Table Row Count | Returns row count from the table |
| Get Table Value | Returns the element by both column and row number from the table |
| Set Table Value | Sets the element by both column and row number in the table |
| Search Value From Table | Searches for a specific value in the table |
| Empty Table | Deletes the contents of an existing table |
| Create Table Object for Table Definition | Creates an empty table for updating the table, use it before using ‘Set Table value’ expression. |
| Search Data in Table | Finds the row number of data in a table |
| Insert Data into a Jiffy Table | Inserts data into Jiffy Table |
| Insert Data into a Inline Jiffy Table | Insert data into the inline table of Jiffy Table |
| Update Data to the Jiffy Table | Updates the data in Jiffy Table |
| Insert Bulk Data into Jiffy Table | Insert multiple rows into the Jiffy Table |
| Insert Bulk Data into Inline Jiffy Table | Insert multiple rows into the inline table of Jiffy Table |
| Select Data from Jiffy Table | Select data from Jiffy Table |
| Insert Attachment into a Jiffy Table | Inserts the attachment into the Jiffy Table |
| Insert Attachment into a Inline Jiffy Table | Inserts the attachment into the inline table of Jiffy Table |
| Update Attachment of the Table Row | Update the attachments in Jiffy Table |
| Download Attachments from Jiffy Table Row | Downloads the attachment from Jiffy Table row or document table row |
| Delete Record (Jiffy Table) | Deletes records in the Jiffy Main Table or Inner Table based on the given UUID |
| Update Multiple Attachment of the Table Row | Update multiple attachments to the attachment field of the table row |