by addacomma | Apr 14, 2021
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.
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.
A CRM (Customer Relationship Management) system was thoroughly researched, tested and deployed.
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.
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.
“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.”
Head Account Handler, Cube Direct
by addacomma | Apr 13, 2021
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.
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.
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.
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.
“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.”
Research Project Manager, University of Exeter Medical School
by addacomma | Sep 28, 2020
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.
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.
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.
“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.”
Blackfen Community Library Manager