Versione 3.28.76Hi, I'm looking for an expression for validating a multiple entry numeric response (attached).
The response is validated if:
1. both boxes are empty;
2. if at least one of the two is full with a maximum length of 4 numeric digits
These two work
But I would need to enter a third option:
3. i.e. if both are filled in then the first value inserted must be lower than the second.
Here is the expression I am using (the bold part works but the second one doesn't)(is_empty(D1a3_SQ001.NAOK) OR strlen(D1a3_SQ001.NAOK) == 4) AND (is_empty(D1a3_SQ002.NAOK) OR strlen(D1a3_SQ002.NAOK) == 4) OR (!is_empty(D1a3_SQ001.NAOK) AND !is_empty(D1a3_SQ002.NAOK) AND D1a3_SQ002>=D1a3_SQ001)how can I solve it

Hi, 
To achieve that sett the validation to
count(self)<2 or (count(self)==2 and Q1_SQ001<=Q1_SQ002)
with a validation tip like
{if(count(self)==2 and Q1_SQ001>Q1_SQ002,"Conclusione greater or equal sottoscrizione","")}

Furthermore you may force the four digits and at the same time a certain range of years by a regular expression like
/^(([1][9][5-9][0-9])|([2][0][01][0-9])|([2][0][2][0-4]))?$/
Here from 1950 - 2024

 

Joffm

Thank you Joffm,
This work
count(self)<2 or (count(self)==2 AND D1a3_SQ001.NAOK<=D1a3_SQ002.NAOK)

Can I add a limit to the string of numbers which must be equal to 4?

I just put this
/^([1-9][0-9][0-9][0-9])?$/
is correct?

It is correct syntax, but it allows 
1492
8745
Not very realistic years

and if i want a range between 1900-2100? What i have to insert?

You see what I entered to limit from 1950 to 2024.
And you may use
[url] regex101.com/ [/url]
to get more familiar with regular expressiona.
 

Thanks Joffm

/^(195[0-9]|19[6-9][0-9]|20[0-9]{2}|2100)$/