Hi,
I have two fields in a form, one of then always starts with “OP” and the other one can be whatever. The data is filled by reading a QR code and sometimes they put the data in the wrong field. I have been able to validate one of then with the expression STARTSWITH([Operario], “OP”) and i would like to do the opposite in the other field, that is, whatever they punt in can´t starts with “OP”. Is this possible?.
If it isn´t possible, how could i validate only the data with more than five characters?
Thanks.
Solved! Go to Solution.
Just a quick thought on this without trying myself, but could you try NOT(STARTSWITH([Operario], "OP"))
Just a quick thought on this without trying myself, but could you try NOT(STARTSWITH([Operario], "OP"))
I tried NOTSTARTSWITH but the expressión was incorrect.
Your expression seems to be right, but it doesn´t behave as expected.
My mistake. Your expressión works perfectly. Thank you!
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |