Quick Base Junkie Blog

Short videos and posts to skyrocket your Quickbase skills!

Get tips in your inbox

Join the Quick Base Junkie Community email list!

Back to the Blog

Stop duplicate records! Require unique values in Quickbase

beginner fields how to Sep 27, 2018
Stop duplicate records! Require unique values in Quickbase

Subscribe on YouTube

Do you often have to 'clean-up' your data to remove or merge duplicate records? This can be a time consuming and frustrating task.

Requiring unique values is often used to prevent duplicate entries. It does so by requiring the value not exist in that field for any other record. If your data contains unique items like the following, you'll want to watch this video:

  • Customer or Prospect
  • Employee
  • Company
  • Department
  • Etc.
 


The steps to require unique values depend on if you already have existing data (and possible duplicates).

Before enabling unique values for any field, you'll want to first eliminate any existing values. Otherwise, it will only prevent new records from being duplicates. I'll walk you through all these details. The basic steps are:

  1. Edit the field settings
  2. Check the 'Must be unique' box
  3. Save the changes

Once you lock down your unique values you'll no longer be do'n the duplicate clean-up!

 

 

 

 

Feeling like a Junkie?  Subscribe Now!

Recent Posts & Videos from the Blog