Skip to Content
avatar image
Former Member

Can Measurment Field be validated??

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 11, 2011 at 10:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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