Code list multiple choice and subsequent concatenation of code label

  • Asked
  • Active
  • Viewed 1582 times
0

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

0

Accepted answer

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

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.