Combine the field values of the specified fields in the retrieved records into a single string using a delimiter. You can reuse the result of the combination in other Actions.
Set Select Record Action, Field to Concatenate, Delimiter, Target Field (Optional), and If no records.
Open the list of Actions and select the Action you used to retrieve the target records.
Select the field in the table that has the value you want to combine. This parameter accepts the following field types:
Specify the delimiter. Optional, and if omitted, will be concatenated without any separator.
To separate by line breaks, you can write it as follows using an expression:
= "\n"
Ignore Empty Value: For example, concatenating “A,” “(empty),” and “B” with the delimiter will result in “A,,B”
Don’t Ignore Empty Value: For example, concatenating “A,” “(empty),” and “B” with the delimiter becomes “A,B”
Use this parameter to set the results to another field. You can omit this parameter if you do not set the results directly in the field but use it in another action.
This parameter accepts the following field types: Fields in tables cannot be selected.
Select the action when there are no rows in the table. Based on the selection made, the value and result value for the action entered in the “Target Field” when no rows in the table will be as follows:
| Parameter Value | Value to be set in the “Target Field” | Action Result |
|---|---|---|
| Set nothing | Do not change the value of the field | undefined |
| Set blank | Clear the value | undefined |