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.

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

Hi thanks for your responses, then is there any way to show the participant that has been responses or complete 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