Forum Discussion

KatieBardwell's avatar
KatieBardwell
Qrew Member
6 years ago

how do i prevent typographical errors to the date field?

I want to create a rule that kicks back in error when a date is before 1997 and after 2027 but I don't need the error to fire if the date field is blank.  I've tried this with the new table base rules...
Forms
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
You can use the new feature called data validation.  You make a formula field to calculate an error message or calculate to blank.  If blank then the record will save, else it will not save.  This also works for grid edit and imports.

Data Validation is set on the Advanced settings for the table.