7 Replies Latest reply on Feb 25, 2016 12:50 AM by m.swanston

    Restrict input to a number in the format NN.NN

    m.swanston

      Hi

      I have added a new field to my FM solution (FM14) and have been told that it can only be in the format NN.NN ie two numbers, a decimal point/period followed by two numbers. I tried to write a calculation to validate it but couldn't get it right, then wondered if I'm complicating things too much? The field is currently set to be numeric with a maximum of 5 characters, which is fine but I want to ensure that users enter it exactly as required. I've searched and found lots of examples for an input mask for a phone number, but can't find anything to get me started with this question.

      Any help/advice/suggestions gratefully received

      Thanks

      Martin