WO2023072203A1 - 表格处理方法、装置、电子设备、介质及程序产品 - Google Patents

表格处理方法、装置、电子设备、介质及程序产品 Download PDF

Info

Publication number
WO2023072203A1
WO2023072203A1 PCT/CN2022/127991 CN2022127991W WO2023072203A1 WO 2023072203 A1 WO2023072203 A1 WO 2023072203A1 CN 2022127991 W CN2022127991 W CN 2022127991W WO 2023072203 A1 WO2023072203 A1 WO 2023072203A1
Authority
WO
WIPO (PCT)
Prior art keywords
trigger
control
workflow
time
target
Prior art date
Application number
PCT/CN2022/127991
Other languages
English (en)
French (fr)
Inventor
陈颖媛
Original Assignee
北京字跳网络技术有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 北京字跳网络技术有限公司 filed Critical 北京字跳网络技术有限公司
Priority to EP22886078.9A priority Critical patent/EP4339753A1/en
Priority to CA3234088A priority patent/CA3234088A1/en
Priority to AU2022374279A priority patent/AU2022374279A1/en
Publication of WO2023072203A1 publication Critical patent/WO2023072203A1/zh
Priority to US18/518,062 priority patent/US20240086631A1/en

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21—Design, administration or maintenance of databases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
    • G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
    • G06F3/04842—Selection of displayed objects or displayed text elements
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Definitions

  • the present application relates to the field of computer technology, and in particular to a table processing method, device, electronic equipment, media and program product.
  • the database table product can provide users with customizable rules, which can include trigger conditions and trigger operations, and the specified trigger operations can be automatically executed when the trigger conditions are met.
  • the database table can remind the designated personnel to modify the corresponding records in the table before the deadline, so it can be applied to scenarios such as task/order management.
  • the above method is not applicable.
  • the present application provides a form processing method, device, electronic equipment, media and program products.
  • a form processing method including:
  • the trigger condition is associated with the data content or time of the online form
  • the trigger operation is associated with the data content or target object of the online form
  • the trigger condition is triggered based on a preset time, then perform the trigger operation according to the preset time; or,
  • the trigger operation is executed according to the time recorded in the online form.
  • the method further includes:
  • the trigger operation is executed when the data content recorded in the online form is updated.
  • the triggering operation includes an operation of sending a message
  • the execution of the trigger operation includes:
  • the target object includes: target user and/or target group.
  • performing the triggering operation according to the time recorded in the online form includes:
  • the workflow interface includes a first area displaying condition controls and a second area displaying operation controls.
  • the first area displays at least one condition control corresponding to a preset trigger condition
  • Receive trigger conditions on the workflow interface including:
  • the preset time is set in response to a time setting operation.
  • the second area displays at least one operation control corresponding to a preset trigger operation
  • Receive trigger operations on the workflow interface including:
  • workflow interface after the workflow interface is displayed, it further includes:
  • a third control panel is generated in the first area, the third control panel and the second control panel have a space in the first area connection relation.
  • workflow interface after the workflow interface is displayed, it further includes:
  • a sixth control panel In response to a trigger operation on a preset control other than the fifth control panel, a sixth control panel is generated in the second area, and there is a space between the sixth control panel and the fifth control panel in the second area connection relation.
  • condition control in the first area is in an activated state
  • operation control in the second area is in an inactive state
  • the method also includes:
  • the operation control in the second area is activated.
  • the displaying the workflow interface in response to the operation on the target control in the online form includes:
  • the displaying the workflow interface in response to the operation on the target control in the online form includes:
  • a workflow creation interface is displayed; the workflow creation interface is located above the interface of the online form through a floating layer;
  • the workflow creation interface is replaced with a workflow interface.
  • the online form is a database form, including one or more data tables, and the data tables include one or more table views.
  • a form processing device including:
  • the workflow interface display module is used for displaying the workflow interface in response to the operation on the target control in the online form
  • a receiving module configured to receive a trigger condition and a trigger operation on the workflow interface, the trigger condition is associated with the data content or time of the online form, and the trigger operation is associated with the data content or target object of the online form Associated;
  • a first trigger module configured to execute the trigger operation according to the preset time if the trigger condition is triggered based on the preset time
  • the second trigger module is configured to execute the trigger operation according to the time recorded in the online form if the trigger condition is triggered based on the time recorded in the online form.
  • the device also includes:
  • the third triggering module is configured to execute the triggering operation when the data content recorded in the online form is updated if the trigger condition is triggered based on the update of the data content recorded in the online form.
  • the triggering operation includes an operation of sending a message
  • the first trigger module, the second trigger module and the third trigger module implement the trigger operation through the following steps:
  • the target object includes: target user and/or target group.
  • the second trigger module is specifically configured to: if the trigger condition is triggered based on the time recorded in the online form, according to the time recorded in the online form and preset in the trigger condition The target time period is used to determine the trigger time; when the trigger time arrives, the trigger operation is executed.
  • the workflow interface includes a first area displaying condition controls and a second area displaying operation controls.
  • the first area displays at least one condition control corresponding to a preset trigger condition
  • the receiving module is specifically configured to receive trigger conditions on the workflow interface through the following steps:
  • the preset time is set in response to a time setting operation.
  • the second area displays at least one operation control corresponding to a preset trigger operation
  • the receiving module is specifically configured to receive trigger operations on the workflow interface through the following steps:
  • the device also includes:
  • a first control panel replacement module configured to replace the first control panel with a second control panel in response to a trigger operation on the conditional control in the first control panel in the first area
  • a first control panel generating module configured to generate a third control panel in the first area in response to a trigger operation on a preset control other than the second control panel, and the third control panel is the same as the first control panel.
  • the two control panels have a spatial relationship in the first area.
  • the device also includes:
  • a second control panel replacement module configured to replace the fourth control panel with a fifth control panel in response to a trigger operation on the operation control in the fourth control panel in the second area;
  • the second control panel generating module is configured to generate a sixth control panel in the second area in response to a trigger operation on a preset control other than the fifth control panel, and the sixth control panel is the same as the first control panel.
  • the five-control panel has a spatial association in the second area.
  • condition control in the first area is in an activated state
  • operation control in the second area is in an inactive state
  • the device also includes:
  • the control activation module is configured to activate the operation control in the second area in response to the conditional control in the first area being triggered.
  • the workflow interface display module is specifically configured to display a workflow creation interface in response to a trigger operation on a target control in the online form; in response to the first creation control or The trigger operation of the second creation control displays the workflow interface, wherein the first creation control is used to create a custom workflow, and the second creation control is used to create a preset template workflow.
  • the workflow interface display module is specifically configured to display a workflow creation interface in response to a trigger operation on a target control in the online form; the workflow creation interface is located in the online form through a floating layer On the interface; in response to a trigger operation on the preset creation control in the workflow creation interface, replace the workflow creation interface with a workflow interface.
  • the online form is a database form, including one or more data tables, and the data tables include one or more table views.
  • an electronic device including: a processor, the processor is configured to execute a computer program stored in a memory, and when the computer program is executed by the processor, the method described in the first aspect is implemented .
  • a computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the method described in the first aspect is implemented.
  • a computer program product which causes the computer to execute the method described in the first aspect when the computer program product is run on a computer.
  • the trigger condition can also be triggered based on the time recorded in the online form, that is, according to the online form Execute the corresponding trigger action at the time recorded in . For example, when the time recorded in the online form arrives, a corresponding trigger operation can be performed. Therefore, the trigger time setting of the workflow is more flexible, which can meet the needs of more business scenarios, such as order expiration reminders and so on.
  • FIG. 1 shows a schematic diagram of the system architecture of an exemplary application environment that can be applied to the table processing method of the embodiment of the present application;
  • Fig. 2 is a kind of flowchart of form processing method in the embodiment of the present application.
  • Fig. 3 is a kind of flowchart of establishing workflow in the embodiment of the present application.
  • FIG. 4A is a schematic diagram of a workflow creation interface in an embodiment of the present application.
  • FIG. 4B is a schematic diagram of the workflow interface in the embodiment of the present application.
  • Fig. 5 is another schematic diagram of the workflow interface in the embodiment of the present application.
  • Fig. 6 is another flow chart of the table processing method in the embodiment of the present application.
  • Fig. 7 is another schematic diagram of the workflow interface in the embodiment of the present application.
  • Fig. 8 is another schematic diagram of the workflow interface in the embodiment of the present application.
  • FIG. 9 is a schematic structural diagram of a form processing device in an embodiment of the present application.
  • FIG. 10 is a schematic structural diagram of an electronic device in an embodiment of the present application.
  • FIG. 1 shows a schematic diagram of a system architecture of an exemplary application environment that can be applied to the form processing method of the embodiment of the present application.
  • a system architecture 100 may include one or more of a terminal device 101 , a terminal device 102 , and a terminal device 103 , a network 104 and a server 105 .
  • the network 104 is used as a medium for providing communication links between the terminal device 101 , the terminal device 102 , the terminal device 103 and the server 105 .
  • Network 104 may include various connection types, such as wires, wireless communication links, or fiber optic cables, among others.
  • the terminal device 101, the terminal device 102, and the terminal device 103 may be various electronic devices, including but not limited to desktop computers, portable computers, smart phones, and tablet computers. It should be understood that the numbers of terminal devices, networks and servers in Fig. 1 are only illustrative. According to implementation needs, there can be any number of terminal devices, networks and servers.
  • the server 105 may be a server cluster composed of multiple servers.
  • the form processing method provided in the embodiment of the present application is generally executed by the server 105 , and accordingly, the form processing device may be set in the server 105 .
  • the table processing method provided in the embodiment of the present application may also be executed by the terminal device 101 , the terminal device 102 , and the terminal device 103 .
  • the terminal device 101 , the terminal device 102 , and the terminal device 103 may pre-establish a workflow, the workflow includes trigger conditions and trigger operations, and upload the workflow to the server 105 .
  • the server 105 acquires the trigger condition and trigger operation in the workflow, if it is determined that the trigger condition is triggered based on the time recorded in the online form, the trigger operation is executed according to the time recorded in the online form.
  • Fig. 2 is a flow chart of the form processing method in the embodiment of the present application, which may include the following steps:
  • Step S210 displaying the workflow interface in response to the operation on the target control in the online form.
  • the online form is a form that can be edited online, and can support online editing by one or more people, for example, it can be a database form.
  • An online form can include one or more data tables, multiple data tables can be located in different sheets, and a data table can include one or more table views. Table view is used to display the transformation of data in the data table.
  • an entry for establishing a workflow may be included, and the entry is a target control.
  • a workflow interface may be displayed.
  • Workflow refers to the automated workflow of database tables. Users can establish workflows that meet business needs according to business needs. Through workflow, table operations can be specified to trigger automatic data update, automatic notification reminders, and scheduled tasks to reduce cumbersome manual operations.
  • Each workflow may include a trigger condition and a trigger operation, and when the trigger condition is met, the corresponding trigger operation may be executed.
  • Step S220 receiving trigger conditions and trigger operations on the workflow interface.
  • Trigger conditions can include time trigger conditions and data change trigger conditions. Time trigger conditions are triggered when the preset deadline is reached, and data change trigger conditions are triggered when the data in the online form changes. triggering conditions. Therefore, the trigger condition can be associated with the data content or time of the online form.
  • the cut-off time can be set in the workflow interface, for example, the preset time can be directly set as the cut-off time, or the time contained in the online form can be used as the cut-off time, for example, the time field can be selected in the online form, and the The time corresponding to the time field is used as the deadline.
  • the trigger operation can be performed according to the time corresponding to the time field recorded in the online form.
  • the order management data table contains the order expiration time field.
  • the trigger operation can be performed directly according to the time corresponding to the order expiration time field in the order management data table, and the user does not need to check the time corresponding to the order expiration time field from the order management data table, and then set the time in the trigger condition , which can simplify the setting process of trigger time.
  • the process of setting the trigger time can be further simplified.
  • the trigger operation may include a trigger operation of sending a message to a target object, and an operation of modifying data in the online form. Therefore, the trigger operation is associated with the data content of the online form or the target object.
  • the target object may include target users and/or target groups. That is, the application may support sending messages to one or more users, and may also support sending messages to one or more groups.
  • Step S230 if the trigger condition is based on a preset time, then perform a trigger operation according to the preset time.
  • the trigger operation can be executed when the preset time arrives. It is also possible to use the preset time as the intermediate time, set the target time period when setting the preset time, and provide the function of triggering based on the preset time ahead of the target time period.
  • Step S240 if the trigger condition is triggered based on the time recorded in the online form, perform a trigger operation according to the time recorded in the online form.
  • the trigger operation can be executed when the time recorded in the online form arrives. It can also be used as an intermediate time to provide the ability to trigger N days, Y hours, and M minutes in advance, and N, Y, and M are all positive integers.
  • the user can set trigger conditions and trigger operations in the workflow interface corresponding to the online form.
  • the trigger condition can also be based on the records recorded in the online form. Time is triggered, that is, the corresponding trigger operation can be performed according to the time recorded in the online form. For example, when the time recorded in the online form arrives, a corresponding trigger operation can be performed. Therefore, the trigger time setting of the workflow is more flexible, which can meet the needs of more business scenarios, such as order expiration reminders and so on.
  • Fig. 3 is a flow chart of establishing workflow in the embodiment of the present application, that is, a flow chart of the method for establishing workflow in the embodiment of Fig. 2, which may include the following steps:
  • Step S310 displaying the workflow interface in response to the operation on the target control in the online form.
  • the online form may include an automated workflow entry, that is, a target control, through which the user can enter the workflow interface. After the user triggers the target control, he can directly enter the workflow interface, or enter the workflow creation interface first, and then enter the workflow interface after the user performs a trigger operation in the workflow creation interface.
  • an automated workflow entry that is, a target control, through which the user can enter the workflow interface. After the user triggers the target control, he can directly enter the workflow interface, or enter the workflow creation interface first, and then enter the workflow interface after the user performs a trigger operation in the workflow creation interface.
  • the workflow creation interface in response to the trigger operation on the target control in the online form, is displayed; in response to the trigger operation on the first creation control or the second creation control in the workflow creation interface, the display Workflow interface.
  • the first creation control is used to create a custom workflow
  • the second creation control is used to create a preset template workflow.
  • users can be provided with multiple different preset template workflows, and different template workflows correspond to different second creation controls.
  • the user can directly trigger the second Create a control and select the corresponding template workflow.
  • the user can trigger the first creation control to create a new custom workflow. For example, create a new workflow by clicking the "Add Custom Process" button.
  • Figure 4A is a schematic diagram of the workflow creation interface in the embodiment of the present application, including a first creation control for creating custom workflows, and five second creation controls for creating template workflows .
  • the user can select the first creation control or the second creation control according to actual needs.
  • a workflow creation interface in response to a trigger operation on the target control in the online form, a workflow creation interface is displayed; wherein, the workflow creation interface may be located on the interface of the online form through a floating layer. That is, the workflow creation interface may be a newly added independent interface. The user can update the interface during subsequent operations.
  • the workflow creation interface is replaced with the workflow creation interface.
  • the preset creation control may be the aforementioned first creation control or the second creation control.
  • the workflow interface may include a first area displaying condition controls and a second area displaying operation controls.
  • the first area may display at least one condition control corresponding to a preset trigger condition
  • the second area may display at least one operation control corresponding to a preset trigger operation.
  • Fig. 4B is a schematic diagram of the workflow interface in the embodiment of the present application.
  • the workflow interface includes two areas on the left and right. ", "When the time in the record is reached” and “Timing trigger” four condition controls, respectively corresponding to four preset trigger conditions, the user can select the desired trigger condition. On the right is the second area, which displays three operation controls of "send message”, “add record” and “modify record”, which correspond to three preset trigger operations respectively, and the user can select the desired trigger operation. It can be understood that the type and quantity of the condition controls and operation controls in the workflow interface may not be limited thereto.
  • Step S320 in response to a trigger operation on the first target condition control in the condition controls, select a trigger condition based on the time recorded in the table from preset trigger conditions.
  • the first target condition control is a condition control in the first area
  • the corresponding trigger condition is: trigger based on the time recorded in the online form, for example, the condition control in Figure 4B "time in the record When" is the first target condition control.
  • a table selection interface may be displayed, and the user may further select a table in the table selection interface.
  • Step S330 in response to the table selection operation, select the target table from the online tables.
  • Step S340 selecting the target time field from the target table in response to the time field selecting operation.
  • the target table is the table in the online form, which contains the time field that the user wants to select. By selecting the target table and target time field, the trigger condition setting is completed.
  • FIG. 5 is another schematic diagram of the workflow interface in the embodiment of the present application.
  • a form selection button can be displayed.
  • the user can continue to perform the table selection operation to select the target table, that is, data table A.
  • the user may further select a target time field from the target table, and the target time field has a corresponding time, and the target time field shown in FIG. 5 is "expiration date”.
  • Step S350 in response to the selection operation on the second target condition control in the condition controls, select a trigger condition based on timing trigger from preset trigger conditions.
  • the user can also trigger the second target condition control, and select a trigger condition based on a preset time for triggering.
  • the condition control "timing trigger" in FIG. 4B is the second target condition control. After that, the user can further set the preset time.
  • Step S360 setting a preset time in response to the time setting operation.
  • the condition control in the first area when the user sets the trigger condition, the condition control in the first area is in an activated state, and at this time, the operation control in the second area may be in an inactive state. That is, the user can first set the trigger condition in order and then set the trigger operation. If the trigger condition is not set, the trigger operation cannot be set.
  • step S370 in response to a trigger operation directed at the target operation control in the operation controls, the trigger operation is selected from preset trigger operations.
  • the trigger operation may be further selected from preset trigger operations, that is, the trigger operation in the workflow of the embodiment in FIG. 2 .
  • the triggering operation may be one or more of multiple preset triggering operations.
  • the triggering action can be modifying a record and sending a message, that is, the message can be sent while the record is being modified.
  • the interfaces in the first area and the second area can also be updated synchronously.
  • the first control panel is replaced with the second control panel.
  • the left side is the first area
  • the gray area in the first area can be the first control panel, which includes four conditional controls, and the user performs a trigger operation on any conditional control
  • the first control panel can be updated to the second control panel.
  • the corresponding second control panel will also be different.
  • the user can set one preset trigger condition, or set multiple preset trigger conditions. If multiple preset trigger conditions are set, the trigger operation is executed when multiple preset trigger conditions are met at the same time. For example, the user can perform a trigger operation on the preset control to set multiple preset trigger conditions. In response to a trigger operation on a preset control other than the second control panel, a third control panel is generated in the first area.
  • the first area includes a "+” control
  • the "+" control is a preset control.
  • the user can generate a third control panel in the first area, wherein the third The control panel and the second control panel may have a spatial relationship in the first area. In this way, the user can respectively select preset trigger conditions in the second control panel and the third control panel.
  • the fourth control panel In response to a trigger operation on the operation controls in the fourth control panel in the second area, the fourth control panel is replaced with the fifth control panel.
  • a sixth control panel In response to a trigger operation on a preset control other than the fifth control panel, a sixth control panel is generated in the second area, and the sixth control panel and the fifth control panel have a spatial correlation in the second area.
  • the update of the control panel in the second area is similar to the update of the control panel in the first area.
  • the workflow can be enabled by default, or an "Enable” button can be provided for the user, and the workflow can be enabled after the user clicks the "Enable” button.
  • trigger operations can be automatically executed according to the trigger conditions in the workflow.
  • FIG. 6 is another flow chart of the form processing method in the embodiment of the present application, which may include the following steps:
  • Step S610 displaying the workflow interface in response to the operation on the target control in the online form.
  • Step S620 receiving a trigger condition and a trigger operation on the workflow interface, the trigger condition is associated with the data content or time of the online form, and the trigger operation is associated with the data content or the target object of the online form.
  • Step S630 if the trigger condition is based on a preset time, then perform a trigger operation according to the preset time.
  • steps S610-S630 are the same as the steps S210-S230 in the embodiment of FIG. 2, and details can be referred to the description in the embodiment of FIG. 2, and will not be repeated here.
  • Step S640 if the trigger condition is triggered based on the time recorded in the online form, perform a trigger operation according to the time recorded in the online form.
  • the time recorded in the online form can be directly used as the trigger time, or the trigger time can be determined according to the time recorded in the online form and the preset target time period in the trigger condition; when the trigger time arrives, Execute the trigger action.
  • the target time period can be set in minutes, hours, days, weeks or months. For example, if the time recorded in the online form is 8:00 on October 12, and the target time period is 5 minutes, then the trigger operation can be executed when 7:55 on October 12 arrives. You can also perform trigger operations when you arrive at 8:05 on October 12. That is, according to actual needs, the trigger operation may be executed in advance or delayed.
  • FIG. 7 is another schematic diagram of the workflow interface in the embodiment of the present application.
  • the user can use the time corresponding to the target time field as the trigger time, or can select the target time period to be advanced or delayed.
  • the set trigger time can be when the time recorded in the online form arrives, or when the time arrives earlier or later than the target time period hour. If the time corresponding to the target time field is inaccurate, you can set a specified trigger time, for example, it can be a few minutes of the day, or a few minutes ahead or behind the target time period, etc.
  • Step S650 if the trigger condition is triggered based on the update of the data content recorded in the online form, a trigger operation is performed when the data content recorded in the online form is updated.
  • step S630 and step S640 both belong to the trigger condition of time, and this application also provides the trigger condition of data change.
  • the user can select a data change trigger condition, for example, in FIG. 4B , can select "when the record content is changed" or "when a table record is added".
  • the update of the data content recorded in the online form may include not only the change of record content, the addition of form records, but also the deletion of form records and so on.
  • the trigger condition is triggered based on the update of the data recorded in the online form, and the trigger action is "add record” or "modify record”
  • the form corresponding to the trigger condition and the form corresponding to the trigger operation can be different forms. For example, if the data content in table A changes, it can trigger to modify the data content in table B, or trigger to add the data content in table C, etc.
  • the triggering operation may include the operation of sending a message.
  • a preset message may be sent to a target object in a pre-associated instant messaging application; wherein, the target object includes: a target user and/or a target group . That is, the application can support selecting users and groups as sending objects. If the sending object is a target group, the preset message will be sent to every user in the target group. When the number of users in the target group increases or decreases, when sending a preset message, the latest member list in the target group at the time of triggering shall prevail, and the user does not need to manually adjust the sending object.
  • Fig. 8 is another schematic diagram of the workflow interface in the embodiment of the present application.
  • the trigger operation is the operation of sending a message
  • the user selects "send message" from multiple preset trigger operations After that, you can further set the sending object and the preset message to be sent. Selecting a target object in response to a selection operation performed by the user on the target object in the instant messaging application on the workflow interface; and editing and generating a preset message in response to a message editing operation performed by the user on the workflow interface.
  • the target object when selecting the target object, can be directly selected from the instant messaging application, or the personnel field can be selected from the table, and the personnel name of the user corresponding to the personnel field can be the same as the personnel name of the user in the instant messaging application.
  • the trigger condition in the pre-established workflow may be triggered based on the time recorded in the online form, that is, the corresponding trigger operation may be performed according to the time recorded in the online form. For example, when the time recorded in the online form arrives, a corresponding trigger operation can be performed.
  • the time recorded in the online form can also be used as the intermediate time to provide the ability to trigger in advance or behind the preset target time period. It can be seen that the trigger time setting of the workflow is more flexible, which can meet the needs of more business scenarios, such as order expiration reminders and so on.
  • the trigger operation is the operation of sending a message
  • the group members change, there is no need to manually modify the sending object, which avoids the problems of untimely information synchronization and information leakage due to the failure to change the sending object in time.
  • the embodiment of the present application also provides a form processing device.
  • the form processing device 900 includes:
  • a workflow interface display module 910 configured to display the workflow interface in response to the operation on the target control in the online form
  • the receiving module 920 is configured to receive a trigger condition and a trigger operation on the workflow interface, the trigger condition is associated with the data content or time of the online form, and the trigger operation is associated with the data content or target object of the online form;
  • the first trigger module 930 is configured to execute a trigger operation according to the preset time if the trigger condition is triggered based on the preset time;
  • the second trigger module 940 is configured to execute a trigger operation according to the time recorded in the online form if the trigger condition is triggered based on the time recorded in the online form.
  • the above form processing apparatus 900 further includes:
  • the third trigger module is configured to execute a trigger operation when the data content recorded in the online form is updated if the trigger condition is triggered based on the update of the data content recorded in the online form.
  • the triggering operation includes an operation of sending a message
  • the first trigger module 930, the second trigger module 940 and the third trigger module implement the trigger operation through the following steps:
  • the target object includes: a target user and/or a target group.
  • the second trigger module 940 is specifically configured to determine the trigger time according to the time recorded in the online form and the preset target time period in the trigger condition if the trigger condition is triggered based on the time recorded in the online form; When the trigger time arrives, the trigger operation is executed.
  • the workflow interface includes a first area displaying condition controls and a second area displaying operation controls.
  • At least one condition control corresponding to the preset trigger condition is displayed in the first area;
  • the receiving module 920 is specifically configured to implement receiving trigger conditions on the workflow interface through the following steps:
  • a preset time is set.
  • the second area displays at least one operation control corresponding to the preset trigger operation
  • the receiving module 920 is specifically configured to implement receiving trigger operations on the workflow interface through the following steps:
  • a trigger operation is selected from preset trigger operations.
  • the above form processing apparatus 900 further includes:
  • the first control panel replacement module is used to replace the first control panel with the second control panel in response to the trigger operation on the conditional control in the first control panel in the first area;
  • the first control panel generation module is configured to generate a third control panel in the first area in response to a trigger operation on a preset control other than the second control panel, and the third control panel and the second control panel have the same structure in the first area spatial association.
  • the above form processing apparatus 900 further includes:
  • the second control panel replacement module is used to replace the fourth control panel with the fifth control panel in response to a trigger operation on the operation controls in the fourth control panel in the second area;
  • the second control panel generating module is configured to generate a sixth control panel in the second area in response to a trigger operation on a preset control other than the fifth control panel, where the sixth control panel and the fifth control panel have a function in the second area spatial association.
  • condition control in the first area is in an activated state
  • operation control in the second area is in an inactive state
  • the above form processing apparatus 900 further includes:
  • the control activation module is configured to activate the operation control in the second area in response to the conditional control in the first area being triggered.
  • the workflow interface display module 910 is specifically configured to display the workflow creation interface in response to the trigger operation on the target control in the online form; in response to the first creation control or the second creation control in the workflow creation interface An operation is triggered to display a workflow interface, wherein the first creation control is used to create a custom workflow, and the second creation control is used to create a preset template workflow.
  • the workflow interface display module 910 is specifically configured to display the workflow creation interface in response to the trigger operation on the target control in the online form; the workflow creation interface is located on the interface of the online form through a floating layer; The trigger operation of the preset creation control in the workflow creation interface is used to replace the workflow creation interface with the workflow interface.
  • the online form is a database form, including one or more data tables, and the data table includes one or more table views.
  • an electronic device including: a processor; a memory for storing processor-executable instructions; wherein, the processor is configured to execute the above-mentioned table processing method in this exemplary embodiment .
  • FIG. 10 is a schematic structural diagram of an electronic device in an embodiment of the present application. It should be noted that the electronic device 1000 shown in FIG. 10 is only an example, and should not limit the functions and scope of use of the embodiments of the present application.
  • an electronic device 1000 includes a central processing unit (CPU) 1001, which can operate according to a program stored in a read-only memory (ROM) 1002 or a program loaded from a storage section 1008 into a random access memory (RAM) 1003 Instead, various appropriate actions and processes are performed.
  • ROM read-only memory
  • RAM random access memory
  • various programs and data necessary for system operation are also stored.
  • the central processing unit 1001, ROM 1002, and RAM 1003 are connected to each other through a bus 1004.
  • An input/output (I/O) interface 1005 is also connected to the bus 1004 .
  • the following components are connected to the I/O interface 1005: an input section 1006 including a keyboard, a mouse, etc.; an output section 1007 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker; a storage section 1008 including a hard disk, etc. and a communication section 1009 including a network interface card such as a local area network (LAN) card, a modem, or the like.
  • the communication section 1009 performs communication processing via a network such as the Internet.
  • a drive 1010 is also connected to the I/O interface 1005 as needed.
  • a removable medium 1011 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is mounted on the drive 1010 as necessary so that a computer program read therefrom is installed into the storage section 1008 as necessary.
  • the processes described above with reference to the flowcharts can be implemented as computer software programs.
  • the embodiments of the present application include a computer program product, which includes a computer program carried on a computer-readable medium, where the computer program includes program codes for executing the methods shown in the flowcharts.
  • the computer program may be downloaded and installed from a network via communication portion 1009 and/or installed from removable media 1011 .
  • the central processing unit 1001 When the computer program is executed by the central processing unit 1001, various functions defined in the apparatus of the present application are executed.
  • a computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the above table processing method is implemented.
  • the computer-readable storage medium described in this application may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to, electrical connections with one or more conductors, portable computer diskettes, hard disks, random access memory, read-only memory, erasable programmable read-only memory (EPROM) or flash memory), fiber optics, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.
  • a computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.
  • Program code contained on a computer readable storage medium may be transmitted using any appropriate medium, including but not limited to: wireless, wires, optical cables, radio frequency, etc., or any suitable combination of the above.
  • a computer program product which causes the computer to execute the above table processing method when the computer program product is run on the computer.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Human Computer Interaction (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • User Interface Of Digital Computer (AREA)
  • Stored Programmes (AREA)

Abstract

涉及一种表格处理方法、装置、电子设备、介质及程序产品，应用于计算机技术领域，方法包括：响应于对在线表格中目标控件的操作，显示工作流界面（S210）；在工作流界面接收触发条件和触发操作（S220），触发条件与在线表格的数据内容或者时间相关联，触发操作与在线表格的数据内容或目标对象相关联；如果触发条件是基于预设时间进行触发，则根据预设时间，执行触发操作（S230）；或者，如果触发条件是基于在线表格中记录的时间进行触发，则根据在线表格中记录的时间，执行触发操作（S240）。可以提高触发时间设置的灵活性，以满足更多业务场景的需求。

Description

表格处理方法、装置、电子设备、介质及程序产品
相关申请的交叉引用
本申请基于申请号为202111257767.9、申请日为2021年10月27日，名称为“表格处理方法、装置、电子设备、介质及程序产品”的中国专利申请提出，并要求该中国专利申请的优先权，该中国专利申请的全部内容在此引入本申请作为参考。
技术领域
本申请涉及计算机技术领域，尤其涉及一种表格处理方法、装置、电子设备、介质及程序产品。
背景技术
目前，数据库表格产品可以为用户提供可自定义设置的规则，规则中可以包含触发条件和触发操作，当满足触发条件时即可自动执行指定的触发操作。例如，数据库表格可以在到达截止时间前提醒指定人员修改表格内对应的记录，因此可以适用于任务/订单管理等场景。然而，对于特殊场景，上述方法并不适用。
发明内容
为了解决上述技术问题或者至少部分地解决上述技术问题，本申请提供了一种表格处理方法、装置、电子设备、介质及程序产品。
根据本申请的第一方面，提供了一种表格处理方法，包括：
响应于对在线表格中目标控件的操作，显示工作流界面；
在所述工作流界面接收触发条件和触发操作，所述触发条件与所述在线表格的数据内容或者时间相关联，所述触发操作与所述在线表格的数据内容或目标对象相关联；
如果所述触发条件是基于预设时间进行触发，则根据所述预设时间，执行所述触发操作；或者，
如果所述触发条件是基于所述在线表格中记录的时间进行触发，则根据所述在线表格中记录的时间，执行所述触发操作。
可选的，在所述工作流界面接收触发条件和触发操作之后，所述方法还包括：
如果所述触发条件是基于所述在线表格中记录的数据内容的更新进行触发， 则在所述在线表格中记录的数据内容更新的情况下，执行所述触发操作。
可选的，所述触发操作包括发送消息的操作；
所述执行所述触发操作，包括：
向预先关联的即时通讯应用中的所述目标对象发送预设消息；其中，所述目标对象包括：目标用户和/或目标群组。
可选的，所述根据所述在线表格中记录的时间，执行所述触发操作，包括：
根据所述在线表格中记录的时间以及在所述触发条件中预先设置的目标时间段，确定触发时间；
在所述触发时间到达时，执行所述触发操作。
可选的，所述工作流界面包括显示条件控件的第一区域和显示操作控件的第二区域。
可选的，所述第一区域显示与预设触发条件对应的至少一个条件控件；
在所述工作流界面接收触发条件，包括：
响应于针对所述条件控件中第一目标条件控件的触发操作，从所述预设触发条件中选取基于表格中记录的时间进行触发的触发条件；
响应于表格选取操作，从所述在线表格中选取目标表格；
响应于时间字段选取操作，从所述目标表格中选取目标时间字段；或者，
响应于针对所述条件控件中第二目标条件控件的选取操作，从所述预设触发条件中选取基于定时触发的触发条件；
响应于时间设置操作，设置所述预设时间。
可选的，所述第二区域显示与预设触发操作对应的至少一个操作控件；
在所述工作流界面接收触发操作，包括：
响应于针对所述操作控件中目标操作控件的触发操作，从所述预设触发操作中选取所述触发操作。
可选的，在所述显示工作流界面之后，还包括：
响应于对所述第一区域的第一控件面板中所述条件控件的触发操作，将所述第一控件面板替换为第二控件面板；
响应于对所述第二控件面板之外的预设控件的触发操作，在所述第一区域生成第三控件面板，所述第三控件面板与所述第二控件面板在第一区域具有空间关联关系。
可选的，在所述显示工作流界面之后，还包括：
响应于对所述第二区域的第四控件面板中所述操作控件的触发操作，将所述第四控件面板替换为第五控件面板；
响应于对所述第五控件面板之外的预设控件的触发操作，在所述第二区域生成第六控件面板，所述第六控件面板与所述第五控件面板在第二区域具有空间关联关系。
可选的，所述第一区域的条件控件处于激活状态，所述第二区域的操作控件处于未激活状态。
可选的，所述方法还包括：
响应于所述第一区域的条件控件被触发后，激活所述第二区域的操作控件。
可选的，所述响应于对在线表格中目标控件的操作，显示工作流界面，包括：
响应于对所述在线表格中目标控件的触发操作，显示工作流创建界面；
响应于对所述工作流创建界面中第一创建控件或第二创建控件的触发操作，显示所述工作流界面，其中，所述第一创建控件用于创建自定义工作流，所述第二创建控件用于创建预设模板工作流。
可选的，所述响应于对在线表格中目标控件的操作，显示工作流界面，包括：
响应于对所述在线表格中目标控件的触发操作，显示工作流创建界面；所述工作流创建界面通过浮层位于所述在线表格的界面之上；
响应于对所述工作流创建界面中预设创建控件的触发操作，使用工作流界面替换所述工作流创建界面。
可选的，所述在线表格为数据库表格，包括一个或多个数据表，所述数据表包括一个或多个表格视图。
根据本申请的第二方面，提供了一种表格处理装置，包括：
工作流界面显示模块，用于响应于对在线表格中目标控件的操作，显示工作流界面；
接收模块，用于在所述工作流界面接收触发条件和触发操作，所述触发条件与所述在线表格的数据内容或者时间相关联，所述触发操作与所述在线表格的数据内容或目标对象相关联；
第一触发模块，用于如果所述触发条件是基于预设时间进行触发，则根据所述预设时间，执行所述触发操作；
第二触发模块，用于如果所述触发条件是基于所述在线表格中记录的时间进行触发，则根据所述在线表格中记录的时间，执行所述触发操作。
可选的，所述装置还包括：
第三触发模块，用于如果所述触发条件是基于所述在线表格中记录的数据内容的更新进行触发，则在所述在线表格中记录的数据内容更新的情况下，执行所述触发操作。
可选的，所述触发操作包括发送消息的操作；
所述第一触发模块、所述第二触发模块和所述第三触发模块通过下述步骤实现执行所述触发操作：
向预先关联的即时通讯应用中的所述目标对象发送预设消息；其中，所述目标对象包括：目标用户和/或目标群组。
可选的，所述第二触发模块，具体用于如果所述触发条件是基于所述在线表格中记录的时间进行触发，根据所述在线表格中记录的时间以及在所述触发条件中预先设置的目标时间段，确定触发时间；在所述触发时间到达时，执行所述触发操作。
可选的，所述工作流界面包括显示条件控件的第一区域和显示操作控件的第二区域。
可选的，所述第一区域显示与预设触发条件对应的至少一个条件控件；
所述接收模块，具体用于通过下述步骤实现在所述工作流界面接收触发条件：
响应于针对所述条件控件中第一目标条件控件的触发操作，从所述预设触发条件中选取基于表格中记录的时间进行触发的触发条件；
响应于表格选取操作，从所述在线表格中选取目标表格；
响应于时间字段选取操作，从所述目标表格中选取目标时间字段；或者，
响应于针对所述条件控件中第二目标条件控件的选取操作，从所述预设触发条件中选取基于定时触发的触发条件；
响应于时间设置操作，设置所述预设时间。
可选的，所述第二区域显示与预设触发操作对应的至少一个操作控件；
所述接收模块具体用于通过下述步骤实现在所述工作流界面接收触发操作：
响应于针对所述操作控件中目标操作控件的触发操作，从所述预设触发操作中选取所述触发操作。
可选的，所述装置还包括：
第一控制面板替换模块，用于响应于对所述第一区域的第一控件面板中所述条件控件的触发操作，将所述第一控件面板替换为第二控件面板；
第一控制面板生成模块，用于响应于对所述第二控件面板之外的预设控件的触发操作，在所述第一区域生成第三控件面板，所述第三控件面板与所述第二控件面板在第一区域具有空间关联关系。
可选的，所述装置还包括：
第二控制面板替换模块，用于响应于对所述第二区域的第四控件面板中所述操作控件的触发操作，将所述第四控件面板替换为第五控件面板；
第二控制面板生成模块，用于响应于对所述第五控件面板之外的预设控件的触发操作，在所述第二区域生成第六控件面板，所述第六控件面板与所述第五控件面板在第二区域具有空间关联关系。
可选的，所述第一区域的条件控件处于激活状态，所述第二区域的操作控件处于未激活状态。
可选的，所述装置还包括：
控件激活模块，用于响应于所述第一区域的条件控件被触发后，激活所述第二区域的操作控件。
可选的，所述工作流界面显示模块，具体用于响应于对所述在线表格中目标控件的触发操作，显示工作流创建界面；响应于对所述工作流创建界面中第一创建控件或第二创建控件的触发操作，显示所述工作流界面，其中，所述第一创建控件用于创建自定义工作流，所述第二创建控件用于创建预设模板工作流。
可选的，所述工作流界面显示模块，具体用于响应于对所述在线表格中目标控件的触发操作，显示工作流创建界面；所述工作流创建界面通过浮层位于所述在线表格的界面之上；响应于对所述工作流创建界面中预设创建控件的触发操作，使用工作流界面替换所述工作流创建界面。
可选的，所述在线表格为数据库表格，包括一个或多个数据表，所述数据表包括一个或多个表格视图。
根据本申请的第三方面，提供了一种电子设备，包括：处理器，所述处理器用于执行存储于存储器的计算机程序，所述计算机程序被处理器执行时实现第一方面所述的方法。
根据本申请的第四方面，提供了一种计算机可读存储介质，其上存储有计算机程序，所述计算机程序被处理器执行时实现第一方面所述的方法。
根据本申请的第五方面，提供了一种计算机程序产品，当所述计算机程序产品在计算机上运行时，使得所述计算机执行第一方面所述的方法。
本申请实施例提供的技术方案与现有技术相比具有如下优点：
用户可以在在线表格对应的工作流界面中设置触发条件和触发操作，触发条件除了可以是基于预设时间进行触发外，还可以是基于在线表格中记录的时间进行触发，即，可以根据在线表格中记录的时间执行相应的触发操作。例如，可以在在线表格中记录的时间到达时，执行相应的触发操作。因此，工作流的触发时间设置更灵活，能够满足更多业务场景下的需求，例如订单到期提醒等等。
附图说明
此处的附图被并入说明书中并构成本说明书的一部分，示出了符合本申请的实施例，并与说明书一起用于解释本申请的原理。
为了更清楚地说明本申请实施例或现有技术中的技术方案，下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍，显而易见地，对于本领域普通技术人员而言，在不付出创造性劳动性的前提下，还可以根据这些附图获得其他的附图。
图1示出了可以应用于本申请实施例的表格处理方法的示例性应用环境的系统架构的示意图；
图2为本申请实施例中表格处理方法的一种流程图；
图3为本申请实施例中建立工作流的一种流程图；
图4A为本申请实施例中工作流创建界面的一种示意图；
图4B为本申请实施例中工作流界面的一种示意图；
图5为本申请实施例中工作流界面的又一种示意图；
图6为本申请实施例中表格处理方法的又一种流程图；
图7为本申请实施例中工作流界面的又一种示意图；
图8为本申请实施例中工作流界面的又一种示意图；
图9为本申请实施例中表格处理装置的一种结构示意图；
图10为本申请实施例中电子设备的一种结构示意图。
具体实施方式
为了能够更清楚地理解本申请的上述目的、特征和优点，下面将对本申请的方案进行进一步描述。需要说明的是，在不冲突的情况下，本申请的实施例及实施例中的特征可以相互组合。
在下面的描述中阐述了很多具体细节以便于充分理解本申请，但本申请还可以采用其他不同于在此描述的方式来实施；显然，说明书中的实施例只是本申请 的一部分实施例，而不是全部的实施例。
图1示出了可以应用于本申请实施例的表格处理方法的示例性应用环境的系统架构的示意图。
如图1所示，系统架构100可以包括终端设备101、终端设备102、终端设备103中的一个或多个，网络104和服务器105。网络104用以在终端设备101、终端设备102、终端设备103和服务器105之间提供通信链路的介质。网络104可以包括各种连接类型，例如有线、无线通信链路或者光纤电缆等等。终端设备101、终端设备102、终端设备103可以是各种电子设备，包括但不限于台式计算机、便携式计算机、智能手机和平板电脑等等。应该理解，图1中的终端设备、网络和服务器的数量仅仅是示意性的。根据实现需要，可以具有任意数量的终端设备、网络和服务器。比如服务器105可以是多个服务器组成的服务器集群等。
本申请实施例所提供的表格处理方法一般由服务器105执行，相应地，表格处理装置可以设置于服务器105中。但本领域技术人员容易理解的是，本申请实施例所提供的表格处理方法也可以由终端设备101、终端设备102、终端设备103执行。举例而言，终端设备101、终端设备102、终端设备103可以预先建立工作流，工作流中包括触发条件和触发操作，并将工作流上传至服务器105。
服务器105获取到工作流中的触发条件和触发操作后，如果确定触发条件为基于在线表格中记录的时间进行触发，则根据在线表格中记录的时间，执行触发操作。
以下首先对本申请实施例的表格处理方法进行详细介绍。
参见图2，图2为本申请实施例中表格处理方法的一种流程图，可以包括以下步骤：
步骤S210，响应于对在线表格中目标控件的操作，显示工作流界面。
本申请实施例中，在线表格是可以在线编辑的表格，可以支持一人或多人在线编辑，例如可以为数据库表格等。在线表格可以包括一个或多个数据表，多个数据表可以位于不同的sheet，数据表可以包括一个或多个表格视图。表格视图用于显示数据表中数据的变换情况。
在在线表格中，可以包含建立工作流的入口，该入口即为目标控件，用户对该目标控件进行触发操作后，可以显示工作流界面。工作流指的是数据库表格的自动化工作流程。用户可以根据业务需求，建立与业务需求相符合的工作流。通过工作流可以指定表格操作触发自动更新数据、自动发送通知提醒以及设置定时 任务等，来减少繁琐的人工操作。每个工作流中可以包括触发条件和触发操作，在满足触发条件的情况下，可以执行对应的触发操作。
步骤S220，在工作流界面接收触发条件和触发操作。
在工作流界面中，用户可以根据业务需求，建立对应的触发条件和触发操作。触发条件可以包括时间类触发条件和数据变更类触发条件，时间类触发条件是在到达预设的截止时间时进行触发的条件，数据变更类触发条件是在线表格中的数据发生变更的情况下进行触发的条件。因此，触发条件可以与在线表格的数据内容或者时间相关联。
其中，该截止时间可以在工作流界面中设置，例如可以直接设置预设时间作为截止时间，或者，可以将在线表格中包含的时间作为截止时间，例如可以在在线表格中选取时间字段，将该时间字段对应的时间作为截止时间。这样，可以根据在线表格中记录的时间字段对应的时间进行触发操作。
举例而言，针对订单管理场景，订单管理数据表中包含订单到期时间字段，在建立工作流时，可以选取订单管理数据表，以及订单到期时间字段。这样，可以直接根据订单管理数据表中订单到期时间字段对应的时间进行触发操作，用户无需从订单管理数据表中查看该订单到期时间字段对应的时间后，再在触发条件中设置该时间，可以简化触发时间的设置过程。尤其在在线表格中记录的时间发生变化的情况下，可以进一步简化触发时间的设置过程。
其中，触发操作可以包括向目标对象发送消息的触发操作，对在线表格中的数据进行进行修改的操作，因此，触发操作与在线表格的数据内容或目标对象相关联。其中，目标对象可以包括目标用户和/或目标群组。即，本申请可以支持向一个或多个用户发送消息，也可以支持向一个或多个群组发送消息。
步骤S230，如果触发条件是基于预设时间进行触发，则根据预设时间，执行触发操作。
如果触发条件是基于预设时间进行触发，那么在预设时间到达时，可以执行触发操作。也可以将预设时间作为中间时间，在设置预设时间时设置目标时间段，提供基于预设时间提前目标时间段进行触发的功能。
步骤S240，如果触发条件是基于在线表格中记录的时间进行触发，则根据在线表格中记录的时间，执行触发操作。
与根据预设时间执行触发操作类似，可以在在线表格中记录的时间到达时，执行触发操作。也可以以此为中间时间提供提前N天、Y小时、M分钟触发的能力， N、Y和M均为正整数。
本申请实施例的表格处理方法中，用户可以在在线表格对应的工作流界面中设置触发条件和触发操作，触发条件除了可以是基于预设时间进行触发外，还可以是基于在线表格中记录的时间进行触发，即，可以根据在线表格中记录的时间执行相应的触发操作。例如，可以在在线表格中记录的时间到达时，执行相应的触发操作。因此，工作流的触发时间设置更灵活，能够满足更多业务场景下的需求，例如订单到期提醒等等。
参见图3，图3为本申请实施例中建立工作流的一种流程图，即图2实施例中工作流的建立方法的流程图，可以包括以下步骤：
步骤S310，响应于对在线表格中目标控件的操作，显示工作流界面。
在线表格中可以包含自动化工作流入口，即目标控件，用户可以通过该目标控件进入工作流界面。用户触发目标控件后，可以直接进入工作流界面，也可以先进入工作流创建界面，用户在工作流创建界面中进行触发操作后，再进入工作流界面。
在一种可选的实施方式中，响应于对在线表格中目标控件的触发操作，显示工作流创建界面；响应于对工作流创建界面中第一创建控件或第二创建控件的触发操作，显示工作流界面。其中，第一创建控件用于创建自定义工作流，第二创建控件用于创建预设模板工作流。
在工作流创建界面中，可以为用户提供多个不同的预设模板工作流，不同的模板工作流对应不同的第二创建控件，在模板工作流符合用户实际需求时，用户可以直接触发第二创建控件选择对应的模板工作流即可。在模板工作流不符合用户实际需求时，用户可以触发第一创建控件，以创建新的自定义工作流。例如，通过点击“新增自定义流程”按钮新建工作流。
参见图4A，图4A为本申请实施例中工作流创建界面的一种示意图，包括一个用于创建自定义工作流的第一创建控件，和五个用于创建模板工作流的第二创建控件。用户可以根据实际需求选择第一创建控件或者第二创建控件。
在一种可选的实施方式中，响应于对在线表格中目标控件的触发操作，显示工作流创建界面；其中，工作流创建界面可以通过浮层位于在线表格的界面之上。即，工作流创建界面可以是新增的一个独立的界面。用户在后续操作过程中，可以对该界面进行更新。响应于对工作流创建界面中预设创建控件的触发操作，使 用工作流界面替换工作流创建界面。预设创建控件可以是前述的第一创建控件或者第二创建控件。
本申请实施例中，工作流界面可以包括显示条件控件的第一区域和显示操作控件的第二区域。第一区域可以显示与预设触发条件对应的至少一个条件控件，第二区域可以显示与预设触发操作对应的至少一个操作控件。
参见图4B，图4B为本申请实施例中工作流界面的一种示意图，工作流界面包括左右两个区域，左边为第一区域，显示有“记录内容变更时”、“新增表格记录时”、“到达记录中的时间时”和“定时触发”四个条件控件，分别对应四个预设触发条件，用户可以选择所需的触发条件。右边为第二区域，显示有“发送消息”、“新增记录”和“修改记录”三个操作控件，分别对应三个预设触发操作，用户可以选择所需的触发操作。可以理解的是，工作流界面中条件控件和操作控件的类型和数量可以不限于此。
步骤S320，响应于针对条件控件中第一目标条件控件的触发操作，从预设触发条件中选取基于表格中记录的时间进行触发的触发条件。
本申请实施例中，第一目标条件控件是第一区域中的一个条件控件，对应的触发条件是：基于在线表格中记录的时间进行触发，例如图4B中的条件控件“到达记录中的时间时”即为第一目标条件控件。在触发该条件控件后，可以显示表格选取界面，用户在该表格选取界面中可以进一步选取表格。
步骤S330，响应于表格选取操作，从在线表格中选取目标表格。
步骤S340，响应于时间字段选取操作，从目标表格中选取目标时间字段。
目标表格为在线表格中的表格，该表格中包含用户想要选取的时间字段。通过选取目标表格和目标时间字段，触发条件设置完成。
参见图5，图5为本申请实施例中工作流界面的又一种示意图，在用户选取“到达记录中的时间时”之后，可以显示表格选取按钮。用户可以继续执行表格选取操作，以选择目标表格，即数据表A。用户可以进一步从目标表格中选取目标时间字段，该目标时间字段具有对应的时间，图5所示的目标时间字段为“截止日期”。
步骤S350，响应于针对条件控件中第二目标条件控件的选取操作，从预设触发条件中选取基于定时触发的触发条件。
用户还可以触发第二目标条件控件，选择基于预设时间进行触发的触发条件，例如，图4B中的条件控件“定时触发”即为第二目标条件控件。之后，用户可以进一步设置预设时间。
步骤S360，响应于时间设置操作，设置预设时间。
本申请实施例中，用户设置触发条件时，第一区域的条件控件处于激活状态，此时，第二区域的操作控件可以处于未激活状态。也就是，用户可以按顺序先设置触发条件后设置触发操作，触发条件未设置完的情况下，不能设置触发操作。
步骤S370，响应于针对操作控件中目标操作控件的触发操作，从预设触发操作中选取所述触发操作。
在确定触发条件之后，可以进一步从预设触发操作中选取所述触发操作，即图2实施例工作流中的触发操作。类似地，触发操作可以是多个预设触发操作中的一个或多个。例如，触发操作可以是修改记录和发送消息，即可以在修改记录的同时发送消息。
可以理解的是，在用户对第一区域和第二区域中的控件进行操作时，第一区域和第二区域中的界面也可以同步更新。响应于对第一区域的第一控件面板中条件控件的触发操作，将第一控件面板替换为第二控件面板。例如，如图5所示，左边为第一区域，第一区域中的灰色区域可以为第一控件面板，该第一控件面板中包括四个条件控件，用户在对任一条件控件执行触发操作后，第一控件面板可以更新为第二控件面板。当然，用户选择不同的条件控件，对应的第二控件面板也会不同。
本申请实施例中，用户可以设置一个预设触发条件，也可以设置多个预设触发条件。如果设置多个预设触发条件，在同时满足多个预设触发条件的情况下，执行触发操作。例如，用户可以对预设控件执行触发操作，以设置多个预设触发条件。响应于对第二控件面板之外的预设控件的触发操作，在第一区域生成第三控件面板。
例如，如图5所示，第一区域中包括“+”控件，该“+”控件即为预设控件，用户通过触发该控件，可以在第一区域生成第三控件面板，其中，第三控件面板与第二控件面板在第一区域可以具有空间关联关系。这样，用户可以在第二控件面板和第三控件面板中分别选取预设触发条件。
响应于对第二区域的第四控件面板中操作控件的触发操作，将第四控件面板替换为第五控件面板。响应于对第五控件面板之外的预设控件的触发操作，在第二区域生成第六控件面板，第六控件面板与第五控件面板在第二区域具有空间关联关系。
需要说明的是，第二区域中控件面板的更新与第一区域中控件面板的更新类 似，具体参见第一区域中控件面板的更新即可，在此不再赘述。
在生成工作流时，可以默认启用该工作流，也可以为用户提供“启用”按钮，用户点击该“启用”按钮后，启用该工作流。在启用该工作流后，可以根据该工作流中的触发条件，自动执行触发操作。
参见图6，图6为本申请实施例中表格处理方法的又一种流程图，可以包括以下步骤：
步骤S610，响应于对在线表格中目标控件的操作，显示工作流界面。
步骤S620，在工作流界面接收触发条件和触发操作，触发条件与在线表格的数据内容或者时间相关联，触发操作与在线表格的数据内容或目标对象相关联。
步骤S630，如果触发条件是基于预设时间进行触发，则根据预设时间，执行触发操作。
上述步骤S610～S630与图2实施例步骤S210～S230相同，具体参见图2实施例中的描述即可，在此不再赘述。
步骤S640，如果触发条件是基于在线表格中记录的时间进行触发，则根据在线表格中记录的时间，执行触发操作。
本申请实施例中，可以直接将在线表格中记录的时间作为触发时间，也可以根据在线表格中记录的时间以及在触发条件中预先设置的目标时间段，确定触发时间；在触发时间到达时，执行触发操作。目标时间段可以以分钟、小时、天、周或月为单位进行设置。例如，在线表格中记录的时间是10月12日8：00，目标时间段为5分钟，那么，可以在10月12日7：55到达时，执行触发操作。也可以在10月12日8：05到达时，执行触发操作。即，根据实际需求，可以提前执行触发操作，也可以延后执行触发操作。
参见图7，图7为本申请实施例中工作流界面的又一种示意图，用户可以将目标时间字段对应的时间作为触发时间，或者，可以选择要提前或延后的目标时间段。需要说明的是，如果目标时间字段对应的时间比较精确，例如精确到分钟或小时，设置的触发时间可以是在在线表格中记录的时间到达时，或者提前或延后目标时间段之后的时间到达时。如果目标时间字段对应的时间不太精确，可以设置指定的触发时间，例如可以是当天几点几分，或者提前或延后目标时间段之后的的几点几分等。
步骤S650，如果触发条件是基于在线表格中记录的数据内容的更新进行触发，则在在线表格中记录的数据内容更新的情况下，执行触发操作。
上述步骤S630和步骤S640均属于时间类触发条件，本申请也提供了数据变更类触发条件。在建立工作流时，用户可以选择数据变更类触发条件，例如，在图4B中可以选择“记录内容变更时”或“新增表格记录时”。在线表格中记录的数据内容的更新除了包括：记录内容变更、新增表格记录，也可以包括删减表格记录等等。
如果触发条件是基于在线表格中记录的数据的更新进行触发，触发操作是“新增记录”或“修改记录”，触发条件所对应的表格和触发操作所对应的表格可以是不同的表格。例如，如果表格A中的数据内容发生变更时，可以触发修改表格B中的数据内容，或者触发新增表格C中的数据内容等。
本申请实施例中，触发操作可以包括发送消息的操作，可选的，可以向预先关联的即时通讯应用中的目标对象发送预设消息；其中，目标对象包括：目标用户和/或目标群组。即，本申请可以支持选择用户以及群组为发送对象。如果发送对象为目标群组，预设消息将被发送至目标群组中的每个用户。当目标群组中的用户增加或减少时，在发送预设消息时，以触发时目标群组内的最新成员名单为准，用户无需手动调整发送对象。
参见图8，图8为本申请实施例中工作流界面的又一种示意图，如果触发操作为发送消息的操作，在建立工作流时，用户从多个预设触发操作中选取“发送消息”后，还可以进一步对发送对象和发送的预设消息进行设置。响应于用户在工作流界面执行的针对即时通讯应用中目标对象的选取操作，选取目标对象；以及响应于用户在工作流界面执行的消息编辑操作，编辑生成预设消息。
其中，在选取目标对象时，可以直接从即时通讯应用中选取目标对象，也可以从表格中选取人员字段，该人员字段对应的用户的人员名称可以与即时通讯应用中该用户的人员名称相同。
本申请实施例的表格处理方法中，在预先建立的工作流中的触发条件，可以是基于在线表格中记录的时间进行触发，即，可以根据在线表格中记录的时间执行相应的触发操作。例如，可以在在线表格中记录的时间到达时，执行相应的触发操作。或者，也可以以在线表格中记录的时间为中间时间，提供提前或延后预设目标时间段进行触发的能力。可见，工作流的触发时间设置更灵活，能够满足更多业务场景下的需求，例如订单到期提醒等等。在触发操作为发送消息的操作时，可以以群组维度为发送对象发送预设消息，解决了大规模发送通知消息时需逐个添加每个用户的问题。并且，在群组人员变动的情况下，无需人工手动修改 发送对象，避免了由于未及时变更发送对象导致信息同步不及时，以及信息泄露的问题。
相应于上述方法实施例，本申请实施例还提供了一种表格处理装置，参见图9，表格处理装置900包括：
工作流界面显示模块910，用于响应于对在线表格中目标控件的操作，显示工作流界面；
接收模块920，用于在工作流界面接收触发条件和触发操作，触发条件与在线表格的数据内容或者时间相关联，触发操作与在线表格的数据内容或目标对象相关联；
第一触发模块930，用于如果触发条件是基于预设时间进行触发，则根据预设时间，执行触发操作；
第二触发模块940，用于如果触发条件是基于在线表格中记录的时间进行触发，则根据在线表格中记录的时间，执行触发操作。
可选的，上述表格处理装置900还包括：
第三触发模块，用于如果触发条件是基于在线表格中记录的数据内容的更新进行触发，则在在线表格中记录的数据内容更新的情况下，执行触发操作。
可选的，触发操作包括发送消息的操作；
第一触发模块930、第二触发模块940和第三触发模块通过下述步骤实现执行触发操作：
向预先关联的即时通讯应用中的目标对象发送预设消息；其中，目标对象包括：目标用户和/或目标群组。
可选的，第二触发模块940，具体用于如果触发条件是基于在线表格中记录的时间进行触发，根据在线表格中记录的时间以及在触发条件中预先设置的目标时间段，确定触发时间；在触发时间到达时，执行触发操作。
可选的，工作流界面包括显示条件控件的第一区域和显示操作控件的第二区域。
可选的，第一区域显示与预设触发条件对应的至少一个条件控件；
接收模块920，具体用于通过下述步骤实现在工作流界面接收触发条件：
响应于针对条件控件中第一目标条件控件的触发操作，从预设触发条件中选取基于表格中记录的时间进行触发的触发条件；
响应于表格选取操作，从在线表格中选取目标表格；
响应于时间字段选取操作，从目标表格中选取目标时间字段；或者，
响应于针对条件控件中第二目标条件控件的选取操作，从预设触发条件中选取基于定时触发的触发条件；
响应于时间设置操作，设置预设时间。
可选的，第二区域显示与预设触发操作对应的至少一个操作控件；
接收模块920具体用于通过下述步骤实现在工作流界面接收触发操作：
响应于针对操作控件中目标操作控件的触发操作，从预设触发操作中选取触发操作。
可选的，上述表格处理装置900还包括：
第一控制面板替换模块，用于响应于对第一区域的第一控件面板中条件控件的触发操作，将第一控件面板替换为第二控件面板；
第一控制面板生成模块，用于响应于对第二控件面板之外的预设控件的触发操作，在第一区域生成第三控件面板，第三控件面板与第二控件面板在第一区域具有空间关联关系。
可选的，上述表格处理装置900还包括：
第二控制面板替换模块，用于响应于对第二区域的第四控件面板中操作控件的触发操作，将第四控件面板替换为第五控件面板；
第二控制面板生成模块，用于响应于对第五控件面板之外的预设控件的触发操作，在第二区域生成第六控件面板，第六控件面板与第五控件面板在第二区域具有空间关联关系。
可选的，第一区域的条件控件处于激活状态，第二区域的操作控件处于未激活状态。
可选的，上述表格处理装置900还包括：
控件激活模块，用于响应于第一区域的条件控件被触发后，激活第二区域的操作控件。
可选的，工作流界面显示模块910，具体用于响应于对在线表格中目标控件的触发操作，显示工作流创建界面；响应于对工作流创建界面中第一创建控件或第二创建控件的触发操作，显示工作流界面，其中，第一创建控件用于创建自定义工作流，第二创建控件用于创建预设模板工作流。
可选的，工作流界面显示模块910，具体用于响应于对在线表格中目标控件的 触发操作，显示工作流创建界面；工作流创建界面通过浮层位于在线表格的界面之上；响应于对工作流创建界面中预设创建控件的触发操作，使用工作流界面替换工作流创建界面。
可选的，在线表格为数据库表格，包括一个或多个数据表，数据表包括一个或多个表格视图。
上述装置中各模块或单元的具体细节已经在对应的方法中进行了详细的描述，因此此处不再赘述。
应当注意，尽管在上文详细描述中提及了用于动作执行的设备的若干模块或者单元，但是这种划分并非强制性的。实际上，根据本申请的实施方式，上文描述的两个或更多模块或者单元的特征和功能可以在一个模块或者单元中具体化。反之，上文描述的一个模块或者单元的特征和功能可以进一步划分为由多个模块或者单元来具体化。
在本申请的示例性实施例中，还提供一种电子设备，包括：处理器；用于存储处理器可执行指令的存储器；其中，处理器被配置为执行本示例实施方式中上述表格处理方法。
图10为本申请实施例中电子设备的一种结构示意图。需要说明的是，图10示出的电子设备1000仅是一个示例，不应对本申请实施例的功能和使用范围带来任何限制。
如图10所示，电子设备1000包括中央处理单元(CPU)1001，其可以根据存储在只读存储器(ROM)1002中的程序或者从存储部分1008加载到随机访问存储器(RAM)1003中的程序而执行各种适当的动作和处理。在RAM 1003中，还存储有系统操作所需的各种程序和数据。中央处理单元1001、ROM 1002以及RAM 1003通过总线1004彼此相连。输入/输出(I/O)接口1005也连接至总线1004。
以下部件连接至I/O接口1005：包括键盘、鼠标等的输入部分1006；包括诸如阴极射线管(CRT)、液晶显示器(LCD)等以及扬声器等的输出部分1007；包括硬盘等的存储部分1008；以及包括诸如局域网(LAN)卡、调制解调器等的网络接口卡的通信部分1009。通信部分1009经由诸如因特网的网络执行通信处理。驱动器1010也根据需要连接至I/O接口1005。可拆卸介质1011，诸如磁盘、光盘、磁光盘、半导体存储器等等，根据需要安装在驱动器1010上，以便于从其上读出的计算机程序根据需要被安装入存储部分1008。
特别地，根据本申请的实施例，上文参考流程图描述的过程可以被实现为计 算机软件程序。例如，本申请的实施例包括一种计算机程序产品，其包括承载在计算机可读介质上的计算机程序，该计算机程序包含用于执行流程图所示的方法的程序代码。在这样的实施例中，该计算机程序可以通过通信部分1009从网络上被下载和安装，和/或从可拆卸介质1011被安装。在该计算机程序被中央处理单元1001执行时，执行本申请的装置中限定的各种功能。
本申请实施例中，还提供了一种计算机可读存储介质，其上存储有计算机程序，所述计算机程序被处理器执行时实现上述表格处理方法。
需要说明的是，本申请所示的计算机可读存储介质例如可以是-但不限于-电、磁、光、电磁、红外线、或半导体的系统、装置或器件，或者任意以上的组合。计算机可读存储介质的更具体的例子可以包括但不限于：具有一个或多个导线的电连接、便携式计算机磁盘、硬盘、随机访问存储器、只读存储器、可擦式可编程只读存储器(EPROM或闪存)、光纤、便携式紧凑磁盘只读存储器(CD-ROM)、光存储器件、磁存储器件、或者上述的任意合适的组合。在本申请中，计算机可读存储介质可以是任何包含或存储程序的有形介质，该程序可以被指令执行系统、装置或者器件使用或者与其结合使用。计算机可读存储介质上包含的程序代码可以用任何适当的介质传输，包括但不限于：无线、电线、光缆、射频等等，或者上述的任意合适的组合。
本申请实施例中，还提供了一种计算机程序产品，当计算机程序产品在计算机上运行时，使得计算机执行上述表格处理方法。
需要说明的是，在本文中，诸如“第一”和“第二”等之类的关系术语仅仅用来将一个实体或者操作与另一个实体或操作区分开来，而不一定要求或者暗示这些实体或操作之间存在任何这种实际的关系或者顺序。而且，术语“包括”、“包含”或者其任何其他变体意在涵盖非排他性的包含，从而使得包括一系列要素的过程、方法、物品或者设备不仅包括那些要素，而且还包括没有明确列出的其他要素，或者是还包括为这种过程、方法、物品或者设备所固有的要素。在没有更多限制的情况下，由语句“包括一个……”限定的要素，并不排除在包括所述要素的过程、方法、物品或者设备中还存在另外的相同要素。
以上所述仅是本申请的具体实施方式，使本领域技术人员能够理解或实现本申请。对这些实施例的多种修改对本领域的技术人员来说将是显而易见的，因此，本申请将不会被限制于本文所述的这些实施例，而是要符合与本文所公开的原理和新颖特点相一致的最宽的范围。

Claims (18)

  1. 一种表格处理方法，其特征在于，所述方法包括：
    响应于对在线表格中目标控件的操作，显示工作流界面；
    在所述工作流界面接收触发条件和触发操作，所述触发条件与所述在线表格的数据内容或者时间相关联，所述触发操作与所述在线表格的数据内容或目标对象相关联；
    如果所述触发条件是基于预设时间进行触发，则根据所述预设时间，执行所述触发操作；或者，
    如果所述触发条件是基于所述在线表格中记录的时间进行触发，则根据所述在线表格中记录的时间，执行所述触发操作。
  2. 根据权利要求1所述的方法，其特征在于，在所述工作流界面接收触发条件和触发操作之后，所述方法还包括：
    如果所述触发条件是基于所述在线表格中记录的数据内容的更新进行触发，则在所述在线表格中记录的数据内容更新的情况下，执行所述触发操作。
  3. 根据权利要求1或2所述的方法，其特征在于，所述触发操作包括发送消息的操作；
    所述执行所述触发操作，包括：
    向预先关联的即时通讯应用中的所述目标对象发送预设消息；其中，所述目标对象包括：目标用户和/或目标群组。
  4. 根据权利要求1所述的方法，其特征在于，所述根据所述在线表格中记录的时间，执行所述触发操作，包括：
    根据所述在线表格中记录的时间以及在所述触发条件中预先设置的目标时间段，确定触发时间；
    在所述触发时间到达时，执行所述触发操作。
  5. 根据权利要求1所述的方法，其特征在于，所述工作流界面包括显示条件控件的第一区域和显示操作控件的第二区域。
  6. 根据权利要求5所述的方法，其特征在于，所述第一区域显示与预设触发条件对应的至少一个条件控件；
    在所述工作流界面接收触发条件，包括：
    响应于针对所述条件控件中第一目标条件控件的触发操作，从所述预设触发 条件中选取基于表格中记录的时间进行触发的触发条件；
    响应于表格选取操作，从所述在线表格中选取目标表格；
    响应于时间字段选取操作，从所述目标表格中选取目标时间字段；或者，
    响应于针对所述条件控件中第二目标条件控件的选取操作，从所述预设触发条件中选取基于定时触发的触发条件；
    响应于时间设置操作，设置所述预设时间。
  7. 根据权利要求5所述的方法，其特征在于，所述第二区域显示与预设触发操作对应的至少一个操作控件；
    在所述工作流界面接收触发操作，包括：
    响应于针对所述操作控件中目标操作控件的触发操作，从所述预设触发操作中选取所述触发操作。
  8. 根据权利要求5所述的方法，其特征在于，在所述显示工作流界面之后，还包括：
    响应于对所述第一区域的第一控件面板中所述条件控件的触发操作，将所述第一控件面板替换为第二控件面板；
    响应于对所述第二控件面板之外的预设控件的触发操作，在所述第一区域生成第三控件面板，所述第三控件面板与所述第二控件面板在第一区域具有空间关联关系。
  9. 根据权利要求5所述的方法，其特征在于，在所述显示工作流界面之后，还包括：
    响应于对所述第二区域的第四控件面板中所述操作控件的触发操作，将所述第四控件面板替换为第五控件面板；
    响应于对所述第五控件面板之外的预设控件的触发操作，在所述第二区域生成第六控件面板，所述第六控件面板与所述第五控件面板在第二区域具有空间关联关系。
  10. 根据权利要求5所述的方法，其特征在于，所述第一区域的条件控件处于激活状态，所述第二区域的操作控件处于未激活状态。
  11. 根据权利要求10所述的方法，其特征在于，还包括：
    响应于所述第一区域的条件控件被触发后，激活所述第二区域的操作控件。
  12. 根据权利要求1所述的方法，其特征在于，所述响应于对在线表格中目标控件的操作，显示工作流界面，包括：
    响应于对所述在线表格中目标控件的触发操作，显示工作流创建界面；
    响应于对所述工作流创建界面中第一创建控件或第二创建控件的触发操作，显示所述工作流界面，其中，所述第一创建控件用于创建自定义工作流，所述第二创建控件用于创建预设模板工作流。
  13. 根据权利要求1所述的方法，其特征在于，所述响应于对在线表格中目标控件的操作，显示工作流界面，包括：
    响应于对所述在线表格中目标控件的触发操作，显示工作流创建界面；所述工作流创建界面通过浮层位于所述在线表格的界面之上；
    响应于对所述工作流创建界面中预设创建控件的触发操作，使用工作流界面替换所述工作流创建界面。
  14. 根据权利要求1所述的方法，其特征在于，所述在线表格为数据库表格，包括一个或多个数据表，所述数据表包括一个或多个表格视图。
  15. 一种表格处理装置，其特征在于，所述装置包括：
    工作流界面显示模块，用于响应于对在线表格中目标控件的操作，显示工作流界面；
    接收模块，用于在所述工作流界面接收触发条件和触发操作，所述触发条件与所述在线表格的数据内容或者时间相关联，所述触发操作与所述在线表格的数据内容或目标对象相关联；
    第一触发模块，用于如果所述触发条件是基于预设时间进行触发，则根据所述预设时间，执行所述触发操作；
    第二触发模块，用于如果所述触发条件是基于所述在线表格中记录的时间进行触发，则根据所述在线表格中记录的时间，执行所述触发操作。
  16. 一种电子设备，其特征在于，包括：处理器，所述处理器用于执行存储于存储器的计算机程序，所述计算机程序被处理器执行时实现权利要求1-14任一项所述的方法的步骤。
  17. 一种计算机可读存储介质，其上存储有计算机程序，其特征在于，所述计算机程序被处理器执行时实现权利要求1-14任一项所述的方法的步骤。
  18. 一种计算机程序产品，其特征在于，当所述计算机程序产品在计算机上运行时，使得所述计算机执行权利要求1-14任一项所述的方法的步骤。
PCT/CN2022/127991 2021-10-27 2022-10-27 表格处理方法、装置、电子设备、介质及程序产品 WO2023072203A1 (zh)

Priority Applications (4)

Application Number Priority Date Filing Date Title
EP22886078.9A EP4339753A1 (en) 2021-10-27 2022-10-27 Table processing method and apparatus, electronic device, medium, and program product
CA3234088A CA3234088A1 (en) 2021-10-27 2022-10-27 Table processing method and apparatus, electronic device, medium and program product
AU2022374279A AU2022374279A1 (en) 2021-10-27 2022-10-27 Table processing method and apparatus, electronic device, medium, and program product
US18/518,062 US20240086631A1 (en) 2021-10-27 2023-11-22 Table processing method and apparatus, electronic device, medium and program product

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN202111257767.9 2021-10-27
CN202111257767.9A CN113900561B (zh) 2021-10-27 2021-10-27 表格处理方法、装置、电子设备、介质及程序产品

Related Child Applications (1)

Application Number Title Priority Date Filing Date
US18/518,062 Continuation US20240086631A1 (en) 2021-10-27 2023-11-22 Table processing method and apparatus, electronic device, medium and program product

Publications (1)

Publication Number Publication Date
WO2023072203A1 true WO2023072203A1 (zh) 2023-05-04

Family

ID=79026546

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2022/127991 WO2023072203A1 (zh) 2021-10-27 2022-10-27 表格处理方法、装置、电子设备、介质及程序产品

Country Status (6)

Country Link
US (1) US20240086631A1 (zh)
EP (1) EP4339753A1 (zh)
CN (1) CN113900561B (zh)
AU (1) AU2022374279A1 (zh)
CA (1) CA3234088A1 (zh)
WO (1) WO2023072203A1 (zh)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113900561B (zh) * 2021-10-27 2023-07-25 北京字跳网络技术有限公司 表格处理方法、装置、电子设备、介质及程序产品
CN116226786B (zh) * 2023-03-22 2023-08-22 中国人民解放军军事科学院系统工程研究院 一种用于信息系统数据融合的数据处理方法及装置

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20200226117A1 (en) * 2019-01-10 2020-07-16 Microsoft Technology Licensing, Llc System and method for generating in-memory tabular model databases
CN112131832A (zh) * 2020-09-28 2020-12-25 北京字跳网络技术有限公司 在线文档任务状态的提醒方法、装置及电子设备
CN112632931A (zh) * 2020-08-06 2021-04-09 腾讯科技（深圳）有限公司 基于表格的任务核销方法、表格生成方法及装置
CN112965988A (zh) * 2021-02-20 2021-06-15 杭州品茗安控信息技术股份有限公司 一种数据交互方法、装置、设备及计算机可读存储介质
CN113900561A (zh) * 2021-10-27 2022-01-07 北京字跳网络技术有限公司 表格处理方法、装置、电子设备、介质及程序产品

Family Cites Families (25)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6067477A (en) * 1998-01-15 2000-05-23 Eutech Cybernetics Pte Ltd. Method and apparatus for the creation of personalized supervisory and control data acquisition systems for the management and integration of real-time enterprise-wide applications and systems
US10997531B2 (en) * 2007-09-11 2021-05-04 Ciambella Ltd. System, method and graphical user interface for workflow generation, deployment and/or execution
CN102521407B (zh) * 2011-12-28 2015-04-01 谢勇 一种多用户之间的文档协作方法
CN104348653A (zh) * 2013-08-06 2015-02-11 中国电信股份有限公司 云管理平台的用户任务实现方法、系统与触发器
WO2016138615A1 (en) * 2015-03-02 2016-09-09 Microsoft Technology Licensing, Llc Table control for progressive workflow management
WO2017155968A1 (en) * 2016-03-07 2017-09-14 3M Innovative Properties Company Intelligent safety monitoring and analytics system for personal protective equipment
US20180213048A1 (en) * 2017-01-23 2018-07-26 Microsoft Technology Licensing, Llc Secured targeting of cross-application push notifications
CN109670159A (zh) * 2018-12-28 2019-04-23 天津字节跳动科技有限公司 视图的创建及管理方法、装置、电子设备和存储介质
CN109948134B (zh) * 2019-03-21 2023-12-01 润电能源科学技术有限公司 一种报告自动生成方法、系统及电子设备和存储介质
CN110096688B (zh) * 2019-04-28 2020-09-15 浙江明度智控科技有限公司 一种基于流程图和表格的生产工序记录方法和装置
CN111258895A (zh) * 2020-01-13 2020-06-09 中汽研汽车检验中心(武汉)有限公司 执行指令处理方法、设备及存储介质
CN111401849B (zh) * 2020-03-18 2023-04-18 浩云科技股份有限公司 一种流程工具自定义节点配置方法
CN111966734A (zh) * 2020-03-30 2020-11-20 北京来也网络科技有限公司 结合rpa和ai的电子表格的数据处理方法与电子设备
CN111813391A (zh) * 2020-07-21 2020-10-23 腾讯科技（深圳）有限公司 工作流生成方法、装置、计算机设备及存储介质
CN111931464A (zh) * 2020-07-30 2020-11-13 北京字节跳动网络技术有限公司 一种文档编辑方法、装置和电子设备
CN112632942B (zh) * 2020-08-19 2021-09-28 腾讯科技（深圳）有限公司 一种文档处理方法、装置、设备及介质
CN112036736B (zh) * 2020-08-28 2023-08-01 杭州指令集智能科技有限公司 一种工作流创建方法及装置
CN112256999A (zh) * 2020-09-11 2021-01-22 长沙市到家悠享网络科技有限公司 页面显示方法、装置、设备
CN112069189B (zh) * 2020-09-16 2024-05-17 深圳市硅格半导体有限公司 多层级映射表格的更新方法、系统、终端设备及存储介质
CN112433712A (zh) * 2020-11-09 2021-03-02 金蝶软件（中国）有限公司 报表展示方法、装置、计算机设备和存储介质
CN112558957B (zh) * 2020-12-08 2024-02-13 中国联合网络通信集团有限公司 生成网页表格的方法、装置、电子设备及可读存储介质
CN112785242A (zh) * 2020-12-18 2021-05-11 成都泛微网络科技有限公司 一种数据处理方法及相关设备
CN112699151B (zh) * 2021-01-04 2022-04-22 腾讯科技（深圳）有限公司 数据处理方法、装置、设备以及介质
CN112732232A (zh) * 2021-01-13 2021-04-30 武汉晨曦芸峰科技有限公司 一种低代码在线创建与定制业务模块的方法
CN113342811A (zh) * 2021-05-31 2021-09-03 中国工商银行股份有限公司 HBase表格数据处理方法及装置

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20200226117A1 (en) * 2019-01-10 2020-07-16 Microsoft Technology Licensing, Llc System and method for generating in-memory tabular model databases
CN112632931A (zh) * 2020-08-06 2021-04-09 腾讯科技（深圳）有限公司 基于表格的任务核销方法、表格生成方法及装置
CN112131832A (zh) * 2020-09-28 2020-12-25 北京字跳网络技术有限公司 在线文档任务状态的提醒方法、装置及电子设备
CN112965988A (zh) * 2021-02-20 2021-06-15 杭州品茗安控信息技术股份有限公司 一种数据交互方法、装置、设备及计算机可读存储介质
CN113900561A (zh) * 2021-10-27 2022-01-07 北京字跳网络技术有限公司 表格处理方法、装置、电子设备、介质及程序产品

Also Published As

Publication number Publication date
CN113900561B (zh) 2023-07-25
EP4339753A1 (en) 2024-03-20
CN113900561A (zh) 2022-01-07
US20240086631A1 (en) 2024-03-14
CA3234088A1 (en) 2023-05-04
AU2022374279A1 (en) 2024-03-28

Similar Documents

Publication Publication Date Title
WO2023072203A1 (zh) 表格处理方法、装置、电子设备、介质及程序产品
JP7108646B2 (ja) 情報プッシュ方法、装置、電子デバイス、記憶媒体、及びプログラム
US20060224430A1 (en) Agenda based meeting management system, interface and method
US10956032B2 (en) Keyboard utility for inputting data into a mobile application
US11095598B2 (en) Managing messaging services
EP3629183A1 (en) Improved issue tracking systems and methods
CN112668283B (zh) 文档编辑方法、装置和电子设备
US10635559B2 (en) Maintaining data integrity over multiple applications
US11875311B2 (en) Communication platform document as a communication channel
US11526853B2 (en) Configurable settings for automatic updates of calendar items
US20190287073A1 (en) Selective update of calendar items on computing devices
CN113076186A (zh) 任务处理的方法、装置、电子设备和存储介质
US20140278677A1 (en) Enhanced scheduling based on the availabilty of sub-environments in an event environment
US20150220882A1 (en) Asset creation and utilization using an asset creation tool
CN115130442A (zh) 报表生成的方法、装置、存储介质及计算机设备
JP2024524107A (ja) フォーム処理方法、装置、電子機器、媒体及びプログラム製品
CN111178823B (zh) 居住相关事务的取消方法和装置
CN113378346A (zh) 模型仿真的方法和装置
US11088969B1 (en) Calendar based auto-reply messages
US20240111504A1 (en) Automatic Generation of Chat Applications from No-Code Application Development Platforms
US20230370405A1 (en) Method and apparatus for messaging service
US11989598B2 (en) Systems and methods for managing application data
CN111192002B (zh) 一种居住区域转移需求的处理方法和装置
US20240193549A1 (en) Determining chronotypes of users for display within a scheduling interface
KR20230160142A (ko) 할 일 목록 관리 방법 및 장치

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 22886078

Country of ref document: EP

Kind code of ref document: A1

WWE Wipo information: entry into national phase

Ref document number: 2022886078

Country of ref document: EP

ENP Entry into the national phase

Ref document number: 2023577614

Country of ref document: JP

Kind code of ref document: A

ENP Entry into the national phase

Ref document number: 2022886078

Country of ref document: EP

Effective date: 20231213

WWE Wipo information: entry into national phase

Ref document number: 2022374279

Country of ref document: AU

ENP Entry into the national phase

Ref document number: 2022374279

Country of ref document: AU

Date of ref document: 20221027

Kind code of ref document: A

WWE Wipo information: entry into national phase

Ref document number: 3234088

Country of ref document: CA

NENP Non-entry into the national phase

Ref country code: DE