All Collections
Help Articles
Reporting in ETO
Functions and Formulas
ETO Results | Formula: Combine or Concatenate Data
ETO Results | Formula: Combine or Concatenate Data

BO 4.3 Platform

Updated over a week ago

When working in ETO Results, you may need to combine or concatenate data. This is helpful for actions such as making new Identifiers, changing name formatting, or even formatting a date differently.

There are a few methods to do this. If you are trying to combine any type of object or number with text strings, you can just put a plus sign (+) between the two (or more) objects or text strings you are trying to concatenate.

For example, let's say you are counting students that went on a trip in a variable called [Students]. You could set up the formula like =[Students]+" Total Students."

If the total number of students is equal to 14, the variable would show "14 Total Students" because the number of students in the [Students] variable would be concatenated with the text string "Total Students."

If you need to concatenate two numbers, on the other hand, you cannot use the plus sign. This is because it would just give you a sum of the two numbers. Instead, you could use the Concat function. For example, if we're trying to add a TouchPoint ID and Response ID to make a new identifier, we could make a variable saying =Concat([TouchPoint Unique Identifier];[Response Unique Identifier]). If the TouchPoint ID is 635 and the Response ID is 154, this formula would give us "635154."

Did this answer your question?