Returns a string created by concatenating of any number of strings or question references.
Concat( p, p, .., p[n] )
p[n] An expression or value to be concatenated, which may include equations, question references and function calls.
Build a sentence:
This example shows the Concat() function being used to build a typical sentence.
Concat([q1.firstName], " has ", [q7.NumberChildren], "children")
or to handle the plural
Concat([q1.firstName], " has ", [q7.NumberChildren], iif(isequal([q7.NumberChildren],"1")," child"," children"),".")
Assuming ‘John’ has two children the concat() function would return: John has 2 children.
format sentence joinif join first firstname numberchildren number children