Knack Blog Better Data with Validation Rules

Your database is only as good as the data it contains.In most cases this is obvious. If you are calculating order totals, you're assuming each order is a number that can be added together. If you are running monthly reports then you'd better have some valid dates so you can group by month.Other cases are more subtle. You may want to only accept dates that are in the future, or define allowable ranges for a number.Data that breaks these types of rules may not crash your database, but getting that data right can be just as critical to ensuring your database is meaningful and correct.Knack has always helped by ensuring field types and providing options for values to be required or unique.We recently added a new feature to take validation to the next level: validation rules.