You can perform various operations using the data processing function. You can perform mathematical calculations across all values in a column, as well as correlate values when entries in two different tables are identical.
You perform data processing operations either manually or by automation. How exactly manual execution works, you will learn in this article. You can find detailed information about execution via automation here.
Execution of a data processing operation
- Open any table where you want to perform a data processing operation.
- Click on the three dots in the view options.
- Click on Data Processing.
- Hover the mouse over an already created data processing operation that you want to perform.
- Click the play icon.
- After successful execution, a green checkmark appears instead of the play icon.
Consequences of execution
Each time the data processing operation is executed, the results are written to the results column regardless. If you do not want to overwrite any data, you should create a new empty column for the results in advance.
Unlike formula columns that permanently monitor the columns involved, result columns do not update themselves. Changes to the values in the source column do not affect the values in the result column without automation or re-execution.
Therefore, to prevent misunderstandings, we recommend that you do not make any manual changes to the columns involved and lock them for editing after execution for security (requires a Plus or Enterprise subscription).
Be aware that the calculated values are a snapshot at the time of execution. If you do not execute the operation again, the results may be outdated if the values in the source column have changed in the meantime.