Skip to main content

Control - Concat

Similar to the CONCATENATE function in Excel, a concat field combines values from multiple fields into a single value.
It is commonly used as a title field to help identify records using one unified field.

Field Configuration​

1. Add a Concat Field​

2. Select Fields to Concatenate​

You can combine:

  • Static text (manually entered)
  • Fields from the worksheet
  • Separators or connectors

After configuration, exit the form editor and create or edit a record to test.

If this field is used as a unique identifier, it is recommended to set it as the title field.

If the text contains URLs, enabling this option will render them as clickable links.
This option is enabled by default.

Result:

4. Usage Notes​

  • Supports Pinyin sorting
    When enabled, Chinese content can be sorted alphabetically (A–Z) based on Pinyin.
    Note: When Pinyin sorting is enabled, the sorting index will not take effect.
    If not needed, it is recommended to leave this option disabled.

  • Auto-updated field
    The concat field updates automatically based on its source fields.
    It cannot be manually edited, imported, or modified via workflow.

  • Using related record values
    If you need to use data from related records as a title, first concatenate the relationship field, then set the concat field as the title field.

  • Ensuring unique titles for workflow tracking
    When reviewing workflow execution history, identical title values can make it difficult to identify which record triggered the workflow.
    To avoid this, concatenate the original value with the record creation time or another field to ensure uniqueness.

Was this document helpful?