Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Problem linking individual participant responses between two surveys

  • HelenNorris
  • HelenNorris's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 11 months ago #240765 by HelenNorris
Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen] First survey is LimeSurvey Cloud 5.6.4
Second survey is hosted on Gent University's LimeSurvey platform, Version 2.05
Own server or LimeSurvey hosting:
Survey theme/template: Fruity
==================
Hello, 

I am collecting data in a classroom setting, 30 adolescents at a time, anonymously.
The first survey is one I created, using LimeSurvey Cloud 5.6.4 where data is collected about reading habits.
Participants then click on a link to take them to the Geneva Emotion Recognition Test or GERT which is hosted on the Gent University's LimeSurvey platform, version 2.05.
I need to be able to match up the responses by participant for the 2 surveys.
I know this is pretty basic and yes, I have spent days trying to find the answer on all the forums/manuals but I have still failed to sort this.

This is what I have done:-

Survey 1
I added an equation question using {SAVEDID}
Code USERID

On the results table this gives me a column with the USER ID. Kind of redundant because it is of course the same number as the ID first column, but, anyway...

Then I've added a question to link to my second survey:-

limefppw.ugent.be/limesurvey205/index.php/survey/index/sid/522217/newtest/Y/lang/en/USERID

Survey 2 (GERT)

Here I added another question at the start of the GERT

Question code USERID

I then tried both text display and equation with {USERID}

In the exported results, I can see the column USERID but it's empty.

I don't fully understand how the {SAVEDID} or the adding the question code onto the end of the link url works and clearly, I'm doing something wrong.

Please can you help? I've read the manual several times but I seem to be misunderstanding something.... or maybe many things. But I assure you, it's not for the want of effort or time spent!

Thank you very much,

Helen
 

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 11 months ago - 1 year 11 months ago #240769 by Joffm
Hi, Helen,

I added an equation question using {SAVEDID}
Code USERID

Not necessary as the variable {SAVEDID} is always available

Kind of redundant because it is of course the same number as the ID first column, but, anyway...

Redundant because you doubled it.
Yes, in the database the column is called "id", but it is accessed in the survey by {SAVEDID}

And now your mistake:
limefppw.ugent.be/limesurvey205/index.php/survey/index/sid/522217/newtest/Y/lang/en/USERID

If you add parameters to an url you do this by a question mark for the first one and an ampersand for all following, like
...google.com?param1=ABC&param2=FGH
or in short
...google.com/param1/ABC/param2/FGH

You used an abbreviation with slashes.
It is equivalent to
...?newtest=Y&lang=en&USERID

You see the value of the parameter "USERID" is missing.

Should be:
...?newtest=Y&lang=en&USERID={SAVEDID}

or in short
.../newtest/Y/lang/en/USERID/{SAVEDID}

Now you can capture the parameter as you did and you get the value of {SAVEDID}

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 1 year 11 months ago by Joffm.
The following user(s) said Thank You: HelenNorris

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 11 months ago #240774 by tpartner
In version 2.05, were you able to use question codes as URL parameters or did you need to use SGQA?

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: HelenNorris

Please Log in to join the conversation.

  • HelenNorris
  • HelenNorris's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 11 months ago #240837 by HelenNorris
I've made those changes and it works!
So relieved.
I did find that I needed to move the USERID question away from the beginning of the GERT (Survey 2). I'm not sure why, but when I moved it to a few questions in, I could see the USERID from the first survey in its own column in the data.

Thank you very much. I've learnt some more things. Only the tip of the iceberg, I guess, but every little helps.

Please Log in to join the conversation.

  • HelenNorris
  • HelenNorris's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 11 months ago #240838 by HelenNorris
Hi Tony,

The question code does appear to work. I'm not sure what SGQA means, though. 

Thank you to you both for being there and taking an interest.

From one relieved, old, PhD student!

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 11 months ago #240847 by tpartner

I did find that I needed to move the USERID question away from the beginning of the GERT (Survey 2).

USERID is only generated after the first survey page submission.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose