Validation for multiple array options

More
1 week 2 days ago #181620 by sbcha28
We used the array (texts) question type to create the attached question. Is there a way to restrict just one of the columns as numeric entry only? In our case, hoping to restrict the middle column to numeric entries only.
Attachments:

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

LimeSurvey Partners
More
1 week 2 days ago #181621 by Joffm
Hi,
well, it's exactly as you say it:
The entries of the column have to be numeric.
...
So you use the function "is_numeric(Q1_SQ001_X002) AND is_numeric(Q1_SQ002_X002) ..." where X002 is the code of the second column.

Or you can use Regular expressions.

Everything you find in the manual.

Joffm


Volunteers are not paid.
Not because they are worthless, but because they are priceless

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

More
1 week 1 day ago #181624 by Joffm
BTW:

The solution with regular expression could be:

For whole numbers (not starting with "0")
Question validation equation:
(regexMatch("/^[1-9][0-9]{0,}$/",self.sq_SQ001_X002) OR is_empty(self.sq_SQ001_X002)) AND
(regexMatch("/^[1-9][0-9]{0,}$/",self.sq_SQ002_X002) OR is_empty(self.sq_SQ002_X002)) AND
...

Joffm


Volunteers are not paid.
Not because they are worthless, but because they are priceless

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

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!