2 Replies Latest reply on Apr 19, 2012 4:08 PM by rcbran

    Scrubbing Issue

    washutech

      We are going to use FileMaker 12 in our telemarketing center. We have every thing else done, except the Do Not Call list. Each database would need to be scrubbed each month, but we need to keep the notes from the calling lists. How can we keep the lists in FileMaker, but keep them clean of DNCs? The calling lists are small, but the DNC list has ten million plus phone numbers in it.

        • 1. Re: Scrubbing Issue
          Stephen Huston

          We need to know more about your current or likely file structure to provide any real detail. However,

           

          If you are tracking records at the phone number level, you could do an import which updates existing records based on the DNC phone numbers as the match field to set a flag field in your table for the DNC field. This need not change any data except the DNC flag field itself.

          • 2. Re: Scrubbing Issue
            rcbran

            Wouldn't it be possible to run a script monthly to compare each record to the DNC list and if it finds a match, to flag the record as DNC?