CollectionsCollections Database

Join text values in a document

To join text values you can use the Join function in a formula. In this tutorual we'll use the included template Formula tutorial.

Open the app and tap on button (top-right corner on iOS, sidebar on macOS).

Join strings

Select Formula tutorial from the list.

Join strings

Tap on Create.

Join strings

Open the newly create collection.

Join strings

Tap on the button (top-right corner).

Join strings

Tap on Edit.

Join strings

Add a Formula field with the button.

Join strings

Select Text (the result is a text).

Join strings

Tap on Done.

Join strings

Open the newly created field.

Join strings

Assign a name such as Full name, then tap on Edit formula.

Join strings

The formula is empty. Tap on the button to add an expression.

Join strings

Scroll down and select Join. The Join function allows to join multiple strings.

Join strings

Tap again the button.

Join strings

Select Name from the list.

Join strings

Tap again the button.

Join strings

Select String.

Join strings

We're going to add a space between our Name and Surname fields. Type in a space character in the keyboard, then tap Done.

Join strings

Tap again the button and this time select Surname.

Join strings

The formula is completed, tap on Save to confirm.