Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Save Group totals and survey total values to database - lime 2.5

  • paulearley
  • paulearley's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 9 months ago #139565 by paulearley
Hello, first post in quite a while.

I have been scouring the Limesurvey manual and how to's and cannot find out how to do this.
I would like to save the total values for responses in each group to the database. I tried using the equation question type where the group questions are labeled A1 through A5:
{A1+A2+A3+A4+A5}
The value never shows up in my MySQL database.

I set the equation type to "always numeric.

What am I doing wrong?
Paul Earley
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 9 months ago #139568 by Joffm
Hi, paulearley,

please have a look to the LS demo survey "Tailoring Examples".
There is a group "Hidden Equations to Compute BMI".
"This computes your body mass index (BMI) and tells you your weight status. It demonstrates the use of hidden Equation-type questions, whose values are stored in the database even though hidden on the screen. "

You can adapt it easily to your needs.

Kind regards
Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 9 months ago #139580 by tpartner
Try this:

Code:
{sum(A1, A2, A3, A4, A5)}

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
  • paulearley
  • paulearley's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 9 months ago #139595 by paulearley
Thanks - because the manual was for an older version, I could not extrapolate to 2.5. I will review again.
The topic has been locked.
  • paulearley
  • paulearley's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 9 months ago #139596 by paulearley
Thanks!
P
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose