Workflow setting method in table and related equipment

Abstract

The invention provides a workflow setting method in a table and related equipment, and the method comprises the steps: generating a workflow in response to a creation operation in the table, the workflow comprising at least one node, and the workflow being used for executing an automatic process based on data of the table; in response to a configuration operation on the target node, obtaining input formula content, the formula content comprising field information of a table; in response to execution of the workflow, a calculation result is generated based on the formula content, the calculation result being included in output content of the workflow. According to the method, the formula can be configured for the workflow node of the database table, and the data calculation and processing capability in the workflow is improved.

Description

TECHNICAL FIELD

[0001] The present disclosure relates to the technical field of electronic computers and Internet, and particularly relates to a table workflow setting method and related equipment. BACKGROUND

[0002] Currently, in the application program of data and business management, a user can store table data by creating a data table, and at the same time, can realize automatic triggering of table functions by creating a workflow, thereby improving the efficiency of business management.

[0003] In the related art, when designing a workflow, a formula calculation is often needed for original data. However, the current setting method cannot directly set a formula, and needs to separately set a formula item in a data table and then reference in a workflow, thereby causing field redundancy, high configuration difficulty and other problems, which seriously affect the user experience.

[0004] It should be noted that the information disclosed in the above background section is only used to strengthen the understanding of the background of the present disclosure, and therefore can include information that does not constitute prior art known to those skilled in the art. SUMMARY

[0005] Therefore, the present disclosure provides a table workflow setting method and related equipment to solve or partially solve the above problems.

[0006] In order to achieve the above purpose, in a first aspect, the present disclosure provides a table workflow setting method, comprising:

[0007] In response to a creation operation in a table, a workflow is generated, the workflow comprising at least one node, the workflow being used to execute an automatic process based on data of the table;

[0008] In response to a configuration operation on a target node, input formula content is obtained, the formula content comprising field information of the table;

[0009] In response to execution of the workflow, a calculation result is generated based on the formula content, and the calculation result is included in output content of the workflow.

[0010] Based on the same concept, in a second aspect, the present disclosure further provides a table workflow setting device, comprising:

[0011] A first module is configured to generate a workflow in response to a creation operation in a table, the workflow comprising at least one node, the workflow being used to execute an automatic process based on data of the table;

[0012] The second module is configured to, in response to a configuration operation on the target node, obtain input formula content, the formula content including field information of a table;

[0013] The third module is configured to, in response to execution of the workflow, generate a calculation result based on the formula content, and include the calculation result in output content of the workflow.

[0014] Based on the same concept, in a third aspect, the present disclosure also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the method according to any one of the above.

[0015] Based on the same concept, in a fourth aspect, the present disclosure also provides a non-transitory computer-readable storage medium, which stores computer instructions for causing a computer to implement the method according to any one of the above.

[0016] Based on the same concept, in a fifth aspect, the present disclosure also provides a computer program product, which includes computer program instructions, when the computer program instructions are executed on a computer, causing the computer to implement the method according to any one of the above.

[0017] As can be seen from the above, the present disclosure provides a method for setting a workflow in a table and related equipment. By adding a corresponding functional area for adding a formula in a setting interface for setting a workflow, the present disclosure can enable a user to directly edit a formula when using a workflow, thereby bypassing a mode of first setting a data table and then determining a formula result by referencing the data table, saving the total amount of fields, reducing the configuration difficulty, enabling the user to only focus on setting a workflow, and not needing to consider the setting of other charts, facilitating user operation. Meanwhile, based on the working process of the workflow, each time the workflow is executed, the corresponding formula will be directly calculated according to the current input data, and after completion, the calculated data will exist as a static data of the workflow. In this way, the calculated data will not change with the adjustment of the formula and the data, which is helpful for information recording of each workflow. Finally, the present disclosure can configure a formula for a workflow node of a database table, improving the calculation and processing capability of data in the workflow, and can improve the overall use efficiency and user experience. BRIEF DESCRIPTION OF DRAWINGS

[0018] In order to more clearly illustrate the technical solutions in the embodiments of the present disclosure or the related art, brief introductions will be given below to the drawings needed to be used in the embodiments or related art descriptions. Obviously, the drawings in the following description are only embodiments of the present disclosure, and for those skilled in the art, other drawings can also be obtained without creative labor based on these drawings.

[0019] Figure 1 A schematic diagram of an example system 100 according to an embodiment of the present disclosure is shown.

[0020] Figure 2 A flowchart of an example method 200 according to an embodiment of the present disclosure is shown.

[0021] Figure 3 A structural diagram of an initial interface 300 according to an embodiment of the present disclosure is shown.

[0022] Figure 4 A structural diagram of generating a second region 312 on a first interface 310 according to an embodiment of the present disclosure is shown.

[0023] Figure 5 A structural diagram of a second interface 320 according to an embodiment of the present disclosure is shown.

[0024] Figure 6 A structural diagram of displaying formula content 311-1 in a first region 311 according to an embodiment of the present disclosure is shown.

[0025] Figure 7 A structural diagram of a third interface 330 according to an embodiment of the present disclosure is shown.

[0026] Figure 8 Another structural diagram of a third interface 330 according to an embodiment of the present disclosure is shown.

[0027] Figure 9 A schematic diagram of an example apparatus 900 according to an embodiment of the present disclosure is shown.

[0028] Figure 10 A schematic diagram of an example computer device 1000 according to an embodiment of the present disclosure is shown. DETAILED DESCRIPTION

[0029] For the purpose of making the purpose, technical solutions and advantages of the present disclosure clearer, the present disclosure is further described in detail below with reference to the embodiments and the accompanying drawings.

[0030] It should be noted that the technical terms or scientific terms used in the embodiments of the present disclosure should be understood as the general meaning understood by those skilled in the art to which the embodiments of the present disclosure belong, unless otherwise defined. The terms "first", "second", and the like used in the examples of the present disclosure do not represent any order, number, or importance, but are only used to distinguish different components. The terms "include", "contain", and the like mean that the elements or objects before the terms encompass the elements or objects listed after the terms and their equivalents, and do not exclude other elements or objects. The terms "connect" or "connected" and the like are not limited to physical or mechanical connections, but can include electrical connections, whether direct or indirect. The terms "upper", "lower", "left", "right", and the like are only used to represent relative positional relationships, and when the absolute positions of the described objects change, the relative positional relationships can also change accordingly.

[0031] It can be understood that, before using the technical solutions disclosed in the embodiments of the present disclosure, the type, use range, use scenario, etc. of the personal information involved in the present disclosure should be informed to the user and the authorization of the user should be obtained in a proper manner according to relevant laws and regulations.

[0032] For example, in response to receiving the active request of the user, prompt information is sent to the user to explicitly prompt the user that the operation requested to be performed will require obtaining and using the personal information of the user. Thus, the user can voluntarily choose whether to provide the personal information to the software or hardware such as electronic devices, application programs, servers, or storage media that perform the operation of the technical solutions of the present disclosure according to the prompt information.

[0033] As an optional but non-limiting implementation manner, in response to receiving the active request of the user, the manner of sending prompt information to the user may, for example, be a pop-up window manner, in which the prompt information can be presented in the form of text. In addition, the pop-up window can also carry selection controls for the user to select "agree" or "disagree" to provide personal information to the electronic device.

[0034] It can be understood that the above notification and user authorization process is only illustrative and does not limit the implementation manner of the present disclosure, and other manners that meet the relevant laws and regulations can also be applied to the implementation manner of the present disclosure.

[0035] It can be understood that the data involved in the present technical solution (including but not limited to the data itself, the acquisition or use of the data) should comply with the requirements of the relevant laws and regulations and the relevant provisions.

[0036] For the purpose, technical solutions, and advantages of the present specification to be clearer and more apparent, the present specification is further described in detail below in conjunction with specific embodiments and with reference to the accompanying drawings.

[0037] Figure 1 FIG2 is a schematic diagram of an exemplary system 100 according to an embodiment of the present disclosure. The system 100 may be a system for implementing workflow settings in a table.

[0038] like Figure 1 As shown, taking the example of a terminal device and a server jointly executing the workflow setting method in the table, the system 100 may include a terminal device 102, a server 104, and a database server 106. The terminal device 102 and the server 104 are connected via a network, such as a wired or wireless network. Optionally, the device for implementing workflow setting may be integrated into the terminal device 102. The database server 106 and the server 104 are connected via a network, such as a wired or wireless network. The database server 106 may store various data related to executing the workflow setting method in the table, such as the basic workflow framework, various node types, the connection relationships between various nodes, the setting interface format of each node, the type of input data, the basic framework for formula editing, the basic logical relationship of the formula, etc.

[0039] Various applications (APPs) may be installed on the terminal device 102, such as text processing applications, video conferencing applications, life service applications, reading applications, video applications, social networking applications, payment applications, web browsers, and instant messaging tools. These applications may be used to display the final interface. As an alternative example, the applications (APPs) installed on the terminal device 102 may be downloaded and installed from the server 104.

[0040] The terminal device 102 herein can be either hardware or software. When the terminal device 102 is hardware, it can be various electronic devices with a display screen, including but not limited to smartphones, tablet computers, e-book readers, MP3 players, laptop computers, and desktop computers (PCs). When the terminal device 102 is software, it can be installed in the electronic devices listed above. It can be implemented as multiple software or software modules (for example, to provide distributed services), or it can be implemented as a single software or software module. No specific limitation is given here.

[0041] Server 104 can be a server that provides various services. For example, it can be a backend server that supports various applications displayed on terminal device 102. Database server 106 can also be a database server that provides various services. It is understood that if server 104 can perform the relevant functions of database server 106, database server 106 may not be provided in system 100.

[0042] The server 104 and the database server 106 herein can be hardware or software. When they are hardware, they can be implemented as a distributed server cluster composed of multiple servers or as a single server. When they are software, they can be implemented as multiple software or software modules (for example, for providing distributed services) or as a single software or software module. No specific limitation is made herein.

[0043] It should be noted that the workflow setting method in the table provided by the embodiments of the present disclosure can be executed by the system 100. Specifically, it can be executed by interaction between the terminal device 102, the server 104 and the database server 106. It can be understood that, in the case where the terminal device 102 has the functions required by the server 104 and the database server 106 in executing the workflow setting method in the table, it can also be executed by the terminal device 102 alone. It should be understood that, Figure 1 The number of the terminal device 102, the server 104, the database server 106 and the user 108 in the system 100 is merely illustrative. According to actual needs, there can be any number of terminal devices, users, servers and database servers.

[0044] In an exemplary application scenario, the user 108 can input an instruction of workflow setting through the terminal device 102, and the server 104 can provide a workflow setting service to the user 108 based on the instruction, and display an operation interface of the workflow setting service in a page through the terminal device 102, which can be referred to as a first interface.

[0045] As described in the background section, in the related art, the calculation of a formula field is currently mainly used to calculate the formula field, so that in the current workflow, although the formula can be set, the formula is first set in the corresponding table, so that the formula becomes a single item or column, and after the calculation is completed, the workflow references the calculation result. For example, when sending a message, the merchant hopes to directly desensitize the user number by replacing the middle X bits with an asterisk. Since text processing cannot be performed in the workflow of message sending, a column of formula fields is added to the table, and the number after desensitization is calculated and then referenced in automation. At the same time, the calculation result set in this way cannot realize static storage (i.e., only calculated once, and not changed later), and cannot meet the demand of recording historical values. In the related art, the formula field value is a dynamic calculation result, and when the dependent data changes, the historical calculated value also changes. For example: at a certain moment, the formula "monthly bonus = basic salary x performance coefficient" is calculated, and it is hoped to be stored as a static value, that is, even if the subsequent basic salary or performance coefficient is adjusted, the bonus value remains unchanged. At this time, since the table actually stores the calculation relationship, when the "basic salary" or "performance coefficient" changes, the reference value of the formula changes, and thus the calculated monthly bonus also changes, which not only affects the current, but also changes the history.

[0046] In view of the above actual situation, the embodiment of the present disclosure provides a workflow setting method in a table. By adding a corresponding functional area for adding a formula in the setting interface of the workflow setting, the user can directly edit the formula when using the workflow, thereby bypassing the way of first setting a data table and then determining the formula result by referencing the data table, saving the total amount of fields, reducing the configuration difficulty, and enabling the user to only focus on setting the workflow without considering the setting of other charts, thereby facilitating user operation. At the same time, based on the working process of the workflow, each time the workflow is executed, the corresponding formula is directly calculated according to the current input data, and after completion, it exists as a static data of the workflow. In this way, the calculated data will not change with the adjustment of the formula and data, which helps to record the information of each workflow. Finally, the present disclosure can configure a formula for the workflow node of the database table, improve the calculation and processing capability of data in the workflow, and improve the overall use efficiency and user experience.

[0047] Figure 2 A flowchart of an example method 200 according to an embodiment of the present disclosure is shown. Optionally, the method 200 can be used for workflow setting in a table, and in particular, can be used for displaying and editing a workflow in automatic business processing. The method 200 can be implemented by the terminal device 102 of Figure 1 , or can be implemented by the system 100 of Figure 1 .

[0048] After that, as shown in Figure 3 The method 200 can form an initial interface 300 through the terminal device 102, and the initial interface 300 can be used to display a workflow 400, which can be composed of at least one node, and the at least one node is connected with each other through a set connection relationship, a superior-inferior relationship, etc., so as to set the workflow 400. Of course, in some scenarios, if a new workflow 400 is created, the initial interface 300 can also not contain any node, and the workflow 400 is completely created through user operation. On this basis, the method 200 specifically includes:

[0049] Step 202, in response to a creation operation in a table, generating a workflow, the workflow including at least one node, the workflow being used to execute an automated process based on data of the table.

[0050] In this step, the table can be a multidimensional table, which can establish the mutual relationship between multiple data. On the basis of the multidimensional table, the workflow 400 is created, and the workflow 400 can be displayed through the initial interface 300, as shown in Figure 3 After that, for a workflow 400, it can be composed of at least one node, and of course in the initial creation process of the workflow 400, the workflow 400 can not exist nodes and need to be created by the user. After that, for the role of the workflow, it can mainly be according to the data in the table combined with the corresponding trigger condition, and when the condition is met, the data automated process can be directly performed, and the work can be automatically performed according to the processing process of the node in the workflow 400.

[0051] Step 204, in response to a configuration operation on a target node, obtaining input formula content, the formula content including field information of a table.

[0052] In this step, the target node 410 is one of the at least one node or a newly added node 410 in the workflow 400. The configuration operation can be re-editing or new creation of the target node 410, etc., which needs to set or modify the attribute of the corresponding target node 410. As shown in Figure 3As shown, assuming that multiple nodes have existed in the current workflow 400, the target node 410 in the workflow 400 can be determined in multiple ways. One way can be a selection operation on the existing nodes. A single click, double click, long press, or other selection operation can be performed on the existing nodes of the workflow 400 to determine the selected node as the target node 410, and finally confirm the configuration operation on the target node 410. Another way can be adding a new node on the basis of the existing workflow 400. A template node can be added to the workflow 400 by dragging to add a node, or a node can be directly added by generating or clicking an add option at a set position of the workflow 400. In this way, a new node is added to the workflow 400, and the added node is taken as the target node 410, and a configuration operation is directly performed on it by default. That is, in some embodiments, the configuration operation on the target node includes: displaying an initial interface 300, the initial interface 300 including at least part of the workflow 400; in response to a selection operation on any node, taking the any node as the target node 410, or in response to an adding operation of a node at any position of the workflow 400, taking the added node as the target node 410.

[0053] Then, the formula content is obtained by a certain operation to obtain the formula content required to be executed by the target node 410. After the target node 410 is determined, a window for inputting a formula can be directly popped up, and then the formula content is set in the window. The formula content is used for the workflow 400, and thus it generally needs to be applied to the data content of part of the table, that is, the field information of part of the table can be required as a component of the formula.

[0054] In some embodiments, in combination with the aforementioned application scenarios, after the target node 410 in the workflow 400 is determined in the initial interface 300, a first interface 310 can be formed based on the initial interface 300. The first interface 310 is a setting interface for the target node 410. The properties, functions, etc. of the target node 410 can be set through the first interface 310. The first interface 310 can include multiple data items that need to be set, including a first area 311 for setting the main content. The first area 311 allows the user to add a variety of content. Afterwards, the first area 311 can be used to add content. For example, if the first area 311 is in the form of a text box, an icon can be generated by clicking on the text box to add content to the first area 311, or an add mark can be set in the text box. When the user selects the add mark, it is considered that the add operation has been performed. After confirming that the user has performed the add operation on the first area 311, the second area 312 can be formed. The second area 312 may include multiple options, and the user determines which content needs to be added to the first area 311 by selecting these options. For example, the second area 312 includes an A table option, a B list option, and an add formula option 312-1. When the user selects the A table option, the content of the A table is added to the first area 311. When the user selects the add formula option 312-1, it is considered that the user needs to add a formula. That is, in some embodiments, the acquisition of the input formula content includes: generating a first interface 310, the first interface 310 includes a first area 311 for adding content, and the first area 311 includes an add formula option 312-1. After the first interface 310 is generated, the method further includes: generating a second area 312 in response to the add operation to the first area 311, and displaying the add formula option 312-1 through the second area 312.

[0055] In some embodiments, as Figure 4 As shown, since the second area 312 may include many options, a search box or search area 312-2 may be provided in the second area 312 to facilitate user selection. The options in the second area 312 can be filtered through the search area 312-2. After the user enters information such as keywords in the search area 312-2, the multiple options can be filtered based on the keyword information, and options that match the keyword information or meet the requirements are selected and presented in the second area 312, facilitating user selection. That is, in some embodiments, the second area 312 includes multiple options and the search area 312-2, keyword information is obtained through the search area 312-2, and the multiple options in the second area 312 are filtered based on the keyword information.

[0056] In some embodiments, the second area 312 can serve as a drop-down menu of the first area 311 ; it can also be a separate option box area. The second area 312 can be next to the first area 311 or at any location according to settings.

[0057] Afterwards, after the add formula option 312-1 is displayed in the first area 311, the add formula option 312-1 can be selected. Then, in response to the selection operation of the add formula option, a second interface 320 can be generated, and the formula content can be obtained through the second interface 320. The selection operation here can be a single click, double click, long press, etc. on the add formula option 312-1. Afterwards, the second interface 320 is mainly used for formula editing, which integrates the main functions of the formula editor. Through the second interface 320, the user can perform specific editing work of the formula. After the user confirms, the present disclosure obtains the specific content of the formula that needs to be stored in the target node 410 through the second interface 320, such as Figure 5 The second interface 320 can be a functional window floating in the first interface 310, or can be presented as a completely independent interface.

[0058] In some embodiments, as Figure 5 As shown, the second interface 320 can mainly include a formula editing area 321 and a reference area 322. The formula editing area 321 is the location where the user mainly edits the formula, receiving the user's input to form the corresponding formula; the reference area 322 is the data that the target node 410 can reference (that is, the field information allowed to be referenced in the table). The user can edit the formula by dragging the reference content in the reference area 322, which can also facilitate the confirmation of the correspondence between the data items in the formula and various input data or stored data. Later, in some more specific embodiments, the second interface 320 can also include other functional areas, such as a history record area 323. That is, in some embodiments, the second interface 320 includes a formula editing area 321 and a reference area 322; after generating the second interface 320, the method further includes: obtaining input information through the formula editing area 321, and / or obtaining reference content from the reference area 322 and adding it to the formula editing area 321, thereby forming the formula content.

[0059] In some more specific application scenarios, since the formula function of the present application is applied in a workflow, the workflow generally needs to meet certain conditions to be triggered, for example, the workflow of salary settlement generally needs to obtain the relevant data of the corresponding personnel for calculation after the time node such as the end of the month. Therefore, when setting the formula, there may be no specific numerical value that cannot be referenced, and the preview value cannot be calculated either. Therefore, in the corresponding scenario, the current formula editor can be simplified, and some functions that cannot be applied to the workflow scenario are removed, for example, directly parsing the input content into a variable, real-time display of the result value of the formula in the current formula editing area, and / or display of the selected part value. Correspondingly, the reference area 322 can also be adjusted according to the workflow scenario, for example, removing the whole table, column reference, adjusting the display logic of the reference content, and the like.

[0060] In some embodiments, when the formula content is obtained, the formula content can be displayed in the first interface 310 through the first area 311, so as to facilitate the user to view and modify. In a specific scenario, when the user completes the formula editing, a save option can be set in the second interface 320, and the user performs a formula saving operation by clicking the save option; or the user directly inputs a corresponding gesture, stroke or code to perform a formula saving operation. Through the operation, the formula logical relationship edited in the second interface 320 is recorded, so as to form a formula content 311-1 convenient to display, and the formula content 311-1 is displayed in the first area 311, as shown in Figure 6 Specifically, the formula content 311-1 can display the name of the corresponding formula (if set), and can display part of the selected content of the formula, so as to facilitate the user to confirm the content and function of the formula.

[0061] In some embodiments, in order to facilitate the user to perform the re-editing operation of the formula, the editing option 311-2 and the deletion option 311-3 can be set on the basis of the formula content 311-1. When the user triggers the editing option 311-2, it is considered that the user wants to adjust and re-edit the formula corresponding to the formula content 311-1. Therefore, the second interface 320 can be displayed again, and the content corresponding to the formula content 311-1 is loaded in the second interface 320. The specific formula is displayed in the second interface 320, so that the user can edit again. When the user triggers the deletion option 311-3, it is considered that the user may not need the formula corresponding to the formula content 311-1. Therefore, the formula content 311-1 is deleted in the first area 311.

[0062] In some embodiments, in order to prevent the workflow data from being too large or the calculation time from being long, certain restrictions and constraints can be placed on the formula after the formula content 311-1 is obtained. First, the data volume of the specific content of the formula can be determined, and then the data volume of the formula itself can be limited by setting corresponding thresholds to constrain it, for example, the specific size of the formula cannot exceed 10MB, etc. Afterwards, the data volume of the calculation result of the formula can be limited. Similar to the above, corresponding thresholds can also be set to constrain it. Afterwards, as long as one item exceeds the corresponding threshold, a corresponding prompt will be generated to prompt the user that rectification is required. For example, if the data volume of the specific content of the formula exceeds the set threshold, a third prompt will be formed, such as "The formula expression is too long, please reconfigure"; if the calculation result of the formula exceeds the set threshold, a fourth prompt will be formed, such as "The calculation result of the formula is too large and exceeds the 10MB upper limit". That is, in some embodiments, after obtaining the input formula content, the method also includes: testing the formula content 311-1, and if the data size of the formula content 311-1 exceeds the set threshold, forming a third prompt; testing the calculation result of the formula content 311-1, and if the data size of the calculation result exceeds the set threshold, forming a fourth prompt.

[0063] In some embodiments, the number of variables that can be set for the first area 311 may be limited depending on its function, such as Figure 6 In the general scenario shown, multiple or unlimited variables can be set in the first area 311. In this case, multiple variables (the formula content 311-1 itself is also a variable) can be added to the first area 311 in sequence or according to set rules. In other embodiments, because the first area 311 may be assigning values ​​to certain items, the first area is limited to the number of variables, for example, only one variable. In this scenario, when the number of running variables reaches the upper limit, the newly added variable can overwrite the original variable. The specific overwriting can be determined according to the settings, such as overwriting the earliest variable or the latest variable. Of course, if the user has already selected the variable to be overwritten, the variable overwriting can be performed according to the user's selection. That is, in some embodiments, the formula content 311-1 is displayed in the first interface 310 through the first area 311; after obtaining the input formula content, the method also includes: determining whether the first area 311 has reached the upper limit of the variable setting; in response to reaching the upper limit of the variable setting, the formula content 311-1 is overwritten with the corresponding variable in the first area 311 according to the setting, or the selection of any variable in the first area 311 is determined, and the formula content is overwritten with the selected variable.

[0064] In some embodiments, since the format of the result formed by the formula editor cannot be fixed, only after the formula editing is completed can the specific format of the result be predicted, and thus the formula editor cannot be limited by prior settings. Therefore, if the first area 311 has a data format requirement, it is also necessary to determine or predict whether the requirement is met after the formula content 311-1 is determined. Therefore, after the formula content 311-1 is displayed in the first area 311, it can be determined whether the first area 311 has a format requirement, if so, then it is further determined whether the formula content 311-1 meets the corresponding format requirement, if not, then the user can be prompted, and the prompting manner can be to display corresponding prompt information, for example, to display a first prompt on one side of the formula content 311-1, and at the same time, the formula content 311-1 can be displayed differently, for example, highlighted, outlined, displayed with a color that can form a difference, etc. That is, in some embodiments, after the formula content is obtained, the method further includes: determining whether the formula content 311-1 meets the format requirement of the first area 311; and in response to not meeting the format requirement, displaying the formula content 311-1 differently and generating a first prompt.

[0065] In some embodiments, in combination with the specific scenario of the workflow, for the formula content 311-1, the content that can be referenced is only the set public reference range and the related data of the predecessor node of the current node. Further, during the workflow setting process, if the predecessor node of the node where the formula is located is adjusted, the content of the formula content 311-1 needs to be referenced and checked. If the reference content of the formula content 311-1 is missing or other abnormalities occur, it means that the adjustment of the predecessor node affects the formula content 311-1, that is, the formula content 311-1 cannot pass the reference check. At this time, similar to the previous embodiment, a corresponding prompt information, that is, a second prompt, can also be formed. Then, for the formula content 311-1, the error content can be determined and displayed differently. For example, in the formula content 311-1, a reference data is missing due to the foregoing adjustment. At this time, the reference data can be marked red (differently displayed), and a second prompt "step has been deleted" can be formed beside it. Of course, the reference check can not only be for the formula content 311-1, but also for all the contents in the first area 311, and even for the information in the first interface 310. If an error occurs, a similar prompt method can be used to prompt the user. That is, in some embodiments, after obtaining the input formula content, the method further includes: in response to adjusting the predecessor node of the target node 410 in the workflow 400, performing reference checking on the target node 410 based on the adjusted predecessor node; in response to the target node 410 not passing the reference checking, determining error content that has a reference error, and differently displaying the error content and generating a second prompt.

[0066] Step 206, in response to execution of the workflow, generating a calculation result based on the formula content, and including the calculation result in the output content of the workflow.

[0067] In this step, after the user completes the setting of the target node 410, a corresponding saving operation is performed, for example, a saving option is set in the first interface 310, and the saving operation is performed by selecting the saving option. After saving, the target node 410 can be functionally set according to the setting content in the first interface 310, so that it can implement corresponding functions. After the entire workflow 400 is set, the workflow 400 can automatically execute according to its triggering condition. When the workflow 400 executes, the target node 410 can calculate a calculation result according to the corresponding formula content 311-1. The calculation result is stored as the value formed by this time workflow execution, so as to realize static storage of data and prevent historical data changes caused by subsequent changes of related data. Finally, the technical result can be output as the output content of the workflow 400.

[0068] In some embodiments, during the specific running process after the workflow setting is completed, if the trigger condition of the workflow 400 is met, the workflow 400 will be executed once and the corresponding data processing and the like will be performed, at this time, the corresponding running record can be formed to be stored. That is, in some embodiments, the response to the execution of the workflow includes: in response to the trigger condition of the workflow 400 being met, performing data processing according to the workflow 400 to generate a running record. Wherein, each workflow 400 is generally set with a corresponding trigger condition at the setting time, and when the condition is met, the specific content of the workflow 400 will be executed once.

[0069] Further, if the user wants to view the corresponding running record, as shown in FIG. 3, a third interface 330 can be formed, in which the records of the workflows 400 that have been completed (whether successful or failed can be recorded) and the records of the workflows 400 that are in progress are recorded. Then, as shown in FIG. 3, if the user only wants to simply view one of the running records, a mouse or the like can be hovered over the running record for a certain period of time, and after that, it is considered that the user has performed a viewing operation on the running record, at this time, a third area 331 can be formed to display the formula content 311-1 and the like contained in the running record. Then, as shown in FIG. 3, if the user wants to determine the specific running data of a running record, the running record or the detail option of the running record can be clicked or selected, at this time, the specific running data and the like of the selected running record can be displayed in the third interface 330. That is, in some embodiments, after the running record is generated, the method further includes: in response to the query operation on the running log of the workflow 400, generating a third interface 330, the third interface 330 including at least one running record; in response to the viewing operation on any running record in the third interface 330, generating a third area 331, and displaying the formula content through the third area 331; in response to the selection operation on any running record in the third interface 330, displaying the running data of the selected running record in the third interface 330. Figure 7 Figure 7 Figure 8

[0070] ​​​As can be seen from the above embodiments, the method for setting a workflow in a table is provided in the embodiments of the present disclosure. By adding a corresponding functional area for adding a formula in a setting interface for setting a workflow, the user can directly edit a formula when using the workflow, so as to bypass the mode of first setting a data table and then determining a formula result by referencing the data table, thereby saving the total amount of fields, reducing the configuration difficulty, enabling the user to only focus on setting the workflow and without considering the setting of other charts, and facilitating the user operation. Meanwhile, based on the working process of the workflow, each time the workflow is executed, the corresponding formula is directly calculated according to the current input data, and after being completed, the formula is used as a static data of the workflow. In this way, the calculated data will not change with the adjustment of the formula and the data, which is helpful for the information recording of each workflow. Finally, the embodiments of the present disclosure can configure a formula for a workflow node of a database table, improve the calculation and processing capability of data in the workflow, and improve the overall use efficiency and user experience.

[0071] It should be noted that the method of the embodiments of the present disclosure can be executed by a single device, such as a computer or a server. The method of the embodiments of the present disclosure can also be applied to a distributed scenario and completed by multiple devices in cooperation. In the case of such a distributed scenario, one of the multiple devices can only execute one or more steps in the method of the embodiments of the present disclosure, and the multiple devices can interact with each other to complete the method.

[0072] It should be noted that the specific embodiments of the present disclosure are described above. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims can be performed in a different order than the order described above and still achieve the desired result. In addition, the processes depicted in the figures do not necessarily require the particular order shown or sequential order to achieve the desired results. In certain implementations, multitasking and parallel processing can be advantageous or necessary.

[0073] Based on the same technical concept, the present disclosure also provides a device for setting a workflow in a table, corresponding to the method of any of the above embodiments. Figure 9 A schematic diagram of an exemplary device 900 provided by the embodiments of the present disclosure is shown. As shown, the device 900 can be used to implement the method 200, and can further include the following modules. Figure 9 As shown, the device 900 can be used to implement the method 200, and can further include the following modules.

[0074] The first module 910 is configured to generate a workflow in response to a creation operation in a table, the workflow including at least one node, the workflow being used to execute an automated process based on data of the table.

[0075] The second module 920 is configured to acquire input formula content in response to a configuration operation on a target node, the formula content including field information of a table.

[0076] The third module 930 is configured to generate a calculation result based on the formula content in response to execution of the workflow, and include the calculation result in output content of the workflow.

[0077] In some example embodiments, the first module 910 is further configured to:

[0078] display an initial interface, the initial interface including at least part of the workflow;

[0079] in response to a selection operation on any node, take the any node as the target node, or in response to an addition operation of a node at any position of the workflow, take the added node as the target node.

[0080] In some example embodiments, the second module 920 is further configured to:

[0081] generate a first interface, the first interface including a first area for adding content, the first area including an addition formula option;

[0082] in response to a selection operation on the addition formula option, generate a second interface through which the formula content is acquired.

[0083] In some example embodiments, the second interface includes a formula editing area and a reference area.

[0084] The second module 920 is further configured to:

[0085] acquire input information through the formula editing area, and / or add reference content from the reference area to the formula editing area to form the formula content.

[0086] In some example embodiments, the second module 920 is further configured to:

[0087] in response to an addition operation on the first area, generate a second area through which the addition formula option is displayed.

[0088] In some example embodiments, the second area includes a plurality of options and a search area, key information is acquired through the search area, and the plurality of options in the second area are filtered according to the key information.

[0089] In some example embodiments, the formula content is displayed in the first interface through the first area; and the second module 920 is further configured to:

[0090] determining whether the first region has reached an upper limit of a variable setting;

[0091] in response to reaching the upper limit of the variable setting, covering the formula content in the corresponding variable in the first region according to the setting, or determining selection of any variable in the first region, and covering the formula content in the selected variable.

[0092] In some example embodiments, the second module 920 is further configured to:

[0093] determining whether the formula content meets a format requirement of the first region;

[0094] in response to not meeting the format requirement, performing differential display on the formula content and generating a first prompt.

[0095] In some example embodiments, the second module 920 is further configured to:

[0096] in response to adjusting a preceding node of the target node in the workflow, performing reference checking on the target node based on the adjusted preceding node;

[0097] in response to the target node failing the reference checking, determining error content in which a reference error occurs, performing differential display on the error content and generating a second prompt.

[0098] In some example embodiments, the third module 930 is further configured to:

[0099] in response to meeting a trigger condition of the workflow, performing data processing according to the workflow and generating a running record.

[0100] In some example embodiments, the third module 930 is further configured to:

[0101] in response to a query operation on a running log of the workflow, generating a third interface, the third interface including at least one of the running record;

[0102] in response to a viewing operation on any of the running records in the third interface, generating a third region, and displaying the formula content through the third region;

[0103] in response to a selection operation on any of the running records in the third interface, displaying running data of the selected running record in the third interface.

[0104] In some example embodiments, the second module 920 is further configured to:

[0105] detecting the formula content, and forming a third prompt if a data size of the formula content exceeds a set threshold;

[0106] testing a calculation result of the formula content, and forming a fourth prompt if a data size of the calculation result exceeds a set threshold.

[0107] For the convenience of description, the above apparatus is described in various modules in terms of functions. Of course, the functions of the modules can be implemented in one or more software and / or hardware when implementing the present disclosure.

[0108] The apparatus of the above embodiments is used to implement the corresponding method 200 in any of the preceding embodiments, and has the beneficial effects of the corresponding method 200 embodiment, which will not be repeated here.

[0109] Based on the same technical concept, corresponding to the method of any of the above embodiments, the present embodiment also provides a computer device for implementing the method 200 described above. Figure 10 A hardware structure schematic diagram of an exemplary computer device 1000 provided by the embodiments of the present disclosure is shown. The computer device 1000 can be used to implement the terminal device 102 of Figure 1 In some scenarios, the computer device 1000 can also be used to implement the server 104, the database server 106 of Figure 1

[0110] As shown in Figure 10 The computer device 1000 can include a processor 1002, a memory 1004, a network interface 1006, a peripheral interface 1008, and a bus 1010. Among them, the processor 1002, the memory 1004, the network interface 1006, and the peripheral interface 1008 are connected by the bus 1010 for communication between each other inside the computer device 1000.

[0111] The processor 1002 can be a central processing unit (CPU), an image processor, a neural network processor (NPU), a microcontroller (MCU), a programmable logic device, a digital signal processor (DSP), an application specific integrated circuit (ASIC), or one or more integrated circuits. The processor 1002 can be used to perform functions related to the techniques described in the present disclosure. In some embodiments, the processor 1002 can also include multiple processors integrated as a single logic component. For example, as shown in Figure 10 The processor 1002 can include multiple processors 1002a, 1002b, and 1002c.

[0112] ​The memory 1004 may be configured to store data (eg, instructions, computer code, etc.). Figure 10 As shown, the data stored in the memory 1004 may include program instructions (e.g., program instructions for implementing the method 200 of the embodiment of the present disclosure) and data to be processed (e.g., the memory may store configuration files of other modules, etc.). The processor 1002 may also access the program instructions and data stored in the memory 1004 and execute the program instructions to operate on the data to be processed. The memory 1004 may include a volatile storage device or a non-volatile storage device. In some embodiments, the memory 1004 may include a random access memory (RAM), a read-only memory (ROM), an optical disk, a magnetic disk, a hard disk, a solid-state drive (SSD), a flash memory, a memory stick, etc.

[0113] The network interface 1006 can be configured to provide the computer device 1000 with communication with other external devices via a network. The network can be any wired or wireless network capable of transmitting and receiving data. For example, the network can be a wired network, a local wireless network (e.g., Bluetooth, WiFi, near field communication (NFC)), a cellular network, the Internet, or a combination thereof. It will be understood that the type of network is not limited to the specific examples above.

[0114] The peripheral interface 1008 can be configured to connect the computer device 1000 to one or more peripheral devices to implement information input and output. For example, the peripheral devices can include input devices such as a keyboard, a mouse, a touchpad, a touch screen, a microphone, and various sensors, as well as output devices such as a display, a speaker, a vibrator, and an indicator light.

[0115] The bus 1010 may be configured to transmit information between various components of the computer device 1000 (e.g., the processor 1002, the memory 1004, the network interface 1006, and the peripheral interface 1008), such as an internal bus (e.g., a processor-memory bus), an external bus (USB port, PCI-E bus), etc.

[0116] It should be noted that although the architecture of the computer device 1000 shown above only shows the processor 1002, the memory 1004, the network interface 1006, the peripheral interface 1008, and the bus 1010, in a specific implementation, the architecture of the computer device 1000 may also include other components necessary for normal operation. In addition, those skilled in the art will understand that the architecture of the computer device 1000 may only include the components necessary to implement the embodiments of the present disclosure, and does not necessarily include all the components shown in the figure.

[0117] Based on the same technical concept, the disclosure also provides a non-transitory computer-readable storage medium storing computer instructions for causing the computer to perform the method 200 of any of the above embodiments.

[0118] The computer-readable medium of the embodiments includes permanent and non-permanent, removable and non-removable media, and can be implemented by any method or technology to store information. The information can be computer-readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassette, magnetic tape disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information accessible by a computing device.

[0119] The computer instructions stored in the storage medium of the above embodiments are used to cause the computer to perform the method 200 of any of the above embodiments, and have the beneficial effects of the corresponding method embodiments, which are not repeated here.

[0120] Based on the same technical concept, the disclosure also provides a computer program product including computer program instructions for causing a computer to perform the method 200 of any of the above embodiments. In some embodiments, the computer program instructions can be executed by one or more processors of the computer to cause the computer and / or the processor to perform the method 200. Corresponding to the execution subject of each step in each embodiment of the method 200, the processor performing the corresponding step can belong to the corresponding execution subject.

[0121] The computer program product of the above embodiments is used to cause the computer and / or the processor to perform the method 200 of any of the above embodiments, and has the beneficial effects of the corresponding method embodiments, which are not repeated here.

[0122] Those of ordinary skill in the art will realize that the foregoing discussion of any of the embodiments has been presented for the purpose of illustration and description and is not intended to be exhaustive or to limit the disclosure to the precise forms described, and that various alternatives, modifications, and variations can be employed without departing from the spirit or scope of the disclosure as set forth in the claims. Examples of such alternate, modified, and varying embodiments have been discussed above in relation to their effect on the methods and devices of the present disclosure, but can not all be explicitly described.

[0123] Additionally, to simplify the description and discussion, and so as not to make the embodiments of the disclosure difficult to understand, the well-known power / ground connections to integrated circuit (IC) chips and other components can or can not be shown in the provided drawings. Further, devices can be shown in block diagram form in order to avoid making the embodiments of the disclosure difficult to understand, and this also takes into account the fact that the details regarding the implementation of these block diagram devices are highly dependent on the platform to which the embodiments of the disclosure are to be implemented (i.e., these details should be well within the understanding of one of ordinary skill in the art). Where specific details (e.g., circuitry) are set forth in order to describe an illustrative embodiment of the disclosure, it should be apparent to one skilled in the art that the embodiments of the disclosure can be practiced without, or with variation of, these specific details. The description is thus to be considered as illustrative and not restrictive, and the scope of the disclosure to be indicated by the appended claims.

[0124] While the present disclosure has been described with respect to a limited number of embodiments, those skilled in the art will appreciate numerous modifications and variations within the scope of the present disclosure. For example, other memory architectures (e.g., dynamic RAM (DRAM)) can use the embodiments discussed.

[0125] It is intended that the embodiments of the present disclosure encompass all such alternatives, modifications, and variations as falling within the broad scope of the appended claims. Accordingly, any and all such modifications, variations, or equivalents that fall within the spirit and scope of the disclosed embodiments are intended to be included.

Claims

1. A workflow setting method in a table, characterized in that: include: In response to a creation operation in a table, generating a workflow, the workflow comprising at least one node, the workflow being used to execute an automated process based on data in the table; In response to a configuration operation on a target node, obtaining input formula content, the formula content including field information of a table; In response to the execution of the workflow, a calculation result is generated based on the formula content, and the calculation result is included in the output content of the workflow.

2. The method according to claim 1, characterized in that The response to the configuration operation on the target node includes: Displaying an initial interface, wherein the initial interface includes at least a portion of the workflow; In response to a selection operation on any node, the any node is used as the target node; or in response to an operation of adding a node at any position in the workflow, the added node is used as the target node.

3. The method according to claim 1, characterized in that The formula content obtained by input includes: Generate a first interface, the first interface including a first area for adding content, the first area including an option to add a formula; In response to the selection operation of the add formula option, a second interface is generated, and the formula content is obtained through the second interface.

4. The method according to claim 3, characterized in that The second interface includes a formula editing area and a reference area; After generating the second interface, the method further includes: Input information is obtained through the formula editing area, and / or reference content is obtained from the reference area and added to the formula editing area, thereby forming the formula content.

5. The method according to claim 3, characterized in that After generating the first interface, the method further includes: In response to an add operation on the first area, a second area is generated, and the add formula option is displayed through the second area.

6. The method according to claim 5, characterized in that The second area includes multiple options and a search area, keyword information is obtained through the search area, and the multiple options in the second area are filtered according to the keyword information.

7. The method according to claim 3, characterized in that The formula content is displayed in the first interface via the first area; after obtaining the input formula content, the method further includes: determining whether the first region has reached an upper limit set for the variable; In response to reaching the variable setting upper limit, the formula content is overwritten with the corresponding variable in the first area according to the setting, or the selection of any variable in the first area is determined and the formula content is overwritten with the selected variable.

8. The method according to claim 7, characterized in that After obtaining the input formula content, the method further includes: Determining whether the formula content meets the format requirements of the first region; In response to not meeting the format requirement, the formula content is displayed differently and a first prompt is generated.

9. The method according to claim 1, characterized in that After obtaining the input formula content, the method further includes: In response to adjusting a predecessor node of the target node in the workflow, performing a reference check on the target node based on the adjusted predecessor node; In response to the target node failing the reference check, an error content of a reference error is determined, the error content is displayed distinctively, and a second prompt is generated.

10. The method according to claim 1, characterized in that The response to the execution of the workflow includes: In response to satisfying the triggering condition of the workflow, data processing is performed according to the workflow to generate a running record.

11. The method according to claim 10, characterized in that After generating the operation record, the method further includes: In response to a query operation on the operation log of the workflow, generating a third interface, the third interface including at least one of the operation records; In response to a viewing operation on any of the operation records in the third interface, generating a third area, and displaying the formula content in the third area; In response to a selection operation on any of the operation records in the third interface, operation data of the selected operation record is displayed in the third interface.

12. The method according to claim 1, characterized in that After obtaining the input formula content, the method further includes: Detecting the formula content, and generating a third prompt if the data size of the formula content exceeds a set threshold; The calculation result of the formula content is tested, and if the data size of the calculation result exceeds a set threshold, a fourth prompt is generated.

13. A workflow setting device in a table, characterized in that: include: A first module is configured to generate a workflow in response to a creation operation in a table, wherein the workflow includes at least one node and is configured to execute an automated process based on data in the table; The second module is configured to obtain input formula content in response to a configuration operation on a target node, where the formula content includes field information of a table; The third module is configured to generate a calculation result based on the formula content in response to the execution of the workflow, and include the calculation result in the output content of the workflow.

14. An electronic device, characterized in that: The method comprises a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method according to any one of claims 1 to 12 when executing the computer program.

15. A non-transitory computer-readable storage medium, characterized in that The non-transitory computer-readable storage medium stores computer instructions for causing a computer to implement the method according to any one of claims 1 to 12.

16. A computer program product, characterized in that The method comprises computer program instructions, which, when executed on a computer, cause the computer to implement the method according to any one of claims 1 to 12.

Images