An intelligent form processing method, device, medium and equipment

Abstract

The present invention discloses an intelligent form processing method, device, medium and equipment, which relates to the field of data collection and management. It includes setting the form style and cells, and splicing different dimension IDs to generate a unique data ID. When filling in the form, a filling form is generated according to the preset form style based on the period to be collected, and the data ID is assigned to the cells for filling in the form. Data is filled in and submitted in the cells corresponding to the data ID in the generated form. It is judged whether there is a situation where the data IDs in the cells of multiple forms are the same but the corresponding filled data is different. If so, it is conflict data; otherwise, the filled data corresponding to the current data ID is used as form data for form generation. By selecting the data ID, the corresponding form data is determined, the out-of-warehouse products are obtained, and the form is out of the warehouse.

Description

Technical Field

[0001] The present invention relates to the technical field of data collection and management, and particularly 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 in the form of forms. At the same time, it is also difficult to summarize and analyze these data because the data formats from different sources are inconsistent, as each data source may have its own unique format, structure, and standard, resulting in a large amount of time and effort being consumed in integration. This makes decision-making more complex and delayed, leading to a problem of 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 problems existing in the prior art, that is, the problem of how to improve the form processing speed in the prior art. The present invention provides an intelligent form processing method, which includes:

[0004] Performing form style setting on the form according to a preset table style, filling content, and restriction conditions of cells; respectively setting unique dimension IDs corresponding to five data dimensions of indicators, data objects, comparison items, grouping, and periods, and sequentially splicing the last second time of the time range corresponding to the period after generating the form for each dimension ID and selecting a specific time to generate a unique data ID;

[0005] Generating a filling form using the preset form style setting according to the period to be collected, and assigning a data ID to the filling cells in the form, filling and submitting data in the cells corresponding to the data ID in the generated form;

[0006] Detecting the current data ID and corresponding filled data in the current form and other forms, and determining whether there is a situation where the data IDs in the cells of multiple forms are the same but the corresponding filled data is different. If so, highlighting the cells where the data IDs are the same but the corresponding filled data is different; otherwise, using the filled data corresponding to the current data ID as the current form data to generate a form;

[0007] By selecting one or more data IDs, determining the form data corresponding to the cells with data IDs, obtaining the out-of-warehouse products, and performing form out-of-warehouse.

[0008] Optionally, the form style setting specifically includes:

[0009] Set the font, color, and border of the table, and set the required items in the cells, the conditional restrictions on the filled content, and the error prompt information.

[0010] Optionally, the conditional restrictions on the filled content specifically include:

[0011] The word count range restriction and the filling format restriction of the filled content.

[0012] It also includes:

[0013] After the data is filled, save the version of the newly generated cell.

[0014] Optionally, after highlighting the cells with the same data ID but different corresponding filled data, determine the source form, specific data value, and associated contact information of the filled data based on the highlighted cells.

[0015] The present invention provides an intelligent form processing device, including:

[0016] A form sample design module, a form filling module, a filled data detection module, and an outbound order module;

[0017] The form sample design module is used to perform form sample settings on the form according to the preset table style, the filled content of the cells, and the restriction conditions; respectively set the unique dimension IDs corresponding to the five data dimensions of indicators, data objects, comparison items, grouping, and periods, and sequentially splice the last second time of the time range corresponding to each dimension ID and the selected specific time after generating the form to generate a unique data ID;

[0018] The form filling module is used to generate a filling form using the preset form sample according to the required period, assign a data ID to the filling cells in the form, fill in and submit data in the cells corresponding to the data ID in the generated form;

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

[0020] The outbound order module is used to select one or more data IDs to determine the form data corresponding to the cells with the data ID, obtain the outbound products, and perform form outbound.

[0021] Optionally, the form filling module further includes a data temporary storage module and a data import / export module;

[0022] The data temporary storage module is used to save the filled data during the data filling process;

[0023] The data import / export module is used to export the form into Excel format, and after filling is completed, import the form data into the form.

[0024] Optionally, the outbound order module further includes:

[0025] A screening and sorting module, which is used to screen and sort the form data according to multiple conditions to determine the required information.

[0026] The present invention provides a computer-readable storage medium, and 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.

[0027] The present invention provides a computer device, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, the above-mentioned intelligent form processing method is implemented.

[0028] Compared with the prior art, the beneficial effects of the present invention are as follows: The present invention provides an intelligent form processing method. When filling in form data, by selecting the corresponding period and data object, data filling is performed in the cell corresponding to the current data ID, which can achieve accurate management and reference of data. When the data submitted by the detected user is abnormal data, by highlighting the abnormal data, the data review and confirmation process is simplified, and users can quickly obtain information related to the abnormal data; when performing form outbound, only by querying the data ID, the form data corresponding to the ID can be obtained, without integrating data from different sources, effectively improving the form processing speed. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] The accompanying drawings herein are incorporated into the specification and constitute a part of this specification, showing embodiments consistent with the present invention, and are used together with the specification to explain the principles of the present invention.

[0030] Figure 1 It is a flowchart of an intelligent form processing method provided by an embodiment of the present invention;

[0031] Figure 2 It is a schematic diagram of an intelligent form processing device provided by an embodiment of the present invention;

[0032] Figure 3 It is a schematic diagram of a computer device for an intelligent form processing method provided by an embodiment of the present invention. Detailed implementation manners

[0033] To make the objectives, technical solutions and advantages of the present invention clearer, the technical solutions in the present invention will be clearly and completely described below with reference to the accompanying drawings in the present invention. Apparently, the described embodiments are some but not all of the embodiments of the present invention. All other embodiments obtained by those of ordinary skill in the art based on the embodiments in the present invention without making creative efforts shall fall within the protection scope of the present invention.

[0034] The technical solutions of the present invention and how the technical solutions of the present invention solve the above technical problems will be described in detail below with specific embodiments. The following several specific embodiments may 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 with reference to the accompanying drawings.

[0035] Figure 1 is a flowchart of an intelligent form processing method provided by an embodiment of the present invention. As Figure 1 shown, an intelligent form processing method shown in this embodiment includes:

[0036] S1: Perform form style setting on the form according to a preset table style, filling content and restriction conditions of cells; respectively set unique dimension IDs corresponding to five data dimensions of indicators, data objects, comparison items, grouping, and periods, and splice the last second time of the time range corresponding to each dimension ID and the period after generating the form by selecting a specific time in sequence to generate a unique data ID.

[0037] Optionally, set the font, color, and border of the table, and set the required items, filling content condition restrictions, and error prompt information in the cells.

[0038] Optionally, the cells include data of the current period or previous periods.

[0039] Exemplarily, for instance, it can provide a user experience similar to Excel, support basic data input, formatting, and cell merging operations, 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 options to select data types such as text, number, date, and formatting options, and can set conditional restrictions on the filled content, such as restricting the word count range of the filled content, and can set format restrictions, such as filling in the format of mobile phone number or email, and can customize error prompt messages to help users understand the reasons for filling errors; Cells with data IDs can be set to reference data of the current period or previous periods, and the system will find the data in other tables according to the data ID and backfill it for auxiliary filling or display.

[0040] Exemplarily, for example, a certain cell is set with: the indicator is the revenue amount with ID 11, the data object is a local branch with ID 22, the comparison item is the month-on-month with ID 33, and the grouping is not set with ID -1. Among them, when setting the ID corresponding to the period, the period dimension IDs corresponding to year, quarter, month, week, and day are 1, 2, 3, 4, and 5 respectively; for example, when the filling form is generated within the time of the fourth quarter of 2024, and 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 this ID is the quarter, then the meaning of this cell in the form is the month-on-month revenue of a local branch in the fourth quarter. The data ID is sequentially spliced by the time range of the last second corresponding to the period after the form is generated by each dimension ID and the specific time (here, the separator ":" is used for example), 11:22:33:-1:2:20241231235959.

[0041] Exemplarily, after the table format is set, version management can be performed on the table, and a new version is generated each time it is saved, and users can go back to the previous version at any time.

[0042] S2: Generate a filling form using the preset table format according to the required period, assign data IDs to the filling cells in the form, fill in and submit data in the cells corresponding to the data IDs in the generated form.

[0043] Exemplarily, during the data filling process, users can choose whether to temporarily save the already input data. By temporarily saving the already input data, data loss caused by unexpected situations is avoided, enabling users to flexibly arrange the filling time and improving the user experience.

[0044] S3: Detect the current data IDs and corresponding filled data in the current form and other forms, and determine whether there are cases where the data IDs in the cells of multiple forms are the same but the corresponding filled data is different. If so, highlight the cells with the same data ID but different corresponding filled data; otherwise, use the filled data corresponding to the current data ID as the current form data to generate the form.

[0045] Exemplarily, by detecting whether there are cases where the data IDs in the system are the same but the filled data contents are different. If there are such cases, it indicates that the cells corresponding to the data IDs are conflict data. Automatically highlight the abnormal cells and remind the user of the conflict data. Then, the user only needs to click on the corresponding cell to view the source form, specific data values, and associated contact information of the conflict data. This design enables the user to quickly understand the problem and communicate effectively. After understanding the cause of the conflict, the user can communicate with the relevant contacts and select one of the data IDs and the corresponding filled data as the valid data to resolve the conflict. This process simplifies the data review and confirmation process and improves work efficiency; otherwise, successfully generate the corresponding form data.

[0046] Exemplarily, after generating the form data, the form data can be exported in Excel format for the user to edit offline. After filling it out, the user can directly import it into the corresponding cell; in addition, data can also be pasted from Excel and then filled in the corresponding cells of the form for form data entry, further enhancing the convenience and flexibility of data entry.

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

[0048] S4: By selecting one or more data IDs, determine the form data corresponding to the cells with data IDs, obtain the outbound products, and perform form outbound.

[0049] Exemplarily, when performing form outbound, for example, a class Excel operation interface similar to the form design can be set up. The user can use the data ID to achieve data reference and freely compose the outbound products to help the user efficiently process the outbound information.

[0050] Exemplarily, when the form is out of the warehouse, data can be filtered and sorted according to various conditions, so as to quickly find the required information and improve work efficiency; when the data is exported, the data can be exported in various formats, such as Excel or PDF format, which is convenient for users to share relevant information or print it into paper materials for archiving.

[0051] The above is the intelligent form processing method provided by one or more embodiments of this specification. Based on the same idea, as Figure 2 shown, this specification also provides a corresponding intelligent form processing device, including:

[0052] The form sample design module, the form filling module, the filled data detection module, and the outbound order module;

[0053] The form sample design module is used to perform form sample settings on the form according to the preset table style, the filled content of the cells, and the restriction conditions; respectively set the unique dimension IDs corresponding to the five data dimensions of indicators, data objects, comparison items, grouping, and periods, and splice the last second time of the time range corresponding to each period after generating the form by selecting specific times for each dimension ID in sequence to generate a unique data ID.

[0054] The form filling module is used to generate a filling form using the preset form sample settings according to the period to be collected, assign data IDs to the filling cells in the form, and fill in and submit data in the cells corresponding to the data IDs in the generated form.

[0055] The data detection module is used to detect the current data IDs and the corresponding filled data in the current form and other forms, and determine whether there are situations where the data IDs in the cells of multiple forms are the same but the corresponding filled data is different. If so, highlight the cells where the data IDs are the same but the corresponding filled data is different; otherwise, use the filled data corresponding to the current data ID as the current form data to generate the form.

[0056] The outbound order module is used to select one or more data IDs to determine the form data corresponding to the cells with data IDs, obtain the outbound products, and perform form outbound.

[0057] Optionally, the form filling module further includes:

[0058] The data temporary storage module and the data import / export module;

[0059] The data temporary storage module is used to save the filled data during the data filling process;

[0060] The data import / export module is used to export the form as an Excel format. After filling it out, the form data can be imported into the form.

[0061] Optionally, the outgoing order form module further includes:

[0062] The filtering and sorting module is used to filter and sort the form data according to multiple conditions to determine the required information.

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

[0064] For the specific limitations of the intelligent form processing device, reference can be made to the limitations of the intelligent form processing method in the above text, which will not be elaborated here. Each module in the above intelligent form processing device can be implemented in whole or in part through software, hardware, and their combinations. The above modules can be embedded in the processor of the computer device in hardware form or be independent of it, or can be stored in the memory of the computer device in software form, so that the processor can call and execute the operations corresponding to the above modules.

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

[0066] The present invention also provides Figure 3 the structural schematic diagram of the computer device shown in 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. Of course, there may also be other 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.

[0067] The technical features of the above embodiments can be combined arbitrarily. For the sake of concise description, 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, it should be considered to be within the scope recorded by 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; The form sample setting specifically includes: Set the font, color and border of the table, set the required items in the cells, the conditional restrictions on the reported content and the error prompt information; the conditional restrictions on the reported content specifically include: Limitations on the number of words and format of the reporting content; 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; 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; 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: Also includes: After the data is filled, the version of the newly generated cell is saved.

3. 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.

4. The intelligent form processing device as claimed in claim 3, 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.

5. The intelligent form processing device as claimed in claim 3, 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.

6. 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 described in any one of claims 1 to 2 is implemented.

7. 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 2 is implemented.

Images