- Posts: 36
- Thank you received: 2
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
- Topic Author
- Offline
- Junior Member
Less
More
3 years 9 months ago #201320
by OngJunYew
How can I know who has responses for my survey ? was created 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.
Thank You.
Attachments:
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12789
- Thank you received: 3940
3 years 9 months ago - 3 years 9 months ago #201323
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic How can I know who has responses for my survey ?
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
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 36
- Thank you received: 2
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12789
- Thank you received: 3940
3 years 9 months ago #201325
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic How can I know who has responses for my survey ?
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
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.