Data Entry Introduction

  • Last update:June 14, 2023
  • Overview

    Functions

    You can use data entry function to write page data into databases, including creating, deleting, and updating data. Data entry also supports custom verification of entered data, Excel data import, intelligent linkage based on entered values, and so on.

    Notes

    1. Databases that do not support FineReport data entry: hive, impala, adb-mysql, MongoDB, XCloud DB, MaxCompute (formerly ODPS), sapbw, Magus openPlant5.0, clickhouse, GaussDB, presto, doris, StellarDB, and oceanbase.

    2. Many dashboards (FRM) requirements are not supported by data entry. Therefore, it is recommended not to use dashboards (FRM) to create data entry templates.

    Steps of Creating a Data Entry Report

    11111111111111111111111.png

    Design Specifications for Data Entry Template

    Although it is easy to customize FineReport templates, due to some limitations of the current functions, it is recommended that you pay attention to the following points when creating data entry templates.

    1. Do not create templates similar to the form of Excel because such templates might have problems in maintenance and preview performance later.

    The form of Excel refers to the template whose header column is composed of non-expanded cells, and other columns are composed of multiple rows of the same field.

    2.png

    2. When there are a large number of expanded rows, do not use SQL functions, and do not enable Display Widgets Directly. The reasons are as follows: SQL functions will be executed for multiple times, affecting calculation speed, and Display Widgets Directly will affect page rendering.

    3.png

    3. Use browsers with Google rendering engine to preview templates. For example, use Chrome and Edge.

    Knowledge Expansion

    You can also use FineDataLink to synchronize operations of creating, deleting and updating data in database A to database B, reducing task configuration costs and improving data collection efficiency.

    Attachment List


    Theme: Data Entry
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy