Processing method and device for workflow in table, electronic equipment and storage medium

Abstract

The embodiment of the invention provides an in-table workflow processing method and device, electronic equipment and a storage medium, a target table item is displayed in an electronic table, and the target table item comprises at least one piece of table data; in response to the first operation instruction, a first task flow corresponding to the table workflow is created in the target table item, the first task flow comprises at least two orderly executed task nodes, and the task nodes bind table data of at least one item in the target table item; the task node is used for executing a table function for forming a table workflow based on the table data; and triggering the first task flow to execute the table workflow. According to the method, the corresponding table function is realized through the task node flexibly bound with the table data in the table item, and the task flow corresponding to the table workflow is constructed and triggered, so that the execution of the table workflow is realized, the dynamic association of the table workflow and the table data is realized, and the creation and execution efficiency of the table workflow is improved.

Description

Technical Field

[0001] The embodiments of the present disclosure relate to the field of Internet technology, and in particular, to a method, device, electronic device, and storage medium for processing a workflow within a table. Background Art

[0002] Currently, in data and business management applications, users can create data tables to store tabular data. At the same time, they can also create workflows to automatically trigger table functions, thereby improving business management efficiency.

[0003] However, in the process of creating and executing workflows within an application, the solutions in the prior art have problems such as a complicated workflow creation process and an inability to flexibly adjust the workflow after it is generated, which affects the interaction efficiency and execution efficiency of the application. Summary of the invention

[0004] The embodiments of the present disclosure provide a task execution method, device, electronic device and storage medium to overcome the problems of complex operation process and inability to flexibly adjust table functions after they are generated.

[0005] In a first aspect, an embodiment of the present disclosure provides a method for processing a workflow in a table, including:

[0006] A target table item is displayed in a project operation area of ​​a spreadsheet, wherein the target table item contains at least one item of table data; in response to a first operation instruction, a first task flow corresponding to a table workflow is created in the target table item, wherein the first task flow includes at least two task nodes that are executed in order, wherein the task nodes are bound to at least one item of table data in the target table item, and wherein the task nodes are used to execute table functions constituting the table workflow based on the table data; and the first task flow is triggered to execute the table workflow.

[0007] In a second aspect, an embodiment of the present disclosure provides a device for processing a workflow in a table, including:

[0008] A display module, used for displaying a target table item in an item operation area of ​​an electronic table, wherein the target table item includes at least one item of table data;

[0009] a processing module, configured to create a first task flow in the target table item in response to a first operation instruction, wherein the first task flow includes at least two task nodes that are executed in order, wherein the task nodes are bound to at least one table data item in the target table item, and wherein the task nodes are configured to execute a corresponding table function based on the table data;

[0010] An execution module is used to trigger the first task flow to execute the form workflow.

[0011] In a third aspect, an embodiment of the present disclosure provides an electronic device, including: a processor and a memory;

[0012] The memory stores computer-executable instructions;

[0013] The processor executes the computer-executable instructions stored in the memory, so that the at least one processor executes the method for processing the workflow in the table as described in the first aspect and various possible designs of the first aspect.

[0014] In a fourth aspect, an embodiment of the present disclosure provides a computer-readable storage medium, in which computer execution instructions are stored. When a processor executes the computer execution instructions, a method for processing a workflow within a table as described in the first aspect and various possible designs of the first aspect is implemented.

[0015] In a fifth aspect, an embodiment of the present disclosure provides a computer program product, including a computer program, which, when executed by a processor, implements the method for processing the workflow in a table as described in the first aspect and various possible designs of the first aspect.

[0016] The processing method, device, electronic device and storage medium of the workflow in a table provided in the present embodiment are as follows: by displaying a target table item in the project operation area of ​​an electronic table, wherein the target table item contains at least one table data; in response to a first operation instruction, creating a first task flow corresponding to the table workflow in the target table item, wherein the first task flow includes at least two task nodes executed in order, wherein the task nodes are bound to at least one table data in the target table item, and the task nodes are used to execute the table functions constituting the table workflow based on the table data; and triggering the first task flow to execute the table workflow. By decomposing the table workflow into multiple table functions, and realizing the corresponding table functions through task nodes flexibly bound to the table data in the table item, and then constructing the task flow corresponding to the table workflow, and then realizing the execution of the table workflow by triggering the task flow, the dynamic association between the table workflow and the table data is realized, the creation and execution efficiency of the table workflow is improved, and the cost of adjusting the workflow in the later stage is reduced, thereby improving the interaction efficiency and execution efficiency of the application. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the embodiments of the present disclosure or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present disclosure. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0018] Figure 1 A schematic diagram of an application scenario for creating a workflow in the prior art provided in an embodiment of the present disclosure;

[0019] Figure 2 A flowchart of a method for processing a workflow in a table provided in an embodiment of the present disclosure Figure 1 ;

[0020] Figure 3 A schematic diagram of an application interface of an electronic spreadsheet provided in an embodiment of the present disclosure;

[0021] Figure 4 for Figure 2 A flowchart of a specific implementation method of step S102 in the illustrated embodiment;

[0022] Figure 5 A schematic diagram of a process for generating a first task flow provided by an embodiment of the present disclosure;

[0023] Figure 6 A schematic diagram of a first task flow provided by an embodiment of the present disclosure;

[0024] Figure 7 A schematic diagram of another first task flow provided by an embodiment of the present disclosure;

[0025] Figure 8 A flowchart of a method for processing a workflow in a table provided in an embodiment of the present disclosure Figure 2 ;

[0026] Fig. 9 A schematic diagram of another process of creating a first task flow provided by an embodiment of the present disclosure;

[0027] Fig.10 for Figure 8 A flowchart of a specific implementation method of step S206 in the illustrated embodiment;

[0028] Fig.11 A structural block diagram of a device for processing a workflow in a table provided in an embodiment of the present disclosure;

[0029] Fig.12 A schematic diagram of the structure of an electronic device provided in an embodiment of the present disclosure;

[0030] Fig.13A schematic diagram of the hardware structure of an electronic device provided in an embodiment of the present disclosure. DETAILED DESCRIPTION

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

[0032] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this disclosure are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with the relevant laws, regulations and standards of relevant countries and regions, and provide corresponding operation entrances for users to choose to authorize or refuse.

[0033] The application scenarios of the embodiments of the present disclosure are explained below:

[0034] Figure 1 A schematic diagram of an application scenario for creating a workflow in the prior art provided by an embodiment of the present disclosure. The method for processing a workflow in a table provided by an embodiment of the present disclosure can be applied to an application (APP, Application) with data and business management functions, such as a project management application, an electronic document application, etc. More specifically, it can be applied to an application scenario in which a workflow is created within an application. The execution subject of this embodiment can be a terminal device that runs the above-mentioned application with data and business management functions, or a server that deploys the server corresponding to the above-mentioned application, or other electronic devices that perform similar functions. Among them, when the execution subject is a server, the server of the above-mentioned application with data and business management functions runs on the server, and executes the method provided by this embodiment on the server side, while the terminal device runs the client of the application, and the communication between the server and the terminal device is based on the server-client, so that the terminal device can obtain the execution result of the method provided in this embodiment and display it as needed.

[0035] Among them, in some embodiments, the terminal device or server can implement the processing method of the workflow in the table provided in the embodiment of the present application by running various computer executable instructions or computer programs. For example, the computer executable instructions can be program-level commands, machine instructions or software instructions. The computer program can be a native program or software module in the operating system; it can be a local application, that is, a program that needs to be installed in the operating system to run, or it can be a small program embedded in any APP, that is, a program running based on a browser environment. In summary, the above-mentioned computer executable instructions can be instructions in any form, and the above-mentioned computer program can be an application, module or plug-in in any form, and the specific implementation form can be configured as needed. Further, in some embodiments, the server can be an independent physical server, or a server cluster or distributed system composed of multiple physical servers, or a cloud server that provides cloud services, cloud storage, cloud communication, cloud database, cloud computing, cloud functions, network services, middleware services, domain name services, security services, content delivery networks (Content Delivery Network, CDN), and big data and artificial intelligence platforms and other basic cloud computing services, wherein the cloud service can be an interactive processing service for terminal devices to call.

[0036] refer to Figure 1 As shown in , taking a terminal device (such as a personal computer) as an example, after the terminal device runs the spreadsheet, a specific business interface, such as a data interface, is displayed. The data interface, for example, displays specific table data (such as table data D1, table data D2, table data D3, etc.) in a table form to achieve basic data management functions. On this basis, the spreadsheet also provides a process component for creating a workflow. When the user clicks on the process component, it jumps to the workflow interface. In the workflow interface, a workflow containing multiple work nodes can be created, such as the workflow Workflow_1 containing work nodes P1, work nodes P2 and work nodes P3 as shown in the figure. At the same time, in the workflow interface, existing workflows (such as workflows Workflow_2, Workflow_3, etc.) can also be displayed. The created workflow is then saved in the spreadsheet, and the corresponding workflow is automatically executed by triggering the workflow.

[0037] In the prior art, during the creation of the above-mentioned workflow, there is no correlation between the created workflow and the table data, that is, each work node in the workflow does not use the table data, or the work node is constructed by statically inputting information into the work node. In this case, on the one hand, since the work node of the workflow needs to contain additional data and information, the creation process of the workflow is complicated, the data volume is large, and the execution efficiency is low; on the other hand, when the workflow needs to be modified, the data and information contained in the work node need to be modified one by one, resulting in an increase in the adjustment cost of the workflow, thereby affecting the interaction efficiency and execution efficiency of the application.

[0038] The embodiments of the present disclosure provide a method, device, electronic device and storage medium for processing a workflow in a table to solve the above problems.

[0039] refer to Figure 2 , Figure 2 A flowchart of a method for processing a workflow in a table provided in an embodiment of the present disclosure Figure 1 The method of this embodiment can be applied in a terminal device or a server. The method for processing the workflow in the table includes:

[0040] Step S101: displaying a target table item in an item operation area of ​​an electronic table, wherein the target table item includes at least one item of table data.

[0041] Step S102: In response to the first operation instruction, a first task flow corresponding to the table workflow is created in the target table item, the first task flow includes at least two task nodes that are executed in order, the task nodes are bound to at least one item of table data in the target table item, and the task nodes are used to execute table functions that constitute the table workflow based on the table data.

[0042] Exemplarily, this embodiment is introduced by taking the case where the terminal device is used as the execution subject as an example. Specifically, an electronic spreadsheet program is run in the terminal device, and the electronic spreadsheet program is, for example, an application program with data and business management functions referred to in the above scenario introduction. After that, specific table items are displayed in the electronic spreadsheet, including the target table items to be processed. Further, the display of the target table items in the steps of this embodiment means displaying the identification of the target table items, for example, the name or icon of the target table items. For the specific implementation of displaying the table items, for example, it includes: displaying "A table item", "B table item", or "A business management item", "B business follow-up item" and other contents in the electronic spreadsheet. Among them, the target table item contains at least one table data, which is data related to the target table item, and can be business-related data bound in the process of creating the target table item, such as sales data, material management data, personnel information data, etc. Exemplarily, in the process of displaying the target table item, the content of the table data corresponding to the target table item or the name of the table data will be displayed at the same time.

[0043] In a possible implementation, the target table item is displayed in the form of a multi-level directory, and the table data corresponding to the target table item is contained in the subordinate directories of the target table item. Of course, in other possible implementations, the target table item can also be displayed in other forms, for example, in the form of a tree diagram, the project name of the target table item is the root node in the tree diagram, and the corresponding table data is the leaf node in the tree diagram, etc. The display method of the target table item in the electronic form can be designed as needed, and no specific restrictions are made at this time.

[0044] Furthermore, after the target table item is displayed in the electronic form, the user can create an automatically executable table workflow for the target table item by applying a creation operation in the electronic form, wherein the table workflow may include multiple work steps, such as data processing steps, information push steps, and the like. Specifically, after receiving the first operation instruction generated based on the above creation operation, the terminal device will create a task flow for implementing the table workflow in the target table item, namely, a first task flow, wherein the first task flow is a data body for implementing the table workflow, and after the first task flow is generated, the first task flow is displayed in the electronic form. Among them, the first task flow includes at least two task nodes that are executed in order, and the task node is bound to at least one table data in the target table item, and the task node is used to execute the table function constituting the table workflow based on the table data. Among them, the table data is data related to the target table item, and is logically stored in the target table item, which has been introduced in the previous part and will not be repeated here. The task node is bound to at least one table data item in the target table item, which means that the task node in the first task flow maps a specific table data item and uses the bound table data to perform a corresponding table function, which is a task performed by calling a function in the electronic form, such as data search, message push, etc. In specific implementation, the task node is bound to at least one table data item in the target table item, which can be determined by the appearance of the task node in the first task flow, for example, the bound table data is displayed in the icon corresponding to the task node.

[0045] Furthermore, in a possible implementation, the target table item has a first subdirectory and a second subdirectory, the directory items of the first subdirectory are used to represent the table data, and the directory items of the second subdirectory are used to represent the task flow; the identifier of the first task flow is the directory item of the second subdirectory. Figure 3 A schematic diagram of an application interface of an electronic spreadsheet provided in an embodiment of the present disclosure, such as Figure 3As shown, exemplarily, in the project management interface in the electronic form, a project operation area is set on the left side (exemplarily), and table projects are loaded in the project operation area, such as project A, project B, project C, etc. shown in the figure. Among them, project B is, for example, a target table project, and under project B, two types of subdirectories can be included, namely, a first subdirectory and a second subdirectory, for example, as shown in the figure, data table #1 and data table #2 are both directory items belonging to the first subdirectory; after responding to the first operation instruction for the project B, under project B, the identification of the task flow L1 is created, and the task flow L_1 is a directory item belonging to the second subdirectory, that is, the identification of the first task flow. In one possible case, for example, under project B, an existing second subdirectory may be included. After responding to the first operation instruction for project B, the terminal device adds a task flow identifier, i.e., the identifier of the first task flow, in the second subdirectory of project B. At this time, the second subdirectory contains at least two task flow identifiers. In another possible case, for example, under project B, the second subdirectory is not initially included. After responding to the first operation instruction for project B, the terminal device adds a second subdirectory under project B, and the second subdirectory includes a task flow identifier, i.e., the identifier of the first task flow. In an exemplary manner, the first subdirectory and the second subdirectory under the table item can be distinguished by corresponding icons. For example, directory items such as data table #1 and data table #2 under project B correspond to one icon (represented by a square icon in the figure), and directory items such as task flow L0 and task flow L1 under project B correspond to another icon (represented by a circular icon in the figure).

[0046] Furthermore, if Figure 4 As shown, illustratively, the specific implementation of step S102 includes:

[0047] Step S1021: in response to the first operation instruction, at least one upstream task node is created in the electronic form, and table data corresponding to the upstream task node is configured;

[0048] Step S1022: automatically generating a downstream task node of the upstream task node according to the table function executed by the upstream task node and the corresponding table data;

[0049] Step S1023: Generate a first task flow according to the upstream task node and the downstream task node.

[0050] Figure 5 A schematic diagram of a process for generating a first task flow provided by an embodiment of the present disclosure is shown below in conjunction with Figure 5 The above process is introduced, for example, with reference to Figure 3The schematic diagram of the application interface shown in the figure, first, after triggering the creation process of the first task flow L0, in the electronic form (for example, in the project management interface, the task flow editing area on the right), add the icon corresponding to the task node, such as the task node P1 shown in the figure, that is, the upstream task node, which can be automatically added or manually added without restriction; then, the user can edit the above task node to determine its specific functional logic (for example, add functional logic Log_1), and then configure the table data corresponding to the upstream task node, the table data corresponding to the upstream task node is the table data under the target table item, for example, bind data table #1 (manually configure) to the task node P1. After the functional logic and corresponding table data of the upstream task node are configured, the configuration process of the upstream task node is completed, and then, the terminal device automatically generates at least one downstream task node, such as task node P2, according to the table function and corresponding table data executed by the upstream task node. Task node P2 is the task node to be executed after the task node P1 is executed. More specifically, for example, according to the functional logic and table data of task node P1, task node P1 is used to execute the table function of calling specific high-authority data. Then, according to the preset task node automatic generation model, a task node P2 is automatically generated after task node P1, and task node P2 is used to execute the table function of sending an approval request to a specific high-authority user. The above-mentioned mapping logic of automatically executing the table function corresponding to task node P2 after the table function corresponding to task node P1 is stored in the task node automatic generation model. The task node automatic generation model also includes the mapping logic of other continuously executed table functions, which are specifically set according to needs and will not be repeated here. Afterwards, the user can further add downstream adjacent task nodes of task node P1 or task node P2 as needed, and configure them, and so on, until all task nodes are created. Finally, all task nodes including the above-mentioned upstream task nodes and downstream task nodes are generated to generate the first task flow.

[0051] In the steps of this embodiment, a solution is provided for automatically generating task nodes to construct a first task flow, by automatically generating downstream task nodes for the configured task nodes according to their functional logic and configuration data, thereby improving the generation efficiency of the first task flow.

[0052] Step S103: triggering the first task flow to execute the form workflow.

[0053] Furthermore, after the first task flow is created, the first task flow is displayed in the electronic form. The first task flow describes the specific execution steps of the form workflow through multiple task nodes that are executed in sequence. On this basis, the user can further modify and adjust the first task flow as needed. Afterwards, the first task flow is triggered to execute the corresponding form workflow. Figure 6 A schematic diagram of a first task flow provided by an embodiment of the present disclosure is shown as follows: Figure 6 As shown, the first task flow includes 4 task nodes that are executed in order, namely, task node P1, task node P2, task node P3 and task node P4, wherein task node P1 is bound to data table #1, task node P2 is bound to data table #2, and task node P3 and task node P4 are all bound to data table #3. According to the table workflow described by the first task flow, after the first task flow is triggered, task node P1 is first executed, and task node P1 uses data table #1 to perform corresponding table functions, such as the average value of the Value_1 column in the statistical data table #1. Afterwards, task node P2 is executed, and task node P2 uses data table #2 to perform corresponding table functions, and then, task nodes P3 and P4 are executed. The specific execution process is similar and will not be repeated. After task nodes P3 and P4 are executed, the first task flow is executed, and accordingly, the automatic execution of the table workflow is realized.

[0054] Furthermore, in a possible implementation, the task node includes a function node and a logic node, the function node is used to characterize the content of the executed table function, the adjacent downstream of the logic node is connected to at least two function nodes, and the logic node is used to characterize the selection strategy of the adjacent downstream function node. Among them, the function node is a node used to execute a specific table function, and the logic node is a node used to execute logical judgment. The first task flow composed of the combination of the function node and the logic node can realize a more complex workflow logic. Exemplarily, the function node contains execution information, and the execution information is used to characterize at least one of the following: the execution time of the function node, the table data corresponding to the function node, and the modification time of the function node.

[0055] Figure 7 A schematic diagram of another first task flow provided by an embodiment of the present disclosure, such as Figure 7As shown, the first task flow includes 1 root task node P0 and 4 task nodes that are executed in order, and the task nodes are respectively functional node P1, logical node P2, logical node P3 and functional node P4, wherein task node P1 and task node P3 are bound to data table #1, task node P2 is bound to data table #2, and task node P4 is bound to data table #3. According to the table workflow described by the first task flow, after the first task flow is triggered, the root task node P0 is first executed, wherein the root task node P0 is used to characterize the triggering condition of the first task flow, for example, the triggering condition characterized by the root task node P0 is: "daily 12:00 scheduled trigger" (shown as T=12:00 in the figure?). That is, when the terminal device detects that the system time is 12:00, the task node in the first task flow will be executed. Afterwards, when the root task node meets the trigger condition, according to the structure of the first task flow, the function node P1 is first executed. The function node P1 is used to use the data table #1 to perform the corresponding table function, such as calculating the average value of value_1 in the data table #1 to obtain mean_1; then, the logic node P2 is executed. The logic node P2 is used to judge the output mean_1 of the function node P1 based on a certain phase value in the data table #2 as the judgment threshold threshold_1 (shown as mean_1>threshold_1? in the figure). If mean_1 is greater than the judgment threshold threshold_1, the function node P3 is executed; or if mean_1 is less than or equal to the judgment threshold threshold_1, the function node P4 is executed. Afterwards, illustratively, the function node P3 is used to calculate the average value mean_2 of value_2 in the data table #1 based on the data table #1; the function node P4 is used to send prompt information to a specific user based on the data table #3. Through the first task flow composed of the function nodes and the logic nodes, a more complex workflow logic can be implemented, so that the workflow reaches a higher degree of automation.

[0056] In this embodiment, by displaying a target table item in an electronic form, the target table item contains at least one table data; in response to a first operation instruction, a first task flow corresponding to the table workflow is created in the target table item, the first task flow includes at least two task nodes executed in order, the task node is bound to at least one table data in the target table item, and the task node is used to execute the table function constituting the table workflow based on the table data; the first task flow is triggered to execute the table workflow. By decomposing the table workflow into multiple table functions, and implementing the corresponding table function through the task nodes flexibly bound to the table data in the table item, and then constructing the task flow corresponding to the table workflow, and then implementing the execution of the table workflow by triggering the task flow, the dynamic association of the table workflow and the table data is realized, the creation and execution efficiency of the table workflow is improved, and the cost of adjusting the workflow in the later stage is reduced, thereby improving the interaction efficiency and execution efficiency of the application.

[0057] refer to Figure 8 , Figure 8 A flowchart of a method for processing a workflow in a table provided in an embodiment of the present disclosure Figure 2 In this embodiment Figure 2 On the basis of the illustrated embodiment, steps S102 and S103 are further refined, and the method for processing the workflow in the table includes:

[0058] Step S201: displaying a target table item in the item operation area of ​​the electronic table, wherein the target table item includes at least one item of table data;

[0059] Step S202: In response to the second operation instruction, an associated task flow is created in the target table item, wherein the associated task flow includes at least two subtask nodes that are executed in order, and the subtask node is used to execute at least one execution step of the table function.

[0060] For example, reference Figure 3The schematic diagram of the application interface of the electronic form shown in the electronic form, in the project management interface of the electronic form, a target table project can be loaded in the project operation area, on this basis, through the second operation instruction, an associated task flow can be created in the target table project, and the associated task flow can be regarded as a task flow called by the first task flow, which is essentially a data body similar to the first task flow. For example, when the first task flow is used to implement an objective function, the associated task flow is used to implement the sub-function in the above-mentioned objective function. Specifically, when the table function performed by the task node in the first task flow is composed of multiple execution steps, the associated task flow can be bound to the task node in the first task flow, so that the task node in the first task flow can implement a more complex table function. And at least two sub-task nodes that are executed in order in the associated task flow are used to execute at least one execution step of the table function.

[0061] Among them, the creation process of the associated task flow is similar to that of the first task flow, for example, gradually adding execution steps and setting the execution logic of the execution steps. Optionally, the creation step of the associated task flow also includes: binding the corresponding table data to the associated task flow. Thereby, the execution steps in the associated task flow are executed based on the bound table data. The specific creation process of the associated task flow can be understood by referring to the creation process of the first task flow, which will not be repeated here.

[0062] Further, exemplarily, since the created associated task flow is also a task flow, it can be marked with the same icon as the first task flow. Of course, the two can also be distinguished by different icons, which can be set as needed and will not be repeated here.

[0063] Step S203: In response to the first operation instruction, based on the associated task flow and the table data, a first task flow corresponding to the table workflow is created in the target table item and displayed.

[0064] Exemplarily, thereafter, in response to the first operation instruction, a first task flow corresponding to the table workflow is created based on the associated task flow and the table data, and the creation process and the creation result are displayed in the electronic form. Fig. 9 Another process diagram of creating a first task flow provided by the embodiment of the present disclosure is as follows: Fig. 9 For an introduction to the creation process of the first task flow, refer to Figure 5As shown, first, after triggering the creation process of the first task flow L1, in the electronic form (for example, in the task flow editing area on the right side of the project management interface), add the icon corresponding to the task node, such as the task node P1 and task node P2 shown in the figure, and edit the above task nodes to determine their specific functions, such as setting the task node as a functional node or a logical node, and setting a specific function implementation method or a logical judgment method, and then, it can be bound to the table data in the target table item, so as to complete the configuration of the task node, for example, for task node P1, manually configure the functional logic Log_1 and data table #1, and complete the configuration process of task node P1. On the other hand, it is also possible to directly bind the associated task flow in the target table item to the task node, so as to complete the configuration of the task node, for example, for task node P2, manually configure the generated task flow L0 (associated task flow) to task node P2, so that task node P2 executes the steps corresponding to task flow L0. Afterwards, optionally, the terminal device can add downstream adjacent nodes to any of the above-mentioned task nodes through automatic generation or manual configuration, thereby expanding the workflow. For the manual configuration method, for example, click the "+" icon shown in the figure to add a downstream task node P3 to the task node P2, and then configure the task node P3 based on the above method until the construction of the first task flow is completed.

[0065] Step S204: displaying a table data page, where the table data page is used to display target table data bound to the task node.

[0066] Exemplarily, on the other hand, for the tabular data used in the first task flow, in one possible implementation method, the table data page can be displayed in the spreadsheet by triggering the directory item in the first subdirectory under the target table item, such as clicking on a specific table data name. Based on the specific data format of the target table data, the table data page may include, for example, data tables, text strings and other contents, that is, the contents of the target table data.

[0067] In another possible implementation, the specific implementation of displaying the table data page includes: in response to the fourth operation instruction for the target task node in the first task flow, displaying the table data page of the target task node. Fig. 9For the first task flow shown, after the first task flow is constructed (or during the construction process), the terminal device can display the table data page of the target table data bound to the task node by responding to the fourth operation instruction input by the user, such as the operation instruction for the task node. The content of the table data page is consistent with the content of the table data page introduced above, and will not be repeated. In this way, the table data used by the task node can be quickly located, displayed, and modified, thereby improving the interactive efficiency of constructing and adjusting the first task flow.

[0068] Step S205: in response to the third operation instruction for the table data page, modify the target table data to obtain modified target table data;

[0069] Step S206: Based on the modified target table data, the first task flow is updated to obtain a second task flow.

[0070] Exemplarily, further, after expanding the table data page, the user can further modify the target table data in the table data page by inputting a third operation instruction to obtain the modified target table data. Afterwards, in some possible implementations, since the downstream task node is generated based on the table data of the upstream task node, after the target table data corresponding to the upstream task node changes, the terminal device will automatically modify the first task flow according to the modified target table data to obtain an automatically synchronized second task flow, thereby completing the dynamic update of the first task flow. Among them, in one possible implementation, in the updated second task flow, at least one new task node is added compared to the first task flow, or at least one task node is reduced compared to the first task flow.

[0071] For example, Fig.10 As shown, the specific implementation of step S206 includes:

[0072] Step S2061: based on the modified target table data, updating the downstream task node of the target task node in the first task flow to obtain an updated downstream task node;

[0073] Step S2062: Generate a second task flow based on the updated downstream task node.

[0074] Exemplarily, first, after the target table data is modified, based on the modified target table data and the functional logic of the target task node, the task node automatic generation model is queried to determine the corresponding table function that needs to be executed continuously. Then, based on the table function, the downstream task node of the target task node is updated. Specifically, for example, it includes generating a new downstream task node; or deleting the original downstream task node, or adjusting the table data corresponding to the downstream task node, that is, obtaining an updated downstream task node. Then, based on the updated downstream task node, a second task flow is generated, that is, the updated first task flow.

[0075] In the steps of this embodiment, after updating the target table data, the terminal device automatically updates the downstream task nodes of the target task node according to the binding relationship between the target table data and the task node, thereby realizing automatic update of the first task flow without the need for manual synchronization adjustment by the user, thereby realizing dynamic binding and linkage between the table data and the task flow and improving interaction efficiency.

[0076] Optionally, this embodiment also includes:

[0077] Step S207: receiving modification instructions sent by at least two target users, and modifying the task nodes in the first task flow;

[0078] Step S208: Displaying the user ID corresponding to each target user in the task node.

[0079] Exemplarily, after the first task flow is created (or in the process of being created), the solution provided in this embodiment can realize the synchronous modification of multiple people, that is, the data corresponding to the first task flow is stored in the cloud, and the modification instructions sent by multiple target users are received through the cloud to modify the first task flow, for example, the functional logic of the task nodes in the first task flow, the table data bound to the task nodes, and the upstream and downstream connection relationships between task nodes, etc. are modified. At the same time, after the first task flow is modified, the terminal device side will display the corresponding modification mark, that is, the user ID corresponding to the target user, thereby marking the modifying user who modified the above task section, further improving the creation and modification efficiency of the task flow, and the interaction efficiency between multiple users of the electronic spreadsheet.

[0080] In this embodiment, the implementation method of step S201 is the same as that of the present disclosure. Figure 2 The implementation method of step S101 in the illustrated embodiment is the same and will not be described in detail here.

[0081] Corresponding to the processing method of the workflow in the table of the above embodiment, Fig.11A block diagram of a processing device for a workflow in a table provided in an embodiment of the present disclosure. The method described in the above embodiment can be executed by the processing device for the workflow in the table, which can be implemented by software and / or hardware, and can be integrated in an electronic device with certain data processing functions. The electronic device can include but is not limited to a mobile terminal with big data processing capabilities, and a fixed terminal with big data processing capabilities such as a desktop computer and a supercomputer.

[0082] For the sake of convenience, only the parts related to the embodiments of the present disclosure are shown. Fig.11 , the processing device 3 of the workflow in the table includes:

[0083] A display module 31 is used to display a target table item in an electronic table, wherein the target table item includes at least one table data;

[0084] A processing module 32, configured to create a first task flow corresponding to the table workflow in the target table item in response to the first operation instruction, wherein the first task flow includes at least two task nodes that are executed in order, the task nodes are bound to at least one table data item in the target table item, and the task nodes are used to execute table functions constituting the table workflow based on the table data;

[0085] The execution module 33 is used to trigger the first task flow to execute the form workflow.

[0086] According to one or more embodiments of the present disclosure, the target table item has a first subdirectory and a second subdirectory, the directory items of the first subdirectory are used to represent the table data, the directory items of the second subdirectory are used to represent the task flow, and the identifier of the first task flow is the directory items of the second subdirectory.

[0087] According to one or more embodiments of the present disclosure, the processing module 32 is specifically used to: create at least one upstream task node in a spreadsheet in response to a first operation instruction, and configure the table data corresponding to the upstream task node; automatically generate a downstream task node of the upstream task node according to the table function performed by the upstream task node and the corresponding table data; generate a first task flow according to the upstream task node and the downstream task node.

[0088] According to one or more embodiments of the present disclosure, a task node includes a function node and a logic node, the function node is used to characterize the content of the executed table function, the adjacent downstream of the logic node is connected to at least two function nodes, and the logic node is used to characterize the selection strategy of the adjacent downstream function node.

[0089] According to one or more embodiments of the present disclosure, the function node contains execution information, and the execution information is used to represent at least one of the following: the execution time of the function node, the table data corresponding to the function node, and the modification time of the function node.

[0090] According to one or more embodiments of the present disclosure, the table workflow includes a target table function consisting of multiple execution steps, and the execution module 33 is specifically used to: obtain an associated task flow by executing the target function node in the first task flow, the associated task flow includes at least two ordered executed sub-task nodes, and the sub-task node is used to execute at least one execution step of the table function; trigger the associated task flow to execute the target table function.

[0091] According to one or more embodiments of the present disclosure, the processing module 32 is further used to: create an associated task flow in the target table item in response to the second operation instruction, and / or bind the corresponding table data to the associated task flow.

[0092] According to one or more embodiments of the present disclosure, the display module 31 is also used to: display a table data page, where the table data page is used to display target table data bound to the task node; the processing module 32 is also used to: modify the target table data in response to a third operation instruction on the table data page to obtain modified target table data; and update the first task flow based on the modified target table data to obtain a second task flow.

[0093] According to one or more embodiments of the present disclosure, the display module 31 is also used to: display the first task flow; when the display module 31 displays the table data page, it is specifically used to: display the table data page of the target task node in response to the fourth operation instruction for the target task node in the first task flow; when the processing module 32 updates the first task flow based on the modified target table data to obtain the second task flow, it is specifically used to: update the downstream task node of the target task node in the first task flow based on the modified target table data to obtain an updated downstream task node; and generate the second task flow based on the updated downstream task node.

[0094] According to one or more embodiments of the present disclosure, the processing module 32 is further used to: receive modification instructions sent by at least two target users to modify the task nodes in the first task flow; the display module 31 is further used to: display the user identification corresponding to each target user in the task node.

[0095] According to one or more embodiments of the present disclosure, the first task flow includes at least one root task node, and the root task node is used to characterize the triggering condition of the first task flow; the execution module 33 is specifically used to: when the root task node meets the triggering condition, execute the downstream task nodes of the root task node in sequence to execute the table workflow.

[0096] The display module 31, the processing module 32 and the execution module 33 are connected in sequence. The processing device 3 for the workflow in the table provided in this embodiment can execute the technical solution of the above method embodiment, and its implementation principle and technical effect are similar, which will not be repeated in this embodiment.

[0097] Fig.12 A schematic diagram of the structure of an electronic device provided by an embodiment of the present disclosure is shown in FIG. Fig.12 As shown, the electronic device 4 includes:

[0098] A processor 41, and a memory 42 communicatively connected to the processor 41;

[0099] The memory 42 stores computer executable instructions;

[0100] The processor 41 executes the computer execution instructions stored in the memory 42 to implement the following Figure 2-Figure 10 The method for processing the workflow in a table in the illustrated embodiment.

[0101] Optionally, the processor 41 and the memory 42 are connected via a bus 43 .

[0102] For related instructions, please refer to Figure 2-Figure 10 The relevant descriptions and effects corresponding to the steps in the corresponding embodiments can be understood, and no further elaboration is made here.

[0103] The present invention provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer-executable instructions, which are used to implement the present invention when executed by a processor. Figure 2-Figure 10 A method for processing a workflow in a table provided in any one of the corresponding embodiments.

[0104] The present invention provides a computer program product, including a computer program. When the computer program is executed by a processor, the present invention is realized. Figure 2-Figure 10 A method for processing a workflow in a table provided in any one of the corresponding embodiments.

[0105] In order to implement the above embodiment, the embodiment of the present disclosure also provides an electronic device.

[0106] refer to Fig.13, which shows a schematic diagram of the structure of an electronic device 900 suitable for implementing the embodiment of the present disclosure, and the electronic device 900 may be a terminal device or a server. The terminal device may include but is not limited to mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, personal digital assistants (PDAs), tablet computers (Portable Android Devices, PADs), portable multimedia players (PMPs), vehicle terminals (such as vehicle navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Fig.13 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0107] like Fig.13 As shown, the electronic device 900 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 901, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 902 or a program loaded from a storage device 908 to a random access memory (RAM) 903. In the RAM 903, various programs and data required for the operation of the electronic device 900 are also stored. The processing device 901, the ROM 902, and the RAM 903 are connected to each other via a bus 904. An input / output (I / O) interface 905 is also connected to the bus 904.

[0108] Typically, the following devices may be connected to the I / O interface 905: input devices 906 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; output devices 907 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; storage devices 908 including, for example, a magnetic tape, a hard disk, etc.; and communication devices 909. The communication device 909 may allow the electronic device 900 to communicate with other devices wirelessly or by wire to exchange data. Although Fig.13 The electronic device 900 is shown with various devices, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead.

[0109] In particular, according to an embodiment of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device 909, or installed from a storage device 908, or installed from a ROM 902. When the computer program is executed by the processing device 901, the above-mentioned functions defined in the method of the embodiment of the present disclosure are executed.

[0110] It should be noted that the computer-readable medium disclosed above may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that may be used by or in combination with an instruction execution system, device or device. In the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, in which a computer-readable program code is carried. This propagated data signal may take a variety of forms, including but not limited to an electromagnetic signal, an optical signal, or any suitable combination of the above. The computer readable signal medium may also be any computer readable medium other than a computer readable storage medium, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer readable medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0111] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device.

[0112] The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device executes the method shown in the above embodiment.

[0113] Computer program code for performing the operations of the present disclosure may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as an independent software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0114] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0115] The units or modules involved in the embodiments described in the present disclosure may be implemented by software or hardware, wherein the name of a unit or module does not, in some cases, constitute a limitation on the unit itself.

[0116] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0117] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0118] In a first aspect, according to one or more embodiments of the present disclosure, a method for processing a workflow in a table is provided, comprising:

[0119] A target table item is displayed in a project operation area of ​​a spreadsheet, wherein the target table item contains at least one item of table data; in response to a first operation instruction, a first task flow corresponding to a table workflow is created in the target table item, wherein the first task flow includes at least two task nodes that are executed in order, wherein the task nodes are bound to at least one item of table data in the target table item, and wherein the task nodes are used to execute table functions constituting the table workflow based on the table data; and the first task flow is triggered to execute the table workflow.

[0120] According to one or more embodiments of the present disclosure, the target table item has a first sub-directory and a second sub-directory, the directory items of the first sub-directory are used to represent the table data, the directory items of the second sub-directory are used to represent the task flow, and the identifier of the first task flow is the directory items of the second sub-directory.

[0121] According to one or more embodiments of the present disclosure, the task node includes a function node and a logic node, the function node is used to represent the content of the executed table function, the adjacent downstream of the logic node is connected to at least two of the function nodes, and the logic node is used to represent the selection strategy of the adjacent downstream function node.

[0122] According to one or more embodiments of the present disclosure, the function node contains execution information, and the execution information is used to represent at least one of the following: the execution time of the function node, the table data corresponding to the function node, and the modification time of the function node.

[0123] According to one or more embodiments of the present disclosure, the table workflow includes a target table function consisting of multiple execution steps, and triggering the first task flow to execute the table workflow includes: obtaining an associated task flow by executing the target function node in the first task flow, the associated task flow including at least two orderedly executed sub-task nodes, and the sub-task nodes are used to execute at least one execution step of the table function; triggering the associated task flow to execute the target table function.

[0124] According to one or more embodiments of the present disclosure, the method further includes: in response to a second operation instruction, creating the associated task flow in the target table item, and / or binding corresponding table data to the associated task flow.

[0125] According to one or more embodiments of the present disclosure, the method also includes: displaying a table data page, wherein the table data page is used to display target table data bound to the task node; in response to a third operation instruction for the table data page, modifying the target table data to obtain modified target table data; and based on the modified target table data, updating the first task flow to obtain a second task flow.

[0126] According to one or more embodiments of the present disclosure, the method also includes: displaying the first task flow; the displaying of the table data page includes: in response to a fourth operation instruction for the target task node in the first task flow, displaying the table data page of the target task node; updating the first task flow based on the modified target table data to obtain the second task flow includes: updating the downstream task node of the target task node in the first task flow based on the modified target table data to obtain an updated downstream task node; generating the second task flow based on the updated downstream task node.

[0127] According to one or more embodiments of the present disclosure, the first task flow corresponding to the table workflow is created in the target table item in response to the first operation instruction, including: in response to the first operation instruction, at least one upstream task node is created in the electronic form, and the table data corresponding to the upstream task node is configured; according to the table function performed by the upstream task node and the corresponding table data, a downstream task node of the upstream task node is automatically generated; according to the upstream task node and the downstream task node, the first task flow is generated.

[0128] According to one or more embodiments of the present disclosure, the method further includes: receiving modification instructions sent by at least two target users, modifying the task node in the first task flow; and displaying user identifiers corresponding to each of the target users in the task node.

[0129] According to one or more embodiments of the present disclosure, the first task flow includes at least one root task node, and the root task node is used to characterize the triggering condition of the first task flow; triggering the first task flow to execute the table workflow includes: when the root task node meets the triggering condition, executing the downstream task nodes of the root task node in sequence to execute the table workflow.

[0130] In a second aspect, according to one or more embodiments of the present disclosure, a device for processing a workflow in a table is provided, comprising:

[0131] A display module, used for displaying a target table item in an item operation area of ​​an electronic table, wherein the target table item includes at least one item of table data;

[0132] A processing module, configured to create, in response to a first operation instruction, a first task flow corresponding to a table workflow in the target table item, wherein the first task flow includes at least two task nodes that are executed in order, the task nodes being bound to at least one table data item in the target table item, and the task nodes being configured to execute table functions constituting the table workflow based on the table data;

[0133] An execution module is used to trigger the first task flow to execute the form workflow.

[0134] According to one or more embodiments of the present disclosure, the target table item has a first sub-directory and a second sub-directory, the directory items of the first sub-directory are used to represent the table data, the directory items of the second sub-directory are used to represent the task flow, and the identifier of the first task flow is the directory items of the second sub-directory.

[0135] According to one or more embodiments of the present disclosure, the processing module is specifically used to: create at least one upstream task node in the electronic form in response to a first operation instruction, and configure the table data corresponding to the upstream task node; automatically generate a downstream task node of the upstream task node according to the table function performed by the upstream task node and the corresponding table data; generate the first task flow according to the upstream task node and the downstream task node.

[0136] According to one or more embodiments of the present disclosure, the task node includes a function node and a logic node, the function node is used to represent the content of the executed table function, the adjacent downstream of the logic node is connected to at least two of the function nodes, and the logic node is used to represent the selection strategy of the adjacent downstream function node.

[0137] According to one or more embodiments of the present disclosure, the function node contains execution information, and the execution information is used to represent at least one of the following: the execution time of the function node, the table data corresponding to the function node, and the modification time of the function node.

[0138] According to one or more embodiments of the present disclosure, the table workflow includes a target table function consisting of multiple execution steps, and the execution module is specifically used to: obtain an associated task flow by executing the target function node in the first task flow, the associated task flow includes at least two ordered executed sub-task nodes, and the sub-task nodes are used to execute at least one execution step of the table function; trigger the associated task flow to execute the target table function.

[0139] According to one or more embodiments of the present disclosure, the processing module is further used to: create the associated task flow in the target table item in response to a second operation instruction, and / or bind corresponding table data to the associated task flow.

[0140] According to one or more embodiments of the present disclosure, the display module is further used to: display a table data page, wherein the table data page is used to display the target table data bound to the task node; the processing module is further used to: modify the target table data in response to a third operation instruction for the table data page to obtain modified target table data; and update the first task flow based on the modified target table data to obtain a second task flow.

[0141] According to one or more embodiments of the present disclosure, the display module is also used to: display the first task flow; when the display module displays the table data page, it is specifically used to: display the table data page of the target task node in response to a fourth operation instruction for the target task node in the first task flow; when the processing module updates the first task flow based on the modified target table data to obtain the second task flow, it is specifically used to: update the downstream task node of the target task node in the first task flow based on the modified target table data to obtain an updated downstream task node; and generate the second task flow based on the updated downstream task node.

[0142] According to one or more embodiments of the present disclosure, the processing module is further used to: receive modification instructions sent by at least two target users to modify the task node within the first task flow; the display module is further used to: display the user identifier corresponding to each of the target users within the task node.

[0143] According to one or more embodiments of the present disclosure, the first task flow includes at least one root task node, and the root task node is used to characterize the triggering condition of the first task flow; the execution module is specifically used to: when the root task node meets the triggering condition, execute the downstream task nodes of the root task node in sequence to execute the table workflow.

[0144] In a third aspect, according to one or more embodiments of the present disclosure, there is provided an electronic device, comprising: at least one processor and a memory;

[0145] The memory stores computer-executable instructions;

[0146] The at least one processor executes the computer-executable instructions stored in the memory, so that the at least one processor performs the method for processing the workflow in the table as described in the first aspect and various possible designs of the first aspect.

[0147] In a fourth aspect, according to one or more embodiments of the present disclosure, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer execution instructions. When a processor executes the computer execution instructions, the method for processing the workflow in the table as described in the first aspect and various possible designs of the first aspect is implemented.

[0148] In a fifth aspect, according to one or more embodiments of the present disclosure, a computer program product is provided, including a computer program, which, when executed by a processor, implements the method for processing the workflow within a table as described in the first aspect and various possible designs of the first aspect.

[0149] The above description is only a preferred embodiment of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present disclosure (but not limited to) by each other to form a technical solution.

[0150] In addition, although each operation is described in a specific order, this should not be understood as requiring these operations to be performed in the specific order shown or in a sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although some specific implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the present disclosure. Some features described in the context of a separate embodiment can also be implemented in a single embodiment in combination. On the contrary, the various features described in the context of a single embodiment can also be implemented in multiple embodiments individually or in any suitable sub-combination mode.

[0151] Although the subject matter has been described in language specific to structural features and / or methodological logical actions, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. On the contrary, the specific features and actions described above are merely example forms of implementing the claims.

Claims

1. A method for processing workflow in a table, characterized in that: include: Displaying a target table item in an item operation area of ​​an electronic table, wherein the target table item includes at least one item of table data; In response to a first operation instruction, a first task flow corresponding to a table workflow is created in the target table item, wherein the first task flow includes at least two task nodes that are executed in order, the task nodes are bound to at least one table data item in the target table item, and the task nodes are used to execute table functions constituting the table workflow based on the table data; The first task flow is triggered to execute the form workflow.

2. The method according to claim 1, characterized in that The target table item in the project operation area has a first sub-directory and a second sub-directory, the directory items of the first sub-directory are used to represent the table data, the directory items of the second sub-directory are used to represent the task flow, and the identifier of the first task flow is the directory items of the second sub-directory.

3. The method according to claim 1, characterized in that The task node includes a function node and a logic node. The function node is used to represent the content of the executed table function. The adjacent downstream of the logic node is connected to at least two of the function nodes. The logic node is used to represent the selection strategy of the adjacent downstream function node.

4. The method according to claim 3, characterized in that: The function node includes execution information, and the execution information is used to represent at least one of the following: The execution time of the function node, the table data corresponding to the function node, and the modification time of the function node.

5. The method according to claim 3, characterized in that: The table workflow includes a target table function consisting of a plurality of execution steps, and the triggering of the first task flow to execute the table workflow includes: By executing the target function node in the first task flow, an associated task flow is obtained, wherein the associated task flow includes at least two subtask nodes executed in order, and the subtask nodes are used to execute at least one execution step of the table function; The associated task flow is triggered to execute the target table function.

6. The method according to claim 5, characterized in that The method further comprises: In response to the second operation instruction, the associated task flow is created in the target table item, and / or the corresponding table data is bound to the associated task flow.

7. The method according to claim 1, characterized in that The method further comprises: Displaying a table data page in the task flow editing area of ​​the electronic form, the table data page is used to display the target table data bound to the task node; In response to a third operation instruction for the table data page, modify the target table data to obtain modified target table data; Based on the modified target table data, the first task flow is updated to obtain a second task flow.

8. The method according to claim 7, characterized in that The method further comprises: Displaying the first task flow in a task flow editing area of ​​the electronic form; The page displaying table data includes: In response to a fourth operation instruction for a target task node in the first task flow, displaying a table data page of the target task node; The updating of the first task flow based on the modified target table data to obtain a second task flow includes: Based on the modified target table data, updating the downstream task node of the target task node in the first task flow to obtain an updated downstream task node; Based on the updated downstream task node, the second task flow is generated.

9. The method according to claim 1, characterized in that: In response to the first operation instruction, creating a first task flow corresponding to the table workflow in the target table item includes: In response to the first operation instruction, at least one upstream task node is created in the electronic form, and table data corresponding to the upstream task node is configured; Automatically generate a downstream task node of the upstream task node according to the table function executed by the upstream task node and the corresponding table data; The first task flow is generated according to the upstream task node and the downstream task node.

10. The method according to claim 1, characterized in that The method further comprises: receiving modification instructions sent by at least two target users, and modifying the task node in the first task flow; The user identification corresponding to each of the target users is displayed in the task node.

11. The method according to claim 1, characterized in that: The first task flow includes at least one root task node, and the root task node is used to represent a triggering condition of the first task flow; The triggering of the first task flow to execute the form workflow includes: When the root task node meets the trigger condition, the downstream task nodes of the root task node are executed in sequence to execute the table workflow.

12. A device for processing workflow in a table, characterized in that: include: A display module, used for displaying a target table item in an item operation area of ​​an electronic table, wherein the target table item includes at least one item of table data; A processing module, configured to create, in response to a first operation instruction, a first task flow corresponding to a table workflow in the target table item, wherein the first task flow includes at least two task nodes that are executed in order, the task nodes being bound to at least one table data item in the target table item, and the task nodes being configured to execute table functions constituting the table workflow based on the table data; An execution module is used to trigger the first task flow to execute the form workflow.

13. An electronic device, characterized in that: include: Processor and memory; The memory stores computer-executable instructions; The processor executes the computer-executable instructions stored in the memory, so that the processor executes the method for processing the workflow within a table according to any one of claims 1 to 11.

14. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions. When the processor executes the computer-executable instructions, the method for processing the workflow in a table as claimed in any one of claims 1 to 11 is implemented.

15. A computer program product comprising a computer program, characterized in that When the computer program is executed by a processor, the method for processing a workflow within a table according to any one of claims 1 to 11 is implemented.

Images