CN115169302B - Data collection method and device based on online form document and storage medium - Google Patents
Data collection method and device based on online form document and storage medium Download PDFInfo
- Publication number
- CN115169302B CN115169302B CN202211093068.XA CN202211093068A CN115169302B CN 115169302 B CN115169302 B CN 115169302B CN 202211093068 A CN202211093068 A CN 202211093068A CN 115169302 B CN115169302 B CN 115169302B
- Authority
- CN
- China
- Prior art keywords
- field
- information
- input field
- generating
- online
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
- G06F16/316—Indexing structures
- G06F16/328—Management therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/38—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F16/383—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using metadata automatically derived from the content
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Business, Economics & Management (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present disclosure provides a data collection method, device and storage medium based on online form document, the method includes: acquiring information to be collected; generating a form based on an online form document according to the information to be collected, wherein the form comprises a tag field and an input field for showing the information to be collected; sending the form to a user side in a link form; receiving filling information sent by the user side based on the form, and generating a summary sheet in the online form document according to the filling information; wherein the summary table and the form have a determined association relationship. Therefore, the form generated based on the method is not limited in format, can support various complex formats, does not need the assistance of additional form tools and technicians, and is high in flexibility. Moreover, after the form design is finished, the data can be automatically collected and summarized, so that a plurality of links are omitted, and the summarizing efficiency is improved.
Description
Technical Field
The present disclosure relates to the field of data interaction technologies, and in particular, to a data collection method and apparatus based on an online form document, and a storage medium.
Background
At present, data collection by using forms is realized based on a series of complicated software development processes such as database design, software coding and the like, a field is added or reduced in a form, the form basically needs to be redesigned as a new service, the development period is long, and a large amount of manpower and time need to be invested. Although HTML forms that do not require assistance from developers are available, the format of HTML forms is too simple to support complex formats, such as multiple columns per row, irregular formats, complex typesetting formats, and the like.
Disclosure of Invention
The present disclosure provides a method, apparatus, and storage medium to at least solve the above technical problems in the prior art.
According to a first aspect of the present disclosure, there is provided a data collection method based on an online form document, the method comprising: acquiring information to be collected; generating a form based on an online form document according to the information to be collected, wherein the form comprises a tag field and an input field for showing the information to be collected; sending the form to a user side in a link form; receiving filling information sent by the user side based on the form, and generating a summary sheet in the online form document according to the filling information; wherein the summary table and the form have a determined association relationship.
In an implementation manner, the generating a form based on an online form document according to the information to be collected includes: generating a worksheet based on the online form document; generating a label field according to the information to be collected based on the grid framework of the worksheet, wherein the label field comprises a label field position used for representing the cell position of the label field; configuring the cell where the label field is located as non-editable; generating an input field according to the label field, wherein the input field comprises an input field position for representing the position of the cell in which the input field is positioned; configuring the attribute of the cell where the input field is located according to the label field; and generating a form according to the label field and the input field.
In an implementation manner, the same cell mark is set for the cell where the tag field is located and the cell where the input field is located, and the cell mark is used for representing the corresponding relationship between the tag field and the input field.
In an embodiment, the generating an input field according to the tag field includes: and configuring an input field for the label field according to the label field position and a preset rule, wherein the input field comprises an input field position used for representing the position of the cell where the input field is located.
In an embodiment, the generating an input field according to the tag field includes: and configuring the cells with the determined position relation with the label field position as an input field according to the label field position.
In an implementation manner, before the receiving the filled-in information sent by the user side based on the form and generating the summary table in the online form document according to the filled-in information, the method further includes: and generating an information collection table for collecting information based on the online form document according to the label field and the input field.
In an implementation manner, the generating a summary table in the online form document according to the filling information includes: storing the filled information to a database; and displaying the filling information stored in the database in a form of a summary table in the online form document.
In an implementation manner, the receiving filled-in information sent by the user side based on the form, and generating a summary table in the online form document according to the filled-in information includes: receiving the form filled by the user side; generating a temporary worksheet aiming at the form of the user side in the online form document according to the received sequence of the form filled by the user side, wherein the temporary worksheet is used for storing filling information in the form filled by the user side; and collecting the filling information in the form filled by each user side to an information collection table in the online form document according to the received sequence of the form filled by each user side and a preset three-dimensional array formula to obtain a summary table.
According to a second aspect of the present disclosure, there is provided an online form document-based data collection apparatus, comprising: the acquisition module is used for acquiring information to be collected; the form generation module is used for generating a form based on an online form document according to the information to be collected, wherein the form comprises a label field and an input field which are used for showing the information to be collected; the form sending module is used for sending the form to the user side in a linked mode; the collection module is used for receiving filling information sent by the user side based on the form and generating a summary sheet in the online form document according to the filling information; wherein the summary table and the form have a determined association relationship.
According to a third aspect of the present disclosure, there is provided a computer-readable storage medium having stored thereon computer instructions for causing the computer to perform the method of the present disclosure.
The data collection method based on the online form document comprises the steps of generating a form based on the online form document according to information to be collected after the information to be collected is obtained, sending the form to a user side in a link mode to receive filling information of the user side based on form filling, and further automatically generating a summary sheet in the online form document according to the filling information. The form comprises a label field and an input field for showing information to be collected, and the summary table and the form have a determined association relationship. Thus, the format of the generated form is not limited, and the form can support a plurality of complex formats. Moreover, after the form is automatically generated, the data can be automatically acquired and summarized, so that many links are omitted, a special form tool and the assistance of technicians are not needed, and the data summarizing efficiency is improved.
It should be understood that the statements in this section are not intended to identify key or critical features of the embodiments of the present disclosure, nor are they intended to limit the scope of the present disclosure. Other features of the present disclosure will become apparent from the following description.
Drawings
The above and other objects, features and advantages of exemplary embodiments of the present disclosure will become readily apparent from the following detailed description read in conjunction with the accompanying drawings. Several embodiments of the present disclosure are illustrated by way of example, and not by way of limitation, in the figures of the accompanying drawings and in which:
in the drawings, the same or corresponding reference numerals indicate the same or corresponding parts.
FIG. 1 is a flow chart illustrating an implementation of a data collection method based on an online form document according to an embodiment of the present disclosure;
FIG. 2 shows a schematic diagram of a data collection device based on online form documents according to another embodiment of the present disclosure.
Detailed Description
In order to make the objects, features and advantages of the present disclosure more apparent and understandable, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present disclosure, and it is apparent that the described embodiments are only a part of the embodiments of the present disclosure, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments disclosed herein without making any creative effort, shall fall within the protection scope of the present disclosure.
Data collection is currently performed mainly by the following three ways: 1) Designing a relatively complex form through a professional form tool, and then storing the collected information into a database for subsequent analysis and processing; 2) Generating a simple HTML form through an online electronic form, associating the form with the electronic form, and directly storing information collected by the HTML form in an electronic form file; 3) Through traditional desktop editing application, electronic forms are designed by matching with the support of VBA programs and a server, and the electronic forms are sent out for filling.
However, for the three data collection methods, the design of the form and the data collection form are not flexible enough, and the tool for generating the form is limited more. Accordingly, to solve the above problems, the present disclosure provides a data collection method based on an online form document.
FIG. 1 is a flow chart illustrating an implementation of a data collection method based on an online form document according to an embodiment of the present disclosure.
Referring to fig. 1, the present disclosure is a data collection method based on an online form document, including: s101: acquiring information to be collected; s102: generating a form based on the online form document according to the information to be collected, wherein the form comprises a tag field and an input field for showing the information to be collected; s103: sending the form to a user side in a link form; s104: receiving filling information sent by a user side based on the form, and generating a summary table in an online form document according to the filling information; wherein, the summary table and the form have a determined association relationship.
At S101, information to be collected needs to be acquired first.
In the process of data collection, the type of the user information to be collected is determined first, and since there are many user information to be collected and flexible configuration can be performed as required, in order to describe the technical solution more simply and accurately, the user information to be collected is hereinafter referred to as information to be collected. The information to be collected may include user information such as name, age, and sex, and may also include dynamic information to be collected such as content of processed items, completion time, and completion status. Specifically, the information to be collected may be obtained by identifying a document template, or may be determined directly based on the current collection requirement. It should be noted that, the specific method for acquiring the information to be collected is not particularly limited, as long as the information to be collected can be acquired.
In the technical solution of the present disclosure, the acquisition, storage, application, and the like of the personal information of the related user all meet the regulations of the relevant laws and regulations, and do not violate the common customs of the public order.
In S102, a form is generated based on the online form document according to the information to be collected, wherein the form comprises a label field and an input field for showing the information to be collected.
One important stage in the data collection process is the process of generating forms for data collection. Compared with the conventional form designing process, the form is established directly based on the online form document, and the content and the format of the form can be more reasonably configured based on the functions of the online form document. For example, forms may be configured with rich formats and content. For example: multiple tag fields are configured in each line of the form and the format of the cell may be a picture, rich text, or file attachment, etc. Thus, unlike conventional HTML forms having a fixed format, forms generated based on online form documents of the present disclosure are able to support richer formats and content.
Specifically, a form is established in the online form document directly based on the information to be collected, and the form includes a plurality of tag fields and input fields corresponding to the tag fields. The tag field is a plurality of pieces of information to be collected, which are included in the information to be collected, and includes: name, ethnicity, age, etc. Correspondingly, the input field is the part corresponding to the label field and needing the user to fill in the content.
In an embodiment of the present disclosure, a worksheet may be generated based on an online form document, a tag field may be generated according to information to be collected based on a grid framework of the worksheet, and a cell where the tag field is located may be configured as non-editable. And the label field comprises a label field position used for representing the position of the cell where the label field is located. Further, an input field is generated according to the label field, the attribute of the cell where the input field is located is configured according to the label field, and the form is generated according to the label field and the input field, wherein the input field comprises an input field position used for representing the position of the cell where the input field is located.
Specifically, a worksheet can be established through the online form document, and based on a network architecture of the worksheet, some cells of the worksheet are configured as tag fields according to actual requirements, so that the tag field positions are obtained. Furthermore, the cell where the tag field is located can be configured to be non-editable, so that the cell where the tag field is located is locked, and the situation that the tag field is deleted due to misoperation in the subsequent filling process is prevented. After the tag field is generated, the corresponding cell can be configured into an input field according to the tag field and actual requirements, and the attribute is configured for the input field according to the tag field. And finally generating the form according to the label field and the input field. Therefore, the generation process of the form is simplified, the form supporting complex format and content can be generated only through the online form document without the assistance of developers and researchers and the use of professional form tools.
For example, the information to be collected may include: name, ethnicity, photograph, age, etc. In the process of generating the form, a worksheet can be generated based on the online form document, and then the information to be collected is configured in some cells of the worksheet, and the cells are configured to be non-editable. The specific cell in which a certain information to be collected is configured can be configured according to specific actual requirements. After the label field is configured, the corresponding cell is configured into an input field based on the position of the label field, and the attribute is configured for the input field according to the label field, so that the input field is configured. Here, the attribute of the tag field may be a number, an integer, or a picture, and the specific setting may be specifically set according to the requirement for the tag field. For example: if the label field is age, the attribute of the corresponding input field can be set as number, then in the process of filling the input field by the user, corresponding reminding information such as data which is used for guiding the input field to input a digital format can be displayed, and the filling of the input field corresponding to the age by the user is guided to be only filled in number. Further, if the tag field age has a specific value range setting, such as 18-50 ages, an age list may be set, and then the corresponding attribute of the tag field is set as a list.
Taking the tag field as an age again as an example, assuming that the cell A1 of the worksheet is configured as the tag field and the contents of the tag field are the age, the cell A1 may be configured as non-editable, thereby locking the cell A1 and not being modifiable by the user. Correspondingly, the cells needing to fill in the age are configured as input fields according to requirements. In order to find the position where the age needs to be filled, the position where the age is filled may be arranged in the adjacent cell of the cell where the age of the tag field is located. Specifically, the cell B1 or the cell A2 may be configured as an input field corresponding to the age of the tag field, the name of the cell in which the input field of the age is assigned is the age, and the attribute of the cell A2 or the cell B1 is configured as a number, so that the input field corresponding to the tag field of "age" is configured. Furthermore, for other tag fields, the configuration of the input fields is performed according to the method, that is, all the input fields in the worksheet can be configured.
It should be noted that, the above description only takes the tag field as "age" as an example to describe the scheme, and the specific content of the tag field may be determined according to the information to be collected in the practical application process, and the specific content of the tag field is not specifically limited in the present disclosure.
After all the tag fields in the worksheet and the input fields corresponding to all the tag fields are configured, the form is generated.
Further, after the user at the user side receives the generated form and opens the form, the configuration of the tag field and the configuration of the input field in the form become effective. For the tag field, the user is restricted to view only the non-editable field; for an input field, limiting the user to be able to further operate only according to the attribute of the input field, for example, if the attribute is a numerical value, only the numerical value can be filled in; whereas if the attribute is a list, only content to be filled in can be selected within the list.
In one embodiment of the present disclosure, the online spreadsheet document is an online spreadsheet document.
In an embodiment of the present disclosure, the same cell mark may be set for the cell where the tag field is located and the cell where the input field is located, so as to represent the corresponding relationship between the tag field and the input field.
Specifically, after the form is generated, a tag identifier may be configured for a tag field in the form and an input field corresponding to the tag field. For example, the cells in which the tag field "name" is located and the cells in the input field corresponding to the tag field "name" are configured to be the same color. Therefore, the corresponding relation between the label field and the input field corresponding to the label field is further improved through the label identification, and the form can be conveniently filled after the form is received by the user side. It should be noted that, the tag identifier in the present disclosure is not further limited, and the tag identifiers that can identify the corresponding relationship between the tag field and the corresponding input field all belong to the protection scope of the present disclosure, for example, a symbol is used as the tag identifier or the same number is used as the tag identifier.
In an embodiment of the present disclosure, an input field may be configured for a tag field according to a tag field position and a preset rule, where the input field includes an input field position for characterizing a cell position where the input field is located.
Specifically, rules for configuring the input field positions according to the tag field bits are preset in advance. In this way, when the tag field is determined, the cells corresponding to the rule in the online form document can be automatically configured as the input fields according to the preset rule directly and automatically based on the position of the cell where the tag field is located.
Further, the preset rule may represent a relative position between each tag field and the input field, for example, the preset rule may be an up-down relationship that the tag field and the input field are adjacent. Thus, after the label field of the form is determined, the adjacent cells below the label field can be automatically set as the input field corresponding to the label field according to the preset rule. Of course, the specific preset rule needs to be set according to actual requirements, and the tag field and the input field can also be set to be in a left-right adjacent position relationship.
In an embodiment of the present disclosure, if the generated input field position does not meet the actual requirement according to the tag field position and the preset rule, the position of the input field that does not meet the requirement may be further reconfigured according to the actual requirement until the actual requirement is met.
In an embodiment of the present disclosure, a cell having a determined positional relationship with a tag field position may be further configured as an input field according to the tag field position.
Specifically, the example is illustrated in which the tag field includes a name, a nation, and a gender, and when the tag field is configured, the tag field "name" may be configured in the cell A1, the tag field "nation" may be configured in the cell B1, and the tag field "gender" may be configured in the cell C1, and then the cells A1, B1, and C1 may be set as uneditable. For convenience of filling, the cell A2 adjacent to the cell A1 may be directly configured as an input field corresponding to the tag field of "name", the cell B2 adjacent to the cell B1 may be configured as an input field corresponding to the tag field of "ethnicity", and the cell C2 adjacent to the cell C1 may be configured as an input field corresponding to the tag field of "gender". Of course, for convenience of viewing and editing, the cell A3 separated from the cell A1 by one cell may be configured as an input field corresponding to the tag field of "name", the cell B3 may be configured as an input field corresponding to the tag field of "ethnicity", and the cell C3 may be configured as an input field corresponding to the tag field of "gender". Of course, the relative positions of the input field and the tag field are not particularly limited, and may be configured according to the requirement. Therefore, in the process of generating the form based on the online spreadsheet document, a form with a complex format can be supported only based on the online spreadsheet document without the help of a special form tool and a technician, and the user experience is improved.
At S103, the form may be sent to the user terminal in the form of a link.
Specifically, after the form is generated, the form may be sent to a plurality of clients needing to fill the form in a linked manner.
In an embodiment of the present disclosure, the form may also be sent to the user side by establishing a form task.
Specifically, a form filling task can be established, the form is imported into the form task, and then the form task is issued to a plurality of clients needing to be filled.
It should be noted that, the manner of sending the form to the user side is not particularly limited, and the method of sending the form to the user side is within the scope of the disclosure.
S104, receiving filling information sent by a user side based on the form, and generating a summary table in an online form document according to the filling information; wherein, the summary table and the form have a determined association relationship.
Specifically, after receiving the form sent by the user side, each field of the form can be analyzed, and the analyzed fields are summarized one by one to generate a summary table in the online form document, so that the data collection of the user side is completed.
In an embodiment of the present disclosure, before receiving the filled-in information sent by the user side based on the form, an information collection table for collecting information is further generated based on the online form document according to the tag field and the input field.
Specifically, after the form is generated, an information collection table may be constructed based on the online form document according to the tag field and the input field of the form.
For example, after the form is generated, the line number, the column number, the field number of the form, and the plurality of tag fields of the form and the input fields corresponding to the plurality of tag fields may be automatically obtained to automatically generate a worksheet for collecting information, where the worksheet is named as an information collection sheet. After receiving the form sent by the user end, all the fields in the form are identified, and the corresponding fields are collected to the corresponding positions in the information collection table, so that a collection table can be generated. It should be noted that, the generation of the information collection table in the present disclosure can be realized by a conventional information collection table generation method, and therefore, details are not described herein.
In an embodiment of the present disclosure, after receiving the filled-in information sent by the user side based on the form, the filled-in information may be stored in the database, and when the collection condition needs to be checked, the filled-in information stored in the database is displayed in the form of a summary table in the online form document.
Specifically, after receiving a form sent by a user, the filling content in the form can be automatically analyzed, such as the number of lines and columns of the form, the number of fields of the form is obtained, the tag field and the input field corresponding to the tag field are analyzed, a database table is automatically created according to the analysis and analysis results of the form sent by the user to store the filling content, and the database table serves as a summary table to display the collected filling content. The specific database collection process can be applied to a conventional implementation method, and therefore, the detailed description is omitted.
In an embodiment of the present disclosure, after receiving a form sent by a user, according to a sequence of the received form sent by the user, a temporary working table for the form of the user is generated in an online form document, and then according to the sequence of the received form filled by the user and a preset three-dimensional array formula, filling information in the temporary working tables corresponding to a plurality of users is collected to an information collection table in the online form document to obtain a summary table, where the temporary working table is used for storing the filling information in the form sent by the user.
Specifically, after receiving the form sent by the user side, a temporary worksheet for temporarily storing the filling information of the user side is generated, and then the filling information in the temporary worksheet is mapped to the information collection sheet for summarizing. Here, the temporary worksheet and the user side for filling the temporary worksheet have an association relationship, the temporary worksheet can be deleted automatically after the summary work is completed, and the temporary worksheet can be stored for a long time for the convenience of calling filling information of a certain user side for subsequent needs.
Furthermore, a three-dimensional array formula is preset in advance for the information collection table, after the form filled by the user side is received and the temporary worksheet is formed, the content filled in each field in the form can be collected in the information collection table in the form of the three-dimensional array formula, and along with the increase of the number of the user sides, the filled content in the temporary worksheet corresponding to each user side can be automatically extended in the information collection table through the three-dimensional array formula. Therefore, by introducing the three-dimensional array formula, the data collection condition can be displayed in real time, the collection process is dynamic, and a collector can conveniently check the data collection condition at any time. It should be noted that, in the specific three-dimensional formula setting process, the conventional three-dimensional formula setting method can be implemented, and therefore, the details are not repeated herein.
Based on the above data collection method based on the online form document, the embodiment of the present disclosure further provides a data collection device based on the online form document, as shown in fig. 2, where the device 20 includes: an obtaining module 201, configured to obtain information to be collected; the form generation module 202 is configured to generate a form based on an online form document according to information to be collected, where the form includes a tag field and an input field for showing the information to be collected; the form sending module 203 is used for sending the form to the user side in a linked mode; the collecting module 204 is configured to receive filling information sent by a user side based on a form, and generate a summary table in an online form document according to the filling information; wherein, the summary table and the form have a determined association relationship.
In an embodiment of the present disclosure, the form generation module 202 includes: the worksheet generation submodule is used for generating a worksheet based on the online document; the label field generation submodule is used for generating label fields based on the grid framework of the worksheet and according to the information to be collected, and the label fields comprise label field positions used for representing the positions of the cells where the label fields are located; the tag field configuration submodule is used for configuring the cell where the tag field is located into a non-editable cell; the input field generation submodule is used for generating an input field according to the label field, and the input field comprises an input field position for representing the position of the cell where the input field is located; the input field attribute configuration submodule is used for configuring the attribute of the cell where the input field is located according to the label field; and the form generation submodule is used for generating a form according to the label field and the input field.
In one embodiment of the present disclosure, the apparatus 20 further comprises: and the marking module is used for setting the same cell marks for the cells where the label fields are located and the cells where the input fields are located, and the cell marks are used for representing the corresponding relation between the label fields and the input fields.
In an embodiment of the present disclosure, the input field generation submodule includes: and the first input field configuration unit is used for configuring an input field for the label field according to the position of the label field and a preset rule, and the input field comprises an input field position for representing the position of the cell where the input field is located.
In an embodiment of the present disclosure, the input field generation submodule includes: and the second input field configuration unit is used for configuring the cells with the determined position relationship with the label field position as the input field according to the label field position.
In an embodiment of the present disclosure, the apparatus 20 further includes: and the information collection table generation module is used for generating an information collection table for collecting information based on the online form document according to the label field and the input field.
In an embodiment of the present disclosure, the collection module 204 includes: the storage submodule is used for storing the filled information to a database; and the filled information display sub-module is used for displaying the filled information stored in the database in a form of a summary table in the online form document.
In one embodiment of the present disclosure, the collecting module 204 includes: the form receiving submodule is used for receiving a form filled by a user side; the temporary worksheet generation submodule is used for generating a temporary worksheet aiming at the worksheet of the user side in the online spreadsheet document according to the sequence of the received worksheets filled by the user side, and the temporary worksheet is used for storing filling information in the worksheets filled by the user side; and the filling information collecting submodule is used for collecting the filling information in the form filled by each user side to an information collecting table in the online form document according to the received sequence of the form filled by each user side and a preset three-dimensional array formula to obtain a summary table.
Here, it should be noted that: the above description of the embodiment of the data collection device is similar to the above description of the embodiment of the data collection method based on online form documents, and has similar beneficial effects to the above embodiment of the data collection method based on online form documents, and therefore, the description is not repeated. For technical details that are not disclosed in the embodiments of the data collection device of the present disclosure, please refer to the description of the embodiments of the data collection method based on online form document of the present disclosure, which is not repeated herein for brevity.
Further, based on the above data identification method, the embodiments of the present disclosure also provide a computer-readable storage medium storing a program, which, when executed by a processor, causes the processor to perform at least the following operation steps: s101: acquiring information to be collected; s102: generating a form based on the online form document according to the information to be collected, wherein the form comprises a tag field and an input field for showing the information to be collected; s103: sending the form to a user side in a link form; s104: receiving filling information sent by a user side based on the form, and generating a summary sheet in an online form document according to the filling information; wherein, the summary table and the form have a determined association relationship.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising a component of' 8230; \8230;" does not exclude the presence of another like element in a process, method, article, or apparatus that comprises the element.
In the several embodiments provided in the present disclosure, it should be understood that the disclosed apparatus and method may be implemented in other ways. The above-described device embodiments are merely illustrative, for example, the division of the unit is only one logical function division, and there may be other division ways in actual implementation, such as: multiple units or components may be combined, or may be integrated into another system, or some features may be omitted, or not implemented. In addition, the coupling, direct coupling or communication connection between the components shown or discussed may be through some interfaces, and the indirect coupling or communication connection between the devices or units may be electrical, mechanical or other forms.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units; can be located in one place or distributed on a plurality of network units; some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, all functional units in the embodiments of the present disclosure may be integrated into one processing unit, or each unit may be separately regarded as one unit, or two or more units may be integrated into one unit; the integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
Those of ordinary skill in the art will understand that: all or part of the steps for realizing the method embodiments can be completed by hardware related to program instructions, the program can be stored in a computer readable storage medium, and the program executes the steps comprising the method embodiments when executed; and the aforementioned storage medium includes: various media that can store program codes, such as a removable Memory device, a Read Only Memory (ROM), a magnetic disk, or an optical disk.
Alternatively, the integrated unit of the present disclosure may be stored in a computer-readable storage medium if it is implemented in the form of a software functional module and sold or used as a separate product. Based on such understanding, the technical solutions of the embodiments of the present disclosure may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the methods described in the embodiments of the present disclosure. And the aforementioned storage medium includes: a removable storage device, a ROM, a magnetic or optical disk, or other various media that can store program code.
The above description is only for the specific embodiments of the present disclosure, but the scope of the present disclosure is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present disclosure, and all the changes or substitutions should be covered within the scope of the present disclosure. Therefore, the protection scope of the present disclosure should be subject to the protection scope of the claims.
Claims (9)
1. A method for data collection based on online tabular documents, the method comprising:
acquiring information to be collected;
generating a form based on an online form document according to the information to be collected, wherein the form comprises a tag field and an input field for showing the information to be collected;
sending the form to a user side in a link form;
receiving filling information sent by the user side based on the form, and generating a summary table in the online form document according to the filling information;
wherein the summary table and the form have a determined association relationship;
generating a form based on an online form document according to the information to be collected, including:
generating a worksheet based on the online form document;
generating a label field according to the information to be collected based on the grid framework of the worksheet, wherein the label field comprises a label field position used for representing the cell position of the label field;
configuring the cell where the label field is located as non-editable;
generating an input field according to the label field, wherein the input field comprises an input field position for representing the position of the cell in which the input field is positioned;
configuring the attribute of the cell where the input field is located according to the label field;
and generating a form according to the label field and the input field.
2. The method of claim 1, further comprising:
and setting the same cell mark for the cell in which the label field is located and the cell in which the input field is located, wherein the cell mark is used for representing the corresponding relation between the label field and the input field.
3. The method of claim 1, wherein generating an input field from the tag field comprises:
and configuring an input field for the label field according to the label field position and a preset rule, wherein the input field comprises an input field position for representing the cell position of the input field.
4. The method of claim 1, wherein generating an input field from the tag field comprises:
and configuring the cells with determined position relation with the label field position as an input field according to the label field position.
5. The method according to claim 1, wherein before the receiving the filled-in information sent by the user side based on the form and generating the summary table in the online form document according to the filled-in information, the method further comprises:
and generating an information collection table for collecting information based on the online form document according to the label field and the input field.
6. The method of claim 1, wherein generating a summary sheet in the online form document according to the filled-in information comprises:
storing the filled information to a database;
and displaying the filling information stored in the database in a form of a summary table in the online form document.
7. The method according to claim 5, wherein the receiving the filled-in information sent by the user side based on the form and generating the summary table in the online form document according to the filled-in information comprises:
receiving the form filled by the user side;
generating a temporary worksheet aiming at the form of the user side in the online form document according to the received sequence of the form filled by the user side, wherein the temporary worksheet is used for storing filled information in the form filled by the user side;
and collecting the filling information in the form filled by each user side to an information collection table in the online form document according to the received sequence of the form filled by each user side and a preset three-dimensional array formula to obtain a summary table.
8. An apparatus for data collection based on online tabular documents, the apparatus comprising:
the acquisition module is used for acquiring information to be collected;
the form generation module is used for generating a form based on an online form document according to the information to be collected, wherein the form comprises a label field and an input field which are used for showing the information to be collected;
the form sending module is used for sending the form to the user side in a linked mode;
the collection module is used for receiving filling information sent by the user side based on the form and generating a summary sheet in the online form document according to the filling information;
wherein the summary table and the form have a determined association relationship;
the form generation module comprises: the worksheet generation submodule is used for generating a worksheet based on the online spreadsheet document; a label field generating submodule, configured to generate a label field according to the information to be collected based on the grid framework of the worksheet, where the label field includes a label field position used for representing a cell position where the label field is located; the tag field configuration submodule is used for configuring the cell where the tag field is located as a non-editable cell; the input field generating submodule is used for generating an input field according to the label field, and the input field comprises an input field position used for representing the position of the cell where the input field is located; the input field attribute configuration submodule is used for configuring the attribute of the cell where the input field is located according to the label field; and the form generation submodule is used for generating a form according to the label field and the input field.
9. A computer-readable storage medium comprising a set of computer-executable instructions that, when executed, perform the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211093068.XA CN115169302B (en) | 2022-09-08 | 2022-09-08 | Data collection method and device based on online form document and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211093068.XA CN115169302B (en) | 2022-09-08 | 2022-09-08 | Data collection method and device based on online form document and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115169302A CN115169302A (en) | 2022-10-11 |
| CN115169302B true CN115169302B (en) | 2022-12-09 |
Family
ID=83481311
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211093068.XA Active CN115169302B (en) | 2022-09-08 | 2022-09-08 | Data collection method and device based on online form document and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115169302B (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102841791A (en) * | 2012-07-12 | 2012-12-26 | 上海高洁信息科技股份有限公司 | Method and system for generating online form |
| CN105701079A (en) * | 2015-12-31 | 2016-06-22 | 广东金赋信息科技有限公司 | Electronic form processing system |
| CN109558575A (en) * | 2018-10-25 | 2019-04-02 | 平安科技（深圳）有限公司 | Online Table edit method, apparatus, computer equipment and storage medium |
| CN110929489A (en) * | 2019-11-18 | 2020-03-27 | 有时数联科技（北京）有限公司 | Form generation and form data processing method and system |
| CN111222843A (en) * | 2019-12-24 | 2020-06-02 | 云南优鸟科技有限公司 | Flexibly configurable online registration creation system and method |
| CN111460776A (en) * | 2020-03-12 | 2020-07-28 | 山东浪潮通软信息科技有限公司 | Method and device for designing contract form and generating contract text on line |
| CN112183036A (en) * | 2019-06-18 | 2021-01-05 | 腾讯科技（深圳）有限公司 | Format document generation method, device, equipment and storage medium |
| CN112232047A (en) * | 2020-09-15 | 2021-01-15 | 福建省农村信用社联合社 | Method, system, equipment and medium for multi-dimensional data acquisition and automatic summarization |
| CN113094046A (en) * | 2021-03-31 | 2021-07-09 | 青岛海尔科技有限公司 | Method, device and terminal for product page development |
| CN114971591A (en) * | 2022-07-27 | 2022-08-30 | 海看网络科技(山东)股份有限公司 | Multi-level reporting and summarizing system and method for enterprise annual budget |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113742338A (en) * | 2021-08-03 | 2021-12-03 | 中铁建华南建设有限公司 | Structured storage system for project acceptance forms |
-
2022
- 2022-09-08 CN CN202211093068.XA patent/CN115169302B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102841791A (en) * | 2012-07-12 | 2012-12-26 | 上海高洁信息科技股份有限公司 | Method and system for generating online form |
| CN105701079A (en) * | 2015-12-31 | 2016-06-22 | 广东金赋信息科技有限公司 | Electronic form processing system |
| CN109558575A (en) * | 2018-10-25 | 2019-04-02 | 平安科技（深圳）有限公司 | Online Table edit method, apparatus, computer equipment and storage medium |
| CN112183036A (en) * | 2019-06-18 | 2021-01-05 | 腾讯科技（深圳）有限公司 | Format document generation method, device, equipment and storage medium |
| CN110929489A (en) * | 2019-11-18 | 2020-03-27 | 有时数联科技（北京）有限公司 | Form generation and form data processing method and system |
| CN111222843A (en) * | 2019-12-24 | 2020-06-02 | 云南优鸟科技有限公司 | Flexibly configurable online registration creation system and method |
| CN111460776A (en) * | 2020-03-12 | 2020-07-28 | 山东浪潮通软信息科技有限公司 | Method and device for designing contract form and generating contract text on line |
| CN112232047A (en) * | 2020-09-15 | 2021-01-15 | 福建省农村信用社联合社 | Method, system, equipment and medium for multi-dimensional data acquisition and automatic summarization |
| CN113094046A (en) * | 2021-03-31 | 2021-07-09 | 青岛海尔科技有限公司 | Method, device and terminal for product page development |
| CN114971591A (en) * | 2022-07-27 | 2022-08-30 | 海看网络科技(山东)股份有限公司 | Multi-level reporting and summarizing system and method for enterprise annual budget |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115169302A (en) | 2022-10-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10860848B2 (en) | Multi-page document recognition in document capture | |
| US20050183002A1 (en) | Data and metadata linking form mechanism and method | |
| CN107145480B (en) | Method for compiling XBRL report based on Word | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN111221522A (en) | Automatic code generation method of front-end and back-end separation architecture for government intensive application development | |
| CN111552704A (en) | Data report generation method and device, computer equipment and storage medium | |
| CN110968996A (en) | Document making method, device, equipment and storage medium | |
| CN112800730A (en) | Report form filling method and device | |
| CN115422903A (en) | Report output method and device, electronic equipment and computer readable storage medium | |
| CN107203525B (en) | Database processing method and device | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| WO2005076900A2 (en) | Data and metadata linking form mechanism and method | |
| CN115169302B (en) | Data collection method and device based on online form document and storage medium | |
| CN111273839B (en) | Data processing method and device for chart, computer equipment and storage medium | |
| CN113177389A (en) | Text processing method and device, electronic equipment and storage medium | |
| CN108228688B (en) | Template generation method, system and server based on XBRL | |
| CN111581937A (en) | Document generation method and device, computer readable medium and electronic equipment | |
| CN116227454A (en) | Universal automatic report generation method and system | |
| US20100023517A1 (en) | Method and system for extracting data-points from a data file | |
| CN115543288A (en) | Code information generation method, device, equipment and storage medium | |
| CN116009859A (en) | Method and tool for guaranteeing unified website system style | |
| CN114996758A (en) | Data desensitization method and device and electronic equipment | |
| CN115579096A (en) | Automatic generation and analysis verification method, system and storage medium for drug alert E2B R3 standard report | |
| CN113407164B (en) | Software code generation method and system based on mind map and tree structure technology | |
| CN117540704B (en) | Data reverse perspective conversion method, device, equipment and medium of data table |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |