Use this action to apply a field formula to set the value of one or more columns for every row in a data table. This action always creates a new data table with the results to avoid unexpected overwriting.
To apply formulas to a CSV the same way, use the CSV: Apply formulas to columns action. CSVs process faster and support higher row limits.
This action takes a formula from the row formula field and executes it for every row. For example, the table below has a
Quantity column, and two empty columns,
A simplified example of the notation is
Destination column = Column A + Column B, like
Total Column = Price * Quantity. All columns used in the formula must exist in the table; new columns can’t be added with this action. Here are some example row formulas:
|Example row formula||Row formula effect||Result|
||Remove all commas from the
Using the last example,
columns['Total'] = columns * columns;columns['Formatted Total'] = '$' + columns * columns + '.00'
Formatted Total columns are set in one row formula, with the result of:
Use the formula notation:
Destination column = rowIndex to quickly assign row numbers to every row. Easily join tables by using a related column between them.
Using the syntax above, add a row number to the column
Row Number with the following formula:
columns['Row Number'] = rowIndex
- Select a table from a list of all tables available on your team. The list only includes tables you have permission to view.
- Enter the row formula to apply to the data table column. Use a combination of columns, text, and fields.
Reference columns in a formula by their name
columns[‘Column Name’]or order
columns, with 1 being the first column.
To quickly add row numbers to every row in a table, see the Add row numbers to make joining tables easier below.
- Enter the name of the field in which the new table should be saved.
The expected output for this action is a new data table with any row formulas applied. The name of the output field will be the Output table name defined during configuration.
Since row formulas will automatically fill all rows in a column, a new table is always created. This action will never edit the source data table.