Welcome to the LimeSurvey Community Forum

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

How can I know who has responses for my survey ?

  • OngJunYew
  • OngJunYew's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 9 months ago #201320 by OngJunYew
Hi, can I know how to get to know that who has responses for my survey after they been completed. I have check the response table but there are only column of fields that include (id, submitdate, startlanguage, seed, startdate, datestamp, ipaddr, refurl, questioncode). With all of these column fields, how can I know who has complete the survey. Maybe I can get the participant id, firstname lastname, email as the foreign key of response table to know who has complete this survey.




Thank You.
Attachments:
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 9 months ago - 3 years 9 months ago #201323 by Joffm
Hi,
you want to directly access the database.
Well, in a not anonymous survey you can merge "lime_survey_123456" and "lime_token_123456" by the token.
And if "submitdate" is NULL the survey was not completed.

In an anonymous survey the token column is not filled. This is obvious.

In the GUI the table of answers automatically merges these two tables.

If you only want to know who answered, who did not you may use the table "lime_token_123456".
Here you find all data if the participant and the field "completed". Either "N" or date of completion.



Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 3 years 9 months ago by Joffm.
The topic has been locked.
  • OngJunYew
  • OngJunYew's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 years 9 months ago #201324 by OngJunYew
Replied by OngJunYew on topic How can I know who has responses for my survey ?
Hi thanks for your responses, then is there any way to show the participant that has been responses or complete my survey ?
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 9 months ago #201325 by Joffm
What exactly and where do you want to display?

As I said (in non anonymous surveys)
You may query the database with a simple
"select t.*, s.* from lime_token_123456 t, lime_survey_123456 s where (t.token=s.token)"

And add a " and (s.submitdate IS NULL)" to get all who did not complete so far.

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose