Welcome, Guest
Username: Password: Remember me

TOPIC: {assessment_CURRENT_TOTAL} in database

{assessment_CURRENT_TOTAL} in database 9 months 1 week ago #103196

  • rodbro10
  • rodbro10's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 7
  • Karma: 0
Hey,

I need to add assessment_CURRENT_TOTAL in the database. So I maded a

Type: Equation
Text: {assessment_CURRENT_TOTAL}
Adv: Hide question

But in the database it inserts: {assessment_CURRENT_TOTAL} and not the actual numbers for assesment.

What do I do wrong?

Hope for a answer, I did try everything!

Kenneth
The administrator has disabled public write access.

{assessment_CURRENT_TOTAL} in database 9 months 1 week ago #103197

  • Ben_V
  • Ben_V's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 1109
  • Thank you received: 250
  • Karma: 78
Hello,

Please have a look here
Benoît

goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche)
goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar)
goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de...
Last Edit: 9 months 1 week ago by Ben_V.
The administrator has disabled public write access.

{assessment_CURRENT_TOTAL} in database 9 months 1 week ago #103200

  • rodbro10
  • rodbro10's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 7
  • Karma: 0
Hey Ben,

Not sure I understand, I cant use the hide question?

It should work as I did read about in a another tread:
www.limesurvey.org/en/forum/design-issue...ue-to-database#95787


Hope someone can help?

Kenneth
Last Edit: 9 months 1 week ago by rodbro10.
The administrator has disabled public write access.

{assessment_CURRENT_TOTAL} in database 9 months 1 week ago #103206

  • tpartner
  • tpartner's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 4264
  • Thank you received: 801
  • Karma: 368
Yes, it should work as indicated in that thread.

Make sure that you use all uppercase in the tag:
Capture2_2014-01-07.PNG


Here is a working sample survey.

File Attachment:

File Name: assess_test.lss
File Size: 17 KB
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
The administrator has disabled public write access.

{assessment_CURRENT_TOTAL} in database 9 months 1 week ago #103209

  • Ben_V
  • Ben_V's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 1109
  • Thank you received: 250
  • Karma: 78
Hello Tony,

I've tried to use {assessment_CURRENT_TOTAL} directly in an equation type question several times before without success and that's why I was still (in 2014) using a basic numerical question + js to store this precious value in the db (to avoid a neverending equation with dozens of qcodes when using radio type questions)...

I've installed your nice sample and I've got this working now... The trick seems that a placeholder type question is required in the same group than the equation question... Why?

Best wishes for 2014

Ben.
Benoît

goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche)
goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar)
goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de...
The administrator has disabled public write access.

{assessment_CURRENT_TOTAL} in database 9 months 1 week ago #103211

  • tpartner
  • tpartner's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 4264
  • Thank you received: 801
  • Karma: 368
Hey, there's nothing wrong with "using a basic numerical question + js" :laugh:

I suspect (without testing) that if the equation question is hidden and there is no placeholder (or other relevant question), the group is never rendered so the equation question cannot be loaded and stored in the data.

Of course, you can still force the submit as in your example but then you're back to where you started...

Happy New Year to you too.

.
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
Last Edit: 9 months 1 week ago by tpartner.
The administrator has disabled public write access.
The following user(s) said Thank You: Ben_V

{assessment_CURRENT_TOTAL} in database 9 months 1 week ago #103212

  • Ben_V
  • Ben_V's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 1109
  • Thank you received: 250
  • Karma: 78
Checked!
The group requires an "always shown" question (the equation question itself or another question if the equation is hidden)

Sure that your sample and this discussion will help a lot users (newbies or not) :)
So, thanks again!
Benoît

goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche)
goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar)
goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de...
The administrator has disabled public write access.

{assessment_CURRENT_TOTAL} in database 9 months 1 week ago #103217

  • rodbro10
  • rodbro10's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 7
  • Karma: 0
Thank you very much, it works just perfect!!
I just needed to make it all upper cases... and wupti.... it worked just as you said.

Again... Thank you!
The administrator has disabled public write access.

{assessment_CURRENT_TOTAL} in database 2 months 1 day ago #111765

  • Agone
  • Agone's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Hello,
i want to do the same without displaying the score to the users.
When i remove displaying, the assessment_CURRENT_TOTAL is equal to 0 ...
thanks for your help
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.269 seconds
Donation Image