Concatenate Connected Data

This action will concatenate information from connected records.

754754

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:

464464

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
788788
  • 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

788788