Customize

Combine Field Values in Records Into Single String by Providing Conditions

Summary

Combine the field values in the fields of the retrieved records matching the specified conditions into a single string using a delimiter. You can reuse the result of the combination in other Actions.

How to use

Parameters

Set Select Record Action, Field to Concatenate, Delimiter, Ignore Empty Value or not, Field for Judgement, Criteria, Comparison value, Target Field (Optional), and If no records.

Select Record Action

Open the list of Actions and select the Action you used to retrieve the target records.

Field to Concatenate

Select the field in the table that has the value you want to combine. This parameter accepts the following field types:

• Text
• Number
• Calculated
• Drop-down
• Link
• Date
• Time
• Date and time
• Lookup (Text)
• Record number
• Created datetime
• Updated datetime
• Status

Delimiter

Specify the delimiter. Optional, and if omitted, will be concatenated without any separators.

To separate by line breaks, you can write it as follows using an expression:

= "\n"

Ignore Empty Value or not

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”

Field for Judgement

Select the field to be used for condition judgment from the app’s fields. Fields in tables cannot be specified.

Criteria

Select a criteria from the options.

• For details for the criteria, refer to List of field criteria.
• For details on comparisons for “equal” and “not equal,” refer to How to Assess the Equality of Field Values.
• For details on greater and smaller comparisons, refer to Here.

Comparison value

Enter the value to compare the field’s value. The parameter accepts the following inputs:

• Direct input
• Formulas (for details, refer to How to Write Formulas)

Target Field (Optional)

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.

• Text
• Text area
• Rich text

If no records meet the conditions

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

If there were no records as a result of the “Select Record Action”, it will be considered as “no records matching the criteria” and will result in the action selected here.