LimeSurvey version: Version 3.27.26.oecd.8
Survey theme/template: oecd
==================
Hi, I have a semi-limited experience working with LimeSurvey and has come across a difficult issue to solve. 

I have solved how to re-use (feed) answers from Q.1. (multiple short text) into a Q.2 (array (text))

Here are the details: 

Q.1. Is asking the names of organisations 1, 2, and 3 (...) 

Q.2 is asking follow up questions about the organisations 1, 2 and 3 (...) listed in Q.1. 

However, sometimes the names listed in Q.1 for organisation 1, 2 and 3 are the same. If organisation 2 and 3 are the same in Q.1. I only want the name of that organisation to be listed one time in Q.2. I.e. I want to only re-use the unique names provided in Q.1., and for those to populate my array question Q.2. 

Is there a way to do this, and if so how?

I hope you understand what I'm asking and sorry if it's any confusing  Very thankful for any type of assistance! 

 

Please, attach a small sample (lss export) of these relevant questions.

Joffm

Here is a copy of survey (it is a test version and only includes 2 questions + one equation)  

Well,
how do you want to decide if two entries are equal?
If somebody enters "Fire Fighters of NSW" and "Fire Fighters of New South Wales"?
Or "The Irish Gardeners Association" and "Gardeners Association".

And I am sure you are only interested in a certain subset of ALL organisations of the world.
Therefore I propose to use an autocomplete question which forces that all entries are unique.
And additionally with dynamic rows

Like this






Here the sample survey
 

The jquery files you find in the internet
and the csv-file is a simple file with one organisation per row.
like
 

Joffm

 

And here an example with an arry instead of a csv file (countries of the world)
and without dynamic rows.

 

 

Joffm
 

If somebody enters "Fire Fighters of NSW" and "Fire Fighters of New South Wales"?
Or "The Irish Gardeners Association" and "Gardeners Association".

Hahahahaha, this reminds me of Monty Python's "Life of Brian"...

Sorry what you’ve provided is good but does not answer the need I have. 

The actual Q.1 will ask:

Which organisations are responsible for the  following areas? 

Area 1: *answering name of organisation responsible for area 1*
Area 2: : *answering name of organisation responsible for area 2*
Area 3: *answering name of organisation responsible for area 3*

The same organisation can be responsible for several areas, let’s say area 1 and 3. For the topic I’m working on this is quite common. When there is the same name for two different areas most people will copy paste what they wrote so while I enjoy the monty python reference the event that they write the same name differently might not happen - but I understand it can.  If it happens a few times it’s not too problematic put not ideal. 

It might be more clear now that I don’t want to remove duplicates in Q.1 because that would mean I’d loose information relevant to the survey. Instead I want Q.2 to only populate the unique names answered and listed in Q.1 for me to ask follow up questions about the organisations 

If you have an alternative way of doing this more intuitively I’m open for it but please note I need the info in Q.1 to remain as it’s relevant for the project. Q.2 needs to be configured if possible 

thank you! 
 

Oh, I see, now it is more clear.
The question is, how many subquestions ("areas") will be there.
Here you talk about three, but your first example showed 11.

You can do this by some (or some more) equations.

I will think about it an send an example.
But not tonight.

Joffm

Actually there are quite many areas… which I understand might cause some difficulties. They are around 78 in total. 

This test example one only has 11 yes.

Thanks! extremely helpful 

Hi,
I will send a solution tomorrow.
Just a bit more of fine tuning necessary.





Joffm

That’s amazing thank you! Looking forward to see how you did that. 

 

Here is the sample with two ways to display.

 

Joffm

To add an explanation:
The first "#" is used to avoid that a valid result of strpos is "0".
You see, there are two meanings of "strpos==0"
1. found at index "0" (the count starts at 0)
2. not found

Hello Joffm, 

Thanks a lot for this. Would it be possible to use an Array(numerical input) with checkbox Q. style instead of Array (text) for the sub-question Q.2? Currently the unique names are fed into the first answer column of the array text question, but for an array with checkbox layout the names would need to feed into the Y sub-question scale? 

I would want to do something like this:

Q.1. Which org are responsible for the following areas?
Area 1. *Name of organisation 1*
Area 2: *Name of organisation 2*
Area 3: *Name of organisation 1*
Area 4: *Name of organisation 2*

Q.2. Please check the box if the following statements are true:  

Column 1(The org has X in place) Column 2 (The org has Y in place) Column 3 (The org has Z in place) Column 4 (The org is in group W)

Would this work? Alternatively if the array with checkbox layout is too complicated multiple follow up array-style sub-questions would also suffice...

Thank you again for all the support on this...

Currently the unique names are fed into the first answer column of the array text question

Oh, no,
didn't you see group G3?