Table processing method and apparatus, and electronic device and storage medium

Abstract

A table processing method, comprising: in response to a first operation event of creating a new field in a table or changing an existing first field, determining a target shortcut field, wherein the target shortcut field is a field in which data processing logic is encapsulated; and creating a new target shortcut field in the table, or, replacing the first field in the table with a target shortcut field. Further disclosed are a table processing apparatus, an electronic device and a storage medium.

Description

Table processing method and device, electronic device, and storage medium

[0001] This application claims priority to Chinese Patent Application No. 202410797354.7, filed on June 19, 2024, the disclosure of which is incorporated herein in its entirety as part of the present application. TECHNICAL FIELD

[0002] The present disclosure relates to a table processing method, device, electronic device, and storage medium. BACKGROUND

[0003] A table, such as a table in a table document or a table in a text document, has cells with fields. A field is a property of a cell that describes the type of content displayed within the cell having the property. Fields are often presented in the form of column names. For example, a date field indicates that the content displayed within the cell of the field is a date. SUMMARY

[0004] The present disclosure provides a table processing method, device, electronic device, and storage medium.

[0005] The present disclosure employs the following technical solutions.

[0006] In some embodiments, the present disclosure provides a table processing method, comprising:

[0007] In response to a first operation event of creating a new field in a table or changing an existing first field, determining a target shortcut field, the target shortcut field being a field encapsulating data processing logic;

[0008] Creating the target shortcut field in the table, or replacing a first field in the table with the target shortcut field.

[0009] In some embodiments, the present disclosure provides a table processing device, comprising:

[0010] A determining unit configured to, in response to a first operation event of creating a new field in a table or changing an existing first field, determine a target shortcut field, the target shortcut field being a field encapsulating data processing logic;

[0011] A control unit configured to create the target shortcut field in the table, or replace a first field in the table with the target shortcut field.

[0012] In some embodiments, the present disclosure provides an electronic device, comprising at least one memory and at least one processor.

[0013] The memory is configured to store program code, and the processor is configured to invoke the program code stored in the memory to execute the method described above.

[0014] In some embodiments, the present disclosure provides a computer-readable storage medium configured to store program code, which, when executed by a processor, causes the processor to execute the method described above. BRIEF DESCRIPTION OF DRAWINGS

[0015] The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent upon consideration of the following detailed description, taken in conjunction with the accompanying drawings. Throughout the drawings, like or similar reference numerals designate identical or similar elements throughout the several views. It should be understood that the drawings are schematic and elements and features are not necessarily drawn to scale.

[0016] FIG. 1 is a flowchart of a table processing method according to an embodiment of the present disclosure;

[0017] FIG. 2 is a flowchart of a table processing method according to an embodiment of the present disclosure;

[0018] FIGS. 3-9 are schematic diagrams of display interfaces according to embodiments of the present disclosure; and

[0019] FIG. 10 is a schematic diagram of the structure of an electronic device according to an embodiment of the present disclosure. DETAILED DESCRIPTION

[0020] It can be understood that, before using the technical solutions disclosed in the embodiments of the present disclosure, the type of personal information involved in the present disclosure, the range of use, the scenario of use, etc. 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.

[0021] For example, in response to receiving an active request of the user, a 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 the electronic device, the application program, the server or the storage medium, etc. that performs the operation of the technical solutions of the present disclosure according to the prompt information.

[0022] As an optional but non-limiting implementation manner, in response to receiving the active request of the user, the manner of sending the 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 a selection control for the user to select “agree” or “disagree” to provide the personal information to the electronic device.

[0023] It can be understood that the above notification and obtaining of the authorization of the user are only illustrative and do not limit the implementation manners of the present disclosure, and other manners that meet the relevant laws and regulations can also be applied to the implementation manners of the present disclosure.

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

[0025] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although some embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure can be implemented in various forms, and should not be interpreted as being limited to the embodiments set forth herein, but rather, these embodiments are provided to more thoroughly and completely understand the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are for exemplary purposes only and are not intended to limit the scope of protection of the present disclosure.

[0026] It should be understood that each step described in the method embodiments of the present disclosure can be executed in series and / or in parallel. In addition, the method embodiments can include additional steps and / or omit the execution of the steps shown. The scope of the present disclosure is not limited in this respect.

[0027] The term "comprising" and variations thereof as used herein are open-ended, that is, "comprising but not limited to". The term "based on" is "based, at least in part, on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". Related definitions for other terms will be given in the description below.

[0028] It should be noted that the concepts of "first", "second", etc. mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not intended to limit the order or interdependence of the functions performed by these devices, modules or units.

[0029] It should be noted that the modification "one" mentioned in the present disclosure is illustrative and not limiting, and those skilled in the art should understand that, unless otherwise explicitly indicated in the context, it should be understood as "one or more".

[0030] The names of the messages or information exchanged between the devices in the embodiments of the present disclosure are only for illustrative purposes, and are not intended to limit the scope of the messages or information.

[0031] The schemes provided by the embodiments of the present disclosure will be described in detail below with reference to the accompanying drawings.

[0032] As shown in FIG. 1, FIG. 1 is a flowchart of a table processing method according to an embodiment of the present disclosure, including the following steps.

[0033] S11, in response to a first operation event of creating a new field in a table or changing an existing first field, determining a target shortcut field.

[0034] In some embodiments, the table is a table in a table document or a table in a non-table document (e.g., a text document). The table can have fields, which are properties of cells in the table, usually displayed in the form of column names. For example, the table in FIG. 3 is a table with fields of “Task Description”, “Business Line”, and “Status”. A new field can be created in the table, which can be creating a new column and using the name of the new field as the column name of the column. In this case, it is necessary to know what kind of field is created. A first field in the table can be changed, in which case it is necessary to know what kind of field is changed. Therefore, in the first operation event, it is necessary to know the target shortcut field, which is the field to be created or changed. The first operation event can include one or more operations, such as including a new field operation and a target shortcut field selection operation, or including a modification field operation and a target shortcut field selection operation. The shortcut field encapsulates processing logic and can be defined with or without configurable items. The target shortcut field can be one or more selected shortcut fields, and therefore the target shortcut field encapsulates processing logic. Some fields without processing logic can be defined in advance as base fields. The shortcut field is a field obtained by performing processing logic on a base field. The processing logic can be a processing method including one or more processing operations. The configurable items can include other fields based on, parameters needed in the specific processing logic, and / or output formats, etc. For example, a text field can be a base field, and a translation field is a field that translates a specified text field into a specified language. The translation field is a shortcut field, and the data processing logic is translation. The configurable items can include the language type to be translated and the specified text field. In some embodiments of the present disclosure, the processing logic is encapsulated in the shortcut field. In this way, users can directly call the shortcut field to quickly perform complex processing logic without the need for users to write these processing logics themselves.

[0035] In some embodiments, in response to the first operation event of creating a new field in the table or changing an existing first field, the target shortcut field is determined by: in response to the operation of creating a new field or changing an existing first field, displaying a field interface, the field types in the field interface including a shortcut field; determining the target shortcut field from the shortcut field in the field interface. Specifically, when the first operation event is performed, the operation of creating a new field can be performed first, at which time the field interface (as shown in FIG. 4) can be displayed. The field types in the field interface include a shortcut field, and can also include a non-shortcut field. The shortcut field is a field encapsulating data processing logic, and the target field shortcut can be one of the field shortcuts. In other embodiments, in response to the first operation event of creating a new field in the table or changing an existing first field, the target shortcut field is determined by: in response to receiving input information of creating a new field or changing an existing first field, determining the target shortcut field from the input information. Specifically, the table can have an information input area (for example, a conversation area of an artificial intelligence program), and the user can write input information in the information input area. The input information can indicate where to create a target shortcut field or which field to change to a target shortcut field, and then (for example, an artificial intelligence program) will parse the content in the input information to determine the target shortcut field.

[0036] S12: creating a target shortcut field in the table, or replacing a first field in the table with a target shortcut field.

[0037] In some embodiments, after the target shortcut field is determined, step S12 can be performed after the generation control is triggered. If the first operation event is a new field operation event, a target shortcut field will be created in the table. Specifically, a column of cells can be added in the table, and the field attribute of the column of cells is set to the target shortcut field. In another embodiment, the first operation event is a first field change operation event, and the first field is changed to a target shortcut field. Specifically, the field attribute of the column in which the first field is located can be changed to the target shortcut field, and at this time, no cell needs to be added or deleted in the table. The field is usually displayed in the form of a column name, and the cells in the column have the field as an attribute.

[0038] In order to better illustrate the method proposed in the present disclosure, some embodiments of the present disclosure are specifically described in combination with the drawings. In some embodiments of the present disclosure, the table is one of the tables in an online table document, and there can be multiple tables in the online table document. As shown in FIG. 3, the table is a table, and the table has three fields of “task description”, “business line” and “progress status”. The three fields are displayed in the form of column names, and the cells in the columns where the column names are located all have the field attributes corresponding to the column names, which describe the content types that can be recorded in the cells in the columns, for example, the cells in the “task description” column can record task descriptions. In the present embodiment, the first operation event includes a new field operation and a target shortcut field operation. Specifically, the user creates a new field by clicking the control (the box with a plus sign in the upper right corner of the table in FIG. 3) for creating a new field in the table, and after triggering the control, a field interface as shown in FIG. 4 is displayed. In the field interface, the user can click the identifier of “select a shortcut field” to display a shortcut field interface as shown in FIG. 5, in which the recommended shortcut fields can be selected. In the present embodiment, the “translation” shortcut field is selected as the target shortcut field. Then, as shown in FIG. 6, a configuration area is displayed in the field interface. In the configuration area, the field “task description” of the source content to be translated needs to be selected, and the language category “English” to be translated into needs to be selected. After determining these contents, the user clicks to generate. Then, as shown in FIG. 7, a column cell is added in the table, and the field attribute of the column cell is the target shortcut field, that is, “translation”. The cell under the “translation” field is the content translated from the cell under the “task description” field to the “English” language. If there is no content in the cell under the “task description” field, no error will be reported in the cell under the “translation” field, that is, when the cell under the target shortcut field lacks the content to be processed by the logic, no error will be reported, but the cell will be left blank. Because the field attribute itself is an attribute, it limits the type of content that can be recorded in the cell.

[0039] In some embodiments of the present disclosure, after determining the target shortcut field in the shortcut field in the field shortcut, before creating the target shortcut field in the table or replacing the first field in the table with the target shortcut field, the method further comprises: displaying a preview control in the field interface. After the preview control is triggered, the field interface does not disappear, and a preview interface is generated around the field interface, in which a preview effect of the target field shortcut is generated. Alternatively, after the preview control is triggered, the target field shortcut is generated in the table to show the preview effect, and if the target shortcut field is cancelled in the field interface, the target field shortcut will not be created in the table or replace the first field. In some embodiments, as shown in FIG. 6, the target shortcut field is translation, and the field interface has a preview control "generate first 5 rows". If the preview control is triggered, a separate preview interface can be generated, which displays the effect of creating a translation field and translating the content of the first 5 rows of the task description field and displaying it in the cells of the translation field. At this time, the field interface does not disappear. Alternatively, after the preview control is triggered, the translation field is created in the table, and the content of the first 5 rows of the task description field is translated and displayed in the cells of the translation field. The field interface does not disappear. In this way, the user can view the preview effect after creating the target shortcut field through the preview control. The preview effect is temporarily displayed and disappears after the generate control or cancel control in the field interface is triggered.

[0040] In some embodiments of the present disclosure, the data processing logic encapsulated in the target shortcut field comprises: generating a second content in the target shortcut field or a third field based on a first content corresponding to the second field in the table. In some embodiments, the data processing logic is encapsulated in the field, not in the cell. In this way, the same field attribute can be assigned to all cells under the field through the field. The first content corresponding to the second field can be the content in the cell of the second field. The second content is generated in the cell of the target shortcut field or the cell of the third field, and the first content and the second content are located in the same record (usually a row of data). The data processing logic encapsulated in the target shortcut field can process the first content in the cell under the second field in the same record to obtain the second content, and write the second content into the cell under the shortcut field or the third field in the same record. For example, as shown in FIG. 7, the target shortcut field is translation, the second field is task description, and the user research in the cell under the task description is translated into English as the second content and written into the cell under the translation field in the same row record. The third field is another field different from the first field and the second field. The content under the second field can be processed through the target shortcut field and written into the cell of the third field, so that cross-field processing can be realized, instead of copying the second content into the cell of the target shortcut field, thereby improving the operation efficiency.

[0041] In some embodiments, if the data processing logic encapsulated in the target shortcut field is AI logic, the first content corresponding to the second field in the table is processed by a large model to generate second content in the target shortcut field or the third field. In some embodiments, the AI logic is artificial intelligence logic, which indicates that the data is processed by artificial intelligence. When the encapsulated processing logic is AI logic, a large model bound to the encapsulated AI logic is called to process the first content under the second field.

[0042] In some embodiments, if the data processing logic encapsulated in the target shortcut field is formula logic, the first content corresponding to the second field in the table is processed by a formula to generate second content in the target shortcut field or the third field. In some embodiments, the formula logic is a logic for processing data by a pre-set formula. When the encapsulated data processing logic is formula logic, the pre-set formula is called to process the first content.

[0043] In some embodiments, if the data processing logic encapsulated in the target shortcut field is API logic, an API is called based on the first content corresponding to the second field in the table to obtain data, and second content is generated in the target shortcut field or the third field based on the obtained data. In some embodiments, the API (Application Interface) logic has a pre-set API. The API is an interface without specific implementation. The API logic calls the API to process data. When the specific processing is performed, the method for implementing the API interface is found according to the API. In this way, the specific method of the called API does not need to be defined at the beginning. Only the called API needs to be indicated. The processing logic can be modified by modifying the method for implementing the API interface later, and the specific processing logic is decoupled from the API.

[0044] In some embodiments, the target shortcut field comprises a summary field, and the method further comprises: obtaining first content of a data column corresponding to the second field in the table, and generating second content summarized from the first content in the data column corresponding to the target shortcut field or the data column corresponding to the third field. In some embodiments, the data processing logic encapsulated in the summary field can be AI logic, and the processing logic of the summary field is to summarize the content. If the first content is in the cell of the second field, the first content is obtained, a summary of the first content is generated as the second content, and then the second content is written into the cell of the same row record under the summary field or the third field. The method of summarizing can be to send the first content to a neural network model for generating a summary, so as to generate the summary. The summary can be an abstract and summary of the first content, rather than a brief information of the first content. After the target shortcut field is determined, the second field can be selected in the configuration area of the field interface, and the user can input prompt information in the configuration area. When the summary is generated, the second field is determined according to the configuration area, and the prompt information input by the user can be displayed on the shortcut field or the third field.

[0045] In some embodiments, the target shortcut field comprises a translation field, and the method further comprises: obtaining first content of a data column corresponding to the second field in the table, and generating second content translated from the first content in the data column corresponding to the target shortcut field or the data column corresponding to the third field. In some embodiments, the data processing logic encapsulated in the translation field can be AI logic, and the processing logic of the translation field is to translate the content under the specified field. In the case that the target shortcut field is the translation field, if the first content is in the cell of the second field, the first content is obtained, the second content is translated from the first content, and then the second content is written into the cell of the same row record under the translation field or the third field. In the case that the target shortcut field is the translation field, the second field can be selected in the configuration area of the field interface, and the user can input prompt information in the configuration area. When the translation is generated, the second field is determined according to the configuration area, and the prompt information input by the user can be displayed on the target shortcut field or the third field.

[0046] In some embodiments, the target shortcut field includes a classification field, and the method further includes: obtaining first content of a data column corresponding to the second field in the table, and generating a type label of the first content in a data column corresponding to the target shortcut field or a data column corresponding to a third field. In some embodiments, the data processing logic encapsulated by the classification field can be AI logic, and at this time, the target shortcut field can send the first content to a large model for classification. The large model can assign a corresponding type label to the first content, and then write the type label into a cell of the target shortcut field or the third field in the same record. For example, the type label can be divided into positive labels and negative labels, so that the target shortcut field can determine whether the first content is positive or negative. Through the classification field, landscapes can also be classified as natural or artificial buildings, or people's photos can be classified as male photos and female photos. However, this is not limited, and any content that needs to be classified can be processed using the classification field.

[0047] In some embodiments, the target shortcut field includes an extraction field, and the method further includes: obtaining first content of a data column corresponding to the second field in the table, and generating second content extracted from the first content in a data column corresponding to the target shortcut field or a data column corresponding to a third field. In some embodiments, the data processing logic encapsulated by the extraction field can be AI logic, and at this time, the target shortcut field can send the first content to a large model for extraction. The large model can perform content extraction on the first content, and the extracted content can be a type of content pre-set by the target shortcut field, such as extracting the phone number, amount, etc. in the first content. In this way, the extraction field can be used to extract specific types of content in the file, which is suitable for scenarios of batch extracting specific content. For example, the amount in the invoice can be batch extracted, the invoice is stored in the cell of the second field, and the specific type of content in the invoice is written in the data column of the target shortcut field or the third field.

[0048] In some embodiments, the target shortcut field includes a field encapsulating a formula, and the method further includes: obtaining first content of a data column corresponding to the second field in the table, processing the first content according to the formula, and generating second content containing a result of the formula processing in a data column corresponding to the shortcut field or a data column corresponding to the third field. In some embodiments, the field encapsulating the formula takes a pre-set formula as a capability of the field itself, and a user does not need to write the formula. If a cell of the second field has the first content, the first content is obtained, the first content is processed according to the formula to obtain the second content, and then the second content is written into a cell of a same row record under the target shortcut field or the third field. The formula is encapsulated in the field instead of a cell, and a cell under the target shortcut field can uniformly apply the formula because of the field attribute, which is different from a way of defining the formula in a cell. The formula can be uniformly used through the field without setting the formula for each cell.

[0049] In some embodiments, the target shortcut field includes a field encapsulating an API, and the method further includes: obtaining first content of a data column corresponding to the second field in the table, processing the first content according to the API, and generating second content containing a result of the API processing in a data column corresponding to the target shortcut field or a data column corresponding to the third field. In some embodiments, for the field encapsulating the API, a developer can write code on a field capability to call a local or third-party API to process data. The API can be a data query API, and the first content can be search content for data query. The first content is sent to the API for data query, and then content obtained by the query is written into a data column corresponding to the target shortcut field or the third field, so as to complete batch writing of data. For example, the third-party API can be an API for querying company information, so that the company name is used as the first content to query the company, and related information such as registered address, legal person, and business is written into a data column of the target shortcut field or the third field.

[0050] In some embodiments of the present disclosure, the target shortcut field is determined from the shortcut fields in the field interface, including: displaying one or more of a shortcut field search control, a shortcut field center entry, and a recommended shortcut field in the field interface or a sub-interface of the field interface; taking a shortcut field searched by the shortcut field search control and selected as the target shortcut field, or, in response to triggering the shortcut field center entry to display the shortcut field center, taking a shortcut field selected by the shortcut field center as the target shortcut field, or taking a recommended shortcut field selected as the target shortcut field.

[0051] In some embodiments, as shown in FIGS. 2 and 3, when a control of the new field on the right side of the "Progress Status" of FIG. 3 is clicked, a field interface as shown in FIG. 4 is displayed, in which a title box can be displayed in which the title of the new field can be input, and a field type box can be displayed in which the type of the new field can be selected, and recommended fields can also be displayed in the field interface. An entry of the shortcut field is displayed in the field type box (the "Select a shortcut field" in FIG. 4), and when the entry is triggered by clicking or the like, a shortcut field interface as a sub-interface is displayed on the left side of the field interface as shown in FIG. 5. If it is the first time to display the entry of the shortcut field, a guide interface can be displayed, and when the guide interface is triggered, a description document of the shortcut field can be displayed to help the user understand the shortcut field. As shown in FIG. 5, a shortcut field search control is displayed in the shortcut field interface (top), by which the shortcut field can be searched. An entry of the shortcut field center (the "+ shortcut field center >" in FIG. 5) is also displayed in the shortcut field interface, and when the entry is triggered by clicking or the like, the shortcut field center can be entered, in which existing shortcut fields are provided, and the shortcut field can be selected as the target shortcut field. Recommended shortcut fields (the "Summary", "Translation", "Classification", "Extraction", "Geolocation Conversion", "Currency Conversion", "Time Zone Conversion", and "Number Amount to Capitalized" in FIG. 5) are also displayed in the shortcut field interface. The recommended shortcut field can be selected as the target shortcut field by clicking or the like.

[0052] In some embodiments of the present disclosure, the target shortcut field corresponds to a base field, and after the target shortcut field is determined, the target shortcut field and the base field corresponding thereto are displayed in the field interface; and when the target shortcut field is changed, the displayed base field corresponding to the target shortcut field is changed. In some embodiments, the shortcut field corresponds to a base field, and as shown in FIG. 4, "Text" and "Select a shortcut field" are displayed in the area below the field type, in which "Text" is the displayed base field, and when the target shortcut field is selected by "Select a shortcut field", the base field is changed to the base field corresponding to the target shortcut field, as shown in FIG. 6, because the base field corresponding to "Translation" is "Text", and thus the base field in FIG. 6 is not changed. After the target shortcut field is determined, the target shortcut field or the first field is generated in the table by clicking the generation control, and before that, the target shortcut field can be changed, for example, the "Translation" field selected in FIG. 6 is changed to another shortcut field, and if the target shortcut field is changed, the base field is also automatically changed. The base field corresponding to the shortcut field is usually the content type that can be displayed in the cell of the shortcut field.

[0053] In some embodiments of the present disclosure, the recommended shortcut fields are displayed in groups according to the shortcut field types; and in response to the number of shortcut fields under one shortcut field type exceeding a preset number, a first identifier is displayed in the group corresponding to the shortcut field type, and the first identifier is used to enter the shortcut field center and locate to the shortcut field list of the shortcut field type.

[0054] In some embodiments, as shown in FIG. 5, there are groups displayed in the shortcut field interface, for example, “AI automatic filling” and “content conversion” in FIG. 5 are the names of the groups, and the recommended shortcut fields are displayed in groups according to the shortcut field types, and each recommended shortcut field is displayed under the group according to the shortcut field type, for example, there are “summary”, “translation”, “classification”, and “extraction” under the “AI automatic filling” group. When the number of shortcut fields under one shortcut field type exceeds a preset number (for example, 4 or 6, etc.), it cannot be completely displayed on the shortcut field interface, at this time, a first identifier (for example, an “all” identifier can be displayed under the group) will be displayed under the group in the shortcut field interface. The first identifier can be triggered by clicking, etc. After the first identifier is triggered, the shortcut field center will be entered and located to the shortcut field list of the shortcut field type, so that all shortcut fields under the shortcut field type can be viewed.

[0055] In some embodiments of the present disclosure, as shown in FIG. 4, recommended fields are displayed in the field interface, for example, “one-sentence introduction of the product”, “detail translation”, etc. in FIG. 4. The user can select the recommended field by clicking, etc. so that the selected recommended field will be newly created in the table. In some embodiments, the recommended field is generated based on the name of the table and / or the existing fields in the table. Specifically, the recommended field can be generated by a neural network model, by obtaining the metadata of the table without reading the content in the specific cells. In this way, the name of the table and the existing fields can be read by the metadata without reading the specific cell content in the table, avoiding information leakage. The name of the table and the existing fields can be input into a large language model, a large voice model to generate a certain number of recommended fields. In this way, the recommended fields will be more relevant to the content of the table itself, and irrelevant fields will not be recommended. In some embodiments, the recommended field is a field different from the existing fields in the table, so as to avoid recommending the existing fields in the table to cause duplication. In some embodiments, the recommended field includes: a shortcut field, and / or a field of a non-shortcut field. The recommended field can have a shortcut field and a field of a non-shortcut field. Optionally, the number of shortcut fields in the recommended field is less than the number of fields of non-shortcut fields, for example, the recommended field can be 4, one of which is a shortcut field, and the field of a non-shortcut field can be a basic field.

[0056] In some embodiments of the present disclosure, after determining the target shortcut field, the target shortcut field is newly created in the table, or, before replacing the first field in the table with the target shortcut field, the method further comprises: in response to the target shortcut field defining a configurable item, displaying a configuration area of the target shortcut field, wherein the configuration area of the target shortcut field is used to set the configurable item of the target shortcut field; and in response to a configuration operation on the configurable item of the target shortcut field in the configuration area, determining the configuration content of the configurable item of the target shortcut field.

[0057] In some embodiments, after determining the target shortcut field, it can be determined whether the target shortcut field has a configurable item. If the target shortcut field does not have a configurable item, there is no need for configuration, and the target shortcut field is directly newly created in the table. If the target shortcut field has a configurable item, it means that the configurable item needs to be configured, and the target shortcut field is used. As shown in FIG. 6, a configuration area (the block area below “Configuration” in FIG. 6) can be displayed in the field interface. In the configuration area, a configuration operation can be performed on the configurable item of the target shortcut field. For example, in FIG. 6, the target shortcut field is “Translation”, and the configurable item includes a field that needs to be translated and a language to which the field is translated. By performing a configuration operation on the configurable item in the configuration area, the configuration content of the configurable item, i.e., the value of the configurable item, is determined. In this way, the target shortcut field is generated according to the configuration content of the configurable item. After determining the target shortcut field, the shortcut field interface is closed, and the field type and the content of the configuration area in the field interface are automatically changed to the content corresponding to the target shortcut field.

[0058] In some embodiments of the present disclosure, the shortcut field center has an entrance in the shortcut field interface, and the shortcut field center can be entered through the entrance. In some embodiments, FIG. 8 schematically shows a schematic diagram of the shortcut field center. The shortcut field center displays all shortcut fields, and a user can select a shortcut field in the shortcut field center to add to the table.

[0059] In some embodiments of the present disclosure, the shortcut field center displays introduction information of the shortcut field. For example, the introduction information of the shortcut field is displayed in the form of a banner on the home page of the shortcut field center, which describes what the shortcut field is, so that a user can understand the shortcut field. In some embodiments, the introduction information displays a usage instruction of the shortcut field after being triggered, which introduces how to create and use the shortcut field in a more detailed manner.

[0060] In some embodiments of the present disclosure, the shortcut field center displays a shortcut field type in the center of the shortcut field center, and displays shortcut fields belonging to the triggered shortcut field type after the shortcut field type is triggered. In some embodiments, as shown in FIG. 8, the shortcut field type is displayed on the left side of the shortcut field center, including “Selected”, “AI Auto-fill”, “Routine”, “Business”, etc. By triggering the shortcut field type, shortcut fields belonging to the shortcut field type will be displayed, for example, “Selected” is selected in FIG. 8, and the shortcut fields under “Selected” are displayed. In this way, the user can quickly select the shortcut field.

[0061] In some embodiments, the shortcut field displayed in the shortcut field center includes one or more of an icon, a name, description information, and source information. As shown in FIG. 8, the figure displays four shortcut fields: “Countdown”, “Ranking”, “Translation”, and “Map”, which display the icon, name, and description information of the shortcut field, and can display the source of the shortcut field, for example, whether the shortcut field is created by the current user or other users. In some embodiments, as shown in FIG. 8, when the control icon hovers over the shortcut field, a control for using the shortcut field can be displayed. By triggering the control, the shortcut field can be selected as the target shortcut field.

[0062] In some embodiments, the shortcut field center has a search control, in which the shortcut field can be searched to quickly find the shortcut field needed by the user.

[0063] In some embodiments of the present disclosure, the shortcut field center displays a shortcut field creation control; the shortcut field creation control creates a custom shortcut field in the shortcut field center after being triggered. In some embodiments, as shown in FIG. 8, the user shortcut field creation field (the “Add Shortcut Field” in the lower left corner of FIG. 8) is displayed in the shortcut field center. The user can create a shortcut field by triggering the control through clicking or the like. When creating the shortcut field, the user can customize the other fields, processing logic, and configurable items, etc. based on which the shortcut field is created, so as to realize specific functions according to the needs of the user. The user can realize the function of the plug-in in the form of a field. When creating the shortcut field, the icon of the shortcut field can be customized, and the icon of the shortcut field can be generated by combining the provided icon library and the provided color.

[0064] In some embodiments of the present disclosure, the field type in the field interface further includes a basic field, the basic field being a field preset in the table, and the shortcut field being a field obtained after the ability of encapsulating a new field based on the basic field is opened. In some embodiments, the basic field is preset in the table, for example, a text field, a number field, etc., and these basic fields serve as the basis of the shortcut field. The processing logic encapsulated by the shortcut field can be the processing logic for processing the basic field. The ability of encapsulating a new field based on the basic field is opened in the embodiments of the present disclosure, and the shortcut field is obtained after processing according to the encapsulated processing logic. For example, in a translation field, the basic field based thereon is text, and the encapsulated processing logic is conversion. Thus, a new shortcut field can be customized as needed for a specified language. The object of the encapsulated processing logic is the field rather than the cell, which is different from the processing manner in the table formula.

[0065] In some embodiments of the present disclosure, after the target shortcut field is newly created in the table or the first field in the table is replaced by the target shortcut field, the method further includes: displaying an icon of the field in the cell where the target shortcut field is located, and displaying the icon of the shortcut field when the control mark hovers over the cell where the target shortcut field is located. In some embodiments, after the target shortcut field is created, the icon of the field can be displayed in the cell where the target shortcut field is located (not shown in FIG. 7), which indicates that the target shortcut field is a field. Specifically, the icon of the basic field based thereon (for example, the icon of text) can be displayed. When the control mark hovers over the target shortcut field, the mark of the shortcut field can be displayed as shown in FIG. 9, which indicates that the field is not a normal field but a shortcut field.

[0066] The present disclosure further provides a table processing apparatus, including:

[0067] A determining unit is configured to determine a target shortcut field in response to a first operation event of newly creating a field in a table or changing an existing first field, the target shortcut field being a field encapsulating data processing logic.

[0068] A control unit is configured to newly create the target shortcut field in the table or replace the first field in the table by the target shortcut field.

[0069] In some embodiments, the data processing logic encapsulated in the target shortcut field includes: generating second content in the target shortcut field or a third field based on first content corresponding to a second field in the table.

[0070] In some embodiments, the control unit is configured to, if the data processing logic encapsulated in the target shortcut field is AI logic, process the first content corresponding to the second field in the table by a large model to generate second content in the target shortcut field or the third field.

[0071] In some embodiments, the control unit is configured to, if the data processing logic encapsulated in the target shortcut field is formula logic, process the first content corresponding to the second field in the table by a formula to generate second content in the target shortcut field or the third field.

[0072] In some embodiments, the control unit is configured to, if the data processing logic encapsulated in the target shortcut field is API logic, call an API based on the first content corresponding to the second field in the table to obtain data, and generate second content in the target shortcut field or the third field based on the obtained data.

[0073] In some embodiments, the target shortcut field comprises a summary field, and the control unit is further configured to: obtain the first content of the data column corresponding to the second field in the table, and generate second content summarizing the first content in the data column corresponding to the target shortcut field or the data column corresponding to the third field.

[0074] In some embodiments, the target shortcut field comprises a translation field, and the control unit is further configured to: obtain the first content of the data column corresponding to the second field in the table, and generate second content translating the first content in the data column corresponding to the target shortcut field or the data column corresponding to the third field.

[0075] In some embodiments, the target shortcut field comprises a classification field, and the control unit is further configured to:

[0076] obtain the first content of the data column corresponding to the second field in the table, and generate a type label of the first content in the data column corresponding to the target shortcut field or the data column corresponding to the third field.

[0077] In some embodiments, the target shortcut field comprises an extraction field, and the control unit is further configured to:

[0078] obtain the first content of the data column corresponding to the second field in the table, and generate second content extracted from the first content in the data column corresponding to the target shortcut field or the data column corresponding to the third field.

[0079] In some embodiments, the target shortcut field comprises a field encapsulating a formula, and the control unit is further configured to: acquire first content of a data column corresponding to the second field in the table, process the first content through the formula, and generate second content containing a result of the formula processing in a data column corresponding to the shortcut field or a data column corresponding to a third field.

[0080] In some embodiments, the target shortcut field comprises a field encapsulating an API, and the control unit is further configured to:

[0081] acquire first content of a data column corresponding to the second field in the table, process the first content through the API, and generate second content containing a result of the API processing in a data column corresponding to the target shortcut field or a data column corresponding to a third field.

[0082] In some embodiments, in response to a first operation event of newly creating a field in the table or changing an existing first field, the target shortcut field is determined, comprising: in response to the operation of newly creating a field or changing an existing first field, displaying a field interface, wherein a field type in the field interface comprises a shortcut field; determining the target shortcut field from the shortcut field in the field interface; or, in response to receiving input information of newly creating a field or changing an existing first field, determining the target shortcut field from the input information.

[0083] In some embodiments, the target shortcut field is determined from the shortcut field in the field interface, comprising: displaying one or more of a shortcut field search control, a shortcut field center entry, and recommended shortcut fields in the field interface or a sub-interface of the field interface; taking a shortcut field searched through the shortcut field search control and selected as the target shortcut field, or, in response to triggering the shortcut field center entry to display the shortcut field center, taking a shortcut field selected by the shortcut field center as the target shortcut field, or taking the recommended shortcut field selected as the target shortcut field.

[0084] In some embodiments, the target shortcut field corresponds to a base field, and the control unit is further configured to: after determining the target shortcut field, displaying the target shortcut field and the base field corresponding thereto in the field interface; and if the target shortcut field changes, the base field corresponding to the displayed target shortcut field changes accordingly.

[0085] In some embodiments, the recommended shortcut fields are displayed in groups according to shortcut field types; and the control unit is further configured to: in response to a number of shortcut fields under a shortcut field type exceeding a preset number, displaying a first identifier in a group corresponding to the shortcut field type, the first identifier being used to enter the shortcut field center and locate to a shortcut field list of the shortcut field type.

[0086] In some embodiments, the field interface displays a recommended field, and at least one of the following is satisfied: the recommended field is generated based on the name of the table and / or the existing fields in the table; the recommended field is a different field from the existing fields in the table; the recommended field includes a shortcut field and / or a non-shortcut field.

[0087] In some embodiments, after determining the target shortcut field, the target shortcut field is newly created in the table, or before replacing the first field in the table with the target shortcut field, the control unit is further configured to: in response to the target shortcut field defining a configurable item, display a configuration area of the target shortcut field, wherein the configuration area of the target shortcut field is used to set the configurable item of the target shortcut field.

[0088] In response to a configuration operation on the configurable item of the target shortcut field in the configuration area, the configuration content of the configurable item of the target shortcut field is determined.

[0089] In some embodiments, one or more of the following is satisfied: the shortcut field center displays all the shortcut fields; the shortcut field center displays introduction information of the shortcut fields, and the introduction information displays usage instructions of the shortcut fields after being triggered; the shortcut field center displays shortcut field types, and displays shortcut fields belonging to the triggered shortcut field type after the shortcut field type is triggered; the shortcut fields displayed in the shortcut field center include one or more of an icon, a name, description information, and source information; and the shortcut field center displays a search control.

[0090] In some embodiments, the shortcut field center displays a shortcut field creation control, and the shortcut field creation control creates a custom shortcut field in the shortcut field center after being triggered.

[0091] In some embodiments, the field type in the field interface further includes a basic field, the basic field is a pre-set field in the table, and the shortcut field is a field obtained after the ability to encapsulate a new field based on the basic field is opened.

[0092] For the embodiment of the device, since it basically corresponds to the method embodiment, the relevant part is described in the part of the method embodiment. The above-described device embodiment is only illustrative, and the modules described as separate modules can or can not be separate. Part or all of the modules can be selected according to actual needs to achieve the purpose of the embodiment. Those skilled in the art can understand and implement without creative labor.

[0093] The above describes the method and apparatus of the present disclosure based on the embodiments and application examples. In addition, the present disclosure also provides an electronic device and a computer readable storage medium, which are described below.

[0094] Reference is made to FIG. 10, which shows a structural schematic diagram of an electronic device (e.g., a terminal device or a server) 800 suitable for implementing the embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure can include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (Personal Digital Assistant), a PAD (Tablet Personal Computer), a PMP (Portable Multimedia Player), a vehicle terminal (e.g., a car navigation terminal), and the like, and a fixed terminal such as a digital TV, a desktop computer, and the like. The electronic device shown in the figure is only an example, and should not impose any limitation on the functions and use range of the embodiments of the present disclosure.

[0095] The electronic device 800 can include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 801, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 802 or a program loaded from a storage device 808 into a random access memory (RAM) 803. In the RAM 803, various programs and data required for the operation of the electronic device 800 are also stored. The processing device 801, the ROM 802, and the RAM 803 are connected to each other through a bus 804. An input / output (I / O) interface 805 is also connected to the bus 804.

[0096] Generally, the following devices can be connected to the I / O interface 805: an input device 806 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, and the like; an output device 807 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, and the like; a storage device 808 including, for example, a magnetic tape, a hard disk, and the like; and a communication device 809. The communication device 809 can allow the electronic device 800 to communicate with other devices wirelessly or by wire to exchange data. Although the electronic device 800 with various devices is shown in the figure, it should be understood that it is not required to implement or have all the devices shown. More or less devices can be alternatively implemented or provided.

[0097] In particular, the processes described above with reference to the flowcharts can be implemented as a computer software program in accordance with embodiments of the present disclosure. For example, embodiments of the present disclosure include a computer program product comprising a computer program carried on a computer readable medium, the computer program comprising program code for performing the methods illustrated by the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via the communication device 809, or installed from the storage device 808, or installed from the ROM 802. When the computer program is executed by the processing device 801, the above-mentioned functions defined in the methods of the embodiments of the present disclosure are performed.

[0098] It should be noted that the computer readable medium described above in the present disclosure can be a computer readable signal medium or a computer readable storage medium or any combination thereof. The computer readable storage medium can be, for example but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or apparatus, or any suitable combination of the above. More specific examples of the computer readable storage medium can include, but are not limited to, an electrical connection having one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, the computer readable storage medium can be any tangible medium that contains or stores a program used by or in connection with an instruction execution system, apparatus or device. In the present disclosure, the computer readable signal medium can include a data signal carried in a baseband or as part of a carrier wave, in which the computer readable program code is carried. Such a propagated data signal can take any of a variety of forms, including but not limited to electro-magnetic, optical, or any suitable combination thereof. The computer readable signal medium can also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code contained in the computer readable medium can be transmitted by any suitable medium, including but not limited to wire, cable, optical fiber, RF, etc., or any suitable combination of the above.

[0099] In some embodiments, the client, server, or other computing devices can communicate using any known or later developed end-to-end protocol, such as the HyperText Transfer Protocol (HTTP), and can be interconnected with any form or medium of digital data communication (for example, a communication network) of the type currently known or later developed.

[0100] The computer-readable medium or media can be of an electronic, magnetic, optical, or other type, including a computer-readable storage medium or media. The computer-readable medium or media can be non-transitory, or can be transitory.

[0101] The computer-readable medium or media can be of an electronic, magnetic, optical, or other type, including a computer-readable storage medium or media. The computer-readable medium or media can be non-transitory, or can be transitory.

[0102] Computer program code for carrying out operations of the present disclosure can be written in any of one or more programming languages or combinations of languages including object or visual programming languages such as Java, Smalltalk, C++, or conventional procedural programming languages such as the "C" programming language or similar programming languages. The program code can execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection can be made to an external computer (for example, through the Internet using an Internet Service Provider).

[0103] The flow and block diagrams in the drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flow and block diagrams can represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical functions. It should also be noted that in some alternative implementations, the functions noted in the blocks can occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently or the blocks can sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and / or flowchart illustrations, and combinations thereof, can be implemented by a dedicated hardware-based system that performs the specified functions or operations, or combinations of hardware and software.

[0104] The units described in the embodiments of the present disclosure can be implemented by software, or by hardware. In some cases, the name of the unit does not constitute a limitation on the unit itself.

[0105] The functions described above in this document can be performed, at least in part, by one or more hardware logic components. For example, and without limitation, example types of hardware logic components that can be used include Field-programmable Gate Arrays (FPGAs), Application-specific Integrated Circuits (ASICs), Application-specific Standard Products (ASSPs), System-on-a-chip systems (SOCs), Complex Programmable Logic Devices (CPLDs), etc.

[0106] In the context of the present disclosure, a machine-readable medium can be a tangible medium that contains or stores a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of the machine-readable storage medium will include one or more lines of electrical connections, portable computer disks, hard disk drives, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or Flash memory), optical fibers, portable compact disc read-only memories (CD-ROMs), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0107] According to one or more embodiments of the present disclosure, a table processing method is provided, comprising:

[0108] In response to a first operation event of creating a new field in the table or changing an existing first field, a target shortcut field is determined, the target shortcut field being a field encapsulating data processing logic;

[0109] The target shortcut field is created in the table, or a first field in the table is replaced by the target shortcut field.

[0110] According to one or more embodiments of the present disclosure, a table processing method is provided, and the data processing logic encapsulated in the target shortcut field includes: based on first content corresponding to a second field in the table, generating second content in the target shortcut field or a third field.

[0111] According to one or more embodiments of the present disclosure, a table processing method is provided, and the data processing logic encapsulated in the target shortcut field includes: based on first content corresponding to a second field in the table, generating second content in the target shortcut field or a third field.

[0112] According to one or more embodiments of the present disclosure, a table processing method is provided, and the data processing logic encapsulated in the target shortcut field includes: based on first content corresponding to a second field in the table, generating second content in the target shortcut field or a third field.

[0113] According to one or more embodiments of the present disclosure, a table processing method is provided, and the data processing logic encapsulated in the target shortcut field includes: based on first content corresponding to a second field in the table, generating second content in the target shortcut field or a third field.

[0114] According to one or more embodiments of the present disclosure, a table processing method is provided, and the target shortcut field includes a summary field, and the method further includes:

[0115] The first content corresponding to a data column of the second field in the table is obtained, and second content summarized from the first content is generated in a data column corresponding to the target shortcut field or a data column corresponding to a third field.

[0116] According to one or more embodiments of the present disclosure, a table processing method is provided, and the target shortcut field includes a translation field, and the method further includes:

[0117] The first content corresponding to a data column of the second field in the table is obtained, and second content translated from the first content is generated in a data column corresponding to the target shortcut field or a data column corresponding to a third field.

[0118] According to one or more embodiments of the present disclosure, a table processing method is provided, the target shortcut field includes a classification field, and the method further includes:

[0119] Obtaining first content of a data column corresponding to the second field in the table, and generating a type label of the first content in a data column corresponding to the target shortcut field or a data column corresponding to the third field.

[0120] According to one or more embodiments of the present disclosure, a table processing method is provided, the target shortcut field includes an extraction field, and the method further includes:

[0121] Obtaining first content of a data column corresponding to the second field in the table, and generating second content extracted from the first content in a data column corresponding to the target shortcut field or a data column corresponding to the third field.

[0122] According to one or more embodiments of the present disclosure, a table processing method is provided, the target shortcut field includes a field encapsulating a formula, and the method further includes:

[0123] Obtaining first content of a data column corresponding to the second field in the table, processing the first content through the formula, and generating second content containing a formula processing result in a data column corresponding to the shortcut field or a data column corresponding to the third field.

[0124] According to one or more embodiments of the present disclosure, a table processing method is provided, the target shortcut field includes a field encapsulating an API, and the method further includes:

[0125] Obtaining first content of a data column corresponding to the second field in the table, processing the first content through the API, and generating second content containing an API processing result in a data column corresponding to the target shortcut field or a data column corresponding to the third field.

[0126] According to one or more embodiments of the present disclosure, a table processing method is provided, in response to a first operation event of newly creating a field or changing an existing first field in a table, determining a target shortcut field, including: in response to the operation of newly creating a field or changing an existing first field, displaying a field interface, the field types in the field interface including a shortcut field; determining the target shortcut field from the shortcut field in the field interface; or, in response to receiving input information of newly creating a field or changing an existing first field, determining the target shortcut field from the input information.

[0127] According to one or more embodiments of the present disclosure, a table processing method is provided, determining the target shortcut field from the shortcut field in the field interface, including:

[0128] displaying one or more of a shortcut field search control, a shortcut field center entry, and a recommended shortcut field in the field interface or a sub-interface of the field interface;

[0129] selecting, as the target shortcut field, a shortcut field searched and selected through the shortcut field search control, or, in response to triggering the shortcut field center entry to display the shortcut field center, selecting, as the target shortcut field, a shortcut field selected by the shortcut field center, or selecting, as the target shortcut field, the recommended shortcut field selected.

[0130] According to one or more embodiments of the present disclosure, a table processing method is provided, further comprising:

[0131] The target shortcut field corresponds to a basic field, and after determining the target shortcut field, the target shortcut field and the basic field corresponding to the target shortcut field are displayed in the field interface; and if the target shortcut field is changed, the displayed basic field corresponding to the target shortcut field is changed.

[0132] According to one or more embodiments of the present disclosure, a table processing method is provided, wherein the recommended shortcut field is displayed in groups according to shortcut field types.

[0133] In response to a number of shortcut fields under a shortcut field type exceeding a preset number, a first identifier is displayed in a group corresponding to the shortcut field type, and the first identifier is used to enter a shortcut field center and locate to a shortcut field list of the shortcut field type.

[0134] According to one or more embodiments of the present disclosure, a table processing method is provided, wherein a recommended field is displayed in the field interface, and at least one of the following conditions is met:

[0135] The recommended field is generated based on a name of the table and / or an existing field in the table.

[0136] The recommended field is a field different from the existing field in the table.

[0137] The recommended field includes a shortcut field and / or a field that is not a shortcut field.

[0138] According to one or more embodiments of the present disclosure, a table processing method is provided, wherein after determining a target shortcut field, the target shortcut field is newly created in the table, or before replacing a first field in the table with the target shortcut field, the method further comprises:

[0139] In response to the target shortcut field defining a configurable item, a configuration area of the target shortcut field is displayed, wherein the configuration area of the target shortcut field is used to set the configurable item of the target shortcut field.

[0140] In response to a configuration operation on the configurable item of the target shortcut field in the configuration area, configuration content of the configurable item of the target shortcut field is determined.

[0141] According to one or more embodiments of the present disclosure, a table processing method is provided, which satisfies one or more of the following:

[0142] All of the shortcut fields are displayed in the shortcut field center;

[0143] The shortcut field center displays introduction information of the shortcut field, and the introduction information displays a use instruction of the shortcut field after being triggered;

[0144] The shortcut field center displays a shortcut field type, and shortcut fields belonging to the triggered shortcut field type are displayed after the shortcut field type is triggered;

[0145] The shortcut fields displayed in the shortcut field center include one or more of an icon, a name, description information, and source information;

[0146] The shortcut field center displays a search control.

[0147] According to one or more embodiments of the present disclosure, a table processing method is provided, and the shortcut field center displays a shortcut field creation control;

[0148] The shortcut field creation control creates a customized shortcut field in the shortcut field center after being triggered.

[0149] According to one or more embodiments of the present disclosure, a table processing method is provided, and the field type in the field interface further includes a basic field, the basic field is a field pre-set in the table, and the shortcut field is a field obtained after the ability of encapsulating a new field based on the basic field is opened.

[0150] According to one or more embodiments of the present disclosure, a table processing apparatus is provided, which includes:

[0151] A determination unit is configured to determine a target shortcut field in response to a first operation event of newly creating a field in a table or changing an existing first field, and the target shortcut field is a field encapsulating data processing logic;

[0152] The control unit is configured to create the target shortcut field in the table, or replace a first field in the table with the target shortcut field.

[0153] According to one or more embodiments of the present disclosure, an electronic device is provided, comprising: at least one memory and at least one processor;

[0154] The at least one memory is configured to store program code, and the at least one processor is configured to invoke the program code stored in the at least one memory to execute the method described in any one of the above.

[0155] According to one or more embodiments of the present disclosure, a computer readable storage medium is provided, the computer readable storage medium is configured to store program code, the program code causes a processor to execute the method described above when the processor runs the program code.

[0156] The above description is merely preferred embodiments of the present disclosure and a description of the principles of the technology employed. It will be understood by those skilled in the art that the scope of the disclosure involved herein is not limited to the technical solutions formed by the specific combinations of the above technical features, and also covers other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the technical solutions formed by replacing the above features with the technical features disclosed in the present disclosure (but not limited to) having similar functions.

[0157] In addition, although each operation is depicted in a particular order, this should not be understood as requiring the operations to be performed in the particular order shown or in sequential order. In certain circumstances, multitasking and parallel processing can be advantageous. Similarly, although several implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the disclosure. Certain features described in the context of separate embodiments can also be combined in a single embodiment. Conversely, various features described in the context of a single embodiment can also be implemented separately or in any suitable sub-combination.

[0158] Although the subject matter has been described in language specific to structural features and / or methodological acts, it is to be understood that the subject defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims.

Claims

1. A table processing method, comprising: In response to a first operation event that creates a new field or modifies an existing first field in a table, a target shortcut field is determined, wherein the target shortcut field is a field that encapsulates data processing logic; Create a new target shortcut field in the table, or replace the first field in the table with the target shortcut field.

2. The method according to claim 1, wherein, The data processing logic encapsulated in the target shortcut field includes: generating second content in the target shortcut field or the third field based on the first content corresponding to the second field in the table.

3. The method according to claim 2, wherein, The method includes at least one of the following: If the data processing logic encapsulated in the target shortcut field is AI logic, the first content corresponding to the second field in the table is processed through a large model to generate the second content in the target shortcut field or the third field; or... If the data processing logic encapsulated in the target shortcut field is formula logic, the first content corresponding to the second field in the table is processed by the formula to generate the second content in the target shortcut field or the third field; or... If the data processing logic encapsulated in the target shortcut field is API logic, the API is called to obtain data based on the first content corresponding to the second field in the table, and the second content is generated in the target shortcut field or the third field based on the obtained data.

4. The method according to any one of claims 1-3, wherein, The target shortcut field includes a summary field, and the method further includes: Obtain the first content of the data column corresponding to the second field in the table, and generate the second content that summarizes the first content in the data column corresponding to the target shortcut field or the data column corresponding to the third field.

5. The method according to any one of claims 1-3, wherein, The target shortcut field includes a translation field, and the method further includes: Obtain the first content of the data column corresponding to the second field in the table, and generate the second content after translating the first content in the data column corresponding to the target shortcut field or the data column corresponding to the third field.

6. The method according to any one of claims 1-3, wherein, The target shortcut field includes a category field, and the method further includes: Obtain the first content of the data column corresponding to the second field in the table, and generate a type label for the first content in the data column corresponding to the target shortcut field or the data column corresponding to the third field.

7. The method according to any one of claims 1-3, wherein, The target shortcut field includes an extraction field, and the method further includes: Obtain the first content of the data column corresponding to the second field in the table, and generate the second content extracted from the first content in the data column corresponding to the target shortcut field or the data column corresponding to the third field.

8. The method according to any one of claims 1-3, wherein, The target shortcut field includes a field encapsulating a formula, and the method further includes: Obtain the first content of the data column corresponding to the second field in the table, process the first content using the formula, and generate the second content containing the formula processing result in the data column corresponding to the shortcut field or the data column corresponding to the third field.

9. The method according to any one of claims 1-3, wherein, The target shortcut field includes a field encapsulating an API, and the method further includes: Obtain the first content of the data column corresponding to the second field in the table, process the first content through the API, and generate the second content containing the API processing result in the data column corresponding to the target shortcut field or the data column corresponding to the third field.

10. The method according to any one of claims 1-9, wherein, The first operation event in response to creating a new field or changing an existing first field in the table determines the target shortcut field, including: In response to an operation of creating a new field or changing an existing first field, a field interface is displayed, wherein the field types in the field interface include shortcut fields; a target shortcut field is determined from the shortcut fields in the field interface; or, In response to receiving input information about creating a new field or changing an existing first field, the target shortcut field is determined from the input information.

11. The method according to claim 10, wherein, Determining the target shortcut field from the shortcut fields in the field interface includes: The shortcut field search control, the shortcut field center entry, and one or more recommended shortcut fields are displayed in the field interface or in a sub-interface of the field interface. The shortcut field searched and selected through the shortcut field search control shall be used as the target shortcut field; or, in response to triggering the display of the shortcut field center entry, the shortcut field center selected in the shortcut field center shall be used as the target shortcut field; or, the recommended shortcut field selected shall be used as the target shortcut field.

12. The method according to claim 10 or 11, further comprising: The target shortcut field corresponds to a basic field. After the target shortcut field is determined, the target shortcut field and its corresponding basic field are displayed on the field interface. If the target shortcut field changes, the corresponding base field of the displayed target shortcut field will also change.

13. The method according to claim 11, wherein, The recommended shortcut fields are displayed in groups according to shortcut field type; In response to the number of shortcut fields under a shortcut field type exceeding a preset number, a first identifier is displayed in the group corresponding to the shortcut field type. The first identifier is used to enter the shortcut field center and locate the shortcut field list of the shortcut field type.

14. The method according to claim 11, wherein, The field interface displays recommended fields, and meets at least one of the following conditions: The recommended fields are generated based on the name of the table and / or existing fields in the table; The recommended field is a field that is different from the existing fields in the table; The recommended fields include: shortcut fields, and / or, non-shortcut fields.

15. The method according to any one of claims 1-14, wherein, After determining the target shortcut field, the method further includes either creating the target shortcut field in the table or replacing the first field in the table with the target shortcut field, or: In response to the definition of configurable items in the target shortcut field, the configuration area of ​​the target shortcut field is displayed, wherein the configuration area of ​​the target shortcut field is used to set the configurable items of the target shortcut field; In response to a configuration operation on the configurable items of the target shortcut field in the configuration area, the configuration content of the configurable items of the target shortcut field is determined.

16. The method according to claim 11, wherein, The method satisfies one or more of the following: All the shortcut fields are displayed in the shortcut field center; The shortcut field displays an introductory information about the shortcut field in the center, and the introductory information displays usage instructions for the shortcut field after being triggered; The shortcut field center displays the shortcut field type, and after the shortcut field type is triggered, the shortcut field belonging to the triggered shortcut field type is displayed; The shortcut fields displayed in the shortcut field center include one or more of the following: icon, name, description, and source information.

17. The method according to claim 11, wherein, The shortcut field center displays a shortcut field creation control; When the shortcut field creation control is triggered, it creates a custom shortcut field in the shortcut field center.

18. The method according to claim 10, wherein, The field types in the field interface also include basic fields, which are pre-set fields in the table. Shortcut fields are fields obtained by opening up the ability to encapsulate new fields based on the basic fields.

19. A form processing apparatus, comprising: The determination unit is configured to determine a target shortcut field in response to a first operation event that creates a new field or changes an existing first field in a table, the target shortcut field being a field that encapsulates data processing logic. The control unit is configured to create the target shortcut field in the table, or to replace the first field in the table with the target shortcut field.

20. An electronic device, comprising: At least one memory and at least one processor; The at least one memory is configured to store program code, and the at least one processor is configured to invoke the program code stored in the at least one memory to execute the table processing method according to any one of claims 1 to 18.

21. A computer-readable storage medium configured to store program code, wherein, When the program code is run by the processor, the processor performs the table processing method according to any one of claims 1 to 18.

Images