Jump to content

interrobang

Newbies
  • Posts

    3
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

interrobang's Achievements

Newbie

Newbie (1/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

0

Reputation

  1. Thanks for taking the time to try and figure this out. In the end I just deiced to create a "UniqueID" field that combined the contacts' first and last names, then used FileMaker's native duplicate search. Not totally ideal, but I think the end result is actually the same as the script would have been (if it had worked).
  2. Thank you for your prompt response! I guess it probably would have been helpful if I showed the results of the script... Unfortunately, running the script produces the same results whether the Set Variable [$id; Value ...] is before or after Loop. There are strange problems with the results as well. A partial screenshot: As you can see, the UniqueID field seems to be working correctly. The script not so much. First, shouldn't the script result in a list of only records marked as duplicates (an "X" in the Duplicate field)? Second, why are some records marked as duplicates when they're obviously not? I would definitely like to try your more efficient version of the script, would your three steps simply replace all actions between Loop and End Loop? And should it look exactly as you've typed? I so appreciate your help.
  3. 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!
×
×
  • Create New...

Important Information

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