Use front-end table technology to build medical SaaS solutions

Electronic Health Records (Electronic Health Records, EHR) are data (medical records, electrocardiograms, medical images, etc.) generated by patients in all medical institutions are stored electronically, and shared among different medical institutions, allowing patients to face Different doctors, in different hospitals, clinics, and even in different countries can get good medical services.

The development status of EHR in our country

In our country, EHR is still in a period of rapid development. In 2012, 35 cities, 2,406 community health service centers, and 9,726 community health service stations nationwide had established community residents’ health files. In 2017, the establishment rate of national residents' electronic health records has reached 76.4%.

Based on the characteristics of EHR data sharing, the future medical information system must be able to share and receive EHR from other providers outside the system. Therefore, for medical and health organizations, the biggest challenge is how to achieve technical connections and collaborative work through a powerful data sharing basic platform.

In order to ensure the accuracy and security of EHR data and allow them to interact between different healthcare providers, emerging technologies such as SaaS, blockchain or API components need to be used to build a set of diverse public and private The data collection system completes the collection of data on health surveys, administrative registration, billing records and electronic medical records.

EHR solution based on cloud and API components

Today, more and more healthcare organizations are considering migrating their healthcare IT solutions to a cloud-based software-as-a-service (SaaS) model. Some have even begun to deploy SaaS applications in hospitals for EMR (electronic Medical records), EHR, PACS, telemedicine and some non-clinical system applications such as RCM, billing and supply chain.

If you are considering moving from standalone software to cloud-based SaaS applications, then, in this case, API components can play a key role. It can not only simplify the migration, but also improve the existing workflow of the IT team. For many years, the medical and health industry has been accustomed to using Excel (.XLSX) files for information management, such as scheduling doctors, collecting contact information, configuring drugs and prescriptions, etc. Although Excel is a great tool, it can help users filter, find, and analyze data more quickly. However, limited by the application itself, the degree of customization of Excel has always been its biggest shortcoming. Using Excel to manage data will inevitably affect the workflow, cause security risks for shared files, and document version control issues.

Based on this feature, when migrating to a cloud-based SaaS medical and health application, the first thing to consider is how to maintain the Excel-like operation interface and functions that users have become accustomed to, such as:

• Excel-like menu bar and tool panel
• Calculation formulas and functions consistent with Excel logic
• Secondary modification operation after exporting data to Excel file
• Supports the direct import of Excel file data instead of manual input of data information

The above four points can all be completed with the help of a table control.

Use SpreadJS to optimize SaaS solutions for the medical industry

SpreadJS is a pure front-end table control based on HTML5, compatible with more than 450 Excel formulas, with product features of "high performance, cross-platform, and high compatibility with Excel", and can be directly used in various front-end development frameworks and back-end servers .

SpreadJS is highly similar to Excel in terms of interface and functions, and provides a more open API interface than Excel. With these interfaces, efficient report template design, online editing, data binding and other functional modules can be implemented on multiple platforms and multiple frames. In order to provide the enterprise information system with form document collaborative editing , data and category and greatly reduce the risk of R & D and 161b01fc2bf8d6 Excel report design project.

Medical and health data kanban developed with SpreadJS

The following are the advantages of SpreadJS in developing healthcare SaaS applications:

1. User experience and accessibility advantages

Embedding SpreadJS table controls in SaaS medical and health applications can perfectly reproduce the UI interface of Excel. In addition to continuing to use the Excel-like client interface that users are most familiar with, the application can also use charts, sparklines, shapes, etc. for data visualization interaction. At the same time, through SpreadJS's worksheet protection and cell lock functions, developers can more easily control end users' editing operations and other behaviors.

In terms of accessibility, SpreadJS provides support for assistive technologies and is also independent of the following browsers and platforms: Windows, Linux, Mac, Android, and iOS.

2. document version control

Document version control makes document versions well organized and consistent, so as to achieve the purpose of data accuracy.

The API provided by SpreadJS can be used to help solve the problem of document version control . By embedding SpreadJS in the application, it not only provides users with a way to directly interact with the workbook, but also provides an event connection that can trigger the workbook to save any changes. After these event connections are obtained, the changes can be stored In the back-end database. Once the changed/updated data is sent to your backend, when another user accesses the data, they can see the latest information.

Technical advantages of SpreadJS in document version control scenarios

3. Data security advantage

When handling personal and medical information, security is of the utmost importance!

According to the Verizon 2020 Data Breach Investigation Report (Verizon Business, 2020), about 90% of data breaches are caused by office files (such as Excel, etc.) that hide malware when sending emails. For the medical industry, as the medical industry opens more and more portals to patients and uses more and more new technical methods to interact with patients, network application attacks will become more common. The use of Excel for data interaction will also It becomes more and more dangerous.

Since SpreadJS is a pure front-end control, it will not save or record any information displayed in the UI. Therefore, with the help of SpreadJS, the sending and receiving of Excel files from external emails can be eliminated, thereby minimizing the risk of malicious software entering the company's system. In addition, SpreadJS also has a built-in application interface that meets the needs of data security, that is, it supports the import/export of password-protected and encrypted Excel files.

Summarize

Through the introduction of this article, we have a general understanding of the development status of EHR in my country, and can see that most medical and health organizations are completing the medical system information reform through the platform based on SaaS and cloud services. In this reform process, it is essential to maintain the original user habits and data interaction methods.

With the help of SpreadJS launched by Grape City, the IT team of the medical system can easily optimize the SaaS solution and provide users with a highly similar Excel experience while satisfying more personalities such as version control, online reporting, and multi-dimensional perspective analysis.化 option. In addition to the medical industry, the various development controls and software development technologies of Grape City have gradually shined in SaaS products in other fields, such as online office field of NetEase document 161b01fc2bfa3d and in the field of financial statements UF T+Cloud etc.