Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: prefill questions based on attribute's in the token table

Re: prefill questions based on attribute's in the token table 3 years 9 months ago #57392

  • joosts
  • joosts's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 6
  • Thank you received: 1
  • Karma: 0
Here goes:

How to use attributes defined in the token table to fill in questions.

1. You need to know how to activate and use Javascript in Limesurvey
If you want to use javascript within Limesurvey you have to disable a security filter before you can add your javascript in source code mode.
* Go to global settings and set the setting 'XSS-Filter' to 'off'.
* Add a new question
* In the question field, expande the tool bar by clicking the upper grey bar to get to the source code editor:

* Click on the button LimeFitWin to get full screen mode with even more buttons in the tool bar:

* Click on the button Source

Now you can add your code. A simple test to see if javascript is enabled is to echo an alert. Use this code to test:

<script type="text/javascript" charset="utf-8">
alert("Test!");
</script>

2. You need to be able to load info in the token table. I just exported an existing table to understand the structure, than used CONCAT in excel to create the text for a CSV, which I pasted in Notepad to save as .CSV .

In recent versions of Limesurvey, you can create unlimited token fields. These have 'nicknames' and internal names. I could only make it work if i used the Token table editor to create the needed fields, then import the CSV file. Extra token fields have to be referred to in this form TOKEN:ATTRIBUTE_X , not using their nickname.



a. To fill in an open text field question I pasted this script into the source code of the question text:
<script type="text/javascript" charset="utf-8">
$(document).ready(function() {
document.getElementById("answer74931X156X880").value = '{TOKEN:LASTNAME}'
});
</script>

Save and reopen the question to check if the code hasn't been messed with. This can happen if you haven't followed the steps above to activate Javascript, or when pasting from another program.

Where 74931 is the survey ID, 156 the group ID and 880 the question ID. Of course, you can use any token. For example TOKEN:ATTRIBUTE_45 .



b. For a single choice question, I used the script below. Here the IF statement refers to a certain individual property, which in this case is a text. It's interesting to know that the syntax does not change if your attribute is text or integer.
<script type="text/javascript" charset="utf-8">
$(document).ready(function() {
if('{TOKEN:ATTRIBUTE_2}' == 'VZW') {$("input#answer74931X156X885X1").attr('checked', true);}
if('{TOKEN:ATTRIBUTE_2}' == 'FV') {$("input#answer74931X156X885X2").attr('checked', true);}
if('{TOKEN:ATTRIBUTE_2}' == 'BVBA') {$("input#answer74931X156X885X3").attr('checked', true);}
if('{TOKEN:ATTRIBUTE_2}' == 'NG') {$("input#answer74931X156X885X4").attr('checked', true);}
if('{TOKEN:ATTRIBUTE_2}' == 'NV') {$("input#answer74931X156X885X5").attr('checked', true);}
if('{TOKEN:ATTRIBUTE_2}' == 'CommV') {$("input#answer74931X156X885X6").attr('checked', true);}
if('{TOKEN:ATTRIBUTE_2}' == 'Eenmanszaak') {$("input#answer74931X156X885X7").attr('checked', true);}
});
</script>

I use X1 through X7 to define answer options. You choose this yourself when defining answer option codes. Be careful, as this info is case sensitive.


c. This syntax would work just as well for a multi answer question, if it weren't that of course you cannot define more than one answer in just one attribute. Hence you need at least as much attribute columns in your token table as the user with the biggest number of crossed answer options had in your original table.

In this case, attribute 3 through 5 contain the old answers. For example 21 could refer to apples, 22 to pears. The answer code for 'apples' is X21, for 'pears' X22. So if a person has the value 21 on either of the three attributes, answer option X21 will be marked.
if('{TOKEN:ATTRIBUTE_3}' == '21' || '{TOKEN:ATTRIBUTE_4}' == '21' || '{TOKEN:ATTRIBUTE_5}' == '21') {$("input#answer74931X156X884X21").attr('checked', true);}
if('{TOKEN:ATTRIBUTE_3}' == '22' || '{TOKEN:ATTRIBUTE_4}' == '22' || '{TOKEN:ATTRIBUTE_5}' == '22') {$("input#answer74931X156X884X22").attr('checked', true);}
if('{TOKEN:ATTRIBUTE_3}' == '23' || '{TOKEN:ATTRIBUTE_4}' == '23' || '{TOKEN:ATTRIBUTE_5}' == '23') {$("input#answer74931X156X884X23").attr('checked', true);}
if('{TOKEN:ATTRIBUTE_3}' == '24' || '{TOKEN:ATTRIBUTE_4}' == '24' || '{TOKEN:ATTRIBUTE_5}' == '24') {$("input#answer74931X156X884X24").attr('checked', true);}

I used this principle on a question with 70 answer options and 14 token attributes, and it worked just fine.
The administrator has disabled public write access.
The following user(s) said Thank You: pwmowers

Re: prefill questions based on attribute's in the token table 1 year 2 months ago #99771

  • duvemyster
  • duvemyster's Avatar
  • OFFLINE
  • Gold Donor
  • Posts: 17
  • Thank you received: 4
  • Karma: 1
On a questionnaire with token-based response persistence, how would you adjust this approach so that new values entered display in place of the prefilled value from the token table? In other words, how would you make this work like a default value? Or, how would you prefill the default value from the token table instead of prefilling the answer?

(Should this approach from manual.limesurvey.org/QS:Defaults work in Version 2.00+ Build 130802? -- "In the text entry field for the default value, you would enter {TOKEN:ATTRIBUTE_1}")
Last Edit: 1 year 2 months ago by duvemyster. Reason: typo
The administrator has disabled public write access.

Re: prefill questions based on attribute's in the token table 1 year 2 months ago #99793

  • Mazi
  • Mazi's Avatar
  • NOW ONLINE
  • LimeSurvey Team
  • Posts: 5426
  • Thank you received: 307
  • Karma: 252
duvemyster, I am not quite sure what you are up to, but maybe this helps:
Pre-filling a text field at Limesurvey 1.92 using default answers and Expression Manager

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
Last Edit: 1 year 2 months ago by Mazi.
The administrator has disabled public write access.

Re: prefill questions based on attribute's in the token table 1 year 2 months ago #99798

  • duvemyster
  • duvemyster's Avatar
  • OFFLINE
  • Gold Donor
  • Posts: 17
  • Thank you received: 4
  • Karma: 1
I was trying to pull the default answer in from the token table on a multiple short-text question in 2.00+ .

Should entering {TOKEN:ATTRIBUTE_1} in a default field of a multiple short-text question be working?
The administrator has disabled public write access.

Re: prefill questions based on attribute's in the token table 1 year 2 months ago #99806

  • Mazi
  • Mazi's Avatar
  • NOW ONLINE
  • LimeSurvey Team
  • Posts: 5426
  • Thank you received: 307
  • Karma: 252
duvemyster wrote:
Should entering {TOKEN:ATTRIBUTE_1} in a default field of a multiple short-text question be working?
Just give it a try...

...the answer is "yes".

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: prefill questions based on attribute's in the token table 1 year 2 months ago #99808

  • duvemyster
  • duvemyster's Avatar
  • OFFLINE
  • Gold Donor
  • Posts: 17
  • Thank you received: 4
  • Karma: 1
Thank you, Mazi.

I haven't figured out yet what I was doing differently yesterday, though this has been working perfectly for me each time today.
The administrator has disabled public write access.
The following user(s) said Thank You: mayeulk
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.279 seconds
Donation Image