Skip to content Skip to main navigation Skip to footer

Concatenate Questions

Concatenate questions are designed to combine the answers provided by Entrants in other questions, which can then be included in Reports and on the Viewing Interface. There might be many reasons why you need to request the data from Entrants across multiple questions, such as first name and last name. When displaying this information for Judges on the Viewing Interface, Admins might want to display a candidate’s name on one field, or even display a range of names in one field where a team of people has been entered. The concatenate question supplies Admins with a hidden field that can be used to combine the data.

How to Create a Concatenate Question

This section will look at the specific functionality of the Concatenate Questions. For information on how to create forms and all question settings see the Question List Guide.

Note – Concatenate questions will only work as Admin-Only fields. They can not be shown to the Entrants.

  • Value/Formula – the field in which the formula is entered
  • Insert question reference – insert a question into the Value/Formula input field, styled so that it will be used correctly

To create a value for the question, Admins need to select the relevant questions from the ‘Insert Question Reference’ drop-down menu. Each time a question is selected it will appear in the Value/Formula input field. The question name surrounded by square brackets will be replaced by the value supplied by the Entrant when the form is first opened by an Admin User. Therefore Admins should use characters and punctuation where appropriate to curate the desired result. For example:

[[Firstname]][[Lastname]] will be printed as JohnSmith. So Admins will need to add a space between the question names [[Firstname]] [[Lastname]] to result in John Smith.

Or for a combination of names: [[candidatename1]], [[candidatename2]], [[candidatename3]] and [[candidatename4]] will appear as Matthew, Lucy, Anna and Thomas.

The question can then be included in data exports or on the Viewing Interface.

Note – Only entries viewed by an Admin User will be included in the exports. If you wish to concatenate data that has not been reviewed or is in a submitted state then a bespoke report can be created.