Intelligent form processing method and device, medium and equipment

Abstract

The invention discloses an intelligent form processing method and device, a medium and equipment, and relates to the field of data collection and management.The intelligent form processing method comprises the steps that a form style and table cells are set, and IDs of different dimensions are spliced to generate a unique data ID; during form filling, according to periods needing to be collected, preset form sample setting is used for generating a form for filling, a data ID is given to a cell for filling in the form, and data filling and submitting are carried out on the cell corresponding to the data ID in the generated form; judging whether the condition that the data IDs are the same but the corresponding filled data are different exists in the cells in the multiple forms, and if yes, determining that the data are conflict data; otherwise, using the filling data corresponding to the current data ID as form data, and performing form generation; and determining the corresponding form data by selecting the data ID, obtaining the ex-warehouse product, and performing form ex-warehouse.

Description

Technical Field

[0001] The present invention relates to the technical field of data collection and management, and in particular to an intelligent form processing method, device, medium and equipment. Background Art

[0002] With the development of informatization, enterprises and organizations need to collect a large amount of data in their daily operations. These data are usually collected through forms. At the same time, it is difficult to summarize and analyze these data because the data formats from different sources are inconsistent. Because each data source may have its own unique format, structure and standard, it takes a lot of time and effort to integrate, which makes decision-making more complicated and delayed, resulting in low processing speed when processing forms. Summary of the invention

[0003] The present invention provides an intelligent form processing method, device, medium and equipment to solve the above-mentioned problem existing in the prior art, that is, how to improve the form processing speed in the prior art. The present invention provides an intelligent form processing method, which includes: Set the form template according to the preset table style, cell filling content and restriction conditions; set the unique dimension IDs corresponding to the five data dimensions of indicators, data objects, comparison items, groups and periods respectively, and concatenate the dimension IDs and the last second of the time range corresponding to the period after selecting a specific time to generate the form to generate a unique data ID; Generate a reporting form using the preset form settings according to the period to be collected, and assign data IDs to the reporting cells in the form. In the generated form, fill in the data in the cells corresponding to the data IDs and submit; Check the current data ID and the corresponding reported data in the current form and other forms to determine whether there are cells in multiple forms with the same data ID but different corresponding reported data. If so, highlight the cells with the same data ID but different corresponding reported data; otherwise, use the reported data corresponding to the current data ID as the current form data to generate the form; By selecting one or more data IDs, the form data corresponding to the cell with the data ID is determined, the outbound product is obtained, and the outbound product is processed.

[0004] Optionally, the setting of the form template specifically includes: Set the font, color and border of the table, and set the required items in the cells, conditional restrictions on the reported content, and error prompt messages.

[0005] Optionally, the conditions for filling in the content include: There are word limits and reporting format limits for the content you fill in.

[0006] Also includes: After the data is filled, the version of the newly generated cell is saved.

[0007] Optionally, after highlighting the cells with the same data ID but corresponding different reported data, the source form of the reported data, the specific data value and the associated contact information are determined according to the highlighted cells.

[0008] The present invention provides an intelligent form processing device, comprising: Form design module, form filling module, filling data detection module and delivery order module; The form design module is used to set the form according to the preset form style and the filling content and restriction conditions of the cells; set the unique dimension IDs corresponding to the five data dimensions of indicators, data objects, comparison items, groups and periods respectively, and sequentially concatenate the last second of the time range corresponding to each dimension ID and the period after the form is generated by selecting a specific time to generate a form to generate a unique data ID; The form filling module is used to generate a filling form according to the period to be collected using a preset form sample, and assign a data ID to the filling cell in the form, and fill in and submit the data in the cell corresponding to the data ID in the generated form; The data detection module is used to detect the current data ID and the corresponding reported data in the current form and other forms, and determine whether there are cells in multiple forms with the same data ID but different corresponding reported data. If so, the cells with the same data ID but different corresponding reported data are highlighted; otherwise, the reported data corresponding to the current data ID is used as the current form data to generate the form; The delivery order module is used to select one or more data IDs, determine the form data corresponding to the cell with the data ID, obtain the delivery product, and perform delivery according to the form.

[0009] Optionally, the form filling module also includes a data temporary storage module and a data import and export module; The data temporary storage module is used to save the reported data during the data reporting process; The data import and export module is used to export the form into Excel format, and after filling in the form, import the form data into the form.

[0010] Optionally, the delivery order module further includes: The filtering and sorting module is used to filter and sort the form data according to various conditions to determine the required information.

[0011] The present invention provides a computer-readable storage medium, wherein the storage medium stores a computer program, and when the computer program is executed by a processor, the above-mentioned intelligent form processing method is implemented.

[0012] The present invention provides a computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the above-mentioned intelligent form processing method when executing the program.

[0013] Compared with the prior art, the beneficial effects of the present invention are as follows: the present invention provides an intelligent form processing method, which can realize accurate management and reference of data by selecting corresponding periods and data objects and filling in data in cells corresponding to current data ID when filling in form data. When the data submitted by the user is detected as abnormal data, the abnormal data is highlighted to simplify the data review and confirmation process, so that users can quickly obtain information related to the abnormal data. When the form is out of the warehouse, the form data corresponding to the ID can be obtained by querying the data ID, without integrating data from different sources, which effectively improves the form processing speed. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and, together with the description, serve to explain the principles of the invention.

[0015] Figure 1 A flow chart of an intelligent form processing method provided by an embodiment of the present invention; Figure 2 A schematic diagram of an intelligent form processing device provided by an embodiment of the present invention; Figure 3 A schematic diagram of a computer device for an intelligent form processing method provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0016] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be clearly and completely described below in conjunction with the drawings of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0017] The technical solution of the present invention and how the technical solution of the present invention solves the above-mentioned technical problems are described in detail below with specific embodiments. The following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments. The embodiments of the present invention will be described below in conjunction with the accompanying drawings.

[0018] Figure 1 is a flow chart of an intelligent form processing method provided by an embodiment of the present invention. Figure 1 As shown, this embodiment shows an intelligent form processing method, including: S1: Set up the form according to the preset table style, cell filling content and restriction conditions; set the unique dimension IDs corresponding to the five data dimensions of indicators, data objects, comparison items, groups and periods respectively, and concatenate each dimension ID and the last second of the time range corresponding to the period after selecting a specific time to generate the form to generate a unique data ID.

[0019] Optionally, set the font, color and border of the table, set the required items in the cells, restrictions on the conditions for filling in the content, and error prompt messages.

[0020] Optionally, the cell includes data for the current period or previous periods.

[0021] Exemplary, for example, it can provide an Excel-like user experience, support basic data input, format settings, cell merging operations, and allow users to customize the font, color, and border style of the table to meet different needs and aesthetics. The cell settings support users to mark which cells are required, provide data type selections, such as text, numbers, dates, and formatting options, and can set conditions to limit the content to be filled in, such as limiting the word count range of the content to be filled in, and can set format restrictions, such as filling in the format of mobile phone numbers or email addresses, and can customize error prompts to help users understand the reasons for filling in errors; cells with data IDs can be set to reference the current or previous periods of data, and the system will find data in other tables based on the data ID and fill it back for auxiliary reporting or display.

[0022] For example, a cell is set up with: the indicator is revenue with ID 11, the data object is a local branch with ID 22, the comparison item is month-on-month with ID 33, and the grouping is not set with ID -1. When setting the ID corresponding to the period, the period dimension IDs corresponding to the year, quarter, month, week and day are 1, 2, 3, 4 and 5 respectively; for example, when the report form is generated in the fourth quarter of 2024, the specific time of form generation is December 10, 2024. At this time, the period ID of the cell is 2, and the period corresponding to the ID is quarter. The meaning of the cell in the table is the month-on-month revenue of a local branch in the fourth quarter. The data ID is the last second of the time range corresponding to the period after the form is generated by each dimension ID and the specific time (the separator ":" is used as an example here), 11:22:33:-1:2:20241231235959.

[0023] For example, after setting up the table template, you can perform version management on the table, generate a new version each time you save it, and the user can go back to the previous version at any time.

[0024] S2: Generate a reporting form using the preset form settings according to the period to be collected, and assign data IDs to the reporting cells in the form. In the generated form, fill in the data in the cells corresponding to the data IDs and submit them.

[0025] For example, during the data filling process, the user can choose whether to temporarily store the input data. By temporarily storing the input data, data loss due to unexpected situations is avoided, and the user can flexibly arrange the filling time, thereby improving the user experience.

[0026] S3: Check the current data ID and the corresponding reported data in the current form and other forms to determine whether there are cells in multiple forms with the same data ID but different corresponding reported data. If so, highlight the cells with the same data ID but different corresponding reported data; otherwise, use the reported data corresponding to the current data ID as the current form data to generate the form.

[0027] Exemplarily, by detecting whether there is a situation in the system where the data ID is the same but the data content filled in is different, if so, it means that the cell corresponding to the data ID is conflicting data, and the abnormal cell is automatically highlighted, and the user is reminded of the conflicting data. Then the user only needs to click on the corresponding cell to view the source form, specific data value and related contact information of the conflicting data. This design enables users to quickly understand the problem and communicate effectively. After understanding the cause of the conflict, they can communicate with the relevant contacts and select one of the data IDs and the corresponding reported data as valid data to resolve the conflict. This process simplifies the data review and confirmation process and improves work efficiency; otherwise, the corresponding form data is successfully generated.

[0028] For example, after the form data is generated, the form data can be exported to Excel format, which is convenient for users to edit offline. After filling in the form, the user can directly import it into the corresponding cell. In addition, the data can be pasted from Excel and then filled in the corresponding cells of the form to enter the form data, which further improves the convenience and flexibility of data entry.

[0029] In this step, the data review and confirmation process is simplified by highlighting the abnormal data, allowing users to quickly obtain information related to the abnormal data and communicate effectively. After understanding the cause of the conflict, they can communicate with the relevant contacts and select one of the values ​​as the valid value to resolve the conflict, thereby simplifying the data review and confirmation process and improving work efficiency.

[0030] S4: by selecting one or more data IDs, determining the form data corresponding to the cell with the data ID, obtaining the outbound product, and performing outbound delivery according to the form.

[0031] For example, when the form is shipped out, an Excel-like operating interface that is the same as the form design can be set up, and the user can reference the data through the data ID and freely compose the shipped products, helping the user to efficiently process the shipping information.

[0032] For example, when a form is exported, the data can be filtered and sorted according to various conditions, so that the required information can be found quickly and work efficiency can be improved; when the data is exported, the data can be exported to multiple formats, such as Excel or PDF, so that users can share relevant information, or print it into paper documents for archiving.

[0033] The above is an intelligent form processing method provided by one or more embodiments of this specification, based on the same idea, such as Figure 2 As shown, this specification also provides a corresponding intelligent form processing device, including: Form design module, form filling module, filling data detection module and delivery order module; The form design module is used to set up the form according to the preset table style and the cell filling content and restriction conditions; set the unique dimension ID corresponding to the five data dimensions of indicators, data objects, comparison items, groups and periods respectively, and concatenate each dimension ID and the last second of the time range corresponding to the period after selecting a specific time to generate the form in sequence to generate a unique data ID.

[0034] The form filling module is used to generate a filling form using a preset form setting according to the period to be collected, and assign a data ID to the filling cell in the form, and fill in and submit the data in the cell corresponding to the data ID in the generated form.

[0035] The data detection module is used to detect the current data ID and the corresponding reported data in the current form and other forms, and determine whether there are cells in multiple forms with the same data ID but different corresponding reported data. If so, the cells with the same data ID but different corresponding reported data are highlighted; otherwise, the reported data corresponding to the current data ID is used as the current form data to generate the form.

[0036] The delivery order module is used to select one or more data IDs, determine the form data corresponding to the cell with the data ID, obtain the delivery product, and perform delivery according to the form.

[0037] Optionally, the form filling module further includes: Data temporary storage module and data import and export module; The data temporary storage module is used to save the reported data during the data reporting process; The data import and export module is used to export the form into Excel format, and after filling in the form, import the form data into the form.

[0038] Optionally, the delivery order module further includes: The filtering and sorting module is used to filter and sort the form data according to various conditions to determine the required information.

[0039] This device supports exporting forms into Excel format, which is convenient for users to edit offline. After filling in the form, the user can directly import it into the system. In addition, the system also supports pasting data from Excel for form data entry, which further improves the convenience and flexibility of data entry. In addition, by filtering and sorting the data, the required information can be quickly found, thereby improving work efficiency.

[0040] For the specific definition of the intelligent form processing device, please refer to the definition of the intelligent form processing method above, which will not be repeated here. Each module in the above-mentioned intelligent form processing device can be implemented in whole or in part by software, hardware and a combination thereof. The above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0041] The present invention also provides a computer-readable storage medium, which stores a computer program. The computer program can be used to execute the intelligent form processing method provided above.

[0042] The present invention also provides Figure 3 The structural diagram of the computer device shown in FIG. Figure 3 As shown, at the hardware level, the computer device includes a processor, an internal bus, a network interface, a memory, and a non-volatile memory, and may also include hardware required for other services. The processor reads the corresponding computer program from the non-volatile memory into the memory and then runs it to implement the intelligent form processing method provided in the above embodiment.

[0043] The technical features of the above embodiments may be arbitrarily combined. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of the present invention.

Claims

1. An intelligent form processing method, characterized in that: include: Set the form template according to the preset table style, cell filling content and restriction conditions; Set the unique dimension IDs corresponding to the five data dimensions of indicators, data objects, comparison items, groups and periods respectively, and concatenate the dimension IDs and the last second of the time range corresponding to the period after selecting a specific time to generate the form to generate a unique data ID; Generate a reporting form using the preset form settings according to the period to be collected, and assign data IDs to the reporting cells in the form. In the generated form, fill in the data in the cells corresponding to the data IDs and submit; Check the current data ID and the corresponding reported data in the current form and other forms to determine whether there are cells in multiple forms with the same data ID but different corresponding reported data. If so, highlight the cells with the same data ID but different corresponding reported data; otherwise, use the reported data corresponding to the current data ID as the current form data to generate the form; By selecting one or more data IDs, the form data corresponding to the cell with the data ID is determined, the outbound product is obtained, and the outbound product is processed.

2. The intelligent form processing method according to claim 1, characterized in that: The form sample setting specifically includes: Set the font, color and border of the table, and set the required items in the cells, conditional restrictions on the reported content, and error prompt messages.

3. The intelligent form processing method according to claim 2, characterized in that: The conditions and restrictions on the reported content include: There are word limits and reporting format limits for the content you fill in.

4. The intelligent form processing method according to claim 1, characterized in that: Also includes: After the data is filled, the version of the newly generated cell is saved.

5. The intelligent form processing method according to claim 1, characterized in that: After highlighting the cells with the same data ID but different corresponding reported data, the source form of the reported data, the specific data value and the associated contact information are determined according to the highlighted cells.

6. An intelligent form processing device, characterized in that: Specifically include: Form design module, form filling module, filling data detection module and delivery order module; The form design module is used to set the form according to the preset form style and the filling content and restriction conditions of the cells; set the unique dimension IDs corresponding to the five data dimensions of indicators, data objects, comparison items, groups and periods respectively, and sequentially concatenate the last second of the time range corresponding to each dimension ID and the period after the form is generated by selecting a specific time to generate the form to generate a unique data ID; The form filling module is used to generate a filling form according to the period to be collected using a preset form sample, and assign a data ID to the filling cell in the form, and fill in and submit the data in the cell corresponding to the data ID in the generated form; The data detection module is used to detect the current data ID and the corresponding reported data in the current form and other forms, and determine whether there are cells in multiple forms with the same data ID but different corresponding reported data. If so, the cells with the same data ID but different corresponding reported data are highlighted; otherwise, the reported data corresponding to the current data ID is used as the current form data to generate the form; The delivery order module is used to select one or more data IDs, determine the form data corresponding to the cell with the data ID, obtain the delivery product, and perform delivery according to the form.

7. The intelligent form processing device according to claim 6, characterized in that: The form filling module also includes a data temporary storage module and a data import and export module; The data temporary storage module is used to save the reported data during the data reporting process; The data import and export module is used to export the form into Excel format, and after filling in the form, import the form data into the form.

8. The intelligent form processing device as claimed in claim 6, characterized in that: The delivery order module further includes: The filtering and sorting module is used to filter and sort the form data according to various conditions to determine the required information.

9. A computer-readable storage medium, characterized in that: The storage medium stores a computer program, and when the computer program is executed by a processor, the smart form processing method according to any one of claims 1 to 5 is implemented.

10. A computer device, characterized in that: The invention comprises a memory, a processor and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, the intelligent form processing method according to any one of claims 1 to 5 is implemented.

Images