VetIndex Ltd, Bath UK
CRM and Sales Management Solution
VetIndex Ltd are specialist publishers serving the UK’s Veterinary sector with a range of services including Practice Newsletters, Online Continuous Professional Development Courses and the publication of the UK’s only A-Z directory of veterinary products, supplies and services.
The entire operation is run on a centralised FileMaker Pro solution that we have been supporting for over a decade.
VetIndex often mail out information to veterinary practices stored on their FileMaker CRM database.
The problem was that the searches were taking too long as they required that Simon and his team laboriously research then build up the practice lists from a series of postcodes that more or less corresponded to the targetted area.
Our solution was to lookup the longtitude and latitude of all of the postcodes stored within their FileMaker database then write some code to isolate practices that were located within the stipulated radius of a given postcode’s longtitude and latitude.
The code included an intuitive Wizard that prompted Simon and his team for the starting postcode and the size of the radius [in miles] out from that point.
The resulting map and list [as per example] clearly illustrates the relevant practices which once checked could be output as letters and/or emails directly from FileMaker or exported out as a .csv file for use in third party apps such as ‘MailChimp.’