Skip to main content

Control - Concat

Function: Similar to the CONCATENATE function in Excel, you can select this control to stitch together the contents of other different fields into a new field value, often set as a title field.

Effect:

Configuration​

1. Add a concat control​

2. Select the field to be spliced​

The content to be spliced can be manually entered fixed characters, fields in the worksheet, separators, connectors, and so on.

After the configuration is complete, close the design page and add or edit a record to test.

If the field is a unique identification field, it is recommended to set it as a title field.

If the text contains a link, the link will be displayed after parsing, and you can click it to open the link. [Parse Links] is checked by default, and links are not parsed if it is unchecked.

Effect:

4. Notes​

  • Concat fields cannot be edited, imported, or modified through workflow, since it automatically changes according to the content of the spliced fields.

  • If you need to select the associated record as the title, you can first splice the associated field with a concat control and then set the concat field as the title field.

  • Sometimes it is necessary to troubleshoot the running history of the workflow, if the content of the title field may be the same, the data that triggered the workflow will also be the same, so that it is impossible to accurately locate which record triggered. This can be solved by choosing a concat control to splice the original content and the creation time of the record, or other fields, as a unique title field.

Have questions about this article？ Send us feedback