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

asked 24 Oct '22, 14:15

janklein's gravatar image

accept rate: 0%

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

permanent link

answered 26 Oct '22, 22:33

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 24 Oct '22, 14:15

question was seen: 419 times

last updated: 26 Oct '22, 22:33