CN112632931A

CN112632931A - Task verification and cancellation method based on table, table generation method and device

Info

Publication number: CN112632931A
Application number: CN202010783523.3A
Authority: CN
Inventors: 徐杨; 李森; 秦银; 张迪; 王宇; 彭萧; 鄢贤卿
Original assignee: Tencent Technology Shenzhen Co Ltd
Current assignee: Tencent Technology Shenzhen Co Ltd
Priority date: 2020-08-06
Filing date: 2020-08-06
Publication date: 2021-04-09
Anticipated expiration: 2040-08-06
Also published as: CN112632931B

Abstract

The application discloses a task verification and cancellation method based on a form, a form generation method and a device, and relates to the field of office software. The method comprises the following steps: receiving a task verification and cancellation request, wherein the task verification and cancellation request is used for verifying and cancellation of collection tasks indicated by a collection table, the collection table corresponds to a task column in an online table, and the task verification and cancellation request comprises verification and cancellation object identifiers of task verification and cancellation objects; matching the verification object identification with the execution object identification in an object column, wherein the object column belongs to an online table, and the execution object identification is the object identification of a task execution object in instant messaging application; and writing the task cancel result into the cell corresponding to the execution object identification in the task column in response to the object column containing the execution object identification matched with the cancel object identification. In the embodiment of the application, the task verification and cancellation process is completed by matching the online form and the collection form, manual verification and cancellation by verification and cancellation personnel are not needed, and the efficiency of task verification and cancellation and the accuracy of task verification and cancellation are improved under the condition that a plurality of task execution objects exist.

Description

Task verification and cancellation method based on table, table generation method and device

Technical Field

The embodiment of the application relates to the field of office software, in particular to a task verification and cancellation method based on a form, a form generation method and a device.

Background

In daily life, people often need to go through the verification and marketing of tasks that have already been completed. For example, the article is checked and sold for pick-up.

In the related art, the verification and cancellation personnel usually edit a form by using office software, and then verify and cancel the form one by using a printed paper form. For example, when an article is dispensed, a verification and cancellation person prints a table containing all article retrievers, and when the article is retrieved, the verification and cancellation person searches the retrievers in the table and performs verification and cancellation.

However, by adopting the above-mentioned verification method, the verification personnel needs to perform manual verification one by one according to the completion condition of the task, and when the number of tasks to be verified is large, the verification efficiency is low and the accuracy is low.

Disclosure of Invention

The embodiment of the application provides a task verification and cancellation method based on a table, a table generation method and a table generation device, and the efficiency and the accuracy of task verification and cancellation can be improved. The technical scheme is as follows:

in one aspect, an embodiment of the present application provides a table-based task verification method, where the method includes:

receiving a task verification and cancellation request, wherein the task verification and cancellation request is used for verifying and cancellation of a collection task indicated by a collection table, the collection table corresponds to a task column in an online table, and the task verification and cancellation request comprises a verification and cancellation object identifier of a task verification and cancellation object;

matching the verification object identification with an execution object identification in an object column, wherein the object column belongs to the online table, and the execution object identification is an object identification of a task execution object in instant messaging application;

and writing a task verification result into a cell corresponding to the execution object identifier in the task column in response to the object column containing the execution object identifier matched with the verification object identifier.

In some embodiments, in response to that the reminding time is not reached and the cell corresponding to the target execution object identifier in the task column does not contain the task verification result, a reminding control is arranged in the cell corresponding to the target execution object identifier in the reminding column;

and sending reminding information to the instant messaging server in response to receiving a manual reminding instruction, wherein the manual reminding instruction is triggered by a reminding control.

In another aspect, an embodiment of the present application provides a table generation method, where the method includes:

creating an online form;

receiving an object setting operation on the online form, and setting an object column in the online form, wherein the object column comprises at least one execution object identifier, and the execution object identifier is an object identifier of a task execution object in an instant messaging application;

receiving task setting operation on the online table, setting a task column corresponding to the object column in the online table, and generating a collection table corresponding to the task column, wherein the collection table is used for writing a task verification and cancellation result into a corresponding cell in the task column according to a task verification and cancellation request triggered by the task execution object.

In some embodiments, the task information of the collected task includes a statistical index, and the collection table is configured to perform statistics on at least one task verification and cancellation record corresponding to the execution object identifier according to the statistical index to obtain a task verification and cancellation result corresponding to the execution object identifier, and return the task verification and cancellation result to the cell corresponding to the execution object identifier in the task column.

In some embodiments, after receiving a task setting operation on the online table, setting a task column corresponding to the object column in the online table, and generating a collection table corresponding to the task column, the method further includes:

and displaying a collection interface two-dimensional code, wherein the collection interface two-dimensional code is generated according to the link of the collection interface corresponding to the collection table.

In some embodiments, the method further comprises:

in response to that the reminding time is not reached and the cell corresponding to the target execution object identifier does not contain the task verification result, displaying a reminding control in the cell corresponding to the target execution object identifier in the reminding column;

and sending reminding information to the instant messaging server through the document server in response to receiving the triggering operation of the reminding control.

In some embodiments, the method further comprises:

receiving an issuing setting operation on the online form, and displaying an issuing setting interface, wherein the issuing setting interface is used for setting automatic issuing time and issuing content;

and responding to a setting completion signal in the issuing setting interface, setting the column for issuing the setting operation function as the issuing column, wherein the issuing column is used for triggering the issuing content to be sent to the task execution object through the instant messaging server when the automatic issuing moment is reached.

In another aspect, an embodiment of the present application provides a form-based task verification apparatus, where the apparatus includes:

the task verification and cancellation system comprises a request receiving module, a task verification and cancellation module and a task verification and cancellation module, wherein the request receiving module is used for receiving a task verification and cancellation request, the task verification and cancellation request is used for verifying and cancellation of a collection task indicated by a collection table, the collection table corresponds to a task column in an online table, and the task verification and cancellation request comprises a verification and cancellation object identifier of a task verification and cancellation object;

the matching module is used for matching the verification and cancellation object identification with an execution object identification in an object column, wherein the object column belongs to the online table, and the execution object identification is an object identification of a task execution object in instant messaging application;

and the core-canceling module is used for writing a task core-canceling result into the cell corresponding to the execution object identifier in the task column in response to the execution object identifier matched with the core-canceling object identifier contained in the object column.

In another aspect, an embodiment of the present application provides a table generating apparatus, where the apparatus includes:

a creation module for creating an online form;

the object setting module is used for receiving object setting operation on the online form, setting an object column in the online form, wherein the object column comprises at least one execution object identifier, and the execution object identifier is an object identifier of a task execution object in instant messaging application;

and the task setting module is used for receiving task setting operation on the online table, setting a task column corresponding to the object column in the online table, and generating a collection table corresponding to the task column, wherein the collection table is used for writing a task verification and cancellation result into a corresponding cell in the task column according to a task verification and cancellation request triggered by the task execution object.

In another aspect, embodiments of the present application provide a server including a processor and a memory, where at least one instruction, at least one program, a set of codes, or a set of instructions is stored in the memory, and the at least one instruction, the at least one program, the set of codes, or the set of instructions is loaded and executed by the processor to implement the table-based task core-selling method according to the above aspect.

In another aspect, an embodiment of the present application provides a terminal, where the terminal includes a processor and a memory, where the memory stores at least one instruction, at least one program, a code set, or a set of instructions, and the at least one instruction, the at least one program, the code set, or the set of instructions is loaded and executed by the processor to implement the table generating method according to the above aspect.

In another aspect, embodiments of the present application provide a computer-readable storage medium, in which at least one instruction, at least one program, a set of codes, or a set of instructions is stored, and the at least one instruction, the at least one program, the set of codes, or the set of instructions is loaded and executed by a processor to implement the table-based task verification method according to the above aspect, or to implement the table generation method according to the above aspect.

In another aspect, embodiments of the present application provide a computer program product or a computer program, which includes computer instructions stored in a computer-readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions to cause the computer device to perform the form-based task approval method provided by the above aspect or to perform the form generation method provided by the above aspect.

The beneficial effects brought by the technical scheme provided by the embodiment of the application at least comprise:

in the embodiment of the application, an object column corresponding to a task execution object is set in an online table, a task column corresponding to the object column is set in the online table according to a task to be executed by the task execution object, and a collection table corresponding to the task column is generated, so that when a task is checked and sold by using the collection table, whether the checked and sold object belongs to the task execution object in the object column is determined based on a checked and sold object identifier of the checked and sold object, and when the checked and sold object belongs to the task column, a task checking and selling result is written into the task column in the online table, and the task checking and selling is completed; the whole task verification and cancellation process is completed through the cooperation of the online form and the collection form, manual verification and cancellation of verification and cancellation personnel are not needed, the task execution object can complete online task verification and cancellation through the collection form, and the efficiency of task verification and cancellation and the accuracy of task verification and cancellation can be improved under the condition that the number of the task execution objects is large.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.

FIG. 1 illustrates a schematic diagram of an implementation environment provided by an exemplary embodiment of the present application;

FIG. 2 illustrates a flow chart of a table generation method provided by an exemplary embodiment of the present application;

FIG. 3 illustrates a flowchart of a table-based task underwriting method provided by an exemplary embodiment of the present application;

FIG. 4 is a schematic diagram illustrating an implementation of the table generation and task cancellation process provided by an exemplary embodiment;

FIG. 5 is a flow diagram illustrating an object column setup process in accordance with an illustrative embodiment;

FIG. 6 is a diagram illustrating an implementation of an object column setup process, according to an illustrative embodiment;

FIG. 7 is a flowchart of a task column setup process, shown in an exemplary embodiment;

FIG. 8 is a diagram illustrating an implementation of a task column setup process, according to an illustrative embodiment;

FIG. 9 is a flowchart of a table generation and task cancellation process, shown in an exemplary embodiment;

FIG. 10 is a flowchart of a task cancel verification result write process, shown in an exemplary embodiment;

FIG. 11 is a diagram illustrating the relationship of an online form to a collection table, according to an exemplary embodiment;

FIG. 12 is a diagram illustrating an implementation of a statistical indicator setting process, according to an exemplary embodiment;

FIG. 13 is a schematic diagram illustrating an implementation of a reminder function setup process, according to an exemplary embodiment;

FIG. 14 is a schematic diagram illustrating an implementation of a reminder function in accordance with an illustrative embodiment;

FIG. 15 is a schematic diagram illustrating an exemplary embodiment of an implementation of a notification function setup and content notification process;

FIG. 16 is a flow diagram depicting a token acquisition and alert message transmission process, according to an exemplary embodiment;

FIG. 17 is a flowchart illustrating a process for sending notification content, in accordance with an illustrative embodiment;

FIG. 18 is a block diagram of a structure of a table-based task cancellation apparatus provided in an exemplary embodiment of the present application;

fig. 19 is a block diagram of a table generating apparatus according to an exemplary embodiment of the present application;

FIG. 20 is a block diagram illustrating a server provided by an exemplary embodiment of the present application;

fig. 21 is a schematic structural diagram of a terminal according to an exemplary embodiment of the present application.

Detailed Description

To make the objects, technical solutions and advantages of the present application more clear, embodiments of the present application will be described in further detail below with reference to the accompanying drawings.

For convenience of understanding, terms referred to in the embodiments of the present application will be first described below.

Online documentation: that is, a collaboration document, a document for directly reading and writing data through a web page (web), the document may be a text document, a table document, a slide document, or the like, and the online document referred to in this embodiment of the present application is an online table. After the online document is created, the creator can send the document link of the online document to other users, and the other users can view the online document in a webpage according to the document link and edit the content of the online document when the online document has the editing right, wherein the same online document allows multiple persons to edit the online document at the same time.

Collecting a table: also known as an online collection form, is a form that collects information unidirectionally over the web. The online collection table generally corresponds to a collection interface, and after a user fills and submits information through the collection interface, the submitted information is collected into the online collection table, wherein the processes of filling and submitting information by different users are independent, that is, the information filling user cannot check the collected information in the online collection table.

In the embodiment of the application, the task verification and cancellation function can be realized through the cooperation of the online form and the online collection form. Before the task is checked and cancelled, a checking and cancelling person firstly creates an online table, and writes an object identifier of a task execution object in instant messaging application into a certain table column in the online table to obtain an object column; then another table column in the online table is set as a task column, and a corresponding online collection table is set for the task column.

When the task is checked and cancelled, the task checking and cancelling object can trigger a task checking and cancelling request through a collection interface corresponding to the online collection table, and the online table determines whether the task checking and cancelling object belongs to the task execution object according to the object column. When the task verification and cancellation object belongs to the task execution object, the task verification and cancellation result collected by the online collection table is written into the task column by the online table, so that verification and cancellation personnel can know the task verification and cancellation condition of each task execution object through the online table.

Compared with a manual verification and cancellation mode in the related art, by adopting the scheme provided by the embodiment of the application, verification and cancellation personnel only need to preset the online form containing the online collection table and provide the collection inlet corresponding to the online collection table for the task execution object, the online form and the online collection table can be matched to complete automatic verification and cancellation of the task, and the verification and cancellation personnel do not need to manually compare one by one and verify and cancel the task. Under the condition that the number of task execution objects is large, for example, when the task completion conditions of 500 group members in the instant messaging application group need to be checked and cancelled, the efficiency of task checking and cancelling can be improved, and the accuracy of task checking and cancelling can be improved (manual checking and cancelling may generate errors in the comparison process of the checking and cancelling object and the execution object).

The method provided by the embodiment of the application can be applied to the following scenes.

1. Check-in scene

In this scenario, after the verifying and canceling person creates the online table, the object identifier corresponding to the person to be checked in the instant messaging application program may be set in the object column, and another table column in the online table is set as the check-in column, so as to generate the online collection table for collecting check-in conditions based on the check-in column.

And the verification and cancellation personnel send the interface links of the on-line collection table corresponding to the check-in interface to the personnel to be checked in through the instant messaging application program. And when the person to be checked in checks in, clicking the interface link received in the instant messaging information application program, and checking in the check-in interface. When a check-in and check-out request triggered in the check-in interface is received, the online table detects whether a check-in and check-out object identifier contained in the check-in and check-out request belongs to an object identifier in an object column, and if the check-in and check-out object identifier belongs to the object identifier, the check-in result is written into the check-in column of the online table. The check-in personnel can quickly know the check-in condition by checking the check-in column in the online table.

2. Attendance condition statistics scene

In this scenario, after the verification and sales personnel create the online table, the corresponding object identifier of the attendance personnel in the instant messaging application program may be set in the object column, another table column in the online table is set as the attendance column, and then an online collection table is generated based on the attendance column, where the online collection table is used to record attendance records of each attendance personnel.

The two-dimensional code that the verification and sales personnel can correspond attendance interface with online collection table is placed in showing the position, and when attendance personnel carried out the attendance and punched the card, scan the two-dimensional code through instant messaging application promptly to carry out the attendance and punch the card at the attendance interface. The online collection table counts the attendance records of each attendance person, generates the attendance result (such as the number of late arrival and early exit times) of each attendance person, and writes the attendance result into the corresponding attendance column in the online table. The verification and cancellation personnel can know the attendance condition of each attendance personnel by checking the attendance column in the online form.

It should be noted that the above application scenarios are only used for exemplary illustration, and the method provided in the embodiment of the present application may also be used in other scenarios where task verification and cancellation are required, and the embodiment of the present application is not limited to a specific application scenario.

Referring to fig. 1, a schematic diagram of an implementation environment provided by an exemplary embodiment of the present application is shown. The implementation environment comprises a first terminal 110, a second terminal 120, a document server 130 and an instant messaging server 140, wherein the first terminal 110 communicates data with the document server 130 and the instant messaging server 140 through a communication network, the second terminal 120 communicates data with the document server 130 and the instant messaging server 140 through the communication network, and the document server 130 communicates data with the instant messaging server 140 through the communication network. Alternatively, the communication network may be a wired network or a wireless network, and the communication network may be at least one of a local area network, a metropolitan area network, and a wide area network.

The first terminal 110 is a terminal for setting a to-be-certified task, the first terminal 110 may be a smart phone, a tablet computer, a personal computer, a portable computer, or the like, and the first terminal 110 is illustrated as a personal computer in fig. 1.

In one possible embodiment, an instant messaging application and an online document application are running in the first terminal 110. Through the online document application, the first terminal 110 may create an online form for task verification and cancellation, and through the instant messaging application, the first terminal 110 may notify each task execution object in the instant messaging application to execute a task and perform task verification and cancellation.

The second terminal 120 is a terminal for performing task verification, the second terminal 120 may be a smart phone, a tablet computer, a personal computer, a portable computer, or the like, and the second terminal 120 is illustrated as a smart phone in fig. 1.

In one possible embodiment, an instant messaging application and an online document application are running in the second terminal 120. The second terminal 120 may perform task cancellation through the online document application, and the second terminal 120 may receive the task cancellation notification sent by the first terminal 110 through the instant messaging application.

The document server 130 is a background server of an online document application, and the document server 130 may be an independent physical server, a server cluster or a distributed system formed by a plurality of physical servers, or a cloud server providing basic cloud computing services such as a cloud service, a cloud database, cloud computing, a cloud function, cloud storage, a Network service, cloud communication, a middleware service, a domain name service, a security service, a Content Delivery Network (CDN), and a big data and artificial intelligence platform.

In some embodiments, the document server 130 is configured to maintain the created online table and update the update operation on the table data by different table editors to the online table, thereby implementing an online editing function for the same table by multiple persons.

The instant messaging server 140 is a background server of an instant messaging application, and the instant messaging server 140 may be an independent physical server, a server cluster or a distributed system formed by a plurality of physical servers, or a cloud server providing basic cloud computing services such as a cloud service, a cloud database, cloud computing, a cloud function, cloud storage, a network service, cloud communication, a middleware service, a domain name service, a security service, a CDN, and a big data and artificial intelligence platform.

In a possible scenario, when it is necessary to cancel the task completion status of the group member in the instant messaging application group, as shown in fig. 1, a cancellation person obtains an object identifier of a task execution object (a user identifier in the instant messaging application) from the instant messaging information server 140 through the instant messaging application in the first terminal 110, and creates an online form and a collection form based on the object identifier and the task to be cancelled. After the online form and the collection form are created, the first terminal 110 sends the collection form (a link of the collection form to the collection interface may be sent) in the group through the instant messaging server 140. After the task execution object completes the task, the task is checked and cancelled in the collection table, so that the task checking and cancelling request is sent to the document server 130. The document server 130 verifies the received task verification request, and writes the task verification result into a cell corresponding to the task execution object in the online form when the verification is passed. In addition, the document server 130 may also send a reminder or notification to the instant messenger server 140 so that the instant messenger server 140 sends a reminder or specified contents to the task execution object.

The following embodiments provide a task verification method and a table generation method for the implementation environment shown in fig. 1.

Referring to fig. 2, a flowchart of a table generation method provided in an exemplary embodiment of the present application is shown. The embodiment is described by taking the method as an example for the first terminal 110 shown in fig. 1 (the following embodiment is simply referred to as terminal), and the method includes the following steps.

At step 201, an online form is created.

In a possible implementation mode, the terminal creates a blank online form through a form creating function of the online document application, or creates an online form according to an online form template selected by a user from the online document application, wherein the online form template comprises a form column name. The embodiment of the present application does not limit the creating manner of the online form.

Step 202, receiving an object setting operation on the online form, and setting an object column in the online form, where the object column includes at least one execution object identifier, and the execution object identifier is an object identifier of a task execution object in the instant messaging application.

In order to ensure the accuracy of the subsequent task verification and cancellation and avoid the illegal task verification and cancellation of the non-task execution object, an object column corresponding to the task execution object needs to be set in the online table.

In a possible implementation manner, an object identifier of each task execution object is set in a cell in the object column, where the object identifier is a unique identifier of each user in the instant messaging application program, for example, the object identifier is a user account in the instant messaging application.

Since the object identifier is usually in the form of a character string, and the verifying and selling personnel may not directly associate with the corresponding task execution object according to the character string, in order to enable the verifying and selling personnel to determine the specific task execution object through the object column in the online table, in one possible embodiment, a user name of the task execution object in the instant messaging application is displayed in a cell of the object column, and the user name is associated with the execution object identifier, or a name column is further provided in the online table, the name column includes the user name of the task execution object in the instant messaging application, and the name column is in one-to-one correspondence with the cell in the object column.

Step 203, receiving a task setting operation on the online table, setting a task column corresponding to the object column in the online table, and generating a collection table corresponding to the task column, where the collection table is used to write a task cancel result into a corresponding cell in the task column according to a task cancel request triggered by the task execution object.

Optionally, after the object column setting is completed, the terminal sets the task column in the online table according to the received task setting operation, and further generates a collection table corresponding to the task column, so as to collect a task verification and cancellation request triggered by the task execution object through the interface through the collection table, and further write a corresponding task verification and cancellation result into the task column. Of course, the user may set the task column in the online table first and then set the object column, and the setting sequence of the task column and the object column is not limited in this embodiment.

The same online table comprises at least one task column, and different task columns correspond to different collection tasks. For example, the online table includes a first task column and a second task column, where the first task column is used to collect the mobile phone number of the task execution object, and the second task column is used to collect the check-in condition of the task execution object.

In one possible implementation mode, in response to receiving a selection operation of a table column in an online table, the terminal displays at least one function option, wherein the at least one function option includes a task setting option. And when the selection operation of the task setting option is received, the terminal determines that the task setting operation of the selected table column is received.

In some embodiments, the task column in the online table is locked, i.e., the contents of the cells in the task column are not editable, thereby avoiding the effect of the misoperation on the verification and cancellation result.

Illustratively, as shown in fig. 4, when the acquisition condition of the cultural shirt needs to be checked and sold, the checking and selling person creates an online table through the first terminal 110, creates an object column 41 and a task column 42 in the online table, and generates a collection table corresponding to the task column 42, wherein the collection table is used for collecting task checking and selling information through the collection interface 43. When the task verification is performed, the first terminal 110 transmits the link of the collection interface 43 to the second terminal 120 used by each task execution object through the instant messaging server 140.

To sum up, in the embodiment of the present application, an object column corresponding to a task execution object is set in an online table, a task column corresponding to the object column is set in the online table according to a task to be executed by the task execution object, and a collection table corresponding to the task column is generated, so that when a task is checked and sold by using the collection table, based on a checking and selling object identifier of the checking and selling object, whether the checking and selling object belongs to the task execution object in the object column is determined, and when the checking and selling object belongs to the task column, a task checking and selling result is written into the task column in the online table, so that task checking and selling is completed; the whole task verification and cancellation process is completed through the cooperation of the online form and the collection form, manual verification and cancellation of verification and cancellation personnel are not needed, the task execution object can complete online task verification and cancellation through the collection form, and the efficiency of task verification and cancellation and the accuracy of task verification and cancellation can be improved under the condition that the number of the task execution objects is large.

The above embodiment describes a table generation process, and an exemplary embodiment describes a task verification process based on the above table.

Referring to fig. 3, a flowchart of a method for form-based task reimbursement provided by an exemplary embodiment of the present application is shown. The present embodiment is described by taking the method as an example for the document server 130 shown in fig. 1, and the method includes the following steps.

Step 301, receiving a task verification and cancellation request, where the task verification and cancellation request is used to verify and cancel a collection task indicated by a collection table, the collection table corresponds to a task column in an online table, and the task verification and cancellation request includes a verification and cancellation object identifier of a task verification and cancellation object.

In a possible implementation manner, the task cancel request is sent to the document server by the second terminal when the second terminal receives a trigger operation on the collection interface corresponding to the collection table. In order to avoid performing illegal task cancellation on an illegal object other than the task execution object, in this embodiment, the task cancellation request sent by the second terminal to the document server includes a cancellation object identifier of the task cancellation object.

In some embodiments, when the task execution object is an object in the instant messaging application, the task verification object is also an object in the instant messaging application, and accordingly, the verification object identifier is a unique user identifier of the task verification object in the instant messaging application.

Optionally, in addition to the verification object identifier, the task verification request may further include information related to the task completion condition, such as task verification time, task completion progress, and task completion amount, which is not limited in this embodiment of the present application.

Step 302, matching the verification and cancellation object identifier with an execution object identifier in an object column, where the object column belongs to an online table, and the execution object identifier is an object identifier of a task execution object in the instant messaging application.

Further, the document server matches the verification object identification with each execution object identification in the online table, so as to determine whether the task verification object belongs to the task execution object.

Step 303, in response to the object column containing the execution object identifier matching with the verification object identifier, writing the task verification result into the cell corresponding to the execution object identifier in the task column.

And if the execution object identification matched with the verification object identification exists in the object class, the task verification object belongs to the task execution object, the document server determines a task verification result according to the information contained in the task verification request, and then writes the task verification result into a corresponding cell in the task column.

The document server writes the task verification and cancellation result into the corresponding cell according to the column identification and the execution object identification, so that the writing confusion of the task verification and cancellation result is avoided.

Optionally, when receiving the task cancel request triggered by the task execution object again, the document server replaces the data in the task column cell corresponding to the task execution object (i.e., only the latest data is retained), or superimposes the data in the task column cell corresponding to the task execution object (i.e., the original data is retained).

Optionally, if the execution object identifier matching with the verification object identifier does not exist in the object column, it indicates that the task verification object does not belong to the task execution object, and therefore, the document server does not write the task verification result into the task column.

Illustratively, as shown in fig. 4, after the task cancellation object (Zhao Liu) receives the cultural shirt, the collection interface 43 is opened by using the second terminal 120, and the confirmation receiving button 431 is clicked to trigger the task cancellation request to be sent to the document server 130. Since the object column 41 includes "@ zhao sixty", the document server 130 determines that the task verification and cancellation object belongs to the task execution object after receiving the task verification and cancellation request, and writes the task verification and cancellation result "complete" into the cell corresponding to "zhao sixty" in the task column 42.

By adopting the form generation method provided by the embodiment, when the number of task execution objects is large, if the user manually inputs the identification of each execution object one by one, a large amount of time is spent, and omission is easily caused. Therefore, the efficiency of setting the object column is improved, and the accuracy is improved. In a possible implementation manner, the user can uniformly copy the object identifier of the object in the instant messaging application, paste the copied object identifier to the online table, and automatically generate the object column according to the copied content by the document server.

Illustratively, as shown in fig. 5, the above step 202 may include the following steps 202A to 202D.

Step 202A, a paste signal is received.

In a possible implementation manner, when a copy operation of a group corresponding member list in the instant messaging application is received, the terminal copies object information of each group object in the group to the pasting board. When the online document application is operated, the user can copy the content in the pasting board to the created online form through pasting operation, and correspondingly, when the pasting operation in the online form interface is received, the terminal receives the pasting signal.

Step 202B, sending the paste content to a document server according to the paste signal, where the document server is configured to, when recognizing that the paste content includes object information of at least one task execution object in the instant messaging application and a preset identifier, perform sorting on the object information to obtain sorted content, where the object information includes an object identifier, and the preset identifier is used to represent that the paste content comes from the instant messaging application.

And when the terminal establishes an online form and receives a pasting signal triggered in an online form interface, the pasting content is sent to the document server, and the document server analyzes the pasting content and determines the pasting requirement of the pasting content.

Because the object information corresponding to different objects in the copied content from the instant messaging application is connected end to form a long text, the pasted content needs to be classified by the document server in order to write the object information of different objects into different cells in the follow-up process.

Since not all the pasted contents of all the sources need to be sorted, but the pasted contents of a specific source need to be sorted automatically, in a possible implementation manner, the content copied from the instant messaging application by the terminal includes a preset identifier, where the preset identifier is used to indicate that the copied content comes from the instant messaging application.

In a possible real-time mode, a document server receives paste content sent by a terminal; and in response to the fact that the paste content contains the preset identification and the paste content contains the object information of at least one task execution object in the instant messaging application, performing sorting on the object information to obtain sorted content.

When the fact that the paste content contains the preset identification is recognized, the document server determines that the paste content is obtained by copying from the instant messaging application, and further recognizes whether the paste content contains the object information. When the object information contained in the paste content is identified, the document server intelligently sorts the object information to obtain sorted content.

For the intelligent column-dividing mode, in a possible implementation manner, in the pasting content, the object information corresponding to different objects is separated by using preset characters, and different types of object information corresponding to the same object adopt preset information templates, so that the document server can realize intelligent column-dividing of the pasting content based on the preset characters and the preset information templates.

In an illustrative example, as shown in fig. 6, a terminal performs account replication on a group member list 61 in an instant messaging application, and the obtained paste contents 62 are: zhangthree + zhangsan; plum four + lisi 001; wangwu + wangwu 001; zhaoliu + zhaoliu; chenqi + chenqi 002; zhuba + zhuba 008. The object information copied from the instant messaging application adopts a template of 'object name + object identification', and the object information of different objects is adopted; "separate, so the document server intelligently classifies the paste content 62 as an object name column 63 and an object identification column 64.

Further, the document server feeds back the content of the intelligent grouping to the terminal so that the terminal can generate the object column.

Step 202C, receiving the content of the column sent by the document server.

Correspondingly, the terminal receives the content of the columns sent by the document server.

In step 202D, an object column is set in the online table according to the contents of the column.

In a possible implementation manner, when the split contents include at least two columns, the terminal merges the at least two columns of split contents into the object column. Although the plurality of columns of contents are merged and displayed in the object column, the mapping relationship among the plurality of columns of contents is still preserved.

In other possible embodiments, the terminal may also directly use the content of the sub-column as the object column, which is not limited in this embodiment.

Illustratively, as shown in fig. 5, the terminal merges an object name column 63 and an object identification column 64 into an object column 65, wherein the object column 65 is displayed in the form of "@ object name".

In the embodiment, the terminal uploads the copied content from the instant messaging application to the document server, the document server identifies the copied content, and automatically lists the copied content when identifying that the copied content comes from the instant messaging application and contains the object information, and then feeds the listed content obtained by the listing back to the terminal, so that the terminal can set the object column according to the listed content, the setting process of the object identifier in the object column is simplified, and the setting efficiency of the object column is improved.

For the process of setting the task list in the above embodiment, in a possible implementation manner, as shown in fig. 7, the step 203 may include the following steps.

Step 203A, in response to receiving a selected operation on a target column in the online form, displaying at least one task option.

In a possible implementation manner, when a user wants to set a task column in an online form, a target column can be selected through operation, and correspondingly, when the selected operation on the target column is received, the terminal displays at least one task option on an online form interface, wherein different task options correspond to different task types.

In some embodiments, at least one task option comprises a task template option and a self-defining option, and a user can modify the task template on the basis of the existing task template by selecting the task template option; by selecting the user-defined option, the user can set the collection task on the blank task template completely according to the self requirement.

Illustratively, as shown in fig. 8, when a selected operation on a target column 81 is received, the terminal displays task options 82 on an online form interface, where the task options 82 include task template options corresponding to the attendance check-in and attendance check-in tasks, and a custom option.

Step 203B, responding to the selection operation of the target task option, displaying a task setting interface corresponding to the target task option, where the task setting interface is used to set task information of the collection task.

Due to the fact that the task verification and cancellation modes corresponding to different collection tasks are different, for example, some collection tasks can be verified and cancelled only by clicking a control by a user, and some collection tasks can be verified and cancelled only by inputting specified contents and submitting the specified contents by the user. Therefore, in the process of setting the task column, task information of the collection task needs to be set through the task setting interface.

In one possible embodiment, the task information includes at least a task name and a task verification mode. When the target column has the column name, the task name corresponding to the collection table can be the column name of the target column, and if the target column does not have the column name, the task name can be manually set by a user and is synchronized to the collection table; the task verification mode comprises at least one of control clicking verification and information submitting verification.

Optionally, when the task verification mode is that the control clicks verification and cancellation, the set task information may further include verification and cancellation result write-in content, where the verification and cancellation result write-in content is a task column used for writing in the online table; when the task verification mode is information submission verification, the set task information may further include an information type, where the information type includes a text type, an option type, an image type, and the like, which is not limited in this embodiment.

Illustratively, as shown in fig. 8, when a click operation for opening a sign-in corresponding task option is received, the terminal displays a task setting interface 83 corresponding to the sign-in task. The user can set the task name 831 and the pinning result write content 832 in the task setting interface 83.

Step 203C, in response to the setting completion signal in the target task setting interface, setting the target column as a task column, and generating a collection table according to the task information set in the task setting interface.

And when receiving a setting completion signal, the terminal determines to complete the task information setting, thereby setting the target column as a task column and generating a collection table according to the set task information. And the generated collection table is bound with the online table and is stored in the document server.

In one possible implementation manner, in order to facilitate collection, the document server generates a collection interface corresponding to the collection table according to the task information, and generates a two-dimensional code according to a link of the collection interface, so that the two-dimensional code is fed back to the terminal, and the terminal displays the two-dimensional code on the online form interface. When the task is subsequently checked and sold, after the task checking and selling object scans the two-dimensional code by using the terminal, the terminal displays the collection interface, so that the task checking and selling object can conveniently check and sell on the collection interface.

Illustratively, as shown in fig. 8, when a click operation on the completion control 833 is received, the terminal generates a collection table according to the set task information, and displays the two-dimensional code 84 corresponding to the collection interface (generated by the document server according to the task information).

In the embodiment, the terminal generates the collection table according to the task information set in the task setting interface, displays the two-dimensional code of the collection table corresponding to the collection interface, and the subsequent task verification and cancellation object can quickly enter the collection interface to perform task verification and cancellation by scanning the code, so that the task verification and cancellation efficiency is improved.

In an illustrative example, as shown in fig. 9, the process of implementing the card punching verification based on the two-dimensional code includes the following steps.

Step 901, selecting a target column in an online form, and setting a card punching task.

Step 902, detect whether the target column contains a column name.

Step 903, if yes, the column name is passed to the collection table.

At step 904, a collection table is created, titled column name.

And step 905, generating a two-dimensional code of the collection table corresponding to the collection interface.

And step 906, setting a task column and displaying the two-dimensional code.

Step 907, scanning the two-dimensional code.

Step 908, match the object id of the card punch object with the object id of the object column in the online table.

Step 909 is whether there is a matching object identification.

Step 910, if yes, updating the card punching status to the cell corresponding to the object identifier in the task column.

In a possible application scenario, a task to be checked and cancelled is a single task, such as check-in, check-up, and the like, and in this scenario, the document server directly writes a task checking and cancelling record (in the collection table) into a cell in a task column; in other possible application scenarios, the task to be checked and cancelled is a circular task, such as attendance record, in such a scenario, a plurality of task checking and cancelling records of the same task execution object exist in the collection table, and if the plurality of task checking and cancelling records are directly written into the task column as the task checking and cancelling result, the data amount of the task column is too much, and the checking and cancelling personnel are not facilitated to check.

Therefore, for the verification and cancellation scene of the circular task, the task information set through the task setting interface further comprises a statistical index, after the task verification and cancellation is carried out, the document server carries out statistics on the task verification and cancellation records in the collection table based on the statistical index, and therefore the statistical result is transmitted back to the online table as the task verification and cancellation result. In a possible implementation, the step 303 may include the following steps.

Step 303A, in response to the object column containing the execution object identifier matching with the cancel object identifier, writing the task cancel record into the collection table.

In one possible implementation, the collection table contains multiple forms (sheets) that correspond to task execution objects in the online form. When the task verification and cancellation object belongs to the task execution object, the document server determines a form of the task execution object from the collection table, and writes the task verification and cancellation record into the form.

Illustratively, as shown in fig. 11, taking an attendance checking scene as an example, the online table 1101 includes 6 task execution objects, and the task column 1101a is used for displaying the number of late-to-early-retirement times. Accordingly, the collection table 1102 created based on the task column 1101a includes 6 forms 1102a, and each form includes the time when the task execution object is punched on/off duty and whether it is late to be early exited. When Zhang III performs attendance card punching through the collection interface corresponding to the collection table 1102, the document server writes attendance card punching time into the form corresponding to Zhang III.

And step 303B, generating a task verification and cancellation result corresponding to the execution object identifier according to at least one task verification and cancellation record corresponding to the execution object identifier in the collection table.

In a possible implementation manner, the document server generates a task verification result corresponding to each task execution object according to at least one task verification record corresponding to each task execution object according to a predetermined period. The predetermined period may be preset, or may be set by default, for example, the preset period is 1 week or 1 month.

In order to enable the document server to know the rule for generating the task verification and cancellation result based on the task verification and cancellation record, so as to ensure the accuracy of the task verification and cancellation result, in one possible implementation, the task information set in the task setting interface further includes a statistical rule, and the statistical rule is used for indicating a statistical mode of the task verification and cancellation record.

Illustratively, as shown in fig. 12, a task setting interface 1201 includes a statistical index 1202 set by a user, and the statistical index 1202 is used for indicating a measure of late arrival/early departure.

Correspondingly, when the task verification and cancellation result is determined, the document server obtains the statistical index corresponding to the collection table, so that at least one task verification and cancellation record is counted according to the statistical index, and the task verification and cancellation result corresponding to the execution object identifier is obtained.

In a possible implementation manner, after the terminal completes the task information setting, the task information is uploaded to the document server, the document server generates a corresponding statistical function according to the statistical index therein, and the statistical function is written into the collection table, so that a task verification and cancellation result is generated based on the statistical function and the task verification and cancellation record during subsequent statistics.

Illustratively, as shown in fig. 12, when a click operation on a generation control 1203 in a task setting interface 1201 is received, the terminal transmits the working time, the working time and the statistical index to the document server. The document server analyzes the received information to obtain a corresponding statistical function, and the statistical function is inserted into the collection table. For example, the statistical function indicates that the on-duty time is late at 9:30 and the off-duty time is early at 17: 00.

When the task verification and cancellation result is generated subsequently, the document server determines the early-late condition of each task verification and cancellation record in the collection table 1102 according to the statistical function, and then transmits the statistical result back to the online table.

In a possible embodiment, in order to improve the accuracy of the statistical result, the collection table may be further externally connected to an Application Programming Interface (API), so as to implement accurate statistics by means of the API. For example, the collection table 1102 in fig. 11 is externally connected to a calendar API 1103, so as to improve the accuracy of determining the working day in the statistical process.

And step 303C, returning the task cancel result to the cell corresponding to the execution object identifier in the task column.

Further, the document server transmits the obtained task verification and cancellation result back to the online form, and the online form writes the task verification and cancellation result into the cell corresponding to the execution object identifier.

Illustratively, as shown in fig. 11, the document server performs statistics on the task verification and cancellation record corresponding to "zhang san" according to the statistical index, determines that there is early fallback on the date "7.5", obtains a statistical result 1102b corresponding to zhang san including the late early fallback number of times of 1, and returns the late early fallback number of times to the task column cell corresponding to zhang san in the online table 1101.

In order to facilitate the verification personnel to check the detailed task verification record, in a possible implementation manner, a verification record checking control is further arranged in a cell in the task column, and when the triggering operation of the verification record checking control is received, the terminal can jump to display the collection table (which can be positioned to a specific form). Illustratively, as shown in fig. 11, when a click operation is received on a cell core pin record viewing control 1101b in a task column 1101a, the terminal jumps to display a collection table 1102.

In the embodiment, the statistical indexes are set for the online collection table, so that the document server can perform statistics on a plurality of task verification and cancellation records of the same object according to the statistical indexes to obtain the task verification and cancellation result, and then the task verification and cancellation result is transmitted back to the online table, so that the data volume of verification and cancellation data in the online table is simplified, and verification and cancellation personnel can conveniently check the verification and cancellation result.

In order to further improve the intelligentization degree of task verification and cancellation, verification and cancellation personnel can set a reminding column in an online table so as to remind a task execution object to perform task verification and cancellation in time. In addition, the verification and cancellation personnel can set a notification column in the online form so as to send the specified content in the online form to the task execution object.

In one possible implementation mode, the terminal receives a reminding setting operation on an online form and displays a reminding setting interface, wherein the reminding setting interface is used for setting reminding time and a task column to be reminded; and setting the column for reminding the setting operation function as a reminding column in response to a setting completion signal in the reminding setting interface.

Optionally, when receiving a selection operation on a table column in the online table, the terminal displays at least one function option, and when receiving a trigger operation of a prompt function option in the at least one function option, the terminal determines a prompt setting operation, and further displays a prompt setting interface.

Illustratively, as shown in fig. 13, when receiving a selection operation on a table column 1301, the terminal displays at least one function option 1302, and when receiving a click operation on a "reminder" function option, the terminal displays a reminder setting interface 1303 on an online table interface. The user may set a reminding time 1303a and a reminding content 1303B in the reminding setting interface 1303, where the reminding content 1303B may be a column identifier of a task column to be reminded (for example, a column identifier column B corresponding to the retrieval state column in fig. 13).

In some embodiments, when receiving a prompt setting operation for an online form, the terminal detects whether the online form contains a task column, displays a prompt setting interface when the online form contains the task column, and displays prompt information to prompt a user to set the task column and then set the prompt column if the online form does not contain the task column.

After the setting of the reminding column is finished, when the document server reaches the reminding time and the cell corresponding to the target execution object identifier in the task column does not contain the task verification result, the document server sends reminding information to the instant messaging server, and the instant messaging server sends reminding information (in the form of instant messaging information) to the target task execution object.

In a possible implementation manner, the reminding information includes an object identifier of the target task execution object. Optionally, the reminding information may further include a link of a collection interface corresponding to the collection table, so that the target task execution object can quickly perform task verification and cancellation by clicking the link.

Optionally, the reminding information may further include a creator identifier of the creator corresponding to the online form, and accordingly, the instant messaging information server sends the reminding information to the target task execution object in the identity of the creator.

Illustratively, as shown in fig. 14, the target task execution object "zhao liu" receives a reminder information 1401 sent by the instant messaging server in the online form creator identity "old", and the reminder information includes a link of the collection form interface. After the user clicks the link, the terminal jumps to the display collection interface 1402, so that the target task execution object performs task verification and cancellation.

In addition to the document server actively triggering and sending the reminding information, in another possible implementation manner, in response to that the reminding time is not reached and the cell corresponding to the target execution object identifier does not contain the task verification result, a reminding control is displayed in the cell corresponding to the target execution object identifier in the reminding column, and the reminding control is used for manually triggering and sending the reminding information to the task execution object. And in response to receiving the triggering operation of the reminding control, the terminal sends reminding information to the instant messaging server through the document server.

Illustratively, as shown in fig. 13, a reminder control 1304 is disposed in a cell corresponding to the reminder column 1301. The user can send the reminding information to the corresponding task execution object through the instant messaging server by clicking the reminding control 1304.

In the embodiment, the reminding columns corresponding to the task columns are set in the online table, and the corresponding reminding time is set for the reminding columns, so that reminding information (in the form of instant messaging messages) is automatically sent to the task execution objects which do not finish task verification and cancellation when the reminding time is reached, and the probability that the task execution objects do not perform task verification and cancellation in time is reduced. In addition, the user can actively trigger the reminding through the reminding control, so that the reminding mode is enriched, and the reminding flexibility is improved.

In one possible implementation mode, the terminal receives notification setting operation on the online form, and displays a notification setting interface which is used for setting notification time and notification content; and setting a column acted by the notification setting operation as a notification column in response to a setting completion signal in the notification setting interface, wherein the notification column is used for triggering the notification content to be sent to the task execution object through the instant messaging server when the notification time is reached.

Optionally, when receiving a selection operation on a table column in the online table, the terminal displays at least one function option, and when receiving a trigger operation on a notification function option in the at least one function option, the terminal determines that a notification setting operation is performed, and further displays a notification setting interface.

Illustratively, as shown in fig. 15, when a selection operation on a table column 1501 is received, the terminal displays at least one function option 1502, and when a click operation on a "notification" function option is received, the terminal displays a notification setting interface 1503 on the online table interface. The user can set a notification time 1503a and a notification content 1503b in the notification setting interface 1503, wherein the notification content 1503b can be the content of the line on which the task execution object is positioned.

Of course, in other possible embodiments, the verification and cancellation personnel may set the shielding content of the task execution object, and determine the content in the online form other than the shielding content as the notification content, which is not limited in this embodiment.

In a possible implementation manner, the notification information includes, in addition to the notification content, a link corresponding to the collection interface of the collection table, so that the user can quickly view the task cancel record corresponding to the notification content by clicking the link.

Optionally, the notification information may further include a creator identifier of a creator corresponding to the online form, and accordingly, the instant messaging information server sends the notification content to the target task execution object by using the identity of the creator.

In some embodiments, a notification control may be further disposed in the cell corresponding to the notification column, and when a trigger operation on the notification control is received, the document server may send notification content to the corresponding task execution object through the instant messaging server. Illustratively, as shown in fig. 15, a notification control 1504 is arranged in a cell corresponding to the notification column 1501, and when a click operation on the notification control corresponding to "zhuyi" is received, the terminal sends notification information 1505 to "zhuyi" through the instant messaging application server. When a click operation for the notification information 1505 is received, the terminal expands and displays the notification information 1505 on the card 1506.

In this embodiment, by setting a notification column in the online table and setting a corresponding notification time for the notification column, when the notification time is reached, notification content (in the form of an instant messaging message) is automatically sent to each task execution object. The automatic attendance information sending method and the device can achieve automatic attendance information sending in an attendance scene, users do not need to copy and send the attendance information one by one, and the sending process of the attendance information is simplified.

When the reminding and content notification functions are realized, the document server needs to send an instant communication message to the task execution object by means of the instant communication server, and the document server needs to use a token (token) when performing a data communication process with the instant communication server. In a possible implementation manner, after receiving the paste content sent by the terminal, the document server sends a token allocation request to the instant messaging server, where the token allocation request includes object information and a preset identifier, and the token allocation request is used to request the instant messaging server to allocate a corresponding token for each task execution object.

After receiving the token allocation request, the instant messaging server allocates tokens to the task execution objects if the preset identification is identified, wherein different task execution objects correspond to different tokens, and the tokens can include token valid time. And if the preset identifier is not identified, not responding to the token allocation request.

Optionally, after distributing the token for the task execution object, the instant messaging server performs associated storage on the mapping relationship between the task execution identifier and the token, so as to verify the token based on the mapping relationship in the following.

Correspondingly, the document server receives the token sent by the instant messaging server and stores the token and the object information in an associated manner.

When the subsequent document server sends reminding information or notification information to the task execution object through the instant messaging server, the token corresponding to the task execution object is added to the reminding information or the notification information; after receiving the reminding information or the notification information, the instant communication server searches the token of the object according to the execution object identifier contained in the reminding information or the notification information, compares whether the token contained in the information is consistent with the searched token, and if so, the instant communication server determines that the information passes the verification, thereby sending the reminding information or the notification content to the corresponding task execution object.

In one illustrative example, as shown in FIG. 16, the token acquisition and alert message sending process includes the following steps.

Step 1601, the instant messaging application terminal copies group member name information in batch and carries a preset identifier.

In step 1602, the online document application end pastes the copied contents to an online form.

Step 1603, the online document application detects whether the preset identifier is included, and the rules of the group member name and the group member identifier.

In step 1604, the online document application sends a token obtaining request to the instant messaging server.

Step 1605, the instant communication application terminal distributes the token for each group member.

In step 1606, the online document application stores the group member id in association with the token.

Step 1607, the online document presents the object column in the form of @ group member name.

At step 1608, the online document triggers a manual or reminder designation of the group member.

Step 1609, the online document application queries for group member identification, tokens, and creator identification.

Step 1610, the instant messaging application verifies the token.

And step 1611, the token is verified, and the instant messaging application terminal verifies the token to send a reminding message to the designated group member in the manner of identity of the creator.

In an illustrative example, as shown in fig. 17, the transmission process of the notification content includes the following steps.

Step 1701, the online document application triggers the transmission of the notification content.

At step 1702, the online document application queries the set column id of the notification content.

Step 1703, the online document application obtains the notification content.

In step 1704, the online document application transmits the group member identifier, the notification content, the creator identifier and the token of the designated group member to the instant messaging application.

Step 1705, the instant messaging application verifies the token.

At step 1706, the instant messaging application sends the notification content to the designated group member with the identity of the creator.

In step 1707, the instant messaging application receives the notification content.

Step 1708, the instant messaging application triggers to view the notification content details.

In step 1709, the online document application detects whether there is an online form viewing right.

Step 1710, show the notification content in card form, and the online document application end does not allow the user to access the complete online form.

Step 1711, show the notice content in card form, and the online document application allows the user to access the complete online form.

Fig. 18 is a block diagram illustrating a structure of a table-based task verification apparatus according to an exemplary embodiment of the present application, where the apparatus, as shown in fig. 18, includes:

a request receiving module 1801, configured to receive a task verification and cancellation request, where the task verification and cancellation request is used to verify and cancel a collection task indicated by a collection table, the collection table corresponds to a task column in an online table, and the task verification and cancellation request includes a verification and cancellation object identifier of a task verification and cancellation object;

a matching module 1802, configured to match the cancel verification object identifier with an execution object identifier in an object column, where the object column belongs to the online table, and the execution object identifier is an object identifier of a task execution object in an instant messaging application;

and the verification module 1803 is configured to, in response to that the object column includes an execution object identifier that matches the verification object identifier, write a task verification result into a cell corresponding to the execution object identifier in the task column.

Optionally, the core-pin module 1803 includes:

a writing unit, configured to write a task cancel verification record into the collection table in response to the object column including the execution object identifier matching the cancel verification object identifier;

a generating unit, configured to generate the task verification and cancellation result corresponding to the execution object identifier according to at least one task verification and cancellation record corresponding to the execution object identifier in the collection table;

and the return unit is used for returning the task cancel result to the cell corresponding to the execution object identifier in the task column.

Optionally, the writing unit is configured to:

acquiring a statistical index corresponding to the collection table;

and counting at least one task verification record according to the statistical index to obtain the task verification result corresponding to the execution object identifier.

Optionally, the apparatus further comprises:

the paste content acquisition module is used for acquiring paste contents in the online form;

the object information comprises object identifiers, the preset identifier is used for representing that the paste content comes from the instant messaging application, and the split content is used for setting the object split;

the token request module is used for sending a token allocation request to an instant messaging server, wherein the token allocation request comprises the object information and the preset identification, and the instant messaging server is used for allocating tokens to the task execution objects after recognizing the preset identification;

and the token receiving module is used for receiving the token sent by the instant messaging server and storing the token and the object information in an associated manner.

Optionally, the online table further includes a reminder column;

the device further comprises:

the reminding information acquisition module is used for determining the reminding time and the task column corresponding to the reminding column;

and the first reminding module is used for responding to the reminding moment and sending reminding information to the instant messaging server in response to that the cell corresponding to the target execution object identifier in the task list does not contain the task verification result, wherein the reminding information contains the target execution object identifier and the token, and the instant messaging server is used for sending reminding information to the target task execution object indicated by the target execution object identifier when the token passes the verification.

Optionally, the apparatus further comprises:

the reminding control display module is used for setting a reminding control in a cell corresponding to the target execution object identifier in the reminding column in response to the reminding time not being reached and the cell corresponding to the target execution object identifier in the task column does not contain the task verification result;

and the second reminding module is used for responding to the received manual reminding instruction and sending the reminding information to the instant messaging server, wherein the manual reminding instruction is triggered by the reminding control.

Optionally, the online table further includes a notification column;

the device further comprises:

a notification content determining module, configured to determine notification time and notification content corresponding to the notification column;

and the notification module is used for responding to the notification moment and sending notification information to the instant messaging server, wherein the notification information comprises the execution object identifier, the token and the notification content, and the instant messaging server is used for sending the notification content to the task execution object indicated by the execution object identifier when the token is verified.

Fig. 19 is a block diagram of a table generating apparatus according to an exemplary embodiment of the present application, and as shown in fig. 19, the apparatus includes:

a creation module 1901 for creating an online form;

an object setting module 1902, configured to receive an object setting operation on the online table, and set an object column in the online table, where the object column includes at least one execution object identifier, and the execution object identifier is an object identifier of a task execution object in an instant messaging application;

the task setting module 1903 is configured to receive a task setting operation on the online table, set a task column corresponding to the object column in the online table, and generate a collection table corresponding to the task column, where the collection table is configured to write a task cancel result to a corresponding cell in the task column according to a task cancel request triggered by the task execution object.

Optionally, the task setting module 1903 includes:

the option display unit is used for responding to the received selected operation of the target column in the online table and displaying at least one task option;

the interface display unit is used for responding to the selection operation of a target task option and displaying a task setting interface corresponding to the target task option, wherein the task setting interface is used for setting task information of a collection task;

and the task setting unit is used for responding to a setting completion signal in the target task setting interface, setting the target column as the task column and generating the collection table according to the task information set in the task setting interface.

Optionally, the task information includes a statistical index, and the collection table is configured to perform statistics on at least one task verification record corresponding to the execution object identifier according to the statistical index, obtain a task verification result corresponding to the execution object identifier, and return the task verification result to the cell corresponding to the execution object identifier in the task column.

Optionally, the apparatus further comprises:

and the two-dimension code display module is used for displaying the collection interface two-dimension code, and the collection interface two-dimension code is generated according to the link of the collection table corresponding to the collection interface.

Optionally, the object setting module 1902 includes:

a signal receiving unit for receiving the paste signal;

the paste content sending unit is used for sending paste content to a document server according to the paste signal, the document server is used for sorting the object information to obtain sorted content when the paste content is identified to contain the object information of at least one task execution object in the instant messaging application and a preset identifier, and the preset identifier is used for representing that the paste content comes from the instant messaging application;

a classified content receiving unit, configured to receive the classified content sent by the document server;

and the object setting unit is used for setting the object column in the online table according to the content of the column.

Optionally, the apparatus further comprises:

the reminding setting interface display module is used for receiving reminding setting operation on the online form and displaying a reminding setting interface, and the reminding setting interface is used for setting reminding time and a task column to be reminded;

and the reminding column setting module is used for setting a column for reminding the setting operation function as the reminding column in response to a setting completion signal in the reminding setting interface, the reminding column is used for triggering that reminding information is sent to an instant messaging server through a document server when the reminding moment is reached and a cell corresponding to a target execution object identifier in the task column does not contain the task verification result, the reminding information comprises the target execution object identifier and a token, the instant messaging server is used for sending a reminding message to the target task execution object indicated by the target execution object identifier when the token passes verification, and the token is distributed by the instant messaging server.

Optionally, the apparatus further comprises:

the reminding control display module is used for responding to the situation that the reminding time is not reached and the cell corresponding to the target execution object identifier does not contain the task verification result, and displaying a reminding control in the cell corresponding to the target execution object identifier in the reminding column;

and the reminding information sending module is used for responding to the received triggering operation of the reminding control and sending the reminding information to the instant messaging server through the document server.

Optionally, the apparatus further comprises:

the notification setting interface display module is used for receiving notification setting operation on the online form and displaying a notification setting interface, and the notification setting interface is used for setting notification time and notification content;

and the notification column setting module is used for setting a column for setting the action of the notification operation as the notification column in response to a setting completion signal in the notification setting interface, and the notification column is used for triggering the notification content to be sent to the task execution object through the instant messaging server when the notification time is reached.

It should be noted that: the device provided in the above embodiment is only illustrated by dividing the functional modules, and in practical applications, the functions may be distributed by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules, so as to complete all or part of the functions described above. In addition, the apparatus and method embodiments provided by the above embodiments belong to the same concept, and specific implementation processes thereof are described in the method embodiments for details, which are not described herein again.

Referring to fig. 20, a schematic structural diagram of a server according to an exemplary embodiment of the present application is shown. Specifically, the method comprises the following steps: the server 2000 includes a Central Processing Unit (CPU) 2001, a system memory 2004 including a random access memory 2002 and a read only memory 2003, and a system bus 2005 connecting the system memory 2004 and the CPU 2001. The server 2000 also includes a basic Input/Output system (I/O system) 2006 to facilitate information transfer between devices within the computer, and a mass storage device 2007 to store an operating system 2013, application programs 2014, and other program modules 2015.

The basic input/output system 2006 includes a display 2008 for displaying information and an input device 2009 such as a mouse, keyboard, etc. for a user to input information. Wherein the display 2008 and the input devices 2009 are coupled to the central processing unit 2001 through an input-output controller 2010 coupled to the system bus 2005. The basic input/output system 2006 may also include an input/output controller 2010 for receiving and processing input from a number of other devices, such as a keyboard, mouse, or electronic stylus. Similarly, the input-output controller 2010 also provides output to a display screen, a printer, or other type of output device.

The mass storage device 2007 is connected to the central processing unit 2001 through a mass storage controller (not shown) connected to the system bus 2005. The mass storage device 2007 and its associated computer-readable media provide non-volatile storage for the server 2000. That is, the mass storage device 2007 may include a computer-readable medium (not shown) such as a hard disk or drive.

Without loss of generality, the computer-readable media may comprise computer storage media and communication media. Computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. Computer storage media includes Random Access Memory (RAM), Read Only Memory (ROM), flash Memory or other solid state Memory technology, Compact disk Read-Only Memory (CD-ROM), Digital Versatile Disks (DVD), or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices. Of course, those skilled in the art will appreciate that the computer storage media is not limited to the foregoing. The system memory 2004 and mass storage device 2007 described above may be collectively referred to as memory.

The memory stores one or more programs configured to be executed by the one or more central processing units 2001, the one or more programs containing instructions for implementing the above-described methods, and the central processing unit 2001 executes the one or more programs to implement the task approval method in the above-described respective method embodiments.

The server 2000 may also operate as a remote computer connected to a network via a network, such as the internet, according to various embodiments of the present application. That is, the server 2000 may be connected to the network 2012 through a network interface unit 2011 that is coupled to the system bus 2005, or the network interface unit 2011 may be utilized to connect to other types of networks or remote computer systems (not shown).

Referring to fig. 21, a schematic structural diagram of a terminal according to an exemplary embodiment of the present application is shown. The terminal 2100 may be a portable mobile terminal such as: smart phones, tablet computers, MP3 players (Moving Picture Experts Group Audio Layer III, motion video Experts compression standard Audio Layer 3), MP4 players (Moving Picture Experts Group Audio Layer IV, motion video Experts compression standard Audio Layer 4). The terminal 2100 may also be referred to by other names such as user equipment, portable terminal, and the like.

In general, the terminal 2100 includes: a processor 2101 and a memory 2102.

The processor 2101 may include one or more processing cores, such as a 4-core processor, an 8-core processor, and so on. The processor 2101 may be implemented in at least one hardware form of a DSP (Digital Signal Processing), an FPGA (Field-Programmable Gate Array), and a PLA (Programmable Logic Array). The processor 2101 may also include a main processor and a coprocessor, the main processor is a processor for Processing data in an awake state, and is also called a Central Processing Unit (CPU); a coprocessor is a low power processor for processing data in a standby state. In some embodiments, the processor 2101 may be integrated with a GPU (Graphics Processing Unit) which is responsible for rendering and drawing the content required to be displayed on the display screen. In some embodiments, the processor 2101 may also include an AI (Artificial Intelligence) processor to process computational operations related to machine learning.

The memory 2102 may include one or more computer-readable storage media, which may be tangible and non-transitory. The memory 2102 may also include high speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash memory storage devices. In some embodiments, a non-transitory computer readable storage medium in the memory 2102 is used to store at least one instruction for execution by the processor 2101 to implement the methods provided by embodiments of the present application.

In some embodiments, the terminal 2100 may further optionally include: a peripheral interface 2103 and at least one peripheral. Specifically, the peripheral device includes: at least one of a radio frequency circuit 2104, a touch display screen 2105, a camera assembly 2106, an audio circuit 2107, a positioning assembly 2108, and a power supply 2109.

The peripheral interface 2103 may be used to connect at least one peripheral related to I/O (Input/Output) to the processor 2101 and the memory 2102. In some embodiments, the processor 2101, memory 2102 and peripheral interface 2103 are integrated on the same chip or circuit board; in some other embodiments, any one or both of the processor 2101, the memory 2102 and the peripheral interface 2103 may be implemented on separate chips or circuit boards, which is not limited by this embodiment.

The Radio Frequency circuit 2104 is used to receive and transmit RF (Radio Frequency) signals, also called electromagnetic signals. The radio frequency circuitry 2104 communicates with a communication network and other communication devices via electromagnetic signals. The radio frequency circuit 2104 converts an electrical signal into an electromagnetic signal to transmit, or converts a received electromagnetic signal into an electrical signal. Optionally, the radio frequency circuitry 2104 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a subscriber identity module card, and so forth. The radio frequency circuitry 2104 may communicate with other terminals via at least one wireless communication protocol. The wireless communication protocols include, but are not limited to: the world wide web, metropolitan area networks, intranets, generations of mobile communication networks (2G, 3G, 4G, and 5G), Wireless local area networks, and/or WiFi (Wireless Fidelity) networks. In some embodiments, the radio frequency circuit 2104 may further include NFC (Near Field Communication) related circuits, which are not limited in this application.

The touch display screen 2105 is used to display a UI (user interface). The UI may include graphics, text, icons, video, and any combination thereof. Touch display screen 2105 also has the ability to capture touch signals on or over the surface of touch display screen 2105. The touch signal may be input as a control signal to the processor 2101 for processing. The touch display 2105 is used to provide virtual buttons and/or virtual keyboards, also referred to as soft buttons and/or soft keyboards. In some embodiments, the touch display screen 2105 may be one, providing the front panel of the terminal 2100; in other embodiments, the touch display 2105 can be at least two, each disposed on a different surface of the terminal 2100 or in a folded design; in still other embodiments, the touch display 2105 can be a flexible display, disposed on a curved surface or on a folded surface of the terminal 2100. Even the touch display screen 2105 may be arranged in a non-rectangular irregular figure, i.e., a shaped screen. The touch Display screen 2105 may be made of LCD (Liquid Crystal Display), OLED (Organic Light-Emitting Diode), or other materials.

The camera assembly 2106 is used to capture images or video. Optionally, camera head assembly 2106 includes a front camera and a rear camera. Generally, a front camera is used for realizing video call or self-shooting, and a rear camera is used for realizing shooting of pictures or videos. In some embodiments, the number of the rear cameras is at least two, and each of the rear cameras is any one of a main camera, a depth-of-field camera and a wide-angle camera, so that the main camera and the depth-of-field camera are fused to realize a background blurring function, and the main camera and the wide-angle camera are fused to realize a panoramic shooting function and a VR (Virtual Reality) shooting function. In some embodiments, camera head assembly 2106 may also include a flash. The flash lamp can be a monochrome temperature flash lamp or a bicolor temperature flash lamp. The double-color-temperature flash lamp is a combination of a warm-light flash lamp and a cold-light flash lamp, and can be used for light compensation at different color temperatures.

The audio circuit 2107 is used to provide an audio interface between a user and the terminal 2100. The audio circuitry 2107 may include a microphone and a speaker. The microphone is used for collecting sound waves of a user and the environment, converting the sound waves into electric signals, and inputting the electric signals into the processor 2101 for processing, or inputting the electric signals into the radio frequency circuit 2104 to realize voice communication. The microphones may be provided in plural, at different locations of the terminal 2100, for stereo sound acquisition or noise reduction purposes. The microphone may also be an array microphone or an omni-directional pick-up microphone. The speaker is used to convert the electrical signals from the processor 2101 or the radio frequency circuit 2104 into sound waves. The loudspeaker can be a traditional film loudspeaker or a piezoelectric ceramic loudspeaker. When the speaker is a piezoelectric ceramic speaker, the speaker can be used for purposes such as converting an electric signal into a sound wave audible to a human being, or converting an electric signal into a sound wave inaudible to a human being to measure a distance. In some embodiments, the audio circuitry 2107 may also include a headphone jack.

The positioning component 2108 is used to locate the current geographic position of the terminal 2100 for navigation or LBS (Location Based Service). The Positioning component 2108 may be a Positioning component based on the united states GPS (Global Positioning System), the chinese beidou System, or the russian galileo System.

Power supply 2109 is used to provide power to various components in terminal 2100. The power source 2109 may be alternating current, direct current, disposable batteries, or rechargeable batteries. When the power source 2109 includes a rechargeable battery, the rechargeable battery may be a wired rechargeable battery or a wireless rechargeable battery. The wired rechargeable battery is a battery charged through a wired line, and the wireless rechargeable battery is a battery charged through a wireless coil. The rechargeable battery may also be used to support fast charge technology.

In some embodiments, the terminal 2100 also includes one or more sensors 2110. The one or more sensors 2110 include, but are not limited to: acceleration sensor 2111, gyro sensor 2112, pressure sensor 2113, fingerprint sensor 2114, optical sensor 2115, and proximity sensor 2116.

The acceleration sensor 2111 can detect the magnitude of acceleration in three coordinate axes of the coordinate system established with the terminal 2100. For example, the acceleration sensor 2111 may be used to detect components of the gravitational acceleration in three coordinate axes. The processor 2101 may control the touch display screen 2105 to display a user interface in a landscape view or a portrait view according to the gravitational acceleration signal collected by the acceleration sensor 2111. The acceleration sensor 2111 may also be used for acquisition of motion data of a game or a user.

The gyro sensor 2112 may detect the body direction and the rotation angle of the terminal 2100, and the gyro sensor 2112 may cooperate with the acceleration sensor 2111 to acquire the 3D motion of the user on the terminal 2100. The processor 2101 may implement the following functions according to the data collected by the gyro sensor 2112: motion sensing (such as changing the UI according to a user's tilting operation), image stabilization at the time of photographing, game control, and inertial navigation.

Pressure sensors 2113 may be provided on the side bezel of terminal 2100 and/or on the lower layer of touch display screen 2105. When the pressure sensor 2113 is provided on the side frame of the terminal 2100, a user's grip signal on the terminal 2100 can be detected, and left-right hand recognition or shortcut operation can be performed based on the grip signal. When the pressure sensor 2113 is disposed at the lower layer of the touch display screen 2105, the operability control on the UI interface can be controlled according to the pressure operation of the user on the touch display screen 2105. The operability control comprises at least one of a button control, a scroll bar control, an icon control and a menu control.

The fingerprint sensor 2114 is used for collecting a fingerprint of the user to identify the identity of the user according to the collected fingerprint. Upon identifying that the user's identity is a trusted identity, the processor 2101 authorizes the user to perform relevant sensitive operations including unlocking the screen, viewing encrypted information, downloading software, payment, and changing settings, etc. The fingerprint sensor 2114 may be provided on the front, back, or side of the terminal 2100. When a physical button or vendor Logo is provided on the terminal 2100, the fingerprint sensor 2114 may be integrated with the physical button or vendor Logo.

The optical sensor 2115 is used to collect the ambient light intensity. In one embodiment, processor 2101 may control the display brightness of touch display 2105 based on the ambient light intensity collected by optical sensor 2115. Specifically, when the ambient light intensity is high, the display brightness of the touch display screen 2105 is increased; when the ambient light intensity is low, the display brightness of the touch display screen 2105 is turned down. In another embodiment, processor 2101 may also dynamically adjust the shooting parameters of camera head assembly 2106 based on the intensity of ambient light collected by optical sensor 2115.

A proximity sensor 2116, also called distance sensor, is typically provided on the front side of the terminal 2100. The proximity sensor 2116 is used to collect the distance between the user and the front face of the terminal 2100. In one embodiment, when proximity sensor 2116 detects that the distance between the user and the front face of terminal 2100 is gradually decreased, touch display 2105 is controlled by processor 2101 to switch from a bright screen state to a rest screen state; when the proximity sensor 2116 detects that the distance between the user and the front surface of the terminal 2100 is gradually increased, the touch display 2105 is controlled by the processor 2101 to switch from the breath-screen state to the bright-screen state.

Those skilled in the art will appreciate that the configuration shown in fig. 21 is not intended to be limiting with respect to terminal 2100, and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components may be used.

The present invention further provides a computer-readable storage medium, where at least one instruction, at least one program, a code set, or a set of instructions is stored in the computer-readable storage medium, and the at least one instruction, the at least one program, the code set, or the set of instructions is loaded and executed by a processor to implement the method for task verification and verification based on a table as described in the foregoing embodiments, or to implement the method for generating a table as described in the foregoing embodiments.

Embodiments of the present application also provide a computer program product or computer program comprising computer instructions stored in a computer-readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions to cause the computer device to execute the form-based task verification method provided by the above-mentioned embodiment, or to implement the form generation method provided by the above-mentioned embodiment.

It will be understood by those skilled in the art that all or part of the steps for implementing the above embodiments may be implemented by hardware, or may be implemented by a program instructing relevant hardware, where the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.

The above description is intended to be exemplary only, and not to limit the present application, and any modifications, equivalents, improvements, etc. made within the spirit and scope of the present application are intended to be included therein.

Claims

1. A method for form-based task underwriting, the method comprising:

2. The method according to claim 1, wherein said writing a task cancellation result to a cell corresponding to the execution object identifier in the task column in response to the object column containing an execution object identifier matching the cancellation object identifier comprises:

writing a task core-canceling record into the collection table in response to the object column containing the execution object identifier matched with the core-canceling object identifier;

generating a task verification and cancellation result corresponding to the execution object identifier according to at least one task verification and cancellation record corresponding to the execution object identifier in the collection table;

and returning the task verification and cancellation result to the cell corresponding to the execution object identifier in the task column.

3. The method according to claim 2, wherein the generating the task cancel result corresponding to the execution object identifier according to at least one of the task cancel records corresponding to the execution object identifier in the collection table includes:

acquiring a statistical index corresponding to the collection table;

4. A method according to any one of claims 1 to 3, wherein prior to receiving a task cancellation request, the method comprises:

acquiring paste contents in the online form;

in response to that the paste content contains a preset identifier and the paste content contains object information of at least one task execution object in the instant messaging application, dividing the object information into columns to obtain a column content, wherein the object information comprises an object identifier, the preset identifier is used for representing that the paste content comes from the instant messaging application, and the column content is used for setting the object column;

sending a token allocation request to an instant messaging server, wherein the token allocation request comprises the object information and the preset identification, and the instant messaging server is used for allocating tokens to the task execution objects after recognizing the preset identification;

and receiving the token sent by the instant messaging server, and performing associated storage on the token and the object information.

5. The method of claim 4, wherein the online table further comprises a reminder column;

the method further comprises the following steps:

determining a reminding time and a task column corresponding to the reminding column;

and in response to the reminding moment is reached and the cell corresponding to the target execution object identifier in the task list does not contain the task verification result, sending reminding information to the instant messaging server, wherein the reminding information contains the target execution object identifier and the token, and the instant messaging server is used for sending reminding information to the target task execution object indicated by the target execution object identifier when the token passes the verification.

6. The method of claim 4, wherein the online table further comprises a notification column;

the method further comprises the following steps:

determining notification time and notification content corresponding to the notification column;

and in response to the notification moment, sending communication information to the instant messaging server, wherein the notification information comprises the execution object identifier, the token and the notification content, and the instant messaging server is used for sending the notification content to the task execution object indicated by the execution object identifier when the token is verified.

7. A method of table generation, the method comprising:

creating an online form;

8. The method of claim 7, wherein the receiving a task setting operation on the online table, setting a task column corresponding to the object column in the online table, and generating a collection table corresponding to the task column comprises:

in response to receiving a selected operation on a target column in the online table, displaying at least one task option;

responding to the selection operation of a target task option, and displaying a task setting interface corresponding to the target task option, wherein the task setting interface is used for setting and collecting task information of a task;

and responding to a setting completion signal in the target task setting interface, setting the target column as the task column, and generating the collection table according to the task information set in the task setting interface.

9. The method of claim 7 or 8, wherein receiving an object setup operation on the online table, setting up an object column in the online table, comprises:

receiving a paste signal;

sending paste content to a document server according to the paste signal, wherein the document server is used for sorting the object information to obtain sorted content when the paste content is identified to contain the object information and a preset identifier of at least one task execution object in the instant messaging application, and the preset identifier is used for representing that the paste content comes from the instant messaging application;

receiving the listed contents sent by the document server;

and setting the object column in the online table according to the column content.

10. The method according to claim 7 or 8, wherein after receiving a task setting operation on the online table, setting a task column corresponding to the object column in the online table, and generating a collection table corresponding to the task column, the method comprises:

receiving a reminding setting operation on the online form, and displaying a reminding setting interface, wherein the reminding setting interface is used for setting reminding time and a task column to be reminded;

and responding to a setting completion signal in the reminding setting interface, setting a column for reminding setting operation action as the reminding column, wherein the reminding column is used for triggering that reminding information is sent to an instant messaging server through a document server when the reminding moment is reached and a cell corresponding to a target execution object identifier in the task column does not contain the task verification result, the reminding information comprises the target execution object identifier and a token, the instant messaging server is used for sending a reminding message to the target task execution object indicated by the target execution object identifier when the token passes verification, and the token is distributed by the instant messaging server.

11. A form-based task verification apparatus, the apparatus comprising:

12. A form generation apparatus, the apparatus comprising:

a creation module for creating an online form;

13. A server, comprising a processor and a memory, wherein the memory has stored therein at least one instruction, at least one program, set of codes, or set of instructions, which is loaded and executed by the processor to implement a table-based task underwriting method according to any one of claims 1 to 6.

14. A terminal, characterized in that it comprises a processor and a memory in which at least one instruction, at least one program, set of codes or set of instructions is stored, which is loaded and executed by the processor to implement a table generation method according to any one of claims 7 to 10.

15. A computer readable storage medium having stored therein at least one instruction, at least one program, a set of codes, or a set of instructions, which is loaded and executed by a processor to implement a table-based task orchestration method according to any one of claims 1-6, or a table generation method according to any one of claims 7-10.