Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: Identifying users who complete the survey and those who screen out!

Identifying users who complete the survey and those who screen out! 1 Jahr 1 Monat her #93916

  • MRFGR
  • MRFGRs Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 18
  • Karma: 0
Hi there

I hope you're well and I hope this make sense.

I need to be able to identfy users who sucessfully complete a survey and those who are screened out. If possible is there away of seeing a completion page and a not suitable page (perhap with different urls)?

Just so you know, the reason why I would like to do this is because we are linking this to another application, where we woud like to offer points for users who successfully complete a survey. We do not want to filter the results afterwards, is there a way of knowing immediately? i.e a successful live link and a screened out live link?

I hope this make sense.

Many thanks
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Identifying users who complete the survey and those who screen out! 1 Jahr 1 Monat her #93918

  • mdekker
  • mdekkers Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 340
  • Dank erhalten: 68
  • Karma: 38
Check out the manual on quota, this is probably what you are looking for. If I remember correct, the completion status will be 'Q' if the survey was 'completed' due to quota.
---
Menno Dekker
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Identifying users who complete the survey and those who screen out! 1 Jahr 1 Monat her #93921

  • tfj
  • tfjs Avatar
  • OFFLINE
  • Expert Lime
  • Beiträge: 80
  • Dank erhalten: 6
  • Karma: 5
MRFGR:

I am not certain what you mean by "screened out," but if you mean users who do not complete the survey, I think I can help.

There could be two approaches, one using a SQL query (since I use MySQL) and one using the end URL and a PHP script.

1) SQL query: I use an SQL query to delete records that have been left incomplete for at least 5 hours and run the query every 3 hours, using a task scheduler. Here is an example of one of these queries:


DELETE
FROM
[Your survey table name]
where
(timestampdiff(hour, [Your survey table name].startdate, now()) >= 5)
AND
([Your survey table name].submitdate is null);


2) End URL and a PHP script:

Through the LimeSurvey End URL setting, you could pass the identifying information about the user to a PHP script that would populate a table immediately. The advantage of this approach would be that you would know right away who completed a survey by reviewing the populated table.

Not knowing the details of your survey, etc., you can find plenty of helpful hints about the End URL setting through the forums and through the LimeSurvey documentation.

Also not knowing your level of comfort with SQL scripts or PHP, the approaches above may not be helpful to you. I have found, though, that using SQL scripts and PHP to supplement LimeSurvey has brought to it a whole new level of possibilities. Others on this forum also have found JavaScript to be very useful.

tfj
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Identifying users who complete the survey and those who screen out! 1 Jahr 1 Monat her #93923

  • tfj
  • tfjs Avatar
  • OFFLINE
  • Expert Lime
  • Beiträge: 80
  • Dank erhalten: 6
  • Karma: 5
MRFGR:

Yes, mdekker's suggestion is a better one than mine, if it is what you meant by "screening out."

tfj
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Identifying users who complete the survey and those who screen out! 1 Jahr 1 Monat her #93926

  • holch
  • holchs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 2445
  • Dank erhalten: 254
  • Karma: 94
@tfj: "Screening out" is quite a normal term ((in market research) for excluding respondents from the questionnaire because the do not match certain (screening) criteria.

E.g. if you only want to interview respondents between 18-60 years old, everyone older and younger will be "screened out".

@MRFGR: Yes, quota would be they right choice. You will need to set the quota to 0 (zero). Each quota has it's on "end page" and you can use a different end url for each of them.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Identifying users who complete the survey and those who screen out! 1 Jahr 1 Monat her #93933

  • tfj
  • tfjs Avatar
  • OFFLINE
  • Expert Lime
  • Beiträge: 80
  • Dank erhalten: 6
  • Karma: 5
Thanks, holch!

I jumped in too quickly to help . . .

tfj
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Identifying users who complete the survey and those who screen out! 1 Jahr 1 Monat her #93934

  • holch
  • holchs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 2445
  • Dank erhalten: 254
  • Karma: 94
No problem. Better jumped in too quick or to often than never. ;-)
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Identifying users who complete the survey and those who screen out! 1 Jahr 1 Monat her #93936

  • MRFGR
  • MRFGRs Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 18
  • Karma: 0
Hi Guys

I just wanted to say a big thank you for all your help, I believe we have sorted it now! :)

I will be in touch if I have any further questions.

Thanks again!
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Identifying users who complete the survey and those who screen out! 1 Jahr 1 Monat her #93940

  • holch
  • holchs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 2445
  • Dank erhalten: 254
  • Karma: 94
Just remember that the quota will only have effect when the survey is active, in preview mode they will not be triggered, because the answers are not saved.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.162 Sekunden
Donation Image