Table processing method and apparatus

Abstract

The present application provides a kind of table processing method and device, and the method comprises: based on the public field and non-public field in original table, generate multiple first forms, or, generate a second form containing multiple form areas;Wherein, any two first forms contain same public field and different non-public field, any two form areas contain same public field and different non-public field;The value of corresponding public field and the value of corresponding non-public field that user inputs through first form or form area are obtained;Based on the value of corresponding public field, the value of corresponding non-public field is written into original table.The table processing method and device provided by the present application, by splitting into multiple first forms or multiple form areas based on different fields of table header in original table, based on multiple first forms or multiple form areas, it can meet the scene that need to fill in table step by step to write data to the same row or column of original table.

Description

Technical Field

[0001] This invention relates to the field of computer technology, and in particular to a method and apparatus for processing tables. Background Technology

[0002] Currently, there are various scenarios where multiple people divide the work of entering data into tables by column or row. For example, the product delivery scenario is one such scenario: data on a product's departure from the warehouse, delivery receipt, and customer rating are maintained by three roles: warehouse manager, delivery person, and customer. The warehouse manager can fill in fields such as departure time and departure photos in the table; the delivery person can fill in fields such as receipt time, receipt photo, and customer signature; and the customer can fill in fields such as confirmation of receipt, whether the product is damaged, and service rating.

[0003] For scenarios where multiple people are dividing the work to enter data into a table by column or row, existing technologies typically involve writing the same row or column of data into a single form, which cannot meet the needs of scenarios where data needs to be filled in step by step. Summary of the Invention

[0004] This invention provides a table processing method and apparatus to solve the shortcomings of existing technologies that cannot fill in a row or column of data in a table step by step, thereby achieving more efficient table processing.

[0005] This invention provides a table processing method, comprising:

[0006] Based on the public and non-public fields in the original table, generate multiple first forms, or generate a second form containing multiple form areas;

[0007] Wherein, any two of the first forms contain the same public fields and different non-public fields, and any two of the form areas contain the same public fields and different non-public fields;

[0008] Obtain the values ​​of the corresponding public fields and the corresponding non-public fields entered by the user through the first form or the form area;

[0009] Based on the value of the corresponding public field, the value of the corresponding non-public field is written into the original table.

[0010] According to a table processing method provided by the present invention, the generation of multiple first forms based on common and non-common fields in the original table includes:

[0011] Based on the public and non-public fields in the original table, generate a third form and multiple first forms;

[0012] Each of the first forms is accessed based on the target link for accessing the third form and the user permissions corresponding to the first form.

[0013] According to a table processing method provided by the present invention, the step of writing the value of the corresponding non-public field into the original table based on the value of the corresponding public field includes:

[0014] If the value of the corresponding public field is the same as the value of the public field in the target area of ​​the original table, the value of the corresponding non-public field will be written into the target area.

[0015] According to a table processing method provided by the present invention, obtaining the values ​​of the corresponding public fields and the corresponding non-public fields input by the user through the first form or the form area includes:

[0016] Receive the user's first input for the first form or the form area;

[0017] Obtain the values ​​of the corresponding public fields and the corresponding non-public fields carried by the first input.

[0018] According to a table processing method provided by the present invention, generating multiple first forms based on public and non-public fields in the original table, or generating a second form containing multiple form areas, includes:

[0019] In the original table, the public field and multiple groups of the non-public fields are identified, wherein each group of the non-public fields includes fields entered based on the same user or the same process;

[0020] The plurality of first forms are generated based on the public fields and the plurality of non-public fields, or the second form is generated based on the public fields and the plurality of non-public fields.

[0021] According to a table processing method provided by the present invention, generating multiple first forms based on the public field and multiple sets of non-public fields includes:

[0022] For each group of non-public fields, perform the following processing:

[0023] Based on the public fields and each group of non-public fields, a first form is generated; each of the non-public fields is a data item to be entered in the first form.

[0024] According to a table processing method provided by the present invention, generating a second form based on the public field and multiple sets of non-public fields includes:

[0025] For each group of non-public fields, perform the following processing:

[0026] Based on the public fields and each group of non-public fields, a form area in the second form is generated; each non-public field is a data item to be entered in the form area.

[0027] According to a table processing method provided by the present invention, determining the common field and multiple sets of non-common fields in the original table includes:

[0028] Receive a second input from the user for the original table; in response to the second input, determine the public fields and multiple sets of the non-public fields;

[0029] Alternatively, the header fields in the original table can be identified to determine the common fields and multiple sets of the non-common fields.

[0030] According to a table processing method provided by the present invention, generating multiple first forms based on public and non-public fields in the original table, or generating a second form containing multiple form areas, includes:

[0031] Based on the public and non-public fields, generate a plurality of the first forms entered in a first order, or generate a second form containing a plurality of the form areas entered in a first order.

[0032] The present invention also provides a table processing apparatus, comprising:

[0033] The generation module is used to generate multiple first forms based on public and non-public fields in the original table, or to generate a second form containing multiple form areas;

[0034] Wherein, any two of the first forms contain the same public fields and different non-public fields, and any two of the form areas contain the same public fields and different non-public fields;

[0035] The acquisition module is used to acquire the values ​​of the corresponding public fields and the corresponding non-public fields entered by the user through the first form or the form area;

[0036] The write module is used to write the value of the corresponding non-public field into the original table based on the value of the corresponding public field.

[0037] According to a table processing apparatus provided by the present invention, the generation module is specifically used to generate a third form and multiple first forms based on public and non-public fields in the original table;

[0038] Each of the first forms is accessed based on the target link for accessing the third form and the user permissions corresponding to the first form.

[0039] According to a table processing apparatus provided by the present invention, the writing module is specifically used to write the value of the corresponding non-public field into the target area when the value of the corresponding public field is the same as the value of the public field in the target area of ​​the original table.

[0040] According to a table processing apparatus provided by the present invention, the acquisition module includes:

[0041] The receiving unit is configured to receive a first input from a user for the first form or the form area;

[0042] The acquisition unit is used to acquire the value of the corresponding public field and the value of the corresponding non-public field carried by the first input.

[0043] According to a table processing apparatus provided by the present invention, the generation module includes:

[0044] A determining unit is configured to determine the public field and multiple sets of non-public fields in the original table, wherein each set of non-public fields includes fields input based on the same user or the same process;

[0045] The generation unit is configured to generate the plurality of first forms based on the public fields and the plurality of sets of non-public fields, or to generate the second form based on the public fields and the plurality of sets of non-public fields.

[0046] According to a table processing apparatus provided by the present invention, the generation unit is specifically configured to perform the following processing for each group of non-common fields:

[0047] Based on the public fields and each group of non-public fields, a first form is generated; each of the non-public fields is a data item to be entered in the first form.

[0048] According to a table processing apparatus provided by the present invention, the generation unit is specifically configured to perform the following processing for each group of non-common fields:

[0049] Based on the public fields and each group of non-public fields, a form area in the second form is generated; each non-public field is a data item to be entered in the form area.

[0050] According to a table processing apparatus provided by the present invention, the determining unit is specifically used for:

[0051] Receive a second input from the user for the original table; in response to the second input, determine the public fields and multiple sets of the non-public fields;

[0052] Alternatively, the header fields in the original table can be identified to determine the common fields and multiple sets of the non-common fields.

[0053] According to a form processing apparatus provided by the present invention, the generation module is specifically used to generate a plurality of first forms entered in a first order based on the public fields and non-public fields, or to generate a second form containing a plurality of form areas entered in a first order.

[0054] The present invention also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement any of the table processing methods described above.

[0055] The present invention also provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the table processing method as described above.

[0056] The present invention also provides a computer program product, including a computer program that, when executed by a processor, implements any of the table processing methods described above.

[0057] The table processing method and apparatus provided by this invention splits the original table into multiple first forms or multiple form areas in a second form based on different fields in the table header. Data filled in different first forms or form areas is directly associated with different corresponding fields in the same original table. Data is written to the same row or column of the original table based on multiple first forms or multiple form areas. Data obtained based on the first forms or multiple form areas is directly written to the original table. There is no need to maintain two tables. This can meet the needs of scenarios that require step-by-step table filling, such as multi-person collaborative data entry (each person corresponds to a first form) or multi-step workflow data entry (each step corresponds to a first form). It is also more convenient to customize and build a management system. The method of automatically summarizing data to the same original table based on multiple first forms or form areas can save manpower for data summarization, greatly reduce the cost of manual table data processing, and improve the real-time performance of data summarization. Attached Figure Description

[0058] To more clearly illustrate the technical solutions in this invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of this invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0059] Figure 1 This is a flowchart illustrating the table processing method provided by the present invention;

[0060] Figure 2 This is a schematic diagram illustrating the generation of a form based on an original table in the table processing method provided by the present invention;

[0061] Figure 3 This is a schematic diagram of the structure of the table processing device provided by the present invention;

[0062] Figure 4 This is a schematic diagram of the structure of the electronic device provided by the present invention. Detailed Implementation

[0063] To make the objectives, technical solutions, and advantages of this invention clearer, the technical solutions of this invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of this invention. All other embodiments obtained by those skilled in the art based on the embodiments of this invention without creative effort are within the scope of protection of this invention.

[0064] In the description of the embodiments of the present invention, the terms "first", "second", and "third" are used for descriptive purposes only and should not be construed as indicating or implying relative importance, nor do they relate to order.

[0065] The following is combined with Figures 1 to 4 This invention describes the table processing method and apparatus provided by the present invention.

[0066] Figure 1 This is a flowchart illustrating the table processing method provided by the present invention. For example... Figure 1 As shown, the execution subject of the table processing method provided in this embodiment of the invention can be a table processing device, and the method includes: step 101, step 102 and step 103.

[0067] Specifically, the form processing device can be implemented in various forms. For example, the form processing device described in the embodiments of the present invention may include mobile terminals such as mobile phones, smartphones, laptops, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), navigation devices, smart bracelets, smart wristbands, digital cameras, etc., as well as fixed terminals such as digital TVs, desktop computers (PCs), embedded devices, etc.

[0068] The table processing method provided in this invention can be applied to scenarios where multiple people divide the work of entering data into a table by column or row, such as collaborative workflow forms or collaborative forms filled out by multiple people.

[0069] Flow-based form collaboration is a scenario where there is a sequence of steps, and the same person may fill out the forms in different steps. Examples include: product delivery information management (warehouse manager, delivery person, and customer fill out forms separately), book borrowing and returning information management (all filled out by the librarian), and online wholesale assignments for teachers (students fill out assignment information, and teachers fill out grading information).

[0070] Collaborative form filling by multiple people refers to a scenario where there is no specific order of processes, and each form is filled out by different people. For example, multiple people filling out property inspection records (such as security guards, cleaners, firefighters, etc., filling out their own inspection records and summarizing them into a daily inspection record form) is an example of collaborative form filling by multiple people.

[0071] Step 101: Generate multiple first forms based on the common and non-common fields in the original table, or generate a second form containing multiple form areas.

[0072] Among them, any two first forms contain the same public fields and different non-public fields, and any two form areas contain the same public fields and different non-public fields.

[0073] Specifically, the original form is the form to be filled out.

[0074] You can generate one second form or multiple first forms by splitting the original table into forms.

[0075] Splitting into a form means breaking down the original form's header fields into common fields for validation and multiple sets of non-common fields for filling in.

[0076] Public fields can be used for the first form validation and positioning, indicating the original area to be written into the original form; non-public fields can be used to retrieve the data of each data item filled in the form.

[0077] Optionally, depending on how each piece of data is stored in the original table, the header of the original table can be either a list header or a row header of the table content.

[0078] Optionally, when the original table stores data in rows, the header of the original table can be a list header of the table content of the original table; when the original table stores data in columns, the header of the original table can be a row header of the table content of the original table.

[0079] Optionally, any two first forms may contain the same common fields and different non-common fields. A combination of a common field and a set of non-common fields is associated with a first form, and the total number of split first forms may be equal to the number of sets of non-common fields.

[0080] Optionally, the second form contains multiple form areas, and any two form areas contain the same common field and different non-common fields. A combination of a common field and a set of non-common fields is associated with one form area in the second form, and the total number of form areas contained in the second form can be equal to the number of sets of non-common fields.

[0081] Optionally, a table-to-form conversion process can be used to establish a link between the data items and the original table headers during the conversion of table headers into form data items. The first form can contain multiple data items, each with a unique ID. The IDs of the original table headers can be associated with the IDs of the data items, allowing data collected based on these data items to be directly written to the cells corresponding to the headers of the associated worksheet. The second form's form area can contain at least one data item, each with a unique ID. The IDs of the original table headers can be associated with the IDs of the data items, allowing data collected based on these data items to be directly written to the cells corresponding to the headers of the associated worksheet.

[0082] Step 102: Obtain the values ​​of the corresponding public fields and the corresponding non-public fields entered by the user through the first form or form area.

[0083] Specifically, for each first form, a user with the permission to fill out the first form can input data based on the data items in the first form.

[0084] It is understood that the data items in the first form are a combination of public fields associated with the first form and a set of non-public fields; therefore, the first form contains both public and non-public fields. User input can include the values ​​of the corresponding public fields and the values ​​of the corresponding non-public fields in the first form. Therefore, based on user input, the form processing device can obtain the values ​​of the corresponding public fields and the values ​​of the corresponding non-public fields in the first form.

[0085] Optionally, each form area may include a prompt message corresponding to that form area to prompt the user to fill in the form area.

[0086] Optionally, the prompt information corresponding to the form area can be a text description of the form area to help different users identify the form area they have filled in.

[0087] For each form area in the first form, a user with permission to fill in that form area can enter data based on the data items in that form area.

[0088] It is understood that the data items in a form area are a combination of public fields and a set of non-public fields associated with that form area; therefore, a form area contains both public and non-public fields. User input can include the values ​​of the corresponding public fields and the corresponding non-public fields in that form area. Therefore, based on user input, the form processing device can obtain the values ​​of the corresponding public fields and the corresponding non-public fields in that form area.

[0089] Step 103: Based on the value of the corresponding public field, write the value of the corresponding non-public field into the original table.

[0090] Specifically, for each first form, based on the value of the corresponding public field in the first form, the writing position of the value of the corresponding non-public field in the first form in the original table can be determined; based on the writing position of the value of the corresponding non-public field in the first form in the original table, the value of the corresponding non-public field in the first form can be written into the original table.

[0091] Figure 2 This is a schematic diagram illustrating the generation of a form based on an original table in the table processing method provided by this invention. Figure 2Taking the original form shown as an example, this original form is a product delivery information management form used for managing product delivery information. Filling out this product delivery information management form is a collaborative workflow scenario, where warehouse managers, delivery personnel, and customers all need to fill out this original form. Based on step 101 above, and using the public fields "product name" and "product barcode" and the non-public fields "outbound time", "outbound photo", "receipt time", "receipt photo", "customer signature", "confirm receipt", "damage", and "service rating" in the original table, three first forms can be generated: Form 1 (containing the public fields "product name" and "product barcode" and the non-public fields "outbound time" and "outbound photo") to be filled out by the warehouse manager, Form 2 (containing the public fields "product name" and "product barcode" and the non-public fields "receipt time", "receipt photo", and "customer signature") to be filled out by the delivery person, and Form 3 (containing the public fields "product name" and "product barcode" and the non-public fields "receipt time", "receipt photo", and "customer signature") to be filled out by the customer.

[0092] In the first form 3 generated from the original table, the value of the corresponding public field "product barcode" is "Y4", the value of the corresponding non-public field "damage" is "none", and the value of the corresponding non-public field "service rating" is "10". Based on the value of the corresponding public field "product barcode" being "Y4" in the first form, the cell located at the intersection of row 6 and column 1 in the original table can be determined as the writing position for the value of the corresponding non-public field "damage", and the cell located at the intersection of row 6 and column J in the original table can be determined as the writing position for the value of the corresponding non-public field "service rating". The value "none" for the corresponding non-public field "damage" is written into the cell located at the intersection of row 6 and column 1, and the value "10" for the corresponding non-public field "service rating" is written into the cell located at the intersection of row 6 and column J.

[0093] Each first form is directly linked to the original form. Data obtained from the first form is directly written into the original form, thus filling in the original form with data. This is different from creating a new form based on the data obtained from the first form and then synchronizing the data between the new and original forms. The method of synchronizing data between the new and original forms is cumbersome, while the method of directly writing data into the original form in this embodiment is much simpler.

[0094] The first form is linked to the original form. Specifically, the data items in the first form are directly linked to the header fields of the original form. Based on the association between the data items in the first form and the header fields of the original form, the values ​​of the non-public fields collected by the data items in the first form are directly written to the associated fields in the original form.

[0095] Optionally, after multiple first forms are filled out, the values ​​of corresponding non-public fields in multiple first forms with the same corresponding public field are written into the same row or column in the original table.

[0096] For example, the value of the corresponding public field "student name" in one first form is A, and the value of the corresponding public field "student name" in another first form is also A. The above two first forms are two first forms with the same corresponding value.

[0097] Optionally, if the original table stores data in rows, the values ​​of corresponding non-public fields in multiple first forms with the same value in the public field are written into the same row of the original table; if the original table stores data in columns, the values ​​of corresponding non-public fields in multiple first forms with the same value in the public field are written into the same column of the original table.

[0098] For each form area, based on the value of the corresponding public field in that form area, the writing position of the corresponding non-public field value in the original table can be determined; based on the writing position of the corresponding non-public field value in the original table, the value of the corresponding non-public field in the form area can be written into the original table.

[0099] Each form area is directly linked to the original table. Data obtained from this form area is directly written to the original table, thus filling in the original table's data. This is different from creating a new table based on the data obtained from the form area and then synchronizing the data between the new table and the original table. The method of synchronizing data between the new table and the original table is cumbersome, while the method of directly writing data to the original table in this embodiment is much simpler.

[0100] The form area is linked to the original table. Specifically, the data items in the form area are directly linked to the header fields of the original table. Based on the association between the data items in the form area and the header of the original table, the values ​​of the non-public fields collected by the data items in the form area are directly written to the associated fields in the original table.

[0101] Optionally, after multiple form areas are filled out, the values ​​of the corresponding non-public fields in the multiple form areas with the same public field value are written into the same row or column in the original table.

[0102] For example, the value of the public field "Area" in one form area is B, and the value of the public field "Student Name" in another form area is also B. The two form areas mentioned above are two form areas with the same corresponding value.

[0103] Optionally, if the original table stores data in rows, the values ​​of corresponding non-public fields in multiple form areas with the same value of a public field are written into the same row of the original table; if the original table stores data in columns, the values ​​of corresponding non-public fields in multiple form areas with the same value of a public field are written into the same column of the original table.

[0104] This invention splits the original table into multiple first forms or multiple form areas within a single second form based on different fields in the table header. Data entered in different first forms or different form areas is directly associated with different corresponding fields in the same original table. Data is written to the same row or column of the original table based on multiple first forms or multiple form areas. Data obtained from the first forms or form areas is directly written to the original table, eliminating the need to maintain two tables. This can meet the needs of scenarios requiring step-by-step form entry, such as multi-person collaborative data entry (each person corresponds to a first form) or multi-step workflow data entry (each step corresponds to a first form). It is also more convenient to customize and build a management system. The method of automatically summarizing data from multiple first forms or form areas to the same original table saves manpower in data summarization, greatly reduces the cost of manually processing table data, and improves the real-time performance of data summarization.

[0105] Optionally, in some possible implementations of the embodiments of the present invention, multiple first forms are generated based on public and non-public fields in the original table, including: generating a third form and multiple first forms based on public and non-public fields in the original table; wherein each first form is accessed based on the target link for accessing the third form and the user permissions corresponding to the first form.

[0106] Specifically, by splitting the original table into multiple first forms, a third form and multiple first forms can be generated. The third form is the parent form of each first form, and each first form is a child form of the third form. All child forms belong to the same parent form.

[0107] The user permissions corresponding to the first form can be used to determine which users can fill out the first form. After setting the user permissions for each first form, based on the user permissions for each first form, different users can access different first forms and fill out different sub-forms by accessing the same parent form's access link (i.e., the target link used to access the third form).

[0108] The embodiments of the present invention generate a parent form and multiple sub-forms belonging to the same parent form, which enables users with different permissions to access the corresponding sub-forms through the same link to access the parent form, thereby improving security.

[0109] Optionally, in some possible implementations of the embodiments of the present invention, writing the value of the corresponding non-public field into the original table based on the value of the corresponding public field includes: writing the value of the corresponding non-public field into the target area when the value of the corresponding public field is the same as the value of the public field in the target area of ​​the original table.

[0110] Specifically, the original table can be divided into multiple regions based on how each piece of data is stored in the original table. The target region is one of these multiple regions.

[0111] Optionally, if the original table stores data in rows, the aforementioned area can be a row in the original table; if the original table stores data in columns, the aforementioned area can be a column in the original table.

[0112] For each first form, after obtaining the values ​​of the corresponding public fields and the corresponding non-public fields in the first form, the values ​​of the corresponding public fields in the first form can be matched with the values ​​of the public fields already written in the original form. If the value of the corresponding public field in the first form is the same as the value of the public field in the target area of ​​the original form, the value of the corresponding non-public field in the first form can be written into the target area. If the value of the corresponding public field in the first form is different from the value of the public field in any filled area of ​​the original form, an unfilled area can be used as the target area, and the value of the corresponding non-public field in the first form can be written into the target area.

[0113] Through the above steps, the first form is filled out separately, and the data is summarized into the original table; the multiple transformed first forms are filled out by different users, and the data written in different first forms is validated and matched according to common fields. If the values ​​of the common fields are the same, they are written into the same row or column in the original table.

[0114] For each form area, after obtaining the values ​​of the corresponding public fields and non-public fields in that form area, the values ​​of the corresponding public fields in the form area can be matched with the values ​​of the public fields already written in the original table. If the value of the corresponding public field in the form area is the same as the value of the public field in the target area of ​​the original table, the value of the corresponding non-public field in the form area can be written to the target area. If the value of the corresponding public field in the form area is different from the value of the public field in any filled area of ​​the original table, an unfilled area can be used as the target area, and the value of the corresponding non-public field in the form area can be written to the target area.

[0115] Through the above steps, the form areas are filled in separately, and the data is summarized into the original table. The converted multiple form areas are filled in by different users, and the data written in different form areas is validated and matched according to common fields. If the values ​​of the common fields are the same, they are written into the same row or column in the original table.

[0116] This invention writes data to the same row or column of an original table based on multiple first forms or multiple form areas in a second form. Data obtained from the first form or form area is directly written to the original table, eliminating the need to maintain two tables. This can meet the needs of scenarios requiring step-by-step form filling, such as multi-person collaborative data entry (each person corresponds to a first form) or multi-step workflow data entry (each step corresponds to a first form). It is also more convenient to customize and build a management system. The method of automatically summarizing data from multiple first forms or multiple form areas to the same original table can save manpower for data summarization, greatly reduce the cost of manually processing table data, and improve the real-time performance of data summarization.

[0117] Optionally, in some possible implementations of the embodiments of the present invention, obtaining the values ​​of the corresponding public fields and the corresponding non-public fields entered by the user through the first form or form area includes: receiving the user's first input for the first form or form area.

[0118] Specifically, for each first form, the user can enter a first input to fill in the data items in the first form, so that the first input can carry the value of the corresponding public field in the first form and / or the value of the non-public field of the form area.

[0119] For each form area, the user can enter a first input to fill in the data items in that form area. The first input can carry the value of the corresponding public field and / or the value of the non-public field in that form area.

[0120] The form processing device can receive the first input mentioned above.

[0121] Optionally, the first input can be implemented in a variety of possible ways. For example, the type of the first input may include at least one of key input, touch input, voice input, and motion input.

[0122] Retrieve the values ​​of the corresponding public fields and the corresponding non-public fields carried by the first input.

[0123] Specifically, based on the first input, the values ​​of public fields and non-public fields in the first form or the form area can be obtained.

[0124] The embodiments of the present invention can improve data acquisition efficiency by obtaining the values ​​of the corresponding public fields and the corresponding non-public fields carried by the user's first input to the first form or form area.

[0125] Optionally, in some possible implementations of the embodiments of the present invention, multiple first forms are generated based on public and non-public fields in the original table, or a second form containing multiple form areas is generated, including: determining public fields and multiple sets of non-public fields in the original table, wherein each set of non-public fields includes fields input based on the same user or the same process.

[0126] Specifically, common fields and multiple sets of non-common fields can be determined based on the user's selection of fields in the original table.

[0127] Optionally, it can also automatically identify fields in the original table to determine whether a field is a public field or belongs to a group of non-public fields.

[0128] Each group of non-public fields may include at least one non-public field.

[0129] Optionally, for scenarios where multiple people collaborate to fill out forms, the principles for dividing non-public fields may include: for any two non-public fields, if the values ​​of the two non-public fields are entered by the same user, the two non-public fields are divided into the same group of non-public fields; if the values ​​of the two non-public fields are entered by different users, the two non-public fields are divided into different groups of non-public fields.

[0130] Optionally, for workflow-based form collaboration scenarios, the principles for dividing non-public fields may include: for any two non-public fields, if the values ​​of the two non-public fields are entered in the same workflow, the two non-public fields are divided into the same group of non-public fields; if the values ​​of the two non-public fields are entered in different workflows, the two non-public fields are divided into different groups of non-public fields.

[0131] Therefore, for each group of non-public fields, in a scenario where multiple people fill out the form collaboratively, the value of the corresponding non-public field is entered by the same user, and in a workflow-based form collaboration scenario, the value of the corresponding non-public field is entered in the same workflow.

[0132] For example, for Figure 2 The original table shown can be identified as having public fields and three sets of non-public fields. The public fields include "Product Name" and "Product Barcode". The first set of non-public fields includes "Outbound Time" and "Outbound Photo". The second set of non-public fields includes "Receipt Time", "Receipt Photo", and "Customer Signature". The third set of non-public fields includes "Confirmation of Receipt", "Damage Status", and "Service Rating".

[0133] Multiple first forms can be generated based on public fields and multiple sets of non-public fields, or a second form can be generated based on public fields and multiple sets of non-public fields.

[0134] Specifically, after identifying the common fields and multiple sets of non-common fields, the original table can be split into multiple first forms or into a second form containing multiple form areas.

[0135] This invention, through identifying common fields and multiple sets of non-common fields in the original table, generates multiple first forms based on these common fields and multiple sets of non-common fields, or generates a second form based on these common fields and multiple sets of non-common fields. This enables data entered in different first forms or form data to be directly associated with different corresponding fields in the same original table. Thus, it enables data to be written to the same row or column of the original table based on multiple form areas in multiple first forms or one second form, which can meet the needs of scenarios that require step-by-step form filling.

[0136] Optionally, in some possible implementations of the embodiments of the present invention, multiple first forms are generated based on public fields and multiple sets of non-public fields, including: performing the following processing for each set of non-public fields: generating a first form based on public fields and each set of non-public fields; each non-public field is a data item to be entered in the first form.

[0137] Specifically, for each group of non-public fields, a first form can be generated based on that group of non-public fields and public fields using any table-to-form conversion method.

[0138] Optionally, the first form may include multiple data items to be entered. Each non-public field in the group of non-public fields can be generated as a data item to be entered in the first form, so that the value of the corresponding non-public field can be obtained based on the user's input of the data item.

[0139] It should be noted that for each common field, it can be generated as a data item to be entered in the first form, or, if the value of the corresponding common field has been obtained, it can be generated as a data item with a determined value in the first form.

[0140] This invention generates a first form based on a public field and a set of non-public fields, thereby generating multiple first forms. Data is written to the same row or column of the original form based on the multiple first forms, which can meet the needs of scenarios that require filling in the form step by step.

[0141] Optionally, in some possible implementations of the embodiments of the present invention, generating a second form based on a public field and multiple sets of non-public fields includes: performing the following processing for each set of non-public fields: generating a form area in the second form based on the public field and each set of non-public fields; each non-public field is a data item to be entered in the form area.

[0142] Specifically, for each group of non-public fields, a form area in the same second form can be generated based on the group of non-public fields and public fields using any table-to-form conversion method.

[0143] Optionally, the form area may include multiple data items to be entered. Each non-public field in the group can be generated as a data item to be entered in the form area, so that the value of the corresponding non-public field can be obtained based on the user's input of that data item.

[0144] It should be noted that for each common field, it can be generated as a data item to be entered in the form area, or, if the value of the corresponding common field has already been obtained, it can be generated as a data item with a determined value in the form area, or a data item with a determined value in the common area of ​​the second form. The common area of ​​the second form is an area in the second form that differs from any other form area.

[0145] This invention generates a form area in the same second form based on a common field and a set of non-common fields, thereby generating a second form containing multiple form areas. Data is written to the same row or column of the original form based on the multiple form areas, which can meet the needs of scenarios that require filling in the form step by step.

[0146] Optionally, in some possible implementations of the embodiments of the present invention, determining common fields and multiple sets of non-common fields in the original table includes: receiving a second input from a user for the original table; and determining common fields and multiple sets of non-common fields in response to the second input.

[0147] Specifically, the user can input a second input to the original table to select common fields and / or groups of non-common fields in the header fields of the original table, thus dividing the header fields of the original table into common fields and multiple groups of non-common fields. The table processing device can receive the aforementioned second input.

[0148] Optionally, the second input can be implemented in a variety of possible ways. For example, the type of the second input may include at least one of key input, touch input, voice input, and motion input.

[0149] For example, the usual table-to-form conversion function can be used to generate multiple first forms from the original table, select the header fields to be converted into each first form, and select the common fields and multiple sets of non-common fields among the above header fields.

[0150] For example, the table-to-form function can be used to generate a second form from the original table. The header fields of each form area to be converted into the second form can be selected, and the common fields and multiple sets of non-common fields in the header fields can be selected.

[0151] against Figure 2 The original table shown can be clicked by the user to display the following in area 202: Figure 2 The content shown includes three controls. The user can then click control 203, one of the three controls in area 202. Control 203 triggers the table-to-form conversion function. Clicking control 203 will bring up interface 204. The user's second input can include entering the number 2 in the input box, checking a box, and clicking control 205 to select the header field from the original table (the field contained in row 2) to generate the second form. Figure 2 The image shows two checkboxes, indicating that a set of non-public fields, "Outbound Time" and "Outbound Photo", has been selected.

[0152] After receiving the second input, a response can be made to it. The second input may carry information about common fields and / or groups of non-common fields, allowing the determination of the common fields and groups of non-common fields in the header fields of the original table based on the second input. There are multiple groups of non-common fields.

[0153] Optionally, in some possible implementations of the embodiments of the present invention, determining the common fields and multiple sets of non-common fields in the original table includes: identifying the header fields in the original table to determine the common fields and multiple sets of non-common fields.

[0154] Specifically, for each header field in the original table, it can be determined whether the header field is a public field or belongs to a group of non-public fields based on preset rules or the characteristics of the header field.

[0155] The preset rules can be set according to specific scenarios and user needs. This embodiment of the invention does not impose specific limitations on the preset rules.

[0156] The characteristics of a header field may include at least one of the following: the name and / or meaning of the header field, the process of entering the value of the header field or user information, and the method of entering the value of the header field.

[0157] Optionally, the input method for the values ​​of the header fields may include, but is not limited to, manual input, barcode input (e.g., scanning a barcode to obtain the product number), and input from an external data source.

[0158] For example, the original form is a student information registration form. The header fields include "name", "gender", "class", "date of birth" and "home address". The header field "name" can be used as a public field, and the header fields "class" and so on can be used as a set of non-public fields for teachers to enter. The "gender", "date of birth" and "home address" can be used as another set of non-public fields for students or their parents to enter.

[0159] This invention allows users to select common fields and multiple sets of non-common fields in the original table through a second input. This enables more flexible determination of common and non-common fields based on user needs. By automatically identifying common fields and multiple sets of non-common fields in the original table, the determination of common and non-common fields can be done more efficiently and quickly.

[0160] Optionally, in some possible implementations of the embodiments of the present invention, multiple first forms are generated based on public and non-public fields in the original table, or a second form containing multiple form areas is generated, including: generating multiple first forms entered in a first order based on public and non-public fields, or generating a second form containing multiple form areas entered in a first order.

[0161] Specifically, in the process of splitting the original table into multiple first forms based on the common and non-common fields in the original table, the input order of these multiple first forms can also be set, thereby obtaining multiple first forms entered in a first order. The set input order of these multiple first forms is called the first order.

[0162] Optionally, after a user completes a first form and submits some data items, the next first form can be forwarded to other users or processes for completion, thereby achieving the goal of multiple people collaboratively completing the same original form.

[0163] In the process of splitting the original table into a second form containing multiple form areas based on the common and non-common fields in the original table, the input order of these multiple form areas can also be set, thereby obtaining a second form containing multiple form areas entered in a first order. The set input order of these multiple form areas is the first order.

[0164] Optionally, after a user fills out a form area and submits some data items, the second form can be forwarded to the next user or the next process in the same order to continue filling out the next form area, thereby achieving the goal of multiple people collaboratively filling out the same original form.

[0165] This invention enables workflow-based form collaboration by determining the input order of multiple first forms or the input order of multiple form areas. It allows data filled in according to the workflow to be directly written into the original table without maintaining two tables, saving manpower for data aggregation, greatly reducing the cost of manually processing table data, and improving the real-time performance of data aggregation.

[0166] The table processing apparatus provided by the present invention is described below. The table processing apparatus described below can be referred to in correspondence with the table processing method described above.

[0167] Figure 3 This is a schematic diagram of the table processing device provided by the present invention. Based on the content of any of the above embodiments, such as… Figure 3 As shown, the device may include a generation module 301, an acquisition module 302, and a writing module 303, wherein:

[0168] The generation module 301 is used to generate multiple first forms based on the public and non-public fields in the original table, or to generate a second form containing multiple form areas;

[0169] Among them, any two first forms contain the same public fields and different non-public fields, and any two form areas contain the same public fields and different non-public fields;

[0170] The acquisition module 302 is used to acquire the values ​​of the corresponding public fields and the corresponding non-public fields entered by the user through the first form or form area;

[0171] The write module 303 is used to write the value of the corresponding non-public field into the original table based on the value of the corresponding public field.

[0172] Specifically, the generation module 301, the acquisition module 302, and the writing module 303 can be electrically connected in sequence.

[0173] The form generation module 301 can generate one second form or multiple first forms by splitting the original table into forms.

[0174] Optionally, any two first forms may contain the same common fields and different non-common fields. A combination of a common field and a set of non-common fields is associated with a first form, and the total number of split first forms may be equal to the number of sets of non-common fields.

[0175] Optionally, the second form contains multiple form areas, and any two form areas contain the same common field and different non-common fields. A combination of a common field and a set of non-common fields is associated with one form area in the second form, and the total number of form areas contained in the second form can be equal to the number of sets of non-common fields.

[0176] For each first form, a user with the permission to fill out the first form can input data based on the data items in the first form. The acquisition module 302 can obtain the values ​​of the corresponding public fields and the corresponding non-public fields in the first form.

[0177] For each form area in the second form, a user with the permission to fill in that form area can input data based on the data items in that form area. The acquisition module 302 can obtain the values ​​of the corresponding public fields and the corresponding non-public fields in that form area.

[0178] The writing module 303 can determine the writing position of the corresponding non-public field value in the original table based on the value of the corresponding public field in a first form (or form area); based on the writing position of the corresponding non-public field value in the original table, the writing module 303 can write the value of the corresponding non-public field in the first form into the original table.

[0179] Optionally, the generation module 301 can be specifically used to generate a third form and multiple first forms based on the public and non-public fields in the original table;

[0180] Each first form is accessed based on the target link used to access the third form and the user permissions corresponding to the first form.

[0181] Optionally, the write module 301 can be specifically used to write the value of the corresponding non-public field to the target area when the value of the corresponding public field is the same as the value of the public field in the target area of ​​the original table.

[0182] Optionally, the acquisition module 302 may include:

[0183] A receiving unit is used to receive the user's first input for the first form or form area;

[0184] The acquisition unit is used to acquire the values ​​of the corresponding public fields and the corresponding non-public fields carried by the first input.

[0185] Optionally, the generation module 301 may include:

[0186] The determination unit is used to identify common fields and multiple sets of non-common fields in the original table, wherein each set of non-common fields includes fields entered based on the same user or the same process;

[0187] The generation unit is used to generate multiple first forms based on common fields and multiple sets of non-common fields, or to generate a second form based on common fields and multiple sets of non-common fields.

[0188] Optionally, the generation unit can be specifically used to perform the following processing for each set of non-public fields:

[0189] A first form is generated based on the public fields and each set of non-public fields; each non-public field is a data item to be entered in the first form.

[0190] Optionally, the generation unit can be specifically used to perform the following processing for each set of non-public fields:

[0191] Based on the public fields and each set of non-public fields, a form area in the second form is generated; each non-public field is a data item to be entered in the form area.

[0192] Optionally, the defined unit can be specifically used for:

[0193] Receive a second input from the user for the original form; in response to the second input, determine the common fields and multiple sets of non-common fields;

[0194] Alternatively, the header fields in the original table can be identified to determine common fields and multiple sets of non-common fields.

[0195] Optionally, the generation module 301 can be specifically used to generate multiple first forms entered in a first order based on public and non-public fields, or to generate a second form containing multiple form areas entered in a first order.

[0196] The table processing apparatus provided in this embodiment of the invention is used to execute the table processing method described above. Its implementation method is consistent with that of the table processing method provided by this invention, and it can achieve the same beneficial effects. Therefore, it will not be described again here.

[0197] This table processing apparatus is used in the table processing methods of the foregoing embodiments. Therefore, the descriptions and definitions in the table processing methods of the foregoing embodiments can be used to understand the execution modules in the embodiments of the present invention.

[0198] This invention splits the original table into multiple first forms or multiple form areas within a single second form based on different fields in the table header. Data entered in different first forms or form areas is directly associated with different corresponding fields in the same original table. Data is written to the same row or column of the original table based on multiple first forms or multiple form areas, and data obtained from the first forms or multiple form areas is directly written to the original table. This eliminates the need to maintain two tables, meeting the needs of scenarios requiring step-by-step form entry, such as collaborative data entry by multiple people (each person corresponds to a first form) or multi-step data entry in a workflow (each step corresponds to a first form). It also facilitates the customization and construction of management systems. The method of automatically summarizing data from multiple first forms or form areas to the same original table saves manpower in data summarization, significantly reduces the cost of manually processing table data, and improves the real-time performance of data summarization.

[0199] Figure 4 This is a schematic diagram of the structure of the electronic device provided by the present invention, such as... Figure 3As shown, the electronic device may include a processor 410, a communications interface 420, a memory 430, and a communication bus 440, wherein the processor 410, communications interface 420, and memory 430 communicate with each other via the communication bus 440. The processor 410 can call logical instructions in the memory 430 to execute a table processing method, which includes: generating multiple first forms based on common and non-common fields in the original table, or generating a second form containing multiple form areas; wherein any two first forms contain the same common field and different non-common fields, and any two form areas contain the same common field and different non-common fields; obtaining the values ​​of the corresponding common fields and the corresponding non-common fields input by the user through the first forms or form areas; and writing the values ​​of the corresponding non-common fields into the original table based on the values ​​of the corresponding common fields.

[0200] Furthermore, the logical instructions in the aforementioned memory 430 can be implemented as software functional units and, when sold or used as independent products, can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or a part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods of the various embodiments of the present invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0201] The processor 410 in the electronic device provided in this application embodiment can call the logical instructions in the memory 430. Its implementation method is consistent with the implementation method of the table processing method provided in this application, and can achieve the same beneficial effects. It will not be described again here.

[0202] On the other hand, the present invention also provides a computer program product, which includes a computer program stored on a non-transitory computer-readable storage medium. The computer program includes program instructions, and when the program instructions are executed by a computer, the computer is able to execute the table processing method provided by the above methods. The method includes: generating multiple first forms based on common and non-common fields in an original table, or generating a second form containing multiple form areas; wherein any two first forms contain the same common field and different non-common fields, and any two form areas contain the same common field and different non-common fields; obtaining the values ​​of corresponding common fields and corresponding non-common fields entered by the user through the first forms or form areas; and writing the values ​​of corresponding non-common fields into the original table based on the values ​​of the corresponding common fields.

[0203] When the computer program product provided in this application embodiment is executed, it implements the above-mentioned table processing method. Its specific implementation method is consistent with the implementation method described in the aforementioned method embodiment, and can achieve the same beneficial effect, which will not be repeated here.

[0204] In another aspect, the present invention also provides a non-transitory computer-readable storage medium storing a computer program thereon, which, when executed by a processor, is implemented to perform the table processing methods provided above. The method includes: generating multiple first forms based on common and non-common fields in an original table, or generating a second form containing multiple form areas; wherein any two first forms contain the same common field and different non-common fields, and any two form areas contain the same common field and different non-common fields; obtaining the values ​​of corresponding common fields and corresponding non-common fields input by a user through the first forms or form areas; and writing the values ​​of corresponding non-common fields into the original table based on the values ​​of the corresponding common fields.

[0205] When the computer program stored on the non-transitory computer-readable storage medium provided in this application embodiment is executed, it implements the above-mentioned table processing method. Its specific implementation method is consistent with the implementation method described in the aforementioned method embodiment and can achieve the same beneficial effect, which will not be repeated here.

[0206] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0207] Through the above description of the embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus necessary general-purpose hardware platforms, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solutions, in essence or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., including several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute the methods of various embodiments or some parts of embodiments.

[0208] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A table processing method, characterized in that, include: Based on the public and non-public fields in the original table, generate multiple first forms, or generate a second form containing multiple form areas; Wherein, any two of the first forms contain the same public fields and different non-public fields, and any two of the form areas contain the same public fields and different non-public fields; Obtain the values ​​of the corresponding public fields and the corresponding non-public fields entered by the user through the first form or the form area; Based on the values ​​of the corresponding public fields, the values ​​of the corresponding non-public fields are written into the original table; The step of writing the values ​​of the corresponding non-public fields into the original table based on the values ​​of the corresponding public fields includes: If the value of the corresponding public field is the same as the value of the public field in the target area of ​​the original table, the value of the corresponding non-public field will be written into the target area. The first form or the form area is directly associated with the original table, so that data obtained from the first form or the form area is directly written into the original table.

2. The table processing method according to claim 1, characterized in that, The process generates multiple first forms based on the public and non-public fields in the original table, including: Based on the public and non-public fields in the original table, generate a third form and multiple first forms; Each of the first forms is accessed based on the target link for accessing the third form and the user permissions corresponding to the first form.

3. The table processing method according to claim 1, characterized in that, The step of obtaining the values ​​of the corresponding public fields and the corresponding non-public fields entered by the user through the first form or the form area includes: Receive the user's first input for the first form or the form area; Obtain the values ​​of the corresponding public fields and the corresponding non-public fields carried by the first input.

4. The table processing method according to claim 1, characterized in that, The process of generating multiple first forms based on public and non-public fields in the original table, or generating a second form containing multiple form areas, includes: In the original table, the public field and multiple groups of the non-public fields are identified, wherein each group of the non-public fields includes fields entered based on the same user or the same process; The plurality of first forms are generated based on the public fields and the plurality of non-public fields, or the second form is generated based on the public fields and the plurality of non-public fields.

5. The table processing method according to claim 4, characterized in that, The generation of multiple first forms based on the public fields and multiple sets of non-public fields includes: For each group of non-public fields, perform the following processing: Based on the public fields and each group of non-public fields, a first form is generated; each of the non-public fields is a data item to be entered in the first form.

6. The table processing method according to claim 4, characterized in that, The process of generating the second form based on the public fields and multiple sets of non-public fields includes: For each group of non-public fields, perform the following processing: Based on the public fields and each group of non-public fields, a form area in the second form is generated; each non-public field is a data item to be entered in the form area.

7. The table processing method according to claim 4, characterized in that, The step of determining the public field and multiple sets of non-public fields in the original table includes: Receive a second input from the user for the original table; in response to the second input, determine the public fields and multiple sets of the non-public fields; Alternatively, the header fields of the original table can be identified to determine the common fields and multiple sets of the non-common fields.

8. The table processing method according to any one of claims 1 to 7, characterized in that, The process of generating multiple first forms based on public and non-public fields in the original table, or generating a second form containing multiple form areas, includes: Based on the public and non-public fields, generate a plurality of the first forms entered in a first order, or generate a second form containing a plurality of the form areas entered in a first order.

9. A form processing device, characterized in that, include: The generation module is used to generate multiple first forms based on public and non-public fields in the original table, or to generate a second form containing multiple form areas; Wherein, any two of the first forms contain the same public fields and different non-public fields, and any two of the form areas contain the same public fields and different non-public fields; The acquisition module is used to acquire the values ​​of the corresponding public fields and the corresponding non-public fields entered by the user through the first form or the form area; The writing module is used to write the value of the corresponding non-public field into the original table based on the value of the corresponding public field; The writing module is further configured to write the value of the corresponding non-public field into the target area when the value of the corresponding public field is the same as the value of the public field in the target area of ​​the original table; The first form or the form area is directly associated with the original table, so that data obtained from the first form or the form area is directly written into the original table.

Images