We have created FileMaker database systems for a wide range of clients and industries. To help you get an overview of what we do let us share with you a few of the systems we have created.
We started work with Andrew Winch, the founder of Winch Designs, in 1995 and have worked with his company as it grew from 10 staff to now over 70.
Winch Design create some of the largest and most fabulous mega yachts on the planet. They create the interiors for large private airplanes and the interiors of castles and mansions all over the world.
The systems we created for his company have helped with time management, project quoting and monitoring and more recently with the specification, budgeting and procurement of the all the products needed for the fit out of all of these projects.
The projects require a lot of reports and schedules which could take hours to produce and format. The staff are able to generate reports with a few clicks and in minutes have the printers whirring or emails flying.
We started work with Coexistence in 2001. Coexistence assemble furniture packages for office contracts and for residential schemes. With orders ranging from a few thousand to several million pounds the skilled staff are able to select and propose coordinated designs for major UK corporations.
Over the years we have produced together a system that manages quotes, order confirmations, suppliers orders, shipping management, client invoicing, staff commission calculations and stock control.
A great deal of coordination of dates and data is required to ensure that the staff are able to deliver the furniture packages to the client on time. The system assists in the collection of the data, the reformatting and restructuring of it to create the multiple documents needed to purchase the items, have them delivered, installed and paid for. The system also needed to allow external access so that the storage warehouses could keep stock records up to date.
We have taken on the ongoing development of the David Collins Studio FileMaker System.
The system that exists assists in the collection of data to help with the interior fit out of the prestigious projects that the studio is commissioned to work on.
This is a great example of where two clients, David Collins Studio and Winch Designs appear to be in the same industry with the same requirements. But each has a unique niche in the market and so whilst the systems are similar, one could not copy one system and insert it into the other office and expect it to work. The needs are different, the time scales are different and the method of working is different. Having a system that is specific to each clients' requirements helps them be as efficient as they can be without the need to ignore features that irrelevant.
We were very keen to work with a company that was involved in renewable energy. L C Energy are one of the largest suppliers of Bio Fuels in the UK. They supply fuel to some of the largest boiler installations in the England and also to the domestic market.
The system we produced for L C Energy manages the quoting, delivery run management, the recording of deliveries using iPads and the return of that data to the office for invoicing.
This system needed a main office element and a remote element. Data is prepared in the office and then uploaded to the truck driver's iPads where delivered quantities and client signatures are collected. The resulting data is returned to the office for invoicing. This process used to take up to a month to process and is now completed within hours, dramatically improving cash flow.
RAL required a system to record the delivery of waste material to a landfill site. The partner trucking company finds and organises the collection and delivery of the waste material and RAL provides and manages the site where the waste is being used as landfill.
The issue here was the management of the strict environmental compliance standards demanded by the Department of the Environment.
The system needs to collect four types of data coming in from four parties, all by email. The emails are sent to the system which then identifies the type of data being received and inserts it as needed. The data relates to the initial waste inspection, a number of deliveries of the waste to the site, photographs of the waste material and chemical analyses taken of the waste. Each data type arrives from different sources and needs to be checked for completeness and accuracy. The system then assists with reporting on the deliveries made each week and invoicing to the trucking company.
A second aspect was to work with the trucking company - Axtell Ltd - to link the system to their PDAs to further reduce the need for data entry.
We have worked with FileMaker since 1995. The first system we produced was designed to manage Architectural practices. The idea being to generate a single solution that would fit all. We soon discovered that there was far more benefit to the clients if the system was written to their specific requirements. No two companies work in the same way.
There are some great off the shelf products that work well when there are well established industry standards or compliance constraints. But where these do not exist or where they are still under development we have found that having a bespoke solution greatly benefits the client. They are able to request system changes to meet new requirements or working methods and see these changes implemented within hours or days rather than having them languish on wish lists.
Since those early years we have produced over 24 major systems.
Previous systems include:
Neals Yard Dairy
Neals Yard Dairy - Wholesale, Mail order and online cheese sale
Order processing, Shipment management, Customs paperwork, invoicing, delivery route planning.
The Conran Shop
Management of product development, selection and production.
Client relationship management, List management, reporting and invoicing.
Contract furniture supply
Quoting, order processing, client invoicing.
Online specialist publications
On line book purchase, data gathering, automated conversion to publication layouts and order taking.
Design development, sample management, client order taking, component ordering and client invoicing.
The Picture Canning Company
Television Broadcast and filming equipment hire
Quoting, job processing, stock management, packing lists, shipping documentation, client invoices, management reports.
Childrens Education Charity
Membership management and correspondence.
The Diana Award
Childrens Anti -Bullying charity
Membership management and correspondence
Online parts sales website
Stock offering, back office management system for multiple suppliers, client accounts. order taking and shipping cart system, multiple currency management, suppliers orders and invoice management.
Sound Equipment hire for large events.
Quoting, order processing, packing lists, stock management.
Online specialist magazine subscriptions
On line product list, order taking and processing, multiple currency management, back office order fulfilment. New supplier telesales operation and commission system. SEO tools and on line marketing system.
Import industry client lists and current projects lists from Barbour Index, Mass targeted and personalised marketing tool. Management feedback reports, quoting and suppliers orders.
Quoting, job bag and client invoicing.
Air and Water quality testing and monitoring
Quoting, job scheduling, client invoices, large contract management.
High Street fashion
Seasonal Product range, client ordering module and invoicing, stock management. Catalogue booklet production.
Solar Panel Installers - In House Call Centre
Prospect list management, campaign management, targeted concentration of calls, tiers call managers, call back management. Reporting on caller performance. Appointment booking management.
t. 01428 717 611
© Copyright 2016. All Rights Reserved.