Concatenate
From Planfix
Set of directory values is a multiplying field when used in document templates.
In some cases, it is necessary to display a set of directory values in one row in documents, for example, a list of services provided. For this, use !concatenate in the document template variable:
- {{Task.Services provided.!concatenate}} — all variable values from the first column of the directory are displayed in the document, separated by a comma without spaces (this is the default setting):
dent repair,filler application,painting
You can specify your delimiter, for example, a comma with a space. To do this, specify the additional attribute «::delimiter="delimiter_value"»:
- {{Task.Services provided.!concatenate::delimiter=", "}} — all variable values from the first column of the directory will be displayed in one line, separated by a comma with a space:
dent repair, filler application, painting
The same rules apply to internal fields of the directory entry:
- {{Task.Services provided.!concatenate.Supervisor}} — all values of the "Supervisor" field will be displayed in one line, separated by a comma without a space:
Smith,Carter,Anderson
You can also specify an additional attribute - "delimiter":
- {{Task.Services provided.!concatenate.Supervisor::delimiter=", "}} — all values of the "Supervisor" field will be displayed in one line, separated by a comma with a space:
Smith, Carter, Anderson