Extension Actions
Extension Actions are powerful field types that allow you to interact with Excel (.xlsx) data directly from your forms. These actions enable you to manipulate Excel entries, modify data, and perform bulk operations on your spreadsheet data.
Overview
Extension Actions provide the following capabilities:
- Single Row Operations: Perform actions on individual Excel rows
- Bulk Operations: Apply actions to multiple Excel rows simultaneously
- Row Freezing: Freeze the current Excel row for a specified duration
- Row Unfreezing: Unfreeze frozen Excel rows
- Data Manipulation: Set, get, and modify Excel column values
- Data Management: Mark entries as saved, delete entries, and refresh data
- Refresh Excel Data: Reload the Excel data in the extension
Excel Row
Performs actions on a single Excel row based on the specified row number.
Description
This field type allows you to apply specific actions to a single Excel entry. The row number can be specified either in the field value or in the default value of the field.
Field Options
| Field Options | Required | Example Values | Description |
|---|---|---|---|
| Actions | Yes | Marked as Saved Unmarked as Saved Delete | Action to perform on the row |
| Field Value | Yes | 1, 5, 10 | Row number to target |
Usage Examples
- Mark as Saved: Mark a specific row as completed/processed
- Unmark as Saved: Remove the saved status from a row
- Delete: Remove the entire row from the Excel (.xlsx) file
Excel Rows
Performs bulk actions on multiple Excel rows simultaneously.
Description
This field type applies actions to all entries in your Excel (.xlsx) file.
Warning
This operation can take a significant amount of time when working with large datasets, as it processes every row in the Excel (.xlsx) file.
Field Options
| Field Options | Required | Example Values | Description |
|---|---|---|---|
| Actions | Yes | Marked as Saved Unmarked as Saved Delete | Action to perform on the row |
| Field Value | Yes | 1, 5, 10 | Row number to target |
Performance Considerations
- Use with caution on large datasets
- Consider using Excel Row for individual operations when possible
- Bulk operations may take several minutes depending on data size
Excel Row Freeze
Freezes the current Excel row for a specified duration in minutes.
Description
This field type allows you to temporarily freeze the current Excel row. During the specified period, the row is locked or ignored to prevent other instances of the extension or concurrent runs from accessing or processing the same entry.
Field Options
| Field Options | Required | Example Values | Description |
|---|---|---|---|
| Minutes | Yes | 1, 2, 5 | The duration (in minutes) for which the current Excel row remains frozen |
Usage Examples
- Temp Lock Row: Freeze a row for
2minutes to avoid duplicate processing in concurrent execution environments.
Excel Rows Unfreeze
Unfreezes frozen Excel rows in the dataset.
Description
This field type allows you to unfreeze Excel rows that were previously frozen. You can configure it to unfreeze only those rows whose freeze time has expired, or unfreeze all frozen rows.
Field Options
| Field Options | Required | Example Values | Description |
|---|---|---|---|
| Unfreeze only those rows whose freeze time has expired? | No | Toggle ON/OFF | When enabled, only unfreezes rows whose freeze time limit has expired |
Usage Examples
- Unfreeze Expired Rows: Automatically unfreeze rows whose freeze duration has expired so they become available for processing again.
Set Excel Column
Sets or updates the value of a specific column in an Excel row.
Description
This field type allows you to write data to a specific cell in your Excel (.xlsx) file by specifying the row number and column/field name.
Field Options
| Field Options | Required | Example Values | Description |
|---|---|---|---|
| Entry Row Number | Yes | 1, 5, 10 | The row number where the data will be written |
| Entry Column/Field Name | Yes | Name, Email, Status | The column name or field identifier |
| Field Value | Yes | John Doe, [email protected] | The value to be written to the specified cell |
Usage Examples
- Update status fields
- Set completion dates
- Write calculated values
- Store form submission data
Get Excel Column
Retrieves the value from a specific column in an Excel row.
Description
This field type reads data from a specific cell in your Excel (.xlsx) file and can be used to populate form fields or perform conditional logic based on existing data.
Field Options
| Field Options | Required | Example Values | Description |
|---|---|---|---|
| Entry Row Number | Yes | 1, 5, 10 | The row number to read data from |
| Entry Column/Field Name | Yes | Name, Email, Status | The column name or field identifier to read |
Usage Examples
- Pre-populate form fields with existing data
- Retrieve previous values for comparison
- Load configuration data from Excel
- Implement data validation based on existing records
Modify Excel Column
Modifies existing values in Excel columns using various mathematical or replacement operations.
Description
This field type allows you to perform operations on existing Excel data, such as incrementing values, decrementing values, or replacing them entirely.
Field Options
| Field Options | Required | Example Values | Description |
|---|---|---|---|
| Entry Row Number | Yes | 1, 5, 10 | The row number containing the data to modify |
| Entry Column/Field Name | Yes | Quantity, Price, Count | The column name or field identifier to modify |
| Actions | Yes | Increase Value Decrease Value Change Value | Action to perform on the existing value |
| Field Value | Yes | 5, 10.50, New Value | The value to use for the modification operation |
Action Types
- Increase Value: Adds the field value to the existing cell value
- Decrease Value: Subtracts the field value from the existing cell value
- Change Value: Replaces the existing cell value with the field value
Usage Examples
- Increment counters or quantities
- Update running totals
- Modify status codes
- Adjust numerical values
Refresh Excel Data
Reloads and refreshes the Excel data in the extension.
Description
This field type forces the extension to reload the Excel (.xlsx) file data, ensuring that any external changes to the file are reflected in the current session.
Field Options
| Field Options | Required | Example Values | Description |
|---|---|---|---|
| None | No | N/A | No specific field options required - this action refreshes all Excel data automatically |
Usage Examples
- After external modifications to the Excel (.xlsx) file
- When switching between different Excel files
- To ensure data consistency across multiple form submissions
- After bulk operations that may have been performed outside the extension
