AnsweredAssumed Answered

Please help with Finding, Marking, and Deleting duplicates using a script

Question asked by jeffbrownell on Nov 8, 2011
Latest reply on Nov 8, 2011 by philmodjunk

Title

Please help with Finding, Marking, and Deleting duplicates using a script

Post

I'm new to filemaker pro and i need help creating a script to find/mark all the duplicates on a database with several hundred thousand entries. I've tried using this script, but i come up with an error at the replace field contents entry.

Show All Records
Sort Records [Restore, No Dialog] Sort by Client ID in Ascending order
Go to Record/Request/Page [First]
Replace Field Contents [No dialog, 'Mark', " "]
Loop
Set Field['Global','ClientID']
Go to Record/Request/Page [Next, Exit after last]
If ['Global = ClientID']
Set Field ['Mark', '"X"']
Else
Set Field ['Global','ClientID']
End If
End Loop
Perform Find [Restore] Find records when Mark = X

.if anybody could offer some helpful advice it would be greatly appreciated as I have almost no idea what to do I've tried multiple scripts from the help section on the filemaker website but nothing seems to be working. I must be making more then one mistake because my scripts never look the exact same as those posted on the website if someone could give me some step by step directions perhaps I'd have more luck. I'm close to running out of time to finish this project so if someone could please respond soon I'd be extremely grateful

 

thanks

Jef Brownell

Outcomes