Log in
Hot & Trending on FMT

De-Duplicate Within A Found Set Of Records

Featured De-Duplicate Within A Found Set Of Records

This is a quick follow up to the Ralph Learmont technique I posted the other day, in response to a comment seeking a generic technique to de-duplicate a found set. Clearly there are various ways to skin this particular cat, and I have a suspicion my initial attempt can be further improved upon, but using Ralph’s demo as a starting point…

5-11-2015 10-47-47 AM

…here’s what I’ve come up with:  De-Duplicate-A-Found-Set.zip

Bear in mind that the goal here is to make the script as portable as possible, and to dynamically specify the field to be de-duplicated, rather than hard coding it. In this case you specify the field by activating it (clicking or tabbing into it) before running the de-dupe script.

The only thing hard-coded is the SelectedField calculation:

5-11-2015 11-01-27 AM

And here’s the relevant portion of the de-duplication script.


To see it in action, you could, for example…

  • Find all “CA” state entries, activate the FirstName field, run the script
  • Find all “Middle Age” AgeGroup entries, activate the State field, run the script
  • Find all “Milwaukee” city entries, activate the AgeGroup field, run the script

Etc, etc, etc.


Read more http://filemakerhacks.com

Kevin Frank

FMT Staff Note: IF you would like any of Kevin's tip or techniques incorprated into a solution or project contact him at his website below.

Hello and welcome. I’m Kevin Frank, and I’ve been using FileMaker Pro since the late ’80s… professionally since 1995. The expression “hack” has both positive and negative connotations. Here it is defined as “a tip, trick or technique that helps you solve a problem,” and the best hacks are the ones that can be re-used and modified to meet a variety of challenges. Or, put another way, as I read recently in Street Fighting Mathematics, “A tool is a trick I use twice.”

Kevin Frank and Associates provides custom FileMaker database solutions for business, government, education and non-profit clients. With over 20 years experience, we are certified FileMaker Developers with a solid reputation for high quality results. We invite you to call us today for a no-charge, no-obligation phone consultation.

To find many more in depth articles from Kevin and some must have tools and services visit his site at the link below:

Website: www.filemakerhacks.com