- Posts: 7
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Saving Assessment scores to survey database
- gsaha
- Topic Author
- Offline
- New Member
For each group, you will need to create a number input question and make it not mandatory.
You will need to input the following code in that numerical input question. Change the numbers 55972 , 9 and 311 to match your survey number, group number and question number. Make sure you do not set the question to hide.
<script>
jQuery(document).ready(function() {
document.getElementById('answer55972X9X311').value = "{ASSESSMENT_CURRENT_TOTAL}";
document.getElementById('display311').style.display= "none";
document.getElementById('answer55972X9X311').style.display= "none";
});
</script><script>
$(document).ready(function()
{
$('#question311').hide();
});
</script>
- TMSWhite
- Offline
- LimeSurvey Community Team
- Posts: 84
- Thank you received: 21
Although gsaha may be right for 1.91+, that approach is not needed for 1.92.
In fact, you almost had it. Instead of:
{sum(q1.NAOK,q2.NAOK,q3.NAOK,q4.NAOK)}
use
{sum(q1.value,q2.value,q3.value,q4.value)}
You could also use
{sum(q1.valueNAOK,q2.valueNAOK,q3.valueNAOK,q4.valueNAOK)}
but, since q1-q4 are always relevant, there is no need for the NAOK suffix
The .value suffix retrieves the assessment value for the answer. When you were using {sum(q1,q2,q3,q4)}, it was retrieving the answer id, so say you answered A1,B2,C3,D1, {sum{q1,q2,q3,q4)} would be 0, since the integer value of "A1" is 0, whereas {sum(q1.value,q2.value,q3.value,q4.value)} would be the equivalent of {sum(5,10,9,1)}, and returns the assessment value of 35.
If you depend upon LimeSurvey or the support team, please give generously to our 2012 fundraiser .
- Expression Manager (EM):
Documentation
|
Sample Surveys
|
How Tos
|
Show Logic File
|
Upgrading to 1.92+ - Excel Style for Survey Structure Import/Export
- Ben_V
- Offline
- Platinum Member
- Posts: 1223
- Thank you received: 351
Could not be more clear !
Benoît
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
- sequoia
- Offline
- New Member
- Posts: 12
- Thank you received: 0
I do have two follow up inquries that may also be of interest to other newbies with LimeSurvey...
- Concerning the assessment total function, it is placed in a question entry. I can have visibility turned off for this one question, but in doing so it removes that data from the email sent out (there is though a db entry and the assessment rules shows corresponding results). Is there a workaround for this? (that is, have the question with the 'Equation'/{sum} output listed in the distributed email but not visible in the survey). What I have now is a blank question page with a sum value in the question area.
- I've read before in another part of the forum benitov's posts regarding the removal of the question codes in any result printout (completed survey page/email) and had no success. The '<span class="nocode">' worked the first time (with the corresponding CSS rule in 1.91+), there after I only had one question for the entire survey. After I removed the code bit things returned back to normal (thus hesitant to try again with the upgraded 1.92+ version). Is there a new functionality with 1.92+ that can remove these answer codes from view in any result print page?
(areas highlighted I'm looking to remove)
Thanks again as always from the newbie
- Ben_V
- Offline
- Platinum Member
- Posts: 1223
- Thank you received: 351
.... visibility turned off for this one question, but in doing so it removes that data
Maybe you can just emule the submit button putting the following code in the source of the question
The may problem is that you have to set your survey "question by question" or "group by group" with a group dedicated for this sole question because the effect will be to skip directly to the next step (next question, group or final submission)
<script type="text/javascript"> jQuery(document).ready(function($) { // Adapt all survey, group & question ID s.... //!\\ document.getElementById('display123').style.display= "none"; //!\\ document.getElementById('answer789X456X123').style.display= "none"; document.limesurvey.submit(); }); </script>
2) for the class="nocode" I've no other solution... If you don't want to create a new css class, you can use inline css like
<span style="display:none"> <!-- don't close this tag -->
Ben
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
- sequoia
- Offline
- New Member
- Posts: 12
- Thank you received: 0
Regarding the javascript in your previous post, is that for use in 1.91+, 1.92+, or both? (I currently have installed 1.92+) ; And would I need to supplement the specific data from my survey into the " ('display123') " (parenthesis) areas?
Again thanks for your input everyone.
- TMSWhite
- Offline
- LimeSurvey Community Team
- Posts: 84
- Thank you received: 21
If you depend upon LimeSurvey or the support team, please give generously to our 2012 fundraiser .
- Expression Manager (EM):
Documentation
|
Sample Surveys
|
How Tos
|
Show Logic File
|
Upgrading to 1.92+ - Excel Style for Survey Structure Import/Export
- sequoia
- Offline
- New Member
- Posts: 12
- Thank you received: 0
Or would Benitov's suggestion working with javascript be the best/current workaround?•Concerning the assessment total function, it is placed in a question entry. I can have visibility turned off for this one question, but in doing so it removes that data from the email sent out (there is though a db entry and the assessment rules shows corresponding results). Is there a workaround for this? (that is, have the question with the 'Equation'/{sum} output listed in the distributed email but not visible in the survey). What I have now is a blank question page with a sum value in the question area.
- TMSWhite
- Offline
- LimeSurvey Community Team
- Posts: 84
- Thank you received: 21
If I'm understanding you, you want to email to contain the assessment score, but not have it show in the survey (or in the print your answers page).
If so, you can simply edit the template for the email being sent out. You can still have the hidden equation to compute the score (so it will be in the database, but never seen by the user). Then, in the email template, say "The subject's score was {score}"
If you depend upon LimeSurvey or the support team, please give generously to our 2012 fundraiser .
- Expression Manager (EM):
Documentation
|
Sample Surveys
|
How Tos
|
Show Logic File
|
Upgrading to 1.92+ - Excel Style for Survey Structure Import/Export
- sequoia
- Offline
- New Member
- Posts: 12
- Thank you received: 0
Thank you for responding.
I'm seeking to have the assessment score output to all three areas (completed survey page, database, and email). This has been resolved with one 'side effect' so to speak...
To better clarify, the issue is with the survey containing a blank question page (the 'equation' question type) with the current assessment total in the question area (and nothing else).
Again I really appreciate all the input, and it helps us newbies get better acclimated to the LimeSurvey programming more rapidly for our needs.
- TMSWhite
- Offline
- LimeSurvey Community Team
- Posts: 84
- Thank you received: 21
the issue is with the survey containing a blank question page (the 'equation' question type) with the current assessment total in the question area (and nothing else).
If you depend upon LimeSurvey or the support team, please give generously to our 2012 fundraiser .
- Expression Manager (EM):
Documentation
|
Sample Surveys
|
How Tos
|
Show Logic File
|
Upgrading to 1.92+ - Excel Style for Survey Structure Import/Export
- sequoia
- Offline
- New Member
- Posts: 12
- Thank you received: 0