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.

    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.

    An online hub for a community hub

    An online hub for a community hub

    Copywriting, Marketing, Web design

    An online hub for a community hub

    Blackfen Community Library and Rooted Coffee House is much more than a library; providing a home away from home, a warm greeting and welcoming space for everyone. In addition, they offer activities for people of all ages each week. The library website had not been updated for some years and did not reflect the experience visitors to the library have.

    The brief 

    Blackfen Community Library tasked We Are Comma with completely overhauling the website to showcase all the activities provided, the services and support available, events and news.

    The impact

    We Are Comma gathered the required information to start rewriting the website. The design team then set about creating a more visually appealing site. We Are Comma also provided website training. The website has launched and helped Blackfen Community Library create an impact online. We Are Comma will also be going back to take photographs for the website when activities re-start after the Covid-19 pandemic.

    Pic showing the Blackfen Community Library website displayed on a laptop screen

    “We are really pleased with the website. It much better reflects the variety of things we do and offer at Blackfen Community Library. Working with We Are Comma has been very easy, especially during lockdown and beyond. The team have given us lots of advice and help to make sure the site functions well and training on how to write for the web.”

    Paula Weston

    Blackfen Community Library Manager

    Related projects

    Pic of ActionAid website montage

    ActionAid

    Copywriting a campaign website focused on women and work for a global charity.

    Pic showing Accessibility Services webpage montage

    Accessibility Services

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

    Pic showing C4ty poster on billboard

    C4ty Branding

    A brand for an organisation providing support to young people living and studying within the City of London.

    Pic showing graphics from the Power 100 2020 publication

    Power 100

    An annual publication highlighting the 100 most influential disabled people in the UK.