- Posts: 54
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
assign text to a numeric answer in the database
- Gabriela
- Topic Author
- Offline
- Banned
Less
More
11 years 3 months ago #90329
by Gabriela
assign text to a numeric answer in the database was created by Gabriela
Good morning,
I have a survey on paper with numeric answers but each number corresponds to a text answer. For example: I have a list of options and each options has a number assigned.
1= I know about this
2= I am aware about this topic
ect...
Is it possible to make a numeric answer question but later in the data base I can read the correspondent text (not the numbers)?
Thank you very, much , hope I wasnt too confusing.
I have a survey on paper with numeric answers but each number corresponds to a text answer. For example: I have a list of options and each options has a number assigned.
1= I know about this
2= I am aware about this topic
ect...
Is it possible to make a numeric answer question but later in the data base I can read the correspondent text (not the numbers)?
Thank you very, much , hope I wasnt too confusing.
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10634
- Thank you received: 3698
11 years 3 months ago #90347
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic assign text to a numeric answer in the database
Not out-of-the-box but depending on the question type you can use JavaScript to display the answer codes (numbers) instead of the answer text.
What are your question types?
What are your question types?
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- Gabriela
- Topic Author
- Offline
- Banned
Less
More
- Posts: 54
- Thank you received: 0
11 years 3 months ago #90390
by Gabriela
Replied by Gabriela on topic assign text to a numeric answer in the database
Hi, thanks for your answer.
Actually my survey is a pre and post test and its on paper.
The respondent can give more than one answer. Depending on his answers, we write the number of the answer in the boxes (max 3). Like this:
As u see its letters. And each letter corresponds to an answer. So If I type 3 letters on the 3 boxes (pre-test), and 3 letters on the 3 boxes (post-test),on the database it would be good it appears the text answers and not the letter...
I was thinking to use a matrix type (x axis Pre and post test) and Y axis...dont know..
Following the image, can you advice wich is the best way to achieve this?
Many many thanks
Actually my survey is a pre and post test and its on paper.
The respondent can give more than one answer. Depending on his answers, we write the number of the answer in the boxes (max 3). Like this:
As u see its letters. And each letter corresponds to an answer. So If I type 3 letters on the 3 boxes (pre-test), and 3 letters on the 3 boxes (post-test),on the database it would be good it appears the text answers and not the letter...
I was thinking to use a matrix type (x axis Pre and post test) and Y axis...dont know..
Following the image, can you advice wich is the best way to achieve this?
Many many thanks
Attachments:
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10634
- Thank you received: 3698
11 years 3 months ago #90400
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic assign text to a numeric answer in the database
Ah, that complicates things. You will need to ensure that only valid letters (numbers?) are entered and that they are only used once for pre and once for post.
It may be easier and safer to use separate multiple-choice questions for pre and post.
It may be easier and safer to use separate multiple-choice questions for pre and post.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- Gabriela
- Topic Author
- Offline
- Banned
Less
More
- Posts: 54
- Thank you received: 0
11 years 3 months ago #90405
by Gabriela
Replied by Gabriela on topic assign text to a numeric answer in the database
;( instead of a matrix...?
Ok...I just wanted to make it as clean as posible.
many thanks again
Ok...I just wanted to make it as clean as posible.
many thanks again
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
11 years 3 months ago #90423
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic assign text to a numeric answer in the database
Hello,
Maybe you can use one question for the 3 letters and after 3 equation question type with some expression to test the first/second/third letter and fill the answer according to the answer.
You can hide the equation question type or shown at the user for information if you want.
Think in equation you have to use:
if(test,"the text for test","")
with test something like that:
substr(QCODE,0,1) for the first letter, substr(QCODE,1,1) for the second etc ... (with QCODE the code of the first question).
Denis
Maybe you can use one question for the 3 letters and after 3 equation question type with some expression to test the first/second/third letter and fill the answer according to the answer.
You can hide the equation question type or shown at the user for information if you want.
Think in equation you have to use:
if(test,"the text for test","")
with test something like that:
substr(QCODE,0,1) for the first letter, substr(QCODE,1,1) for the second etc ... (with QCODE the code of the first question).
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- Gabriela
- Topic Author
- Offline
- Banned
Less
More
- Posts: 54
- Thank you received: 0
11 years 3 months ago #90432
by Gabriela
Replied by Gabriela on topic assign text to a numeric answer in the database
Thanks, Id like to try anything. especially because other users are complaining on questions lenght (and that they dont match the diplaying form on paper)
Please, can you specify a little bit your example. Tried to do it on my own but no results.
Thanks again.
Please, can you specify a little bit your example. Tried to do it on my own but no results.
Thanks again.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
11 years 3 months ago #90442
by DenisChenu
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic assign text to a numeric answer in the database
I don't understand : why no use a list question type ?Gabriela wrote: Thanks, Id like to try anything. especially because other users are complaining on questions lenght (and that they dont match the diplaying form on paper)
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- Gabriela
- Topic Author
- Offline
- Banned
Less
More
- Posts: 54
- Thank you received: 0
11 years 3 months ago #90445
by Gabriela
Replied by Gabriela on topic assign text to a numeric answer in the database
hi, thanks.
Ill try to explain with an image: this is the test I have to construct with limesurvey:
I have to figure out how to build it as similar as posible...
Thanks a lot
Ill try to explain with an image: this is the test I have to construct with limesurvey:
I have to figure out how to build it as similar as posible...
Thanks a lot
Attachments:
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10634
- Thank you received: 3698
11 years 3 months ago #90474
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic assign text to a numeric answer in the database
I still think that to avoid input errors, multiple-options questions are the best bet despite the space required.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.