Data Entry

Various widgets support massive data entry

  • Advanced asynchronous control loading technology is used to avoid frame freezing caused by full loading of controls.
  • The data can be filled in multiple sources. The data in a report can be extracted from different databases or data tables and then backfilled to another database or data table.


Intelligent data submission widgets satisfy customized submission requirements

  • Four types of submission: built-in smart submission, insert submission, delete submission, update submission, etc. Users can set the cells not to be included in the submission when they are not edited.
  • Custom submission: support custom JAVA class submission.
  • Smart binding fields and cells: intelligently add fields and cells, and quickly bind fields with respective cells.
  • Support the submission of conditions and events: only the data that meet the conditions will be filled into the database.

Intelligent data submission control
Comprehensive data validation

Comprehensive data validation ensures the correctness of data formats

  • Timely verification: check the cell content timely, such as text length/number accuracy
  • Submit verification: check the global data when submitting, and support formula/custom java class
  • JS verification: support the write-in of JS events to achieve complex data validation
  • Mandatory submission: force data submission even in case of data verification failure


Import excel data online: provides multiple matching logics

  • Import row-based reports: support the import of fixed and unfixed lines, provide intelligent matching logics such as matching by title and position, and support the import of bi-directionally extended reports.
  • Import freeform reports: support the import of freeform reports, match by cell locations to achieve full-style import.
  • Custom import: support custom importing of row-based reports and users can choose the rows, columns and sheets to be imported.

Import excel data online


  • Import Excel data in batches: vitalize historical data
  • Offline data entry: update data anytime and anywhere without the need of Internet connection
  • Smart temporary storage: avoid accident-incurred data loss
  • Multi-sheet data entry: support data entry in multiple sheets and submit these sheets in batches
  • Multi-level reporting: quickly go through the process of data reporting, approval and return


Privacy     Copyright©2020 FanRuan Software Co., Ltd.