User Manual

10.03.2024

MANUAL

Formula (Extended): $CONCAT Function

## Overview Concatenate the specified strings. ## Syntax ``` $CONCAT(Text1,[Text2],...) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Text1|Arbitrary String|Required|| |[Text2],...|Arbitrary String|Optional|| ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Text1|Yes|Yes|Yes*1|Yes|Yes*2| |[Text2],...|Yes|Yes|Yes*1|Yes|Yes*2| *1: Output the format specified in "[Editor Format](/en/manual/table-management-editor-format)". *2: Output the string "True" or "False". ## Return Value Concatenated string. ### Return Value Display Content |Target|Display Content of Return Value| |:---|:---| |Classification (including title, status, manager, owner)|Display return value. If the return value is a half-width numerical value and is a drop-down list with values, display the options that match the return value| |Numerical Value (including work volume, progression rate, remaining work volume)|Display the return value only if the return value is a half-width numerical value. | |Date (including start and completion)|Display the return value only if the return value is in date format. | |Description (including content)|Display the return value. | |Check (including lock)|Do not display. | ## Usage Example ① Specify parameters by screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/50c2da76beeb4777b8039124492b48e3) ### Parameters ![image](https://pleasanter.org/binaries/477f9a0110c148ba8c730a6edc267817) ### Calculation Result ![image](https://pleasanter.org/binaries/37f2c78211a644f1b4c1349633c5868c) ## Usage Example ② Specify four parameters. ### Formula ![image](https://pleasanter.org/binaries/314eb8fe750e4bacb0b341730b31d52a) ### Parameters ![image](https://pleasanter.org/binaries/8cd9e76a1cb54efea335882f05f80242) ### Calculation Result ![image](https://pleasanter.org/binaries/7a320adcd32545318de0689085fa61a9)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.