Can Measurment Field be validated??

[Former Member]

Hi Experts,

I have a field called Selling Space (Type: Measurment)

Like you all know once this is set, user can enter a numeric value and can select the appropriate Measurment from the List Which is tied to the same field.

Now, i need to restrict the user to select Either ''Sq feet'' or ''sq meters'' .

If he select any other type from the drop down then the validation should fail!!!

Is it possible to validate a measurment field??

I thought of using the Has any values but not sure how to include the measurments in it!!!!!!

I thought of placing the ''Sq feet'' and ''sq meters'' in a lookup table , But then it will be 2 fields..

Selling space

Measurment look up field (from were user select either of the 2 values)

What would you suggest??

Kind Regards

John

[Former Member · Accepted solution]

Hi John,

As you mentioned you have created Selling Space field as of type Measurement (And I assumne Dimention must be Area)

So try below validation expression & see if it works for your requirement:-

( ( RIGHT(Selling Space,3) = ft2) OR ( RIGHT(Selling Space,2) = m2) ) AND

( RIGHT(Selling Space,3) <> mm2) AND

( RIGHT(Selling Space,3) <> cm2) AND

( RIGHT(Selling Space,3) <> km2)

Thanks & Regards,

Maheshwari

[Former Member · Accepted solution]

Hi John,

Your problem got reolved?

Regards,

Mahi

[Former Member · Accepted solution]

Hi Maheshwari Morbale,

Yes my problem got resolved.

But i have written a validation which checks the content of the Field.

used HAS ANY VALUES and selected every thing other than square feet and sqare meeter.

Thanks.

KR

John