Jump to content

Search the Community

Showing results for tags 'duplicates'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
    • Product Ideas
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FileMaker Vendors
    • FM Starting Point - By Richard Carlton Consulting
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • Comm-Unity Networking Systems (CNS)
    • SmartPill PHP Edition
    • FileMaker Plug-Ins
    • Accounting Solutions
    • FM Easy Suite Framework
  • FileMaker Training Resources
    • Professional FileMaker Training
    • ISO FileMaker Magazine
    • FileMaker Developer Conference
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins

Found 4 results

  1. Hey guys, How does Mirrorsync actually work? Does it use the creation timestamp to find and sync the same records? I have a problem where after a sync last night, I'm left with about 146 duplicates of each record. Quite a few of my records don't have creation field data as this field was only created after I already had many records in the database. Needing to rectify this quite urgently, so any help or input will be greatly appreciated. Thanks in advance!
  2. How to delete all duplicates

    I have a table with about 100,000 records. One of the fields in the table is called "DecimalNumber" (type is "Number"). There are many records (perhaps 10 to 20%) which have the same value in that field as another. Sometimes only 2 records have common values, sometimes more. What I want to do is to delete all records except one of each of those which share a value, thereby removing 'duplicates'. How do I achieve this? I assume a script will be needed, if so please can you give me the whole of that script. Many thanks in anticipation.
  3. Finding/Marking Duplicates

    I have only been working with FileMaker for a couple of months now, and it seems pretty daunting. The most pressing issue that I need help with is finding the duplicates in my contacts database. I've followed the instructions found here: http://help.filemaker.com/app/answers/detail/a_id/3441 And here is my script: My "UniqueID" field uses the contact's last name and email address to calculate a unique id. I followed the instructions exactly... slowly figuring out how to accomplish each step. I am fairly confident that every step is correct except for "If [$id = Scratch::UniqueID]" because I didn't know how to enter the variable into the calculation. I just typed it in... which I don't think is correct. Also, on my computer (in the picture) the $ sign looks more like an S, but on another computer it looks as it should. Thank you for any time and advice you're able to give!
  4. Hello, This one is a bit tricky: I have a database with people where the email is the primary key. These people can have one or more values from a value list. The value list are different check box categories that the person belongs to, like what type of movie they prefer: Action, Comedy, Cartoon etc. Is there a script or function that will check for duplicates on import and retain the existing values, and just append the new category? Or in other words: Jack@example.com already exists in the database and he likes "Drama" and "Detective movies" In an external text file, with several people, there's also an entry for jack@example.com "Romantic comedy" When this duplicate record is found, I'd like the import process to append "Romantic Comedy" to Jack's record, so it reads: jack@example.com "Detective movies", "Drama", "Romantic comedy" It's given that I've created the new value list entry before importing. Thanks for any pointers. Regards, Willy T. Koch Norway

Important Information

By using this site, you agree to our Terms of Use.