Building a relationship to move forward

Building a relationship to move forward

coding, CRM systems, online platforms, project planning

Building a relationship to move forward

Setting up a CRM system that was fit for purpose required thorough research and testing. The results delivered a robust system that successfully automated tasks and saved staff from hours of data entry.

The brief 

Cube Direct sources products from a large global network of suppliers. A robust solution was required to manage existing supplier data, alongside an efficient process to enter new details onto the system.

The solution

A CRM (Customer Relationship Management) system was thoroughly researched, tested and deployed.

  • Three separate Zoho applications have been integrated, automating much that was previously required to be entered by hand

  • Emails to suppliers are automatically scheduled, with an online platform that allows suppliers to register and update their details

  • A mixture of coding (PHP, jquery and Zoho’s proprietary language) was written to handle any bespoke aspects required

    To see the range and variety of products that the supplier has to offer you can visit the site by using the link shown below.

    https://cubedirect.co.uk/

    The impact

    The CRM has been a success, releasing office man-hours and ensuring supplier information is always up to date. Future development will include increased functionality for the issuing of quotes, automatic supplier selection and customer billing.

    Pic showing several Cube Direct website pages

    Working with a diverse range of suppliers from all over the world, we required a CRM that allows us to select exactly the suppliers we require to make our products. Using Zoho CRM as a basis, we worked with Dan and the team to produce an efficient solution that matched our requirements. Significant hurdles were encountered, but with custom development and the integration of other Zoho products, these were overcome, and we very much look forward to advancing the next stages of the CRM build.”

    Janet Johnson

    Head Account Handler, Cube Direct

    Related projects

    Pic showing the University of Exeter app login screen on a laptop

    University of Exeter Medical School

    Careful planning and coding were required to provide an online platform for GPs to match patient data and samples.

    Pic showing various digital devices all displaying the Aaduki website next to a camera and lenses

    Aaduki Insurance

    Developing an efficient online quotation system helped to streamline the sign up process and boost customers.

    NHS Diabetes Calculator

    Complex scripting was required to produce an online tool to be used in the battle against childhood Diabetes.

    Pic showing Accessibility Services webpage montage

    Accessibility Services

    Data analysis and email marketing help a business correctly identify customers and achieve to profitability.

    Presenting a picture of the data

    Presenting a picture of the data

    coding, information display, online platforms, project planning, web apps

    Presenting a picture of the data

    Designing an effective visual solution to display complex background maths calculations led to scripting in three different programming languages. The result was a web application to be used as a tool in the battle against diabetes.

    The brief 

    A graphical solution was required to display data entered into an NHS funded online calculator for the Exeter University Living Systems Institute to show the probability of a child developing Type-1 diabetes later in life.

    The calculations were complex, and the real-time interplay between the maths, user interface, and the graphical elements presented a challenge.

    The solution

    A simple uncluttered layout was designed so as to support ease of use for all users.

    • Three different programming languages used to create the final interface
    • Real-time interaction with the background calculations
    • Standard data entry inputs to ensure user familiarity (ie sliders, radio buttons and check boxes) 
    • Simple use of colour and icons to support results output

    This important tool supports the latest ground-breaking data in Diabetes research.

    https://lf-d.shinyapps.io/t1d_predictor/

    The impact

    Whilst the appearance may be clean and uncluttered, the application has the opportunity to make a considerable impact on the battle against diabetes. Used as one of the tools available, an early warning predictor can allow individuals to make changes to avoid health issues later in life.

    Pic showing a close up of a computer screen with some results showing

    Dan was able to quickly understand the scope of the project, and build up a working prototype. His contribution enabled us to display complex research data into a user-friendly graphical interface.”

    Lauric Ferrat

    Postdoctoral Research Fellow, Living Systems Institute

    Related projects

    Pic showing the University of Exeter app login screen on a laptop

    University of Exeter Medical School

    Careful planning and coding were required to provide an online platform for GPs to match patient data and samples.

    Pic showing various digital devices all displaying the Aaduki website next to a camera and lenses

    Aaduki Insurance

    Developing an efficient online quotation system helped to streamline the sign up process and boost customers.

    Pic showing someone working on a laptop with the Cube Direct login page on screen

    Cube Direct

    Thorough research and testing were required to set up a CRM system that automated tasks to reduce time spent on data entry.

    Pic showing Accessibility Services webpage montage

    Accessibility Services

    Data analysis and email marketing help a business correctly identify customers and achieve to profitability.

    A simplified process to matching results

    A simplified process to matching results

    coding, data security, online platforms, project planning, web apps

    A simplified process to matching results

    Careful planning and coding experience of web applications were required to provide a robust online platform that ensured a smooth process for GPs to match patient data to their separately sent samples at the lab.

    The brief 

    Members of our team were briefed to build an online platform for the University of Exeter Medical School that allows GPs to submit patients’ blood results to an online database for laboratory analysis.

    As you’d expect for confidential information, security of patient data and robustness of system was paramount.

    The solution

    A simple step process was introduced to ensure efficiency and ease of compliance. The steps were logical and reduced the possibility of errors in the matching of any details and samples.

    • Patient information is logged onto the platform by a GP

    • The data is then anonymised, with a unique barcode generated

    • Code printed off and stuck to the blood sample container

    • Samples are posted to the laboratory where patient data and blood samples are married up, ready for analysis

    The platform is live and is proving an efficient pipeline for those requiring the lab services. On going evaluation of the process and system has helped to keep the system fit for purpose.

    Due to the sensitive nature of the data being handled, visuals and access to this project are limited.

    https://www.exet1d.com/

    The impact

    Extending far beyond this project, the research and development time invested in this platform has meant that the team have been able to develop a solution that can easily be incorporated into future university medical projects and applications.

    Pic showing the close up of a computer screen showing the Exeter login screen

    We commissioned Dan to build this ground breaking platform that enables clinicians to register and submit research participant data remotely and upload biochemistry results from analyses of the participants’ blood and urine samples by our NHS laboratories. This platform could easily be reappropriated for other designs of research study and associated biochemistry tests.”

    Michelle Hudson

    Research Project Manager, University of Exeter Medical School

    Related projects

    Pic showing someone working on a laptop with the Cube Direct login page on screen

    Cube Direct

    Thorough research and testing were required to set up a CRM system that automated tasks to reduce time spent on data entry.

    Pic showing various digital devices all displaying the Aaduki website next to a camera and lenses

    Aaduki Insurance

    Developing an efficient online quotation system helped to streamline the sign up process and boost customers.

    Pic showing the NHS Diabetes application on a computer screen

    NHS Diabetes Calculator

    Complex scripting was required to produce an online tool to be used in the battle against childhood Diabetes.

    Pic showing Accessibility Services webpage montage

    Accessibility Services

    Data analysis and email marketing help a business correctly identify customers and achieve to profitability.