Article Tags

Hide tags

Click or tap one of the article tags to filter down to a smaller selection.

Show all content

Videos about "duplicates"

3 videos found.
Catching Duplicates with Validation 02/19/2021 - 8:00am

One of the best feelings for any database developer is knowing that duplicate data simply can't sneak into your solution. You've got clean data such that when you search for a specific email address you know there's only one and it belongs to the right entity.

In the associated video and sample file you'll get all the details for how you can use FileMaker's Unique value validation option. You'll see how you can prevent FileMaker from showing it's annoying dialog box which uses the name of the field when a duplicate is entered. Additionally, you'll be able to execute your own script when the validation is triggered and do really cool things like locate and present the existing instance to the user.

It's helpful features like this that make using a database system that much more user friendly. And this is where you'll find all the details.

List View Grouping Indicators 12/26/2019 - 4:49pm

There are all kinds of methods for using indicators within FileMaker. We have multi-segment button bars, using the Hide calculation on any number of layout objects and, of course, there's simply using text alone to indicate something. In one of my more recent projects, I needed to group duplicates together.

While normally you'd want to rid your system of duplicates, this particular use case actually wanted them retained as an indication of importance or urgency. So, what was really needed was a method to indicate which members were part of a duplicate group or not.

Within this video article you'll find a very good use of a variety of methods to identify a duplicate and then indicate if it's part of a group of duplicates.

If you've ever have a need for this type of display, you're in luck. And, even if you don't, you'll learn how you can make one record aware of its neighbors. Of course, what you do with that information is between you and your records. ;)

Identifying Duplicates 06/14/2019 - 2:21pm

You may be familiar with the routine when you have multiple duplicate records in your database. You end up having to reference multiple sources. Which can be a real pain. Ultimately, you end up needing to decide which record is the master and then merging as much of the data as possible from any of the duplicates.

This is a common scenario with any multi-user database system. Where, anytime you have more than one person working on the same data, you can inevitably end up with duplicates.

There are a few ways to deal with duplicates. The first is to try to prevent them in the first place. While this is certainly possible, there are other times where routine imports come from external sources or you've simply allowed duplicates to be entered into the database.

The question now is, "How do you identify duplicates?" and how do you address the fact that our eyes can trick us when we're looking at data which appears exactly the same - yet it's not. This video will show you how to truly approach duplicates and how to deal with them by giving you full control over defining what determines a duplicate or not.