Skip to main content
Question

Data Validation Strategy

  • March 31, 2020
  • 0 replies
  • 23 views
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 time. 

Is there a data validation or script that I can create that checks to see if a school has entered more than one time. I am checking this manually daily by sorting by the day and their school number, but it would be nice If I could create some sort of script or report that indicates duplicate entries on the same day for a single school number. 

I am probably missing something so obvious - any help is appreciated

------------------------------
Ryan Shook
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+11
  • IvanWeiss
  • Registered
  • March 31, 2020

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
------------------------------
Terms & ConditionsAccessibility statement