Check out the LimeSurvey source code on GitHub!

please help with assessment saving to db, i tried all possible ways!

More
3 years 4 months ago #99660 by itsme
Hi guys

I'm trying to make an array assessment results being saved to database (normal array) of 2 questions, one is calculating the columns as 0,1,2,3 and one is calculating differently as 4,5,6,7

lime survey version 1.92+
using group by group

in this group, i put only these 2 array questions and added another question with "always hide this question" then added the java script mentioned here:
www.limesurvey.org/de/forum/can-i-do-thi...tabase?lang=en#73833

without results

also tried using the expression manager and crated new question as equation type and in question text:

sum(ct_g2_q01.NAOK,ctspq_g2_q02.NAOK)
also tried
sum(ct_g2_q01.value.NAOK,ct_g2_q02.value.NAOK)
also tried
sum(ct_g2_q01.value,ct_g2_q02.value)

no use at all, the numeric field (for java) and the equation field (for equation) is always kept empty, no use what i try

i have been reading the expression manager thing over and over even i got depressed but nothing worked for me, please guys help me save this array assessment results to database

by the way, in assessment range values in the end page is working fine, gives me the results
also if i place holder in the end page in template, it gives it ok,,, but i am not able to save it along with the database

is there anyway to save the results of the range of assessment as well to database? i mean, i've put in the assessment page that if score is 1-6 then inform participant that he is fine, if 7-10 he is abnormal, it is showing ok in the end page, but can i save this value to database also???

please help guys, appreciated any hint or lead to what i can do

Mike

Please Log in to join the conversation.

More
3 years 4 months ago #99661 by jelo
Thinks you should attach a surveyfile of your two,three questions here to get the whole picture.

E.g.: Is the QCode correct?
manual.limesurvey.org/Expression_Manager#Qcode_Variable_Naming

Perhaps you have found a bug with your Limesurvey installation.
Try your stripped down surveyfile on the demo installation here to check that too.
The following user(s) said Thank You: itsme

Please Log in to join the conversation.

More
3 years 4 months ago #99668 by DenisChenu
Hi,

Don't use Text question type/hide attribute.
Use directly a equation question type : it made for this.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
The following user(s) said Thank You: itsme

Please Log in to join the conversation.

More
3 years 4 months ago #99680 by itsme
hello again and thanks for the quick reply

actually i couldn't understand this Qcode thing, it is too complicated and don't know which of the arrays is flixable or not, there not examples for the array with assessemnt like the one i am working on... so i have tried all what is written one by one, no use :ohmy:

the survey is here, i've kept the group of 2 questions and 1 question for calcuation (equpation)

stardvb.com/vpn/limesurvey_survey_75233.lss

the first 2 questions are array, and i've made them in 2 questions (although the headers are the same) in order to assess them differently...

if you notice, the assessment is working fine and it give the values when done in the end page, i also added in my template the {current total short code} it is working fine,, but i want this calculation value to be saved to database!! and also to have the output results (normal, abnormal ,borderline) as to be in the database along with the answers record

using ls 1.92

appreciated any input

Mike

Please Log in to join the conversation.

More
3 years 4 months ago #99700 by itsme
hello, anybody please advise

Please Log in to join the conversation.

More
3 years 4 months ago #99701 by Ben_V
Hello,

1) As already said by Denis, use a hidden equation type question to grab the assessment value.

2) Avoid the use of javascript based workarounds described elsewhere in the forum (only indicated for versions before 1.92)

3) Go to this old post , install the survey sample (assess.lss) and play around to understand how this works

Hope this helps you....

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
All LS releases => bit.ly/1VMuTDu | 2.06lts => bit.ly/1Qv44A1
Demo surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)

Please Log in to join the conversation.

More
3 years 4 months ago #99703 by itsme
hi and thanks a lot for your reply

i've done that actually but didn't work, i changed the question codes to q1 and q2 to cope with the example but keep showing undefined variable in the equation question!

my questions are "array" not radio buttons with comments and i am stuck in the middle of this, please have a look at my given survey above and just put the formula for me

i would like to save the assessment results as well that which is shown in the end of the survey (assessment page - end page) so please help in this as well

I know we are newbies and might bother you a little, believe me i've searched all over the forums and played around for long time without active results, i appreciate any input can help me finish this

thanks a lot in advanced

Mike

Please Log in to join the conversation.

More
3 years 4 months ago - 3 years 4 months ago #99728 by amit01
Hello,
I tried the attached survey and found that you are using incorrect expression.

Please use the subquestion code as well in the expression

The correct expression would be :
{sum(ct_g1_q01_SQ001.NAOK, ct_g1_q02_SQ001.NAOK)}

Hope this helps!!

--
amit
Last Edit: 3 years 4 months ago by amit01. Reason: missed expressions tag

Please Log in to join the conversation.

More
3 years 4 months ago #99729 by itsme
thank you amit
i tried that but didn't work
can you please make changes to the same example i attached and reupload, it doesn't make sense and drives me crazy :(

Please Log in to join the conversation.

More
3 years 4 months ago - 3 years 4 months ago #99732 by amit01
Here it is:

File Attachment:

File Name: h0c777bb_2...9-10.lss
File Size:38 KB


Maybe try using "value" instead of "NAOK" in the expression.

--
amit
Attachments:
Last Edit: 3 years 4 months ago by amit01. Reason: Missed the attachement

Please Log in to join the conversation.

More
3 years 4 months ago #99766 by itsme
perfect, now it works !!! thanks a lot my dear, appreciated a lot ;)

best regards
Mike

Please Log in to join the conversation.

More
3 years 4 months ago #99794 by Mazi
Please add your example here to help others: manual.limesurvey.org/Expression_Manager_Examples

Thanks!


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
3 years 4 months ago - 3 years 4 months ago #99811 by itsme
done but i am not familiar with wiki, please check the same link and see if needs modification or something!?
thanks a lot guys, amit, DenisChenu, benoit, and Mazi :)
Last Edit: 3 years 4 months ago by itsme.

Please Log in to join the conversation.

More
3 years 4 months ago #99815 by Mazi
I adjusted it a little. Thanks for sharing your solution!


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form