AnsweredAssumed Answered

Restrict input to a number in the format NN.NN

Question asked by m.swanston on Feb 24, 2016
Latest reply on Feb 25, 2016 by m.swanston


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