Completed Responses in the Database

More
4 months 4 days ago #181876 by rbernhardthki
Hi,

I am trying to make a refreshable spreadsheet so i don't have to download responses and copy them into a rolling report each week.

I am in the 'lime_survey_XXXXXX' table, but I can't see how completed and non-completed answers are differentiated.

First I thought it was the 'lastpage' column, but it doesn't work for 1 pager surveys.

I want only completed answers.

Thanks

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
4 months 4 days ago #181889 by tpartner
If I remember correctly, it's the "submitdate" column.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Official LimeSurvey Partner - partnersurveys.com
The following user(s) said Thank You: DenisChenu, rbernhardthki

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!