Forum Discussion

RyanShook's avatar
RyanShook
Qrew Trainee
5 years ago

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 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
------------------------------
Formulas and functions
Tables and fields
  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    5 years ago

    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's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      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
      ------------------------------