& Operator: Concatenating Strings and Numbers
You can concatenate multiple fields by using the "&" operator.
When concatenating strings and numbers, you must use a half-width "&" operator. You cannot use a "+" operator for this purpose.
Fields That Can Be Concatenated with "&" Operator
When using the "&" operator to concatenate fields, you can specify the following field types for concatenation.
- Radio Button
- Date and time1
- Record created by
- Record updated by
- Record created datetime1
- Record updated datetime1
1: Use the DATE_FORMAT function to specify a formula.
2: If the Key Field is a Link field or a Lookup field (when the Key Field is a Link field), that field cannot be referenced by a formula.
This section describes the way to concatenate the Surname and the Given Name fields, by using an example of a company directory app.
Image of the completed app:
Click the app setting button on the upper right of the record view, and select the "Form" tab.
From the parts list shown in the left side, drag and drop two Text fields.
For the first field, specify "Surname" as the field name and the field code. For the second field, specify "Given Name" as the field name and "Given_name" as the field code.
Place the Text field to be used to display the result, and then change the field name to "Full Name" and the field code to "Full_Name_0".
Open the screen to set the "Name" field, select Calculate automatically, and then enter "Surname&" "&Given_name".
You must use half-width '&' to concatenate strings. When adding a character or a space, use half-width double quotation marks (" ").
Click Save on the field settings screen.
Click Save Form on the upper left side of the screen, and then click Update App on the upper right side of the screen.
Now, you can concatenate strings.
Enter values in the Surname field and the Given Name field, to check that the result is displayed in the Name field.
TIPS: If Empty Fields Are Included
Empty fields are concatenated as null strings.
For example, if you set a formula "Prefecture&Municipalities&Chome&Building_Name&" "&Floor" in the Address field, even when the Building Name is empty, other strings are concatenated.