Hi people, first of all, thanks for the help.

Ive been looking for infomation with this and Im sure I found it on the past but today I cant found the information.

I have an array text question, I attached here, the row name is SQ001, SQ002... and the Column names is COL1,COL2 and COL3, I need to make the column 2 just allow to insert text and the column 3 just allow insert numbers, that is not a problem with regex, but I dont be able to put the correct equation on equation validation and on the tip of equation validation, can you help me, please?

And why don't you send us your sample file?
Please, ease our voluntary work, send us your tries, so we can improve, correct, whatever.

Joffm

Hi, I try this on validation question equation for the numeric validation

regexMatch("^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$",P3_SQ001_COL2)

and this on validation tip

{if((is_empty(P3_SQ001_COL2) or regexMatch("^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$",P3_SQ001_COL2)), '', 'Please, insert just integers.')}

But seems like the validation tip on array text works different than a multiple short text, because dont work fine.

related to the question, Im sorry, I cant export the lss file because is a too long survey and still not finished.

If you use regexMatch in "Logic" the syntax is:
regexMatch("/^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$/",P3_SQ001_COL2)

Analogue in tip:
{if((is_empty(P3_SQ001_COL2) or regexMatch("/^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$/",P3_SQ001_COL2)), '', 'Please, insert just integers.')}

Joffm

It works, but theres a problem, that question is based on previous question, I mean, if you select 1 on a previous question, you just see 1 row on this question, and doing the validation like this, even if the row 2 dont appear, the error message keep showing and dont let you continue with the survey.

How can we fix this?

I correct myself, if I show the second row the validation let me continue even if I dont insert numbers on the second row




I put this on ecuation validation subquestion
(regexMatch("/^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$/",P3_SQ001_COL3)) or (regexMatch("/^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$/",P3_SQ002_COL3))

And this on the tip
{if((is_empty(P3_SQ001_COL3) or regexMatch("/^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$/",P3_SQ001_COL3)), '', 'Please, insert just integers.')}<br>
{if((is_empty(P3_SQ002_COL3) or regexMatch("/^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$/",P3_SQ002_COL3)), '', 'Please, insert just integers.')}

the previous question is called P1, and have 5 choices, from A1 to A5, I supose we have to add that filter to the validation

I try to put like this

(regexMatch("/^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$/",P3_SQ001_COL3)) or (regexMatch("/^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$/",P3_SQ001_COL3) AND ((P1.NAOK == "A1")))
OR (regexMatch("/^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$/",P3_SQ001_COL3)) or (regexMatch("/^([0-9]|[1-8][0-9]|9[0-9]|[1-8][0-9]{2}|9[0-8][0-9]|99[0-9]|1000)$/",P3_SQ002_COL3) AND ((P1.NAOK == "A2")))

but doesnt work, any idea?

Again:
Better to send your sample.

And we only expact the relevant questions.
So copy the survey, remove everything not related to your question and send the lss export.

Joffm

By the way: If you only want to limit to an integer <=1000, you could use
is_int(Q1_SQ001_COL3.NAOK) and Q1_SQ001_COL3.NAOK le 1000

Ok, thanks hoffman, Im preparing the lss to send you, meanwhile I have another question, I want to sum a different questions, on this case P1 and P2, 2 multiple numerical input, that is easy to do, but I want use the result of that sum to prefill P3 question wich is another multiple numerical input.

I be able to do it in the title of the P3, but on the default response field the number dont change, keeps on 0 all the time, is there any way to do it?

I attache the survey Lss

That is because the default value is only loaded on page-load, it is not dynamic. Move the third question to a following group.

Ok, thanks tpartner