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.
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
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