Trouble getting my duplicate record script working. Please help.
I've taught myself filemaker and i'm not good with scripts. I went through the tutorial and cannot get this script working.
Here is the table. If you want more information please ask.
Thanks so much - in advance!!
It may be easier to say exactly what you want the script to do, then comment line by line what you think it's doing. Seems to me the only thing this script is going to do is replace all the Id's with the first one, but your set field script step is wrong (luckily).
A few things stick out.
What is the 'Replace Field Contents' suppose to do?
I was following these instructions.
Yes but you missed a few tidbits ......
You missed on Replace Field Contents, the calculated result of ""
And.. your If step is not the same.
And...your Set Field is wrong....
Keep in mind this script is designed to create a found set of duplicate records for you to delete. You have to make sure you absolutely end up with only a found set of duplicates, or you will lose records. I strongly advise you to back up your database before you duplicate records. BTW is this a recurring problem (duplicates)? If so, it may be better to figure out a way to avoid them in the first place.
Also keep in mind, if you are using a unique ID as your primary key, this script may not work as advertised. In other words, if two people or one person twice, creates a duplicate record of a customer, the Unique ID will be different.
When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.
Retrieving data ...