R5 - Using formula language (fairly simple)

[JoseQuiervo]

I want to have an @If determine that if the field value is >= 10 and <=25 and another field's value is >10, then the result will be "Failed". But using 3 &'s isn't working and I figured this out before, I'm just having a lapse this Friday afternoon.

Example of what's not working:
@If(Field1 >=10 & <=25 & Field2 >10; "Failed" ; Field2)

Thank you for the help, have a great weekend.

 

[lespaul]

what about:

@If(Field1 >=10 & Field1 <=25 & Field2 >10; "Failed" ; Field2)


Leslie

 

[mswymer]

I am trying to use the following formula to make sure that a field is equal to 9 characters. Does anyone have an idea as to what could be changed with the formula to make it work? I've moved a few things around, but still no luck.

@If (@Length(*fieldname)=9;@Success;@Failure("Number must be 9 characters"))

 

[pmonett]

mldavis :

You should create a new post for this question.
Are you controlling a number field, or a text field ?
Your control is almost good for the Validation formula of a text field.
I would have written it like this :

@If(@IsDocBeingSaved & @Length([i]fieldname[/i])=9;@Success;@Failure("Number must be 9 characters"))

Unfortunately, this control does not work for a Number field, because @length can only be used on text.
Therefor, if it is a number you need to do this :

@If(@isDocBeingSaved & @Length(@Trim(@Text([i]fieldname[/i])))=9;@Success;@Failure("Number must be 9 characters"))

Pascal.

 

[mswymer]

Thank you, but the formula was fine...just needed to hit a key that I didn't think to use.