The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »

Bienvenido, Invitado
Nombre de Usuario: Contraseña: Recordarme
  • Página:
  • 1

TEMA: 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 hace 3 meses 2 días #92930

  • monikak
  • Avatar de monikak
  • DESCONECTADO
  • Fresh Lemon
  • Mensajes: 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
Adjuntos:
El administrador ha desactivado la escritura pública.

Limesurvey 2.00+ how to add another database update query of final submit button hace 3 meses 2 días #92933

  • ResearchOnBlogs
  • Avatar de ResearchOnBlogs
  • DESCONECTADO
  • Gold Lime
  • Mensajes: 171
  • Gracias recibidas 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
Esta dirección electrónica esta protegida contra spambots. Es necesario activar Javascript para visualizarla
El administrador ha desactivado la escritura pública.

Limesurvey 2.00+ how to add another database update query of final submit button hace 3 meses 2 días #92936

  • monikak
  • Avatar de monikak
  • DESCONECTADO
  • Fresh Lemon
  • Mensajes: 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
El administrador ha desactivado la escritura pública.

Limesurvey 2.00+ how to add another database update query of final submit button hace 2 meses 3 semanas #93023

  • ResearchOnBlogs
  • Avatar de ResearchOnBlogs
  • DESCONECTADO
  • Gold Lime
  • Mensajes: 171
  • Gracias recibidas 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
Esta dirección electrónica esta protegida contra spambots. Es necesario activar Javascript para visualizarla
El administrador ha desactivado la escritura pública.

Limesurvey 2.00+ how to add another database update query of final submit button hace 2 meses 3 semanas #93025

  • monikak
  • Avatar de monikak
  • DESCONECTADO
  • Fresh Lemon
  • Mensajes: 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?
El administrador ha desactivado la escritura pública.

Limesurvey 2.00+ how to add another database update query of final submit button hace 2 meses 3 semanas #93034

  • holch
  • Avatar de holch
  • DESCONECTADO
  • LimeSurvey Team
  • Mensajes: 1974
  • Gracias recibidas 156
  • Karma: 80
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!
El administrador ha desactivado la escritura pública.
  • Página:
  • 1
Moderadores: DenisChenu, ITEd
Tiempo de carga de la página: 0.190 segundos
Donation Image