Extension Actions
Extension Actions are powerful field types that allow you to interact with Excel 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
- ⚙️ 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 file
📚 Excel Rows
Performs bulk actions on multiple Excel rows simultaneously.
📝 Description
This field type applies actions to all entries in your Excel file. ⚠️ Warning: This operation can take a significant amount of time when working with large datasets, as it processes every row in the Excel 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
✏️ 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 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 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 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 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