---
title: "Code list multiple choice and subsequent concatenation of code label"
url: "https://openforis.support/questions/3456/code-list-multiple-choice-and-subsequent-concatenation-of-code-label"
tags: ["collect"]
status: "answered"
score: 0
answer_count: 1
asked: "2022-10-24T14:15:42"
last_activity: "2022-10-26T22:33:21"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Code list multiple choice and subsequent concatenation of code label

Asked by janklein on 2022-10-24

Dear OF team,

I wish to select multiple entries from a code list and subsequently concatenate the code labels in another field.

As an example, I have a list of all my 10 colleagues amongst which I want to chose the current field team members inventorying the sampling unit. Each entry corresponds to a colleague with first and last name: '1 - A.Lastname1' until '10 - J.Lastname10'.

Let’s say, only three persons take part in the survey on that day, so I select ‘1 - A.Lastname1, ‘4 - D.Lastname4’ and '10 - J-Lastname10' on my phone.

My final result should be a concatenation of these names, calculated in the background in a second field named ‘collectors’. In this case, the ‘collectors’ field should look like this: ‘A. Lastname1; D.Lastname4; J.Lastname10’, i.e., the code labels separated by a semicolon.

I am currently clueless how to code this in OpenForis.

Many thanks in advance for any help regarding this.

Best,
Jan


## Answer (score 0, by Stefano (OF) on 2022-10-26)

Link: https://openforis.support/questions/3456/code-list-multiple-choice-and-subsequent-concatenation-of-code-label/3468

Dear Jan,  
There is not such a possibility now in Collect... what you could do is to do this concatenation in Excel, after exporting the data and selecting `Include code item label column` in the `Additional Options`. Every item selected for the multiple code attribute will have a column with the value and another one with the label; you could do something with those columns, but only after the data has been collected.  
Many thanks,  
Open Foris Team