The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

Validate FileMaker Data In A Range – FileMaker Today

Get real time updates directly on you device, subscribe now.

The in range validation is used to make sure the data entered falls in between a starting value and an ending value. When setting up this validation, the lowest acceptable value would go in the box on the left and the highest acceptable value would go in the box on the right. An example would be a teacher entering in student’s test scores. You would want to enter in a range between zero and 100. This way, no one could accidentally type in a score of 700 when they meant to type in 70.

The in range validation setting is primarily used for fields defined as number, date or time data types. The in range option can even be used for text but any form of text range operation is very uncommon. I guess you could use the timestamp data type as well for data entry validation but I don’t see that many users manually entering in timestamp related information. Timestamp data would normally be auto entered ( via a calculation ) or by a execution of a script step.

FYI … it would not be uncommon for the range validation setting to be used in concert with one of the other validation settings. A number range validation would likely be used with the numeric only strict data type validation.


More info about the author and FileMaker in general, contact me at This email address is being protected from spambots. You need JavaScript enabled to view it..

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More