Concatenate: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=Concatenate |titlemode=append |keywords=user fields, directory value set, concatenate, !concatenate |description=Concatenate }} 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:...") |
No edit summary |
||
| Line 9: | Line 9: | ||
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: | 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: | ||
*'''<nowiki>''' — 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): | *'''<nowiki>{{Task.Services provided.</nowiki><span style="color:green;">!concatenate</span>}}''' — 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 | dent repair,filler application,painting | ||
You can specify your delimiter, for example, a comma with a space. To do this, specify the additional attribute | You can specify your delimiter, for example, a comma with a space. To do this, specify the additional attribute «::delimiter="delimiter_value"»: | ||
*'''<nowiki>''' — all variable values from the first column of the directory will be displayed in one line, separated by a comma with a space: | *'''<nowiki>{{Task.Services provided.</nowiki>!concatenate<span style="color:green;">::delimiter=", "</span>}}''' — 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 | dent repair, filler application, painting | ||
| Line 21: | Line 21: | ||
The same rules apply to internal fields of the directory entry: | The same rules apply to internal fields of the directory entry: | ||
*'''<nowiki>''' — all values of the "Supervisor" field will be displayed in one line, separated by a comma without a space: | *'''<nowiki>{{Task.Services provided.</nowiki><span style="color:green;">!concatenate</span>.Supervisor}}''' — all values of the "Supervisor" field will be displayed in one line, separated by a comma without a space: | ||
Smith,Carter,Anderson | Smith,Carter,Anderson | ||
| Line 27: | Line 27: | ||
You can also specify an additional attribute - "delimiter": | You can also specify an additional attribute - "delimiter": | ||
*'''<nowiki>''' — all values of the "Supervisor" field will be displayed in one line, separated by a comma with a space: | *'''<nowiki>{{Task.Services provided.</nowiki>!concatenate.Supervisor<span style="color:green;">::delimiter=", "</span>}}''' — all values of the "Supervisor" field will be displayed in one line, separated by a comma with a space: | ||
Smith, Carter, Anderson | Smith, Carter, Anderson | ||
Revision as of 09:36, 28 February 2024
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