Definition and Usage
Write to row allows you to write, insert, or append values to a specific row in a data table. This command provides flexibility in how data is added to tables by supporting different write modes and input methods.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Data table | Select an existing data table or create a new one |
| Yes | You can create a new sheet by clicking the "Add New Sheet" button |
Write mode | Select how to write data to the row | Append, Insert, Overwrite | Yes |
|
Row | Specify the row number. Use 1 for the first row, or -1 for the last row |
| Yes |
|
Input mode | Choose how to input data | Entire row, Specified column(s) | Yes |
|
Value | Define column and content pairs when using Specified column(s) mode |
| Yes | When using "Specified column(s)" mode |
Value to write | Enter values to write |
| Yes | In Entire row mode, ensure the number of values matches the target table's columns |
Append to end if out of range | If the row number doesn't exist, a new row will be added at the end |
| No | This is enabled by default |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
You can use variables in any parameter field where you see the {x} icon. This allows you to dynamically set values based on previously defined variables. For example, you can use a variable to specify which row to write to or what values to insert into the table.
Notes
When using "Entire row" input mode, make sure the number of values matches the number of columns in the target data table to avoid errors.
The "Append to end if out of range" option ensures that data will still be written even if the specified row doesn't exist by adding it to the end of the table.
The "Row" parameter accepts negative values, where -1 represents the last row in the table.
Different write modes offer different behaviors:
Append: Adds values at the end of the specified row
Insert: Creates a new row at the specified position
Overwrite: Replaces existing values in the specified row