Limesurvey 2.00+ how to add another database update query of final submit button

Hi,
We have installed limesurvey for php +extjs based prj. ( www.mickley.net/zcon02/Shop/ )

our prj is related with Hotel mgmt, where shopper role person after login will fill survey details for caller person.
For that we have opened Limesurvey questionaire on our application ( in pop up page)
our task is to find out a way when final submit btn of survey form will be clicked, at that time how we can fire MySQL query on our prj database for recording result of survey.

actually based of survey result - ie if result >=75% then we have to do further status activation for caller.

How to modify or find out way in Limesurvey in this case. Help and Guide on this appreaciated.

Thanks
Monika

You could bind an ajax request to your button, but your task is not quite clear.

Cheers Kai

Hi,
Thank you for your reply ..

which php file under Limesurvey has that final submit button ?
ie in which file exactly should i add ajax call ?


We are calling limesurvey on our project when clicked on caller(person) survey link.
So actually we want to add our database Mysql query to record result of the survey form (filled for one perticular Caller Person)

Am also having one small doubt as we are filling survey form , so can we get result of survey filled based in percentage? as some questions might be like only comments/ descriptions to enter along with radio options to select.

Thanks

I would hook in with jQuery to catch the send button.


"percentage" as far as I know this value isn't saved to database. In order to that it's not easy to get the result participant "xy has done 80%". I think you must calculate this manually.

ok will check for jQuery function to be called on final submit btn ( '#movesubmitbtn') ...

For Percentage calculatation as you suggested we have to do it mannually from SQL query to check how many correct answers are there, but we are not getting while creating questions , how to define correct answer for specific question ? (eg survey question is multiple choice selection) , so can i define whether out of 3 choices , which choice is correct while creating question itself?

Not really a response to your question, but "Mystery Shopping" is written wrong in the header of your tool ( www.mickley.net/zcon02/Shop/ ).