Data Validation Strategy
I am a relatively new user and I learn an enormous amount from all of you so thank you! My question, I have a form which schools enter their attendance in daily. I only want them to submit one...
Forum Discussion
Ryan, welcome to Quick Base! If you do not want a field to be repeated the best way to do that is to make it a unique field. That will prevent double entry.
you mentioned schools though. You might have some entry errors for example Xxxxx High School vs Xxxxx HS
so maybe consider prepopulating the type of school with a dropdown to control the data entry? You could use a formula to create a normalized name as another field combining those two fields.
------------------------------
Ivan Weiss
------------------------------
- MarkShnier__You
Qrew Legend
Ryan, you can make a text formula field like this.
List("-", [School Name], ToText([Reporting Date]))
and mark it as Unique, there is a checkbox for that. It will block dups.
i suggest that you call the field something like
School and Date must be Unique
as the field name will come up in the error message when attempting to save a duplicate.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
