- Posts: 3
- Thank you received: 0
- Forum
- English support forums
- Development
- Limesurvey 2.00+ how to add another database update query of final submit button
Limesurvey 2.00+ how to add another database update query of final submit button
5 years 1 month ago #92930
by monikak
monikak created the topic: 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
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
Please Log in or Create an account to join the conversation.
5 years 1 month ago #92933
by KRav
research on BLOGS - Professional LimeSurvey support
Consultant - Templates - Training - JQuery magic - Support - Coding - Survey creation and more..
Contact
Professional LimeSurvey support
This email address is being protected from spambots. You need JavaScript enabled to view it.
KRav replied the topic: Limesurvey 2.00+ how to add another database update query of final submit button
You could bind an ajax request to your button, but your task is not quite clear.
Cheers Kai
Cheers Kai
research on BLOGS - Professional LimeSurvey support
Consultant - Templates - Training - JQuery magic - Support - Coding - Survey creation and more..
Contact
Professional LimeSurvey support
This email address is being protected from spambots. You need JavaScript enabled to view it.
Please Log in or Create an account to join the conversation.
5 years 1 month ago #92936
by monikak
monikak replied the topic: Limesurvey 2.00+ how to add another database update query of final submit button
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
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
Please Log in or Create an account to join the conversation.
5 years 1 month ago #93023
by KRav
research on BLOGS - Professional LimeSurvey support
Consultant - Templates - Training - JQuery magic - Support - Coding - Survey creation and more..
Contact
Professional LimeSurvey support
This email address is being protected from spambots. You need JavaScript enabled to view it.
KRav replied the topic: Limesurvey 2.00+ how to add another database update query of final submit button
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.
"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.
research on BLOGS - Professional LimeSurvey support
Consultant - Templates - Training - JQuery magic - Support - Coding - Survey creation and more..
Contact
Professional LimeSurvey support
This email address is being protected from spambots. You need JavaScript enabled to view it.
Please Log in or Create an account to join the conversation.
5 years 1 month ago #93025
by monikak
monikak replied the topic: Limesurvey 2.00+ how to add another database update query of final submit button
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?
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?
Please Log in or Create an account to join the conversation.
5 years 1 month ago #93034
by holch
I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds
holch replied the topic: Limesurvey 2.00+ how to add another database update query of final submit button
Not really a response to your question, but "Mystery Shopping" is written wrong in the header of your tool (
www.mickley.net/zcon02/Shop/
).
I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds
Please Log in or Create an account to join the conversation.