- Posts: 161
- Thank you received: 4

- Forum
- English support forums
- Can I do this with LimeSurvey?
- How can carry out dual-column multiple numerical input?

# How can carry out dual-column multiple numerical input?

*How can carry out dual-column multiple numerical input?*was created by

*mrli999*

Please Log in or Create an account to join the conversation.

*first*on topic

*How can carry out dual-column multiple numerical input?*

if no

array number --> advance settings [Text inputs = Yes]

if Yes

Need some javascript .

Survey Designer and Programmer

Please Log in or Create an account to join the conversation.

*mrli999*on topic

*How can carry out dual-column multiple numerical input?*

OMdev wrote: Do you have input fields in first column as well(a....,b... etc) ?

if no

array number --> advance settings [Text inputs = Yes]

if Yes

Need some javascript .

Thank you very much! YES, I need to input in the first column(CURRENTLY) and in the second column(5-7 YEARS AGO)

Please Log in or Create an account to join the conversation.

*Mazi*on topic

*How can carry out dual-column multiple numerical input?*

Then use array filter feature at the follow up "Array Numbers" question to only show rows for which a text exists. You can display the text of the previous question using placeholders. If the multiple short question uses question code "q22" and the sub-questions are numbered 1 to X use:

{q22_1.NAOK}

{q22_2.NAOK}

{q22_x.NAOK}

Best regards/Beste Grüße,

Dr. Marcel Minke

**Need Help?**We offer professional Limesurvey support

*Contact:*marcel.minke(at)survey-consulting.com

Want to

**use your survey offline**-> www.offlinesurveys.com

Please Log in or Create an account to join the conversation.

*mrli999*on topic

*How can carry out dual-column multiple numerical input?*

Mazi wrote: You can add a question of type "multiple short text" before that question and ask something like "Please enter details about XYZ" to let the user enter the open texts there.

Then use array filter feature at the follow up "Array Numbers" question to only show rows for which a text exists. You can display the text of the previous question using placeholders. If the multiple short question uses question code "q22" and the sub-questions are numbered 1 to X use:

{q22_1.NAOK}

{q22_2.NAOK}

{q22_x.NAOK}

thank you. Could you please explain more clearly?

Please Log in or Create an account to join the conversation.

*mrli999*on topic

*How can carry out dual-column multiple numerical input?*

Please Log in or Create an account to join the conversation.

*Mazi*on topic

*How can carry out dual-column multiple numerical input?*

Please do so and attach the LSS file.

Best regards/Beste Grüße,

Dr. Marcel Minke

**Need Help?**We offer professional Limesurvey support

*Contact:*marcel.minke(at)survey-consulting.com

Want to

**use your survey offline**-> www.offlinesurveys.com

Please Log in or Create an account to join the conversation.

*mrli999*on topic

*How can carry out dual-column multiple numerical input?*

Mazi wrote: Did you already try to create a sample survey using a multiple short text + Array numbers question?

Please do so and attach the LSS file.

Thank you very much for your kindness. I tried to use array(numbers). It seems work well me. However, I don't how to validate whether the sum of first column or the second column add up to 100 or not? Can I use "Question validation equation" to validate it? If so, how to do it ? Thanks.

Attachment please find my question.

Please Log in or Create an account to join the conversation.

*tpartner*on topic

*How can carry out dual-column multiple numerical input?*

*curr*" and "

*ago*", the question validation equation would be:

`sum(self.sq_curr) == 100 OR sum(self.sq_ago) == 100`

Question attached:

*Cheers,*

Tony Partner

Tony Partner

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

*Official LimeSurvey Partner - partnersurveys.com*

Please Log in or Create an account to join the conversation.

*mrli999*on topic

*How can carry out dual-column multiple numerical input?*

tpartner wrote: Given your x-scale codes of "

curr" and "ago", the question validation equation would be:sum(self.sq_curr) == 100 OR sum(self.sq_ago) == 100

Question attached:

Thank you very much! Another question, even this question is not mandatory, if the respondent doesn't respond to this question, he can not go ahead with other questions. How should I do with this? thanks again!

Please Log in or Create an account to join the conversation.

*tpartner*on topic

*How can carry out dual-column multiple numerical input?*

I don't understand. You said "Thank you very much! Another question, even this question is not mandatory, if the respondent doesn't respond to this question, he can not go ahead with other questions. How should I do with this? thanks again!

*validate whether the sum of first column or the second column add up to 100*". In that case, the respondent is not supposed to be allowed to proceed unless that requirement is met.

*Cheers,*

Tony Partner

Tony Partner

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

*Official LimeSurvey Partner - partnersurveys.com*

Please Log in or Create an account to join the conversation.

*mrli999*on topic

*How can carry out dual-column multiple numerical input?*

tpartner wrote:

I don't understand. You said "Thank you very much! Another question, even this question is not mandatory, if the respondent doesn't respond to this question, he can not go ahead with other questions. How should I do with this? thanks again!

validate whether the sum of first column or the second column add up to 100". In that case, the respondent is not supposed to be allowed to proceed unless that requirement is met.

Can the respondent leave the question blank and go ahead with afterward questions?

Please Log in or Create an account to join the conversation.

*tpartner*on topic

*How can carry out dual-column multiple numerical input?*

- Nothing is answered

OR

- Both columns total to 0

OR

- One column totals to 100

`count(self) == 0 OR (sum(self.sq_curr)== 0 AND sum(self.sq_ago)== 0) OR (sum(self.sq_curr)== 100 OR sum(self.sq_ago)== 100)`

*Cheers,*

Tony Partner

Tony Partner

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

*Official LimeSurvey Partner - partnersurveys.com*

Please Log in or Create an account to join the conversation.

*mrli999*on topic

*How can carry out dual-column multiple numerical input?*

tpartner wrote: Try this for the following requirements:

- Nothing is answered

OR

- Both columns total to 0

OR

- One column totals to 100

count(self) == 0 OR (sum(self.sq_curr)== 0 AND sum(self.sq_ago)== 0) OR (sum(self.sq_curr)== 100 OR sum(self.sq_ago)== 100)

perfect!!!

Please Log in or Create an account to join the conversation.