Paint Tech supply high quality, environmentally friendly paint coatings from their Paint Centers in Auckland, Hamilton, Wellington, Christchurch and Timaru.
Orchid were approached by Paint Tech to develop a new web application to manage their extensive database of paint formulas.
Paint tech required a new system to be built to allow all employees from all branches within New Zealand, to access the companies extensive, ever increasing database of paint tinting formulas.
Some of the key features the web application needed to provide, were:
- Ability to search the complete database of paint formulas and retrieve the relevant paint tinting formulas
- Implement an algorithm to calculate new formulas for paint colours, dependent on the quantity of paint required
- Provide a secure login system, only accessible to employees at the various paint centers.
- Ability to administrate the employees, paint colours, formulas and colour cards through a central system.
- Ability to easy communicate with employees through announcements
Orchid developed a solution for Paint Tech utilising the popular Ruby on Rails web framework with an SQL database powering the backend.
Ruby on Rails provides a structured development framework that makes it simpler to produce a solution that’s flexible, which makes it easier to build future feature requests at minimal cost to the client.
Ruby on Rails also provides developers with a huge range of tools, which reduces the time to deliver a project, without sacrificing the quality of the end product.
The web application Orchid built for Paint Tech allows employees to login to a central website, search for a paint formula and enter the quantity of paint that’s required.
Behind the scenes, the Paint Tech web application intelligently searches for the paint colour, also providing approximate matches to the users search term.
The system then calculates a new tinting formula to achieve the desired colour.
The most advanced element of the application is the behind the scenes math required to produce the new paint tinting formulas on the fly.
Developing this algorithm has saved employees of the company countless hours and also helped Paint Tech’s bottom line, by reducing human error in the calculations, which would result in the incorrect paint colour being produced.
Paint Tech initially rolled the application out to its Auckland branch and has now rolled the application out to all employees throughout New Zealand.
The new application is central to Paint Tech’s business, as employees rely on the system to calculate the formula’s they need to create the paint colours customers require.