The purpose of this formula is so that the field requires 9 digits and doesn’t allow any more or less. This is not working. Any suggestions? Thanks!
@Length(Field) = 9; @Failure(“The field is limited to 9 characters”); @Success)
Subject: Input Validation formula
Besides what Karl said, the formula as written is doing the exact opposite of what you want.
Change the = to != and it would be the correct statement
Subject: Input Validation formula
- What does “not working” mean? Error message?2) The formula is not complete, as you posted it. Can you even save it like that?
Subject: RE: Input Validation formula
Sorry Karl, yes you are correct this is just the last part of the formula, I didn’t post the whole formula. And what I meant by not working is that originally I used >9 which worked but then the user changed the requirement and said nothing less than 9 as well. When I used = it did not produce any results.
Martha yes that does work but I am having an issue of when the message pops up because this is a field that is atuo populated from another system when a hotspot is initiated on another field. I am probably not articualting this very well, but basically I wanted to see if the operator part of the formula was even correct before I try to figure out the other issue. Thanks both for your help!