Frontend development of a custom system for the customer’s specific business needs

Provided services

Client

A company engaged in the translation and localization of games, applications, and websites.

Product

An equivalent of Google spreadsheets designed for the systematic management of the company’s processes.

Business challenge

All the company’s documentation and processes are stored in Google services, but the existing capabilities do not allow them to quickly and conveniently solve the necessary tasks and store a large amount of data. Also, Google services do not provide complete security and confidentiality of stored information. Therefore, the customer needed to develop a custom web application that’s convenient to use for solving specific tasks (translation processes management), and help to optimize routine actions.

Technological features of the project

The web application included some of the most complex components that JazzTeam have ever developed. It supported all the functionality of Google spreadsheets, as well as customer-specific functions.
In the course of development, special attention was paid to cross-browser and cross-platform compatibility.
When working on the task, it was necessary to continuously conduct various studies. For example, it was necessary to study rarely used CSS features.
The development was based on the existing architecture and the small codebase prepared by the customer’s team.

To develop a custom web application convenient for solving specific tasks and optimizing route actions

To make the app both cross-browser and cross-platform

To ensure complete security and confidentiality of stored information

1

Creation of spreadsheet component that can be easily customized and developed for the necessary tasks Development of a spreadsheet architecture that can work with large amount of data, automatic calculation of fields on the server side, and sending emails to customers from the application
2

Ensuring complete freedom of text styling, expansion, and customization Conducting research to find the optimal framework (Draft.JS)
3

Ensuring easy further development of the system Creating a unified style for the project code Optimizing the application performance

The application is actively used by the customer's team and ensures fast, convenient work with the necessary tasks
Web application virtualization was implemented
It is possible to re-use and quickly update other sections of the application

Block diagram: Frontend development of a custom system for the customer's specific business needs

Approaches and solutions

Development of a spreadsheet component that can be easily customized and developed for the desired tasks. In a short time, our developers prepared the spreadsheet architecture, which included the following functionalities:

Display, easy reading, editing, deleting, and processing a large amount of data;
Automatic calculation of fields on the server side;
Sending emails to customers from the app.

Creation of the custom mail editor interface using the Draft.JS framework. It was necessary to ensure complete freedom of styling, expansion, and customization of the text, which required the use of a lower-level tool. We did some research in order to find the most optimal option, and priority was given to the Draft.JS framework. This solution provides opportunities for inline text styling, adding links, and creating an image slider.
Establishing the unified project code style and optimizing the application performance to ensure easy further development of the system. In addition to development, we were involved in the long-term support and development of an essential component of the system.

Results and achievements

The web component of the system was successfully implemented. The application is actively used by the customer’s team and ensures fast, convenient work with the necessary tasks.
The research on selecting the optimal framework for editing email texts was successfully performed.
Virtualization of the web application was implemented, which made it possible to store a large amount of data within a single page.
A database of components for re-use and quick updating of other sections of the application, as well as other projects of the customer, was developed.
Effective work according to the Scrum methodology, with frequent deliveries and daily customer feedback, was established on the project, which made it possible to complete a large amount of work in a short period of time and meet all the customer’s requirements.