Concatenate Connected Data
This action will concatenate information from connected records.
![Screen Shot 2022-08-15 at 17.21.15.png 754](https://files.readme.io/b0f92a4-Screen_Shot_2022-08-15_at_17.21.15.png)
With the action “Concatenate Connected Data”, you can concatenate information from connected records automatically when the chosen trigger is activated.
Trigger -> Action
The most important thing about a trick is understanding its conditions and actions. They have a simple generic structure:
When the condition (trigger) happens, then do (action).
Trigger -> Action
How to create
You just have to click on the "+ Automations" icon on the upper right corner of the screen to open the No code automations panel, and then on the "+ Create new automation" button:
![Screen Shot 2022-08-15 at 18.08.43.png 464](https://files.readme.io/63c93a7-Screen_Shot_2022-08-15_at_18.08.43.png)
Select the trigger of your choice to activate the action, then select the "Concatenate Connected Data" action, and fill in the options:
- Choose table to get data from:
- Select the table that has a connected field to the record you wish to update
- Choose field to get data from:
- Choose the field that holds the data that will be concatenated
- Choose the connected field:
- Choose the field that points to the record that will be updated
![Screen Shot 2022-08-22 at 15.19.54.png 788](https://files.readme.io/4b4e7dc-Screen_Shot_2022-08-22_at_15.19.54.png)
- Choose table to be updated:
- Choose the table that holds the record that will be updated
- Choose field to be updated(optional):
- Choose field to receive the concatenated data. If no field is chosen, record won't be updated and concatenated data will be returned for posterior actions.
- Choose record to be updated/used to aggregate:
- Write or select the id of the record to be updated
- Write separator:
- Write text to be inserted between connected data (example: "," will put a comma before each data input).
Click on save
![Screen Shot 2022-08-22 at 15.20.50.png 788](https://files.readme.io/cb5a2a7-Screen_Shot_2022-08-22_at_15.20.50.png)
Updated almost 2 years ago