AnsweredAssumed Answered

Case sensitive data entry

Question asked by JohnDennis on Mar 2, 2013
Latest reply on Mar 2, 2013 by JohnDennis


Case sensitive data entry


     Hi all, first post here! I have been using FileMaker for some time now, but obviously I'm still learning, so bear with me if I've missed something obvious here.

     I'm just wondering if there is a way to validate a text field so that only numbers and uppercase letters can be entered into it.

     The reason I ask is that I am creating a field where the text will be used to generate a barcode. However, the barcode font will only allow uppercase letters and numbers, so I need to restrict the field to only accept this kind of text.

     My other option is to investigate having a relationship set up with another table where a serial number is generated for the client, and have this serial number return the client's record when scanned. I would prefer not to have to do this, however, as it could be annoying to set up.

     Thanks in advance for your help!