How do I perform string manipulation in Cflow?

Cflow provides a powerful String Concatenation feature that allows you to combine field values and constants to dynamically construct a string. This is useful for creating custom IDs, display labels, or even conditional values based on business rules.

From the Form Creation tab, when you click on a field and navigate to the Advanced tab, you can configure this logic using the Add Operation → String Concatenation option.

A condition is set first:

If Department is equal to “Finance”, then the concatenation rule will apply.

Under the logic builder:

The field Category is selected.

A substring operation is applied (0 characters from the start).

The Append operator is used – meaning this string will be appended to the final value.

Key Notes:

  • String manipulation is allowed on most data types except: Decimal, Identity, Integer, and Date.
  • You can concatenate multiple fields, static values, or substrings.
  • Conditional logic can be applied, enabling rule-based output (as seen in the “If Department = Finance” rule here).
  • Use the Add New option to stack more fields or values.

Example:

Let’s say you want to create a custom employee email ID when the department is Finance. You could concatenate the Employee Name and a static value like “@company.com” to auto-generate it.

This setup lets you automate field population and improve accuracy in form entries.