Скачать с ютуб Stop duplicate records! Require unique values in Quickbase в хорошем качестве

Stop duplicate records! Require unique values in Quickbase

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. ***FREE GUIDEBOOK*** The Ultimate Grid Edit Guidebook: Using Grid Edit will never be the same! https://quickbasejunkie.com/grid-edit... FROM THE VIDEO: "...Let's say I have an issue with duplicate customers being entered on this table. Let me show you why. I'll add a new customer with the same name it's an existing company and I'll click Save. There's nothing that prevented me from creating that duplicate customer. Let me show you how we can change that. I'm going to right-click on the label for customer name and choose edit the properties for this field. With the customer name field settings open, you can see I can click on the 'Must be unique box.' This box is checked it will require all entries in that field be unique. In this case because I have existing data I may also want to check existing entries for duplicate values. Now, because I know I just entered a duplicate value, let's see what happens when I check that box and click Save. You'll notice Quickbase has given me an error saying the existing values in the field customer name are not unique. Unfortunately this is the most information I'm going to get. I'll need to go back into my table and sort by that field and identify those duplicate records. I could also create a summary report with that field in order to find my duplicate records and change them either to no longer be duplicate or to delete the duplicate record. We'll go ahead and click OK and let's go ahead and delete that record ourselves. Back on the record I can now delete the customer. And here I'll go ahead and make another edit to the customer name field properties getting here slightly different way this time from the report. And now that I know I don't have any more duplicates I can check the 'Must be unique' and 'Check for duplicate entries' and click Save. You'll see here it allowed me to save because there are no duplicate entries. Well let's see what happens when I try to enter a duplicate customer. You'll see I've gotten this error message that says that "The fields that are marked unique must contain unique values for all records. You have entered a duplicate value for the unique field customer name please check your data and try again. The customer was not saved." So in this instance we prevented that duplicate customer..." Feeling like a Junkie? Subscribe Now! https://www.quickbasejunkie.com/sign-up LET'S CONNECT! LinkedIn ➤   / quickbasejunkie   Instagram ➤   / quickbasejunkie   Facebook ➤ https://fb.me/quickbasejunkie Quick Base Junkie ➤ https://quickbasejunkie.com Learn More About Quickbase @ https://quickbase.com © Quick Base Junkie COPYRIGHT NOTICE: The content, title, description, and specific ways in which the information in this video is organized, documented, and presented are the creative property of Quick Base Junkie. For use in any medium attribution is required, for questions or use permission, contact me @ https:/quickbasejunkie.com/contact. Quick Base Junkie is unofficial and not affiliated with Quickbase Inc.