Welcome, Guest
Username: Password: Remember me

TOPIC: 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 1 year 9 months ago #92930

  • monikak
  • monikak's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
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
Attachments:
The administrator has disabled public write access.

Limesurvey 2.00+ how to add another database update query of final submit button 1 year 9 months ago #92933

  • ResearchOnBlogs
  • ResearchOnBlogs's Avatar
  • OFFLINE
  • Gold Lime
  • Posts: 184
  • Thank you received: 16
  • Karma: 8
You could bind an ajax request to your button, but your task is not quite clear.

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.
The administrator has disabled public write access.

Limesurvey 2.00+ how to add another database update query of final submit button 1 year 9 months ago #92936

  • monikak
  • monikak's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
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
The administrator has disabled public write access.

Limesurvey 2.00+ how to add another database update query of final submit button 1 year 8 months ago #93023

  • ResearchOnBlogs
  • ResearchOnBlogs's Avatar
  • OFFLINE
  • Gold Lime
  • Posts: 184
  • Thank you received: 16
  • Karma: 8
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.

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.
The administrator has disabled public write access.

Limesurvey 2.00+ how to add another database update query of final submit button 1 year 8 months ago #93025

  • monikak
  • monikak's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
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?
The administrator has disabled public write access.

Limesurvey 2.00+ how to add another database update query of final submit button 1 year 8 months ago #93034

  • holch
  • holch's Avatar
  • NOW ONLINE
  • LimeSurvey Team
  • Posts: 2952
  • Thank you received: 378
  • Karma: 124
Not really a response to your question, but "Mystery Shopping" is written wrong in the header of your tool (www.mickley.net/zcon02/Shop/).
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.138 seconds
Donation Image