Web & Database Development

Bromptons Opticians

Bromptons of Brighton is a boutique optician located in the vibrant North Laine district of Brighton. Independently owned, they offer an exceptional selection of contemporary and stylish designer eyewear, including bespoke, handmade, and vintage frames, along with lenses, sunglasses, and accessories. They provide comprehensive eye care services, including eye exams, lens fittings, and repair services.

Creative Brief

The Situation

An existing Access-based system was being used for managing patient records and booking appointments, but it was no longer suitable. A rather complex Excel spreadsheet was utilised for order management, while payment and refund details were tracked via till receipts, and paper forms were used to document bespoke order processes. A small number of PCs were employed to access these disparate systems and manage stock control.

The Solution

A new network infrastructure was established, with Apple devices forming the foundation of a comprehensive FileMaker database. This system securely stores patient records, manages appointments through an advanced calendar, and includes postcode lookup for easy data entry. Optician rotas and holidays are integrated into the calendar, while products and stock are tracked via barcode scanning. Orders are monitored down to individual components and payment status, with automated SMS and email reminders for patient appointments and collections.

The Results

All day-to-day operations of the shop are centralised within the FileMaker database, significantly reducing administration time. Multiple Mac computers throughout the shop provide easy access to all necessary information. Access-restricted functionality within the database prevents accidental data errors, ensuring accuracy. Staff can quickly switch users, allowing secure login and logout from the custom database, maintaining data security. An extensive dashboard and reporting system offers real-time data to senior staff, providing live insights as needed.

What We Did

We began with an initial on-site meeting to understand the client’s needs, followed by in-depth specification refinement to ensure all requirements were met. We designed an interface mockup aligned with the company’s branding, incorporating features such as patient record management, a streamlined appointment booking and calendar system, and comprehensive product and stock management. We also implemented order processing, integrated a postcode lookup function, and set up an SMS and email communication system. An advanced dashboard was developed for real-time reporting. After thorough in-place testing, the solution was deployed, and we continue to provide ongoing support and maintenance to ensure its smooth operation.

Ready to join tech pioneers?

Browse our career opportunities below

Claris Studio / FileMaker and AI Developer

As a Claris Studio / FileMaker and AI Developer, you'll create innovative business solutions using Claris platforms and AI technologies. You'll work on diverse projects, developing database applications, integrating AI functionalities, and leveraging Claris Studio's features. If you're passionate about creating powerful, user-friendly solutions, fill out our application form to join our team and shape the future of business applications.

Ready to Elevate Your Digital Presence?

Don't get left behind

Ensure your business stays ahead with cutting-edge digital solutions. Contact us today to keep your company at the forefront of your industry and continue thriving.

Stay Connected with iSOS

At iSOS.com, we specialise in custom software development, web development, and IT consultancy, leveraging Claris FileMaker, Laravel, and AI technologies to create tailored digital solutions that enhance business efficiency and maximise ROI.

Copyright: © 2024 iSOS. All Rights Reserved.

Ready to join tech pioneers?

Browse our career opportunities below

Claris Studio / FileMaker and AI Developer

As a Claris Studio / FileMaker and AI Developer, you'll create innovative business solutions using Claris platforms and AI technologies. You'll work on diverse projects, developing database applications, integrating AI functionalities, and leveraging Claris Studio's features. If you're passionate about creating powerful, user-friendly solutions, fill out our application form to join our team and shape the future of business applications.

Ready to Elevate Your Digital Presence?

Don't get left behind

Ensure your business stays ahead with cutting-edge digital solutions. Contact us today to keep your company at the forefront of your industry and continue thriving.

Stay Connected with iSOS

At iSOS.com, we specialise in custom software development, web development, and IT consultancy, leveraging Claris FileMaker, Laravel, and AI technologies to create tailored digital solutions that enhance business efficiency and maximise ROI.

Copyright: © 2024 iSOS. All Rights Reserved.

Ready to join tech pioneers?

Browse our career opportunities below

Our Services

Claris Studio / FileMaker and AI Developer

As a Claris Studio / FileMaker and AI Developer, you'll create innovative business solutions using Claris platforms and AI technologies. You'll work on diverse projects, developing database applications, integrating AI functionalities, and leveraging Claris Studio's features. If you're passionate about creating powerful, user-friendly solutions, fill out our application form to join our team and shape the future of business applications.

Claris Studio / FileMaker and AI Developer

As a Claris Studio / FileMaker and AI Developer, you'll create innovative business solutions using Claris platforms and AI technologies. You'll work on diverse projects, developing database applications, integrating AI functionalities, and leveraging Claris Studio's features. If you're passionate about creating powerful, user-friendly solutions, fill out our application form to join our team and shape the future of business applications.

Ready to Elevate Your Digital Presence?

Don't get left behind

Ensure your business stays ahead with cutting-edge digital solutions. Contact us today to keep your company at the forefront of your industry and continue thriving.

Stay Connected with iSOS

At iSOS.com, we specialise in custom software development, web development, and IT consultancy, leveraging Claris FileMaker, Laravel, and AI technologies to create tailored digital solutions that enhance business efficiency and maximise ROI.

Copyright: © 2024 iSOS. All Rights Reserved.