Use information prompting method and device, electronic equipment, storage medium and program product

Abstract

The embodiment of the invention provides a use information prompting method and device, electronic equipment, a storage medium and a program product. The method comprises the steps that in response to a received modification instruction for data lines in a table, use information of the table is obtained, the use information comprises use information of all the data lines in the table and / or use information of data lines of sub-tables, and the use information comprises the use rate; in response to the fact that the usage rate is matched with a first prompt level, prompt content is displayed, and the prompt content comprises the usage information. By means of the technical scheme, the practicability of prompting the use condition of the table can be improved, and the continuity of the business process is improved.

Description

Technical Field

[0001] The embodiments of this application relate to the field of computer technology, and in particular to a method, apparatus, electronic device, storage medium, and program product for providing information. Background Technology

[0002] In data management platforms, it's often necessary to provide prompts regarding user table usage. However, current technologies for providing such prompts are not very practical and cannot guarantee the continuity of business processes. Summary of the Invention

[0003] The embodiments of this application provide a method, apparatus, electronic device, storage medium, and program product for prompting usage information, so as to realize hierarchical prompts for form usage, improve the practicality of prompting form usage, and enhance the continuity of business processes.

[0004] In a first aspect, embodiments of this application provide a method for prompting usage information, including:

[0005] In response to receiving a modification instruction for a data row in a table, the user obtains the table's usage information, which includes the usage information of all data rows in the table and / or the usage information of data rows in sub-tables, and the usage information includes the usage rate.

[0006] In response to the usage rate matching a first prompt level, a prompt is displayed, the prompt including the usage information.

[0007] Secondly, embodiments of this application also provide a usage information prompting device, comprising:

[0008] The information acquisition module is used to acquire the usage information of the table in response to receiving a modification instruction for the data rows in the table. The usage information includes the usage information of all data rows in the table and / or the usage information of data rows in sub-tables. The usage information includes the usage rate.

[0009] A prompt module is used to display prompt content in response to the usage rate matching a first prompt level, the prompt content including the usage information.

[0010] Thirdly, embodiments of this application also provide an electronic device, including:

[0011] One or more processors;

[0012] Memory, used to store one or more programs.

[0013] When the one or more programs are executed by the one or more processors, the one or more processors implement the usage information prompting method as described in the embodiments of this application.

[0014] Fourthly, embodiments of this application also provide a computer-readable storage medium having a computer program stored thereon that, when executed by a processor, implements the method for prompting usage information as described in embodiments of this application.

[0015] Fifthly, embodiments of this application also provide a computer program product that, when executed by a computer, causes the computer to implement the method for prompting usage information as described in embodiments of this application.

[0016] The usage information prompting method, apparatus, electronic device, storage medium, and program product provided by the embodiments of this application provide tiered prompts for table usage. Compared with the scheme of prompting only after the table capacity reaches or exceeds the upper limit, it enables users to receive clear prompts before the table reaches the capacity limit, improves the practicality of prompting table usage, reduces operation failures caused by the resource capacity reaching or exceeding the upper limit, and improves the continuity of business processes. Attached Figure Description

[0017] The above and other features, advantages, and aspects of the various embodiments of this application will become more apparent when taken in conjunction with the accompanying drawings and the following detailed description. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic, and the originals and elements are not necessarily drawn to scale.

[0018] Figure 1 A schematic diagram of an exemplary system provided for implementation of this application;

[0019] Figure 2 A flowchart illustrating a method for providing usage information in accordance with an embodiment of this application;

[0020] Figure 3 A flowchart illustrating a method for providing usage information in accordance with an embodiment of this application;

[0021] Figure 4 A flowchart illustrating another method for providing usage information according to an embodiment of this application;

[0022] Figure 5 A structural block diagram of a usage information prompting device provided for an embodiment of this application;

[0023] Figure 6 This is a schematic diagram of the structure of an electronic device provided for an embodiment of this application. Detailed Implementation

[0024] The embodiments of this application will now be described in more detail with reference to the accompanying drawings. While some embodiments of this application are shown in the drawings, it should be understood that this application can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of this application. It should be understood that the drawings and embodiments of this application are for illustrative purposes only and are not intended to limit the scope of protection of this application.

[0025] It should be understood that the steps described in the method embodiments of this application may be performed in different orders and / or in parallel. Furthermore, the method embodiments may include additional steps and / or omit the steps shown. The scope of this application is not limited in this respect.

[0026] The term "comprising" and its variations as used herein are open-ended inclusions, meaning "including but not limited to". The term "based on" means "at least partially based 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". Definitions of other terms will be given in the following description.

[0027] It should be noted that the concepts of "first" and "second" mentioned in this application are only used to distinguish different devices, modules or units, and are not used to limit the order of functions performed by these devices, modules or units or their interdependencies.

[0028] It should be noted that the terms "a" and "a plurality of" used in this application are illustrative rather than restrictive, and those skilled in the art should understand that, unless otherwise expressly indicated in the context, they should be understood as "one or more".

[0029] The names of the messages or information exchanged between multiple devices in the embodiments of this application are for illustrative purposes only and are not intended to limit the scope of these messages or information.

[0030] It is understood that before using the technical solutions disclosed in the various embodiments of this application, users should be informed of the types, scope of use, and usage scenarios of the personal information involved in this application in an appropriate manner in accordance with relevant laws and regulations, and user authorization should be obtained.

[0031] For example, upon receiving a user's active request, a prompt message is sent to the user to explicitly inform them that the requested operation will require the acquisition and use of the user's personal information. This allows the user to independently choose whether to provide personal information to the software or hardware, such as the electronic device, application, server, or storage medium performing the operations of this application's technical solution, based on the prompt message.

[0032] As an optional but non-limiting implementation, in response to a user's active request, sending a prompt message to the user can be done via a pop-up window, where the prompt message can be presented in text format. Furthermore, the pop-up window can also include a selection control allowing the user to choose "agree" or "disagree" to provide personal information to the electronic device.

[0033] It is understood that the above notification and user authorization process are merely illustrative and do not constitute a limitation on the implementation of this application. Other methods that comply with relevant laws and regulations may also be applied to the implementation of this application.

[0034] It is understood that the data involved in this technical solution (including but not limited to the data itself, the acquisition or use of the data) shall comply with the requirements of relevant laws, regulations and related provisions.

[0035] Figure 1 This is a schematic diagram of an exemplary system provided for implementation of this application. This exemplary system can be used to implement the various methods described herein. References Figure 1 The system 100 includes one or more client devices 101, 102, 103, 104, 105 and 106, a server 120, and one or more communication networks 110 coupling the one or more client devices to the server 120. The client devices 101, 102, 103, 104, 105 and 106 can be configured to execute one or more applications.

[0036] In embodiments of this application, server 120 may run one or more services or software applications that enable the execution of the methods provided in embodiments of this application.

[0037] In some implementations, server 120 may also provide other services or software applications, which may include non-virtual and virtual environments. In some implementations, these services may be provided as web-based services or cloud services, such as to users of client devices 101, 102, 103, 104, 105, and / or 106 under a Software as a Service (SaaS) model.

[0038] exist Figure 1In the configuration shown, server 120 may include one or more components that implement the functions performed by server 120. These components may include software components, hardware components, or combinations thereof that can be executed by one or more processors. Users operating client devices 101, 102, 103, 104, 105, and / or 106 can sequentially interact with server 120 using one or more client applications to utilize the services provided by these components. It should be understood that various different system configurations are possible and may differ from system 100. Therefore, Figure 1 This is an example of a system used to implement the various methods described herein, and is not intended to be limiting.

[0039] Users can use client devices 101, 102, 103, 104, 105, and / or 106 to input user commands and obtain the results of command execution. The client devices can provide an interface that allows users to interact with the client devices. The client devices can also output information to the user through this interface. Although... Figure 1 Only six client devices are described, but those skilled in the art will understand that this application can support any number of client devices.

[0040] Client devices 101, 102, 103, 104, 105, and / or 106 may include various types of computer devices, such as portable handheld devices, general-purpose computers (such as personal computers and laptops), workstation computers, wearable devices, smart screen devices, self-service terminal devices, service robots, gaming systems, thin clients, various messaging devices, sensors, or other sensing devices. These computer devices can run various types and versions of software applications and operating systems, such as Microsoft Windows, Apple iOS, UNIX-like operating systems, Linux or Linux-like operating systems (such as Google Chrome OS); or include various mobile operating systems, such as Microsoft Windows Mobile OS, iOS, Windows Phone, and Android. Portable handheld devices may include cellular phones, smartphones, tablets, personal digital assistants (PDAs), etc. Wearable devices may include head-mounted displays (such as smart glasses) and other devices. Gaming systems may include various handheld gaming devices, internet-enabled gaming devices, etc. Client devices are capable of executing various applications, such as various internet-related applications, communication applications (such as email applications), short message service (SMS) applications, and can use various communication protocols. In some implementations, the client device can execute an application that provides the functionality described below.

[0041] Network 110 can be any type of network well known to those skilled in the art, and can use any of a variety of available protocols (including but not limited to TCP / IP, SNA, IPX, etc.) to support data communication. By way of example only, one or more networks 110 can be a local area network (LAN), an Ethernet-based network, a token ring network, a wide area network (WAN), the Internet, a virtual network, a virtual private network (VPN), an intranet, an extranet, a blockchain network, a public switched telephone network (PSTN), an infrared network, a wireless network (e.g., Bluetooth, WIFI), and / or any combination of these and / or other networks.

[0042] Server 120 may include one or more general-purpose computers, special-purpose server computers (e.g., PC (personal computer) servers, UNIX servers, mid-range servers), blade servers, mainframe computers, server clusters, or any other suitable arrangement and / or combination. Server 120 may include one or more virtual machines running a virtual operating system, or other computing architectures involving virtualization (e.g., one or more flexible pools of logical storage devices that can be virtualized to maintain virtual storage devices for servers). In some implementations, server 120 may run one or more services or software applications that provide the functionality described below.

[0043] The computing unit in server 120 can run one or more operating systems, including any of the aforementioned operating systems and any commercially available server operating system. Server 120 can also run any of a variety of additional server applications and / or middleware applications, including HTTP servers, FTP servers, CGI servers, JAVA servers, database servers, etc.

[0044] In some implementations, server 120 may include one or more applications to analyze and merge data feeds and / or event updates received from users of client devices 101, 102, 103, 104, 105 and / or 106. Server 120 may also include one or more applications to display data feeds and / or real-time events via one or more display devices of client devices 101, 102, 103, 104, 105 and / or 106.

[0045] In some implementations, server 120 can be a server for a distributed system or a server integrated with blockchain. Server 120 can also be a cloud server, or an intelligent cloud computing server or intelligent cloud host with artificial intelligence technology. A cloud server is a host product in the cloud computing service system, designed to address the shortcomings of traditional physical hosts and Virtual Private Server (VPS) services, such as high management difficulty and weak business scalability.

[0046] System 100 may also include one or more databases 130. In some embodiments, these databases 130 may be used to store data and other information. For example, one or more of the databases 130 may be used to store information such as audio files and video files. Databases 130 may reside in various locations. For example, a database used by server 120 may be local to server 120, or it may be located away from server 120 and may communicate with server 120 via a network-based or dedicated connection. Databases 130 may be of different types. In some embodiments, the database used by server 120 may be, for example, a relational database. One or more of these databases may store, update, and retrieve data from and from the databases in response to commands.

[0047] In some implementations, one or more of the databases 130 may also be used by an application to store application data. The databases used by the application may be of different types, such as key-value stores, object stores, or regular stores supported by a file system.

[0048] Figure 1 The system 100 can be configured and operated in various ways to enable the application of the various methods and apparatus described in this application.

[0049] Figure 2 This is a flowchart illustrating a method for providing usage information prompts according to embodiments of this application. The method can be executed by a usage information prompting device, which can be implemented in software and / or hardware and can be configured in an electronic device, typically a computer, mobile phone, or tablet. The usage information prompting method provided in this application is applicable to scenarios where the usage status of a table is prompted in a tiered manner, such as prompting the user in advance before the number of used data rows in the table reaches its limit. Figure 2 As shown, the method for providing usage information in this embodiment may include:

[0050] S201. In response to receiving a modification instruction for data rows in a table, obtain usage information of the table, the usage information including usage information of all data rows in the table and / or usage information of data rows in sub-tables, the usage information including usage rate.

[0051] A table is a structure that organizes and displays data in rows and columns, and it can be used to record data. This can include, but is not limited to, online spreadsheets that support multi-user collaboration or tables related to business operations. Data rows in a table refer to the horizontal components of the table; different data rows generally correspond to different data items, and a table can include one or more data rows. Sub-tables can be understood as tables contained within a table; a table file can contain one or more sub-tables. Table usage information can be understood as information related to the table's usage, such as usage information for all data rows in the table and / or usage information for data rows in sub-tables. This usage information can include usage rates, such as the usage rate of all data rows in the table and / or the usage rate of data rows in sub-tables. This usage rate can be obtained by calculating the ratio between the current number of used data rows in the table or sub-table and the total number. Furthermore, usage information can also further include the total number and used number of data rows, such as the total number and used number of all data rows in the table, and / or the total number and used number of data rows in sub-tables, etc.

[0052] Specifically, upon receiving a modification instruction for a data row in a table, the table's usage information can be retrieved. For example, usage information for all data rows in the table can be retrieved, such as at least one of the usage rate, number used, and total number of all data rows; and / or, usage information for data rows in sub-tables of the table can be retrieved, such as at least one of the usage rate, current number used, and total number of data rows in the sub-tables, etc., to facilitate subsequent hierarchical prompts regarding the table's usage information.

[0053] S202. In response to the usage rate matching the first prompt level, a prompt is displayed, the prompt including the usage information.

[0054] The first prompt level can be one of several pre-defined prompt levels that matches the table's usage rate. In some examples, the table's usage rate can be greater than or equal to the usage rate corresponding to the first prompt level, but less than the usage rate corresponding to the next higher prompt level adjacent to the first prompt level.

[0055] Optionally, the table has multiple prompt levels, including the first prompt level, with different prompt levels corresponding to different usage rate thresholds. These multiple prompt levels can be understood as multiple usage rate levels, each corresponding to a different usage rate threshold. For example, as the prompt level increases, the corresponding usage rate threshold can increase. The number of prompt levels and their corresponding thresholds can be flexibly set as needed; this embodiment does not limit this. For instance, in ascending order of prompt levels, the usage rate thresholds corresponding to these multiple prompt levels could be: 70%, 80%, 90%, 95%, 99%, and 100%, etc. The prompting methods corresponding to different prompt levels can be the same or different, or the table's state under different prompt levels can be the same or different. This state can be used to indicate whether to prompt the table's usage information when the table's usage rate matches this prompt level.

[0056] The prompt content for a table can be understood as content used to indicate the current usage information of the table. For example, this prompt content may include the table's usage information to inform the user of this usage information. In some examples, this prompt content may include a first prompt content and / or a second prompt content. Optionally, the first prompt content includes the usage information; the second prompt content is used to indicate one or more of the following: a first prompt level, or, the usage rate is greater than or equal to a first usage rate threshold, where the first usage rate threshold includes the smallest usage rate threshold among the different usage rate thresholds.

[0057] The first prompt may include usage information for the table to inform the user of this usage information. For example, the first prompt may indicate at least one of the following: the usage rate of data rows in the table, the number used, and the total number; and / or, indicate at least one of the following: the usage rate of data rows in the table's sub-tables, the current number used, and the total number, etc.

[0058] The second prompt content can be used to indicate that the usage rate of the form matches the first prompt level; it can also be used to indicate that the usage rate of the form is greater than or equal to the first usage rate threshold. For example, the second prompt content corresponding to at least some prompt levels can have different display styles, so that the display of the second prompt content can indicate to the user that the usage rate of the form is greater than or equal to the first usage rate threshold, and the different display styles of the second prompt content can indicate that the usage rate of the form currently matches the first prompt level in this at least some prompt levels; or, the second prompt content corresponding to at least some prompt levels, including the lowest prompt level, can have the same display style, so that the display of the second prompt content can indicate to the user that the usage rate of the form is greater than or equal to the first usage rate threshold.

[0059] The first usage rate threshold can be the threshold that triggers tiered alerts, such as the minimum threshold for triggering tiered alerts. In some examples, the first usage rate threshold can correspond to the lowest alert level among multiple set alert levels. The second usage rate thresholds for other alert levels besides this lowest alert level can be different from the first usage rate threshold. The first usage rate threshold can be set as needed; for example, the first usage rate threshold can be less than 100%. Taking usage rate thresholds of 70%, 80%, 90%, 95%, 99%, and 100% for each alert level as an example, the first usage rate threshold can be 70%.

[0060] In this step, if the usage rate of the table matches the first prompt level, a prompt can be displayed to provide usage information for the table.

[0061] In some cases, after obtaining the usage rate of a form, it can be determined whether this usage rate matches a pre-set prompt level, and based on this, it can be determined whether to prompt the user with usage information for this form.

[0062] For example, after obtaining the usage rate of the table, it can be determined whether the usage rate of the table is greater than or equal to the first usage rate threshold.

[0063] If the table's usage rate is greater than or equal to a first usage rate threshold, it can be determined that the table's usage rate matches a pre-set prompt level. Furthermore, the prompt level matched by this usage rate can be determined. For example, it can be judged whether this usage rate is greater than the usage rate threshold corresponding to the highest prompt level, or whether it lies between the usage rate thresholds corresponding to two adjacent prompt levels. If the table's usage rate is greater than the usage rate threshold corresponding to the highest prompt level, this highest prompt level can be determined as the first prompt level matched by this usage rate. Alternatively, if the table's usage rate is greater than or equal to the usage rate corresponding to a certain prompt level but less than the usage rate corresponding to the next higher prompt level, this prompt level can be used as the first prompt level matched by this usage rate.

[0064] If the usage rate of the table is less than the first usage rate threshold, it can be determined that the usage rate of the table does not match the pre-set prompt level. In this case, the user may not be prompted about the usage of the table, such as not displaying prompt content, in order to avoid interfering with the user by prompting about the usage of the table.

[0065] In some implementations, the prompt content may include a first prompt content and / or a second prompt content. Taking the prompt content as including a first prompt content and a second prompt content as an example, the timing of displaying the first prompt content and the second prompt content can be flexibly set as needed. Optionally, displaying the prompt content includes: displaying the first prompt content and the second prompt content; or, displaying the second prompt content; or, displaying the first prompt content in response to a first trigger operation based on the second prompt content. For example, when the table is in a first state at the first prompt level, both the first and second prompt content can be displayed without user triggering; alternatively, the second prompt content can be displayed, and upon receiving a first trigger operation from the user for the second prompt content, the first prompt content can be displayed, and the display of the second prompt content can be maintained or canceled. Here, the first trigger operation can be understood as a trigger operation used to indicate the display of the first prompt content for the table. In some examples, the first trigger operation can be performed based on the second prompt content for the table. For example, the first trigger operation may include an operation to move an input indicator (such as a cursor) to the display area of ​​the second prompt content, or an operation to trigger the second prompt content, etc. This implementation is not limited in this comparison.

[0066] In some implementations, after determining the first prompt level that the usage rate matches, usage information for the form can be prompted based on this first prompt level. For example, it can be determined whether to prompt the user with usage information for the form when the usage rate is within the first prompt level, based on the state of the form in the first prompt level; and / or, prompting the user with usage information for the form can be done using a prompting method corresponding to the first prompt level, such as displaying prompt content for the form, etc.

[0067] In some implementations, the decision to prompt the user with table usage information can be determined based on the table's state within the first prompt level, specifically when the usage rate is within that level. Optionally, displaying prompt content in response to the usage rate matching the first prompt level includes: displaying prompt content in response to the usage rate matching the first prompt level and the table being in a first state at the first prompt level. For example, when the table is in a first state within the first prompt level, prompt content can be displayed for the table, providing usage information about the table.

[0068] The table can have at least two different states at a certain prompt level (such as the first prompt level), such as a first state and a second state. The first state can be a state where usage information is prompted, and the second state can be a state where usage information is not prompted. For example, if the table is in the first state at a certain prompt level, and the usage rate of the table matches this prompt level, usage information can be prompted to the user, for example, displaying prompt content for the table; if the table is in the second state at a certain prompt level, and the usage rate of the table matches this prompt level, usage information can be not prompted to the user, for example, not displaying prompt content for the table.

[0069] For example, after determining the first alert level where the usage rate falls, the status of the table at that first alert level can be further determined. For instance, a status list can be pre-set to record the status of one or more tables at different alert levels, or the status list can record the alert level at which each table is currently in the first state or the alert level at which it is currently in the second state. After determining the first alert level that the usage rate of a certain table matches, the status of that table at the first alert level can be determined based on this status list.

[0070] If the table is in the first prompt level state, then prompt content can be displayed. For example, as Figure 3 As shown in the figure (using a data table that supports collaborative editing by multiple users as an example), the table interface can include a first area 31 and a second area 32. The first area 31 can be used to display a list of tables that the user has access to, and the second area 32 can be used to display the data content of the table selected by the user in the first area 31. When this table interface is displayed, if the table is in the first prompt level state, prompts for the table can be displayed in this table interface, such as the table name (e.g., in the first prompt area 31) along with the table name. Figure 3 The first prompt 33 and / or the second prompt 34 are displayed at the locations associated with the data tables 1 and 3 shown in the figure.

[0071] In some examples, when a table is in the first state at the first prompt level, when the table interface is displayed, the second prompt content can be displayed in the position associated with the table name in the first area until the table's state in the first prompt level changes from the first state to the second state or the table's usage rate changes to the prompt level of the second state.

[0072] When the table is in the first state of the first prompt level, if the table data is displayed when the table interface is displayed (e.g., the data displayed in the current second area is the data of this table), and the number of times the first prompt content for the table is displayed is less than or equal to a preset display count threshold, the first prompt content for the table can be automatically displayed based on the table interface; and / or, if the table data is not displayed (e.g., the data displayed in the current second area is not the data of this table), the first prompt content for the table can be displayed in response to the user's first trigger operation for the second prompt content.

[0073] In addition, after the first prompt is displayed, the user can also cancel the display of the first prompt by triggering a corresponding action (such as a second or third trigger).

[0074] Optionally, the method for prompting usage information may further include at least one of the following: in response to a second triggering operation, maintaining the table in the state of the first prompting level and canceling the display of the first prompting content; in response to a third triggering operation, switching the state of the table in at least one prompting level to a second state and canceling the display of the prompting content, wherein the at least one prompting level includes the first prompting level and / or the second prompting level, and the usage rate threshold corresponding to the second prompting level is less than the usage rate threshold corresponding to the first prompting level.

[0075] The second prompt level can be a prompt level lower than the first prompt level among a set of preset prompt levels. For example, the usage rate threshold corresponding to the second prompt level can be lower than the usage rate threshold corresponding to the first prompt level. The first state can be a state where usage information is prompted, and the second state can be a state where usage information is not prompted.

[0076] Both the second and third trigger operations can be used to instruct the cancellation of the first prompt content for the table. The second trigger operation can cancel the display of the first prompt content for the table while maintaining the table's state at all prompt levels (including the first prompt level), and retain the display of the second prompt content for the table. The third trigger operation can switch the table's state from the first state to the second state at at least some prompt levels, and cancel the display of both the first and second prompt content for the table. The execution method of the second and third trigger operations is not limited; for example, the second and third trigger operations can act on the same or different controls, or on the same or different areas. In some examples, the second trigger operation may include a cancellation operation performed on the first prompt content when the cancellation prompt item for the table is not selected; the third trigger operation includes a cancellation operation performed on the first prompt content when the cancellation prompt item for the table is selected. The execution method of this cancellation operation is not limited; for example, this cancellation operation may include an operation that triggers an area other than the first prompt content, or an operation that triggers the cancellation control for the first prompt content, etc.

[0077] For example, upon receiving a second trigger operation, the table can remain in the first state at the first prompt level, the first prompt content for the table can be canceled, and the second prompt content for the table can remain displayed. Upon receiving a third trigger operation, the table's state at the first prompt level and / or at least one second prompt level can be switched from the first state to the second state, and the first and second prompt contents for the table can be canceled.

[0078] In one situation, such as Figure 3As shown, when a user triggers an area outside the first prompt content 33, or triggers a first control (such as the cancel display control 35) or a second control (such as the expand control 36) associated with the first prompt content 33, it can be determined whether the cancel prompt item 37 associated with the first prompt content 33 is selected. If this cancel prompt item 37 is unselected, it can be confirmed that a second trigger operation has been received, and in response to this second trigger operation, the first prompt content 33 is canceled, the second prompt content 34 for the table is displayed, and the table remains in the first prompt level state. If this cancel prompt item 37 is selected, it can be determined that a third trigger operation has been received, and in response to this third trigger operation, the first prompt content 33 and the second prompt content 34 for the table are canceled, and the state of the table at the first prompt level and / or the second prompt level is switched from the first state to the second state. For example, the state of the table at the first prompt level and each of the second prompt levels is switched from the first state to the second state to meet the user's different prompt needs for table usage information at different prompt levels.

[0079] In some examples, regardless of whether the first prompt level is the third prompt level, when displaying the first prompt content for the table, the corresponding cancel prompt item for the table can be displayed, so that users can set whether to display table usage information at each prompt level as needed.

[0080] In other examples, it may be considered whether the first prompt level is the third prompt level. Only when the first prompt level is not the third prompt level, when displaying the first prompt content for the table, a cancellation prompt item corresponding to the table is further displayed; when the first prompt level is the third prompt level, when displaying the first prompt content for the table, the cancellation prompt item corresponding to the table is not displayed, in order to avoid the situation where the user switches the table to the second state at this prompt level, resulting in the inability to prompt key changes in the table's usage information.

[0081] In this case, optionally, in response to the first prompt level and the third prompt level being different prompt levels, the prompt content displays a cancel prompt item, which is used to switch the state of the table at the first prompt level; in response to the first prompt level and the third prompt level being the same prompt level, the prompt content does not display a cancel prompt item.

[0082] The third prompt level can be understood as the prompt level that keeps the table in the first state. The third prompt level can be a critical prompt level that needs to provide the user with usage information about the table. For example, the third prompt level can be the highest usage level among multiple pre-set prompt levels, such as the prompt level corresponding to a usage rate of 100%, to ensure that the user is prompted when the table's used capacity is greater than or equal to its maximum capacity supported by the user. The number of third prompt levels can be one or more; for example, the third prompt level can further include other prompt levels besides the pre-set highest prompt level, which can be set as needed.

[0083] Understandably, after canceling the display of the first prompt, it is also possible to respond to the user's first trigger action on the second prompt and redisplay the first prompt for the table.

[0084] The usage information prompting method provided in this embodiment, in response to receiving a modification instruction for data rows in a table, obtains the table's usage information, which includes usage information for all data rows in the table and / or the usage information for data rows in sub-tables, and includes a usage rate; in response to this usage rate matching a first prompt level, displays prompt content, which includes the aforementioned usage information. This embodiment, by utilizing the above technical solution, provides tiered prompts for table usage information. Compared to a solution that only prompts users after the table's capacity reaches or exceeds its limit, this allows users to receive clear prompts before the table's capacity reaches its limit, improving the practicality of prompting table usage information, reducing operation failures due to the table's capacity reaching or exceeding its limit, and enhancing the continuity of business processes.

[0085] Figure 4 This is a flowchart illustrating another method for providing usage information according to an embodiment of this application. The solution in this embodiment can be combined with one or more optional solutions from the above embodiments. Optionally, the step of obtaining table usage information in response to receiving a modification instruction for a data row in the table includes: updating the table usage rate in response to receiving a modification instruction for a data row in the table and currently meeting update conditions; and obtaining usage information for at least one table in response to the completion of the usage rate update, wherein the usage rate of the at least one table is greater than or equal to a first usage rate threshold.

[0086] Correspondingly, such as Figure 4 As shown, the method for providing usage information in this embodiment may include:

[0087] S301. In response to receiving a modification instruction for a data row in a table, and if the update conditions are currently met, update the usage rate of the table.

[0088] The update condition can be understood as the condition that triggers the recalculation and update of the table's usage rate. This update condition can be set as needed; for example, it can be a periodic update or an update triggered upon receiving a modification instruction for data rows in the table. Optionally, the update condition includes at least one of the following: a first duration reaches a first duration threshold, or a second duration reaches a second duration threshold, to achieve a balance between the timeliness of updating the usage rate and the table's occupancy status, avoiding resource consumption and user interference caused by frequent usage rate updates and notifications.

[0089] Modification instructions for data rows in a table can be understood as events that cause changes to the table's usage information. In some examples, modification instructions for data rows in a table may include deletion instructions for data rows in the table, and / or addition instructions for data rows in the table, etc. A deletion instruction can be used to instruct the deletion of one or more data rows in the table, such as instructing the switching of one or more data rows in the table from a used state to an unused state; an addition instruction can be used to instruct the addition of one or more data rows in the table, such as when a user instructs the switching of one or more data rows in the table from an unused state to a used state. Different modification instructions may correspond to the same or different tables for the current user, and these modification instructions may be generated based on data deletion or data addition operations performed on this table by the current user or other users with collaborative editing permissions.

[0090] Optionally, the first duration is the time elapsed since the last usage rate update, and the second duration is the time elapsed since the last modification instruction was received; the table is a table containing modification instructions since the last usage rate update, and the modification instruction is an event in which usage information has changed.

[0091] The first duration can be understood as the time elapsed since the last usage rate update; the second duration can be understood as the time elapsed since the last modification command was received. The first and second duration thresholds can be set as needed. For example, the first duration threshold can be greater than the second duration threshold. For instance, the first duration threshold can be set to 2000ms or 3000ms, and the second duration threshold can be set to 200ms or 400ms.

[0092] Specifically, upon receiving a modification instruction for data rows in a table, it can be determined whether the current conditions meet the usage rate update conditions. If the current conditions meet the usage rate update conditions, for example, if the current time is within a first time threshold since the last usage rate update, and / or if the current time is within a second time threshold since the last received modification instruction, it can be determined that tables have had data row changes since the last batch calculation and update of usage rates. For each table or at least some tables, the total number of data rows in the table and the number of rows used are obtained. The usage rate of the table is calculated based on this total number and the number of rows used, and the stored usage rate is updated.

[0093] In this solution, the method for determining whether the current conditions meet the update conditions can be set as needed.

[0094] Optionally, the step of updating the table's usage rate in response to receiving a modification instruction for a data row in the table, and where the update conditions are currently met, includes: in response to receiving a modification instruction for the table, obtaining a first duration, where the first duration is the duration since the last usage rate update; in response to the first duration reaching a first duration threshold, updating the table's usage rate; in response to the first duration not reaching the first duration threshold, timing based on a timer; and in response to the second duration recorded by the timer reaching the second duration threshold, updating the table's usage rate and turning off the timer.

[0095] For example, each time a modification instruction for a data row in a table is detected, a first duration since the last usage update can be obtained. If this first duration is greater than or equal to a first duration threshold, the tables with modification instructions since the last usage update can be identified, and the usage rate of each table can be calculated and updated. If this first duration is less than the first duration threshold, timing can be started, such as using a timer; if a second duration of timing is greater than or equal to a second duration threshold, the tables with modification instructions since the last usage update can be identified, the usage rate of each table can be calculated and updated, and the timer can be turned off.

[0096] Taking timer-based timing as an example, when timing is initiated based on a timer in response to a first duration being less than a first duration threshold, timing can be based on an already started timer or a new timer can be started. For instance, if a timer is already started and not yet closed (e.g., the timing duration has not yet reached the second duration threshold), this already started timer can be reset, such as resetting its timing duration (i.e., the second duration) to zero, and using the reset timer for timing. This avoids the simultaneous existence of multiple timers timing the second duration, thereby avoiding frequent triggering of usage rate updates and usage information reminders. If no timer is already started and not yet closed, a timer can be started to time the second duration. In this case, optionally, timing based on a timer includes at least one of the following: in response to the existence of an already started timer, initializing the timing duration of the timer and restarting timing based on the timer; or, in response to the absence of an already started timer, starting a timer and timing based on the timer.

[0097] Furthermore, when updating the usage rate in response to the first duration reaching a first duration threshold, if there is a timer currently used to time the second duration and has not yet been turned off, this timer may not be turned off, and the usage rate update and usage information prompt may be performed when the timer's timing duration reaches the second duration threshold; alternatively, this timer may be turned off to further reduce the number of usage rate updates and usage information prompts. In this case, optionally, the usage information prompting method may further include: turning off the started timer in response to the first duration reaching the first duration threshold.

[0098] In some implementations, after updating the usage rate, the updated usage rate can be further stored, and / or a table recording the updated usage rate that is greater than or equal to a first usage rate threshold can be created. For example, the updated usage rate can be stored locally on the client or on the server, and / or a table recording the updated usage rate that is greater than or equal to the first usage rate threshold can be created for subsequent retrieval.

[0099] Optionally, the updated usage rate is stored in a usage rate list; and, based on the updated usage rate, a first set is updated, wherein the first set is used to record a first table, the usage rate of the first table being greater than or equal to a first usage rate threshold.

[0100] The usage rate list can be a list used to store the usage rates of each user-related table. For example, the usage rates of each user-related table can be stored in key-value pairs in this list. The first set can be understood as a set of user-related first tables, such as storing the table identifiers of each first table. The first table can be a table whose usage rate is greater than or equal to a first usage rate threshold. This table identifier can be understood as the table's identifier, such as the table's name and / or identifier (ID), etc.

[0101] For example, after updating the usage rate, the usage rate list can be updated based on the updated usage rate. For instance, the usage rate stored in the usage rate list can be updated from the usage rate before the update to the usage rate of the corresponding table after the update, so that the updated usage rate is stored in the usage rate list. Furthermore, tables whose updated usage rate is greater than or equal to a first usage rate threshold can be identified, and the table identifier of these tables can be added to a first set. For instance, for tables whose updated usage rate is greater than or equal to the first usage rate threshold, if the table identifier of this table is not in the first set, the table identifier of this table can be added to the first set. And for tables whose updated usage rate is less than the first usage rate threshold, if the table identifier of this table is in the first set, the table identifier of this table can be removed from the first set, so as to ensure that all tables corresponding to the table identifiers in the first set have a usage rate greater than or equal to the first usage rate threshold.

[0102] In some implementations, a second set can be set up locally on the client or on the server to record tables whose usage rates match the third prompt level. For example, after updating the usage rates, the second set can be updated based on the updated usage rates of each table. For instance, tables whose updated usage rates match the third prompt level but whose pre-update usage rates did not match the third prompt level can be retrieved and their table identifiers added to the second set. Similarly, tables whose updated usage rates do not match the third prompt level but whose pre-update usage rates match the third prompt level can be retrieved and their table identifiers removed from the second set. This ensures that all tables corresponding to the table identifiers in the second set have usage rates matching the third prompt level. Therefore, it can be subsequently determined whether the first prompt level for a table's usage rate is at the third prompt level based on whether the table identifier is within the second set, and thus determine whether to display a cancellation prompt item corresponding to that table when displaying the first prompt content for that table. Optionally, in this case, the usage information prompting method can further include: updating the second set based on the updated usage rates, wherein the second set is used to record second tables whose usage rates match the third prompt level. The second set can be understood as a collection of second tables, such as storing one or more table identifiers for the second tables. The second table can be understood as a table whose usage rate matches the third prompt level.

[0103] S302. In response to the completion of the usage rate update, obtain the usage information of at least one table, wherein the usage rate of the at least one table is greater than or equal to a first usage rate threshold.

[0104] Specifically, after the usage rate of each table is updated, the tables with a usage rate greater than or equal to the first usage rate threshold can be identified, and the usage rate of these tables can be obtained. This information can then be used to prompt the user with table usage information based on the first prompt level matched by this usage rate.

[0105] In some examples, when updating the usage rates of each table, the first set can be updated based on the updated usage rates of each table. After the first set is updated, the table corresponding to the table identifier in the first set can be identified, and the usage rate of this table can be obtained from the usage rate list, and / or, the total number of data rows and the number of used rows in this table can be obtained, thereby realizing the acquisition of table usage information. In this case, optionally, the usage information also includes the total number of data rows and the number of used rows, and the acquisition of table usage information includes: for at least some tables in the first set, obtaining the usage rate of the table from the usage rate list, and determining the total number of data rows and the number of used rows.

[0106] S303. In response to the usage rate matching the first prompt level, a prompt is displayed, the prompt including the usage information.

[0107] The usage information prompting method provided in this embodiment does not immediately update the usage rate and prompt the usage information after receiving a modification instruction for a data row in the table. Instead, it adopts an asynchronous approach, updating the usage rate and prompting the usage information only after a first duration threshold is reached or a second duration threshold is reached. This avoids the need for frequent updates and prompts of the table's usage information due to high-frequency modifications to the data rows in the table, reduces the resources occupied by updating the usage rate, and reduces the interference caused to the user by prompting the usage information.

[0108] In some alternative implementations, taking a data table as an example, in modern data collaboration platforms (such as online spreadsheets), due to considerations such as technical architecture (such as performance bottlenecks in full-load mode) or system stability (preventing abuse by a single user from causing a decline in overall service quality), there are usually restrictions on the amount of data that users can create (especially the number of "records" or "rows").

[0109] Related technologies typically employ a relatively simple static upper limit check mechanism. For example, when a user attempts to add a record, the system only checks whether a preset fixed upper limit has been exceeded momentarily. The drawback of this method is that:

[0110] Lack of early warning: Users only become aware of the limitations when they reach or exceed the limit or when an operation fails, making it impossible to plan data capacity or make necessary upgrades in advance, resulting in an interrupted user experience.

[0111] The prompts are not intelligent: The prompts are usually a single modal pop-up or error message, lacking the ability to provide tiered prompts based on the proximity of usage to total usage.

[0112] Inflexible notification mechanism: The data modification instructions on the backend and the user interface (UI) prompts on the frontend are usually tightly coupled or polled, lacking an efficient, low-latency notification mechanism that can handle high-frequency events. In high-concurrency write scenarios, this may lead to frequent frontend refreshes or data delays.

[0113] In view of this, this embodiment provides a method for prompting usage information. This method detects or receives modification instructions for data rows in a table, asynchronously calculates the usage rate of each data table, and efficiently transmits the usage rate changes to the UI layer through an asynchronous notification mechanism. Finally, the UI layer determines whether and how to display tiered prompts based on the status of the data table in each prompt level, so as to at least solve at least some of the above-mentioned problems.

[0114] For example, taking the longest waiting time (i.e., the first duration threshold) NOTIFY_MAX_DELAY as 2000ms and the throttling delay (i.e., the second duration threshold) NOTIFY_THROTTLE_DELAY as 200ms as an example, during initialization, modification instructions for each data table can be subscribed to from the event bus, such as modification instructions related to changes in usage rate. This allows the data bus to send the modification instructions to the thread or module executing the usage information prompting method provided in this embodiment when there are modification instructions for data rows in each data table.

[0115] Upon receiving a modification instruction from the data bus, the interval between the current time and the last time a prompt was made (i.e., the first duration) can be detected.

[0116] If this interval has reached or exceeded NOTIFY_MAX_DELAY, then NOTIFY_THROTTLE_DELAY will be disregarded, and the usage rate will be updated immediately along with usage information.

[0117] If this interval has not yet reached NOTIFY_MAX_DELAY, a timer corresponding to NOTIFY_THROTTLE_DELAY can be started. During this period, if there is a new status change (such as receiving a new modification instruction), the timer's duration is reset.

[0118] When the timer expires (i.e., the second duration reaches the second duration threshold) or the longest waiting condition is met (i.e., the first duration reaches the first duration threshold), the exposed table usage status change hook (onTableUsedStatusChange) can be called to update the usage rate of all affected (i.e., modified) data tables in this change cycle, and to provide usage information prompts for data tables whose table ID (i.e., table identifier) ​​is located in the set changeTableIdSet (i.e., the first set).

[0119] For example, two sets, approachLimitTableIdSet (i.e., the first set) and reachMaxLimitTableIdsSet (i.e., the second set), can be maintained locally on the client, along with a map: tableUsedPercentMap (i.e., the usage rate list), which stores the table IDs that are at the threshold (i.e., the usage rate is greater than or equal to the first usage rate threshold), the table IDs that have reached the upper limit (i.e., the usage rate matches the third warning level), and the usage percentage (i.e., the usage rate) of each table.

[0120] When updating the usage rate of a data table, the latest number of used records (i.e., the number of records used) can be obtained. Based on the number of records and the upper limit (i.e., the total number), the usage rate usedPercent of this data table is calculated, and it is determined whether usedPercent has reached or exceeded the preset threshold (i.e., the first usage rate threshold), and whether the number of records has reached or exceeded the upper limit (i.e., whether the usage rate matches the third warning level). The above set and mapping are updated based on the judgment results.

[0121] The client can store a tiered threshold array tipLevels=[100, 99, 95, 90, 80, 70] (i.e., the usage thresholds corresponding to multiple tip levels), and can find the highest threshold level (i.e., the first tip level that determines the usage of the table) based on the usedPercent stored in the mapping.

[0122] In addition, a cancellation prompt mapping can be stored in LocalStorage, which stores the user's instructions to cancel the prompt by clicking "Don't prompt again" (i.e., the cancellation prompt item) for each table and at which level.

[0123] If the current level is greater than or equal to the "Don't remind me again" level recorded in the above mapping, it indicates that the data table has entered a more severe usage state. In this case, a warning icon (i.e., a second warning message) can be displayed, such as setting the iconVisible display state to true. If the current level is less than the level recorded in the above mapping, the warning icon can be hidden based on the user's settings, such as setting the iconVisible display state to false. Furthermore, when the number of records decreases, causing the current usage rate to become 0, the "Don't remind me again" status can be reset so that the warning message is displayed again the next time the table re-enters the critical usage state.

[0124] When `iconVisible` is true, the current table is active (i.e., in a displayed state), and the user has not actively closed the popover for this table (i.e., the first popover message), the popover can automatically appear. Whether the user has actively closed the popover for this table can be determined by the popover flag in `LocalStorage`. Clicking on a non-Popover area or the corresponding control within the popover area closes the popover. In this case, `LocalStorage` records that the table has triggered a popover closure once to prevent subsequent automatic popovers. Clicking "Don't show again," for example, if the user checks "Don't show again" in the popover and closes it, the current level is recorded in `LocalStorage`. Furthermore, when the usage rate is at 100% (i.e., the third popover level), the "Don't show again" option may not be displayed to ensure that a prompt is given even when the limit is reached.

[0125] This implementation utilizes the aforementioned technical solution, employing a proactive and tiered early warning mechanism. Users receive clear notifications before reaching the capacity limit, effectively preventing operation failures due to capacity constraints. Furthermore, the personalized "don't remind me again" function reduces unnecessary interference. The asynchronous batch notification method, combining "event-driven + throttling waiting," effectively solves the "notification storm" problem under high-frequency write operations, reducing front-end and back-end communication overhead and front-end UI rendering load, ensuring smooth interface response. By decoupling the capacity limit strategy from the detection mechanism, adjusting and expanding the capacity limit strategy becomes simple, enabling rapid adaptation to changing business needs without modifying the core monitoring logic. By maintaining multiple state sets and maps, the usage status of each table is centrally and efficiently managed, ensuring that the complexity of status query and update operations is O(1), guaranteeing high performance in large-scale data table scenarios.

[0126] Figure 5 This is a structural block diagram of a usage information prompting device provided for embodiments of this application. The device can be implemented by software and / or hardware, and can be configured in an electronic device, typically a computer, mobile phone, or tablet computer. It can provide tiered prompts on the usage status of a table by executing a usage information prompting method, such as prompting the user in advance before the number of used data rows in the table reaches its limit. Figure 5 As shown, the information prompting device provided in this embodiment may include: an information acquisition module 501 and a prompting module 502, wherein,

[0127] The information acquisition module 501 is used to acquire the usage information of the table in response to receiving a modification instruction for the data rows in the table. The usage information includes the usage information of all data rows in the table and / or the usage information of the data rows in the sub-tables. The usage information includes the usage rate.

[0128] The prompt module 502 is used to display prompt content in response to the usage rate matching the first prompt level.

[0129] The usage information prompting device provided in this embodiment, in response to receiving a modification instruction for data rows in a table, acquires the table's usage information through an information acquisition module. This usage information includes the usage information of all data rows in the table and / or the usage information of data rows in sub-tables, and includes a usage rate. The prompting module, in response to this usage rate matching a first prompting level, displays prompt content, which includes the aforementioned usage information. This embodiment, by utilizing the above technical solution, provides tiered prompts for table usage. Compared to a solution that only prompts users after the table's capacity reaches or exceeds its limit, this allows users to receive clear prompts before the table reaches its capacity limit, improving the practicality of prompting table usage, reducing operation failures due to resource capacity reaching or exceeding limits, and enhancing the continuity of business processes.

[0130] Optionally, the prompting module 502 may be specifically used to: display a first prompting content and a second prompting content; or, display the second prompting content; in response to a first triggering operation based on the second prompting content, display the first prompting content; wherein, the table has multiple prompting levels, the multiple prompting levels include the first prompting level, and different prompting levels correspond to different usage rate thresholds; the first prompting content includes the usage information; the second prompting content is used to prompt one or more of the following: the first prompting level, or, the usage rate is greater than or equal to a first usage rate threshold, the first usage rate threshold including the minimum usage rate threshold among the different usage rate thresholds.

[0131] Optionally, the prompt module 502 may be specifically used to: display prompt content in response to the usage rate matching a first prompt level, and the table being in a first state at the first prompt level.

[0132] Furthermore, the usage information prompting device may further include at least one of the following: a first cancellation display module, configured to, in response to a second trigger operation, maintain the table in the state of the first prompt level unchanged and cancel the display of the first prompt content; a second cancellation display module, configured to, in response to a third trigger operation, switch the state of the table in at least one prompt level to a second state and cancel the display of the prompt content, wherein the at least one prompt level includes the first prompt level and / or the second prompt level, and the usage rate threshold corresponding to the second prompt level is less than the usage rate threshold corresponding to the first prompt level.

[0133] Optionally, in response to the first prompt level and the third prompt level being different prompt levels, the prompt content is associated with a cancel prompt item, which is used to switch the state of the table at the first prompt level; in response to the first prompt level and the third prompt level being the same prompt level, the prompt content is not associated with a cancel prompt item.

[0134] Furthermore, the information acquisition module 501 may include: a usage rate update unit, configured to update the usage rate of the table in response to receiving a modification instruction for a data row in the table and the current update condition being met; and an information acquisition unit, configured to acquire usage information of at least one table in response to the completion of the usage rate update, wherein the usage rate of the at least one table is greater than or equal to a first usage rate threshold.

[0135] Optionally, the utilization rate update unit may include: a duration acquisition subunit, configured to acquire a first duration in response to receiving a modification instruction for the table, wherein the first duration is the duration since the last utilization rate update at the current time; a first update subunit, configured to update the utilization rate of the table in response to the first duration reaching a first duration threshold; a second update subunit, configured to perform timing based on a timer in response to the first duration not reaching the first duration threshold; and to update the utilization rate of the table and turn off the timer in response to the second duration recorded by the timer reaching the second duration threshold.

[0136] Optionally, the second update subunit may be specifically used to perform at least one of the following: in response to the existence of an already started timer, initialize the timing duration of the timer and restart timing based on the timer; or, in response to the absence of an already started timer, start the timer and start timing based on the timer; the usage information prompting device may further include: a timer shutdown module, used to shut down the already started timer in response to the first duration reaching a first duration threshold.

[0137] Furthermore, the usage information prompting device may further include: a usage rate storage module for storing the updated usage rate in a usage rate list; and a first addition module for updating a first set based on the updated usage rate, wherein the first set is used to record a first table, and the usage rate of the first table is greater than or equal to a first usage rate threshold; the usage information also includes the total number of data rows and the number of rows used, and the information acquisition module 501 may be specifically used to: for at least some tables in the first set, obtain the usage rate of the table from the usage rate list, and determine the total number of data rows and the number of rows used.

[0138] Furthermore, the usage information prompting device may also include: a second adding module, used to update a second set based on the updated usage rate, wherein the second set is used to record a second table, and the usage rate of the second table matches the third prompt level.

[0139] The usage information prompting device provided in the embodiments of this application can execute the usage information prompting method provided in any embodiment of this application, and has the corresponding functional modules and beneficial effects for executing the usage information prompting method. Technical details not described in detail in this embodiment can be found in the usage information prompting method provided in any embodiment of this application.

[0140] The following is for reference. Figure 6 The diagram illustrates a structural schematic of an electronic device (e.g., a client device) 600 suitable for implementing embodiments of this application. The terminal devices in the embodiments of this application may include, but are not limited to, mobile terminals such as mobile phones, laptops, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. Figure 6 The electronic device shown is merely an example and should not impose any limitation on the functionality and scope of use of the embodiments of this application.

[0141] like Figure 6 As shown, electronic device 600 may include a processing device (e.g., a central processing unit, a graphics processor, etc.) 601, which can perform various appropriate actions and processes according to a program stored in read-only memory (ROM) 602 or a program loaded from storage device 608 into random access memory (RAM) 603. RAM 603 also stores various programs and data required for the operation of electronic device 600. Processing device 601, ROM 602, and RAM 603 are interconnected via bus 604. Input / output (I / O) interface 605 is also connected to bus 604.

[0142] Typically, the following devices can be connected to I / O interface 605: input devices 606 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 607 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 608 including, for example, magnetic tapes, hard disks, etc.; and communication devices 609. Communication device 609 allows electronic device 600 to communicate wirelessly or wiredly with other devices to exchange data. Although Figure 6 An electronic device 600 with various devices is shown; however, it should be understood that it is not required to implement or possess all of the devices shown. More or fewer devices may be implemented or possessed alternatively.

[0143] Specifically, according to embodiments of this application, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this application include a computer program product comprising a computer program carried on a non-transitory computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via a communication device 609, or installed from a storage device 608, or installed from a ROM 602. When the computer program is executed by the processing device 601, it performs the functions defined in the methods of embodiments of this application.

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

[0145] In some implementations, clients and servers can communicate using any currently known or future-developed network protocol such as HTTP (Hypertext Transfer Protocol) and can interconnect with digital data communication (e.g., communication networks) of any form or medium. Examples of communication networks include local area networks (“LANs”), wide area networks (“WANs”), the Internet (e.g., the Internet of Things), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future-developed networks.

[0146] The aforementioned computer-readable medium may be included in the aforementioned electronic device; or it may exist independently and not assembled into the electronic device.

[0147] The aforementioned computer-readable medium carries one or more programs that, when executed by the electronic device, cause the electronic device to: in response to receiving a modification instruction for data rows in a table, acquire usage information of the table, the usage information including usage information of all data rows in the table and / or usage information of data rows in sub-tables, the usage information including a usage rate; and in response to the usage rate matching a first prompt level, display prompt content, the prompt content including the usage information.

[0148] Computer program code for performing the operations of this application can be written in one or more programming languages ​​or a combination thereof, including but not limited to object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages ​​such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0149] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this application. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0150] The units described in the embodiments of this application can be implemented in software or hardware. The names of modules do not, in some cases, constitute a limitation on the unit itself.

[0151] The functions described above in this document can be performed at least in part by one or more hardware logic components. For example, exemplary types of hardware logic components that can be used, without limitation, include: field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), system-on-a-chip (SoCs), complex programmable logic devices (CPLDs), and so on.

[0152] In the context of this application, a machine-readable medium can be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, apparatus, or device. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. Machine-readable media can be, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0153] According to one or more embodiments of this application, Example 1 provides a method for prompting information, including:

[0154] In response to receiving a modification instruction for a data row in a table, the user obtains the table's usage information, which includes the usage information of all data rows in the table and / or the usage information of data rows in sub-tables, and the usage information includes the usage rate.

[0155] In response to the usage rate matching a first prompt level, a prompt is displayed, the prompt including the usage information.

[0156] According to one or more embodiments of this application, Example 2, based on the method described in Example 1, includes the following:

[0157] Display the first and second prompts; or,

[0158] Display a second prompt; in response to a first triggering operation based on the second prompt, display a first prompt.

[0159] The table contains multiple prompt levels, including the first prompt level, with different prompt levels corresponding to different usage rate thresholds; the first prompt content includes the usage information; the second prompt content is used to prompt one or more of the following: the first prompt level, or the usage rate is greater than or equal to a first usage rate threshold, where the first usage rate threshold includes the minimum usage rate threshold among the different usage rate thresholds.

[0160] According to one or more embodiments of this application, Example 3, based on the method described in Example 1, includes displaying prompt content in response to the usage rate matching a first prompt level, including:

[0161] In response to the usage rate matching a first alert level, and the table being in a first state at the first alert level, a alert message is displayed.

[0162] According to one or more embodiments of this application, Example 4 describes the method according to Example 3, wherein the method further includes at least one of the following:

[0163] In response to the second triggering operation, the table remains in the state of the first prompt level, and the first prompt content is canceled from being displayed;

[0164] In response to a third trigger operation, the table is switched from a state at at least one prompt level to a second state, and the prompt content is canceled. The at least one prompt level includes the first prompt level and / or the second prompt level, and the usage rate threshold corresponding to the second prompt level is less than the usage rate threshold corresponding to the first prompt level.

[0165] According to one or more embodiments of this application, Example 5 describes the method described in Example 3.

[0166] In response to the fact that the first prompt level and the third prompt level are different prompt levels, the prompt content is associated with a cancel prompt item, which is used to switch the state of the table at the first prompt level;

[0167] In response to the first and third prompt levels being the same, the prompt content does not display a cancellation prompt item.

[0168] According to one or more embodiments of this application, Example 6 describes the method according to any one of Examples 1-5, wherein the step of obtaining table usage information in response to receiving a modification instruction for data rows in the table includes:

[0169] In response to receiving a modification instruction for a data row in the table, and if the update conditions are currently met, update the table's usage rate;

[0170] In response to the completion of the usage rate update, usage information of at least one table is obtained, wherein the usage rate of the at least one table is greater than or equal to a first usage rate threshold.

[0171] According to one or more embodiments of this application, Example 7 describes the method described in Example 6, wherein updating the table utilization rate in response to receiving a modification instruction for a data row in a table and the current update conditions are met includes:

[0172] In response to receiving a modification instruction for the table, the first duration is obtained, which is the duration since the last usage rate update at the current time;

[0173] In response to the first duration reaching the first duration threshold, update the usage rate of the table;

[0174] In response to the first duration not reaching the first duration threshold, timing is performed based on a timer; in response to the second duration recorded by the timer reaching the second duration threshold, the usage rate of the table is updated and the timer is turned off.

[0175] According to one or more embodiments of this application, Example 8 describes the method of Example 7, wherein the timing based on a timer includes at least one of the following:

[0176] In response to the existence of an already started timer, initialize the timer's duration and restart timing based on the timer; or,

[0177] In response to the absence of a timer already started, a timer is started, and timing is performed based on the timer;

[0178] The method further includes:

[0179] In response to the first duration reaching a first duration threshold, the started timer is turned off.

[0180] According to one or more embodiments of this application, Example 9, based on the method described in Example 6, further includes:

[0181] Store the updated usage rate in the usage rate list; and,

[0182] Based on the updated usage rate, update the first set, wherein the first set is used to record the first table, and the usage rate of the first table is greater than or equal to the first usage rate threshold;

[0183] The usage information also includes the total number of data rows and the number of rows used. Obtaining the table's usage information includes:

[0184] For at least a portion of the tables in the first set, the usage rate of the tables is obtained from the usage rate list, and the total number of data rows and the number of rows used are determined.

[0185] According to one or more embodiments of this application, Example 10, based on the method described in Example 6, further includes:

[0186] Based on the updated usage rate, the second set is updated, wherein the second set is used to record the usage rate of the second table, which matches the third prompt level.

[0187] According to one or more embodiments of this application, Example 11 provides a notification device for usage information, comprising:

[0188] The information acquisition module is used to acquire the usage information of the table in response to receiving a modification instruction for the data rows in the table. The usage information includes the usage information of all data rows in the table and / or the usage information of data rows in sub-tables. The usage information includes the usage rate.

[0189] A prompt module is used to display prompt content in response to the usage rate matching a first prompt level, the prompt content including the usage information.

[0190] According to one or more embodiments of this application, Example 12 provides an electronic device, including:

[0191] One or more processors;

[0192] Memory, used to store one or more programs.

[0193] When the one or more programs are executed by the one or more processors, the one or more processors implement a method for prompting usage information as described in any of Examples 1-10.

[0194] According to one or more embodiments of this application, Example 13 provides a computer-readable storage medium having a computer program stored thereon that, when executed by a processor, implements a method for prompting usage information as described in any of Examples 1-10.

[0195] According to one or more embodiments of this application, Example 14 provides a computer program product that, when executed by a computer, causes the computer to implement a method for prompting usage information as described in any of Examples 1-10.

[0196] The above description is merely a preferred embodiment of this application and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of disclosure in this application is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described disclosed concept. For example, technical solutions formed by substituting the above features with (but not limited to) technical features with similar functions disclosed in this application.

[0197] Furthermore, although the operations are described in a specific order, this should not be construed as requiring these operations to be performed in the specific order shown or in a sequential order. In certain circumstances, multitasking and parallel processing may be advantageous. Similarly, while several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of this application. Certain features described in the context of individual embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented individually or in any suitable sub-combination in multiple embodiments.

[0198] Although the subject matter has been described using language specific to structural features and / or methodological logic, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. Rather, the specific features and actions described above are merely illustrative examples of implementing the claims.

Claims

1. A method for providing information prompts, comprising: In response to receiving a modification instruction for a data row in a table, the user obtains the table's usage information, which includes the usage information of all data rows in the table and / or the usage information of data rows in sub-tables, and the usage information includes the usage rate. In response to the usage rate matching a first prompt level, a prompt is displayed, the prompt including the usage information.

2. The method according to claim 1, wherein the display of prompt content includes: Display the first and second prompts; or, The second prompt message will be displayed. In response to a first triggering operation based on the second prompt content, the first prompt content is displayed; The table contains multiple prompt levels, including the first prompt level, with different prompt levels corresponding to different usage rate thresholds; the first prompt content includes the usage information; the second prompt content is used to prompt one or more of the following: the first prompt level, or the usage rate is greater than or equal to a first usage rate threshold, where the first usage rate threshold includes the minimum usage rate threshold among the different usage rate thresholds.

3. The method according to claim 1, wherein displaying a prompt message in response to the usage rate matching a first prompt level includes: In response to the usage rate matching a first alert level, and the table being in a first state at the first alert level, a alert message is displayed.

4. The method of claim 3, further comprising at least one of the following: In response to the second triggering operation, the table remains in the state of the first prompt level, and the first prompt content is canceled from being displayed; In response to a third trigger operation, the table is switched from a state at at least one prompt level to a second state, and the prompt content is canceled. The at least one prompt level includes the first prompt level and / or the second prompt level, and the usage rate threshold corresponding to the second prompt level is less than the usage rate threshold corresponding to the first prompt level.

5. The method according to claim 3, In response to the fact that the first prompt level and the third prompt level are different prompt levels, the prompt content is associated with a cancel prompt item, which is used to switch the state of the table at the first prompt level; In response to the first and third prompt levels being the same, the prompt content does not display a cancellation prompt item.

6. The method according to any one of claims 1-5, wherein obtaining table usage information in response to receiving a modification instruction for a data row in the table includes: In response to receiving a modification instruction for a data row in the table, and if the update conditions are currently met, update the table's usage rate; In response to the completion of the usage rate update, usage information of at least one table is obtained, wherein the usage rate of the at least one table is greater than or equal to a first usage rate threshold.

7. The method according to claim 6, wherein updating the table utilization rate in response to receiving a modification instruction for a data row in the table and the current update condition is met includes: In response to receiving a modification instruction for the table, the first duration is obtained, which is the duration since the last usage rate update at the current time; In response to the first duration reaching the first duration threshold, update the usage rate of the table; In response to the first duration not reaching the first duration threshold, timing is performed based on a timer; in response to the second duration recorded by the timer reaching the second duration threshold, the usage rate of the table is updated and the timer is turned off.

8. The method according to claim 7, wherein timing based on a timer includes at least one of the following: In response to the existence of an already started timer, initialize the timer's duration and restart timing based on the timer; or, In response to the absence of a timer already started, a timer is started, and timing is performed based on the timer; The method further includes: In response to the first duration reaching a first duration threshold, the started timer is turned off.

9. The method according to claim 6, further comprising: Store the updated usage rate in the usage rate list; as well as, Based on the updated usage rate, update the first set, wherein the first set is used to record the first table, and the usage rate of the first table is greater than or equal to the first usage rate threshold; The usage information also includes the total number of data rows and the number of rows used. Obtaining the table's usage information includes: For at least a portion of the tables in the first set, the usage rate of the tables is obtained from the usage rate list, and the total number of data rows and the number of rows used are determined.

10. The method of claim 6, further comprising: Based on the updated usage rate, the second set is updated, wherein the second set is used to record the usage rate of the second table, which matches the third prompt level.

11. A notification device for using information, comprising: The information acquisition module is used to acquire the usage information of the table in response to receiving a modification instruction for the data rows in the table. The usage information includes the usage information of all data rows in the table and / or the usage information of data rows in sub-tables. The usage information includes the usage rate. A prompt module is used to display prompt content in response to the usage rate matching a first prompt level, the prompt content including the usage information.

12. An electronic device, comprising: At least one processor; as well as A memory communicatively connected to the at least one processor; wherein, The memory stores a computer program that can be executed by the at least one processor, the computer program being executed by the at least one processor to enable the at least one processor to perform the method of prompting usage information as described in any one of claims 1-10.

13. A computer-readable storage medium storing computer instructions that, when executed by a processor, implement the method for prompting the use of information according to any one of claims 1-10.

14. A computer program product comprising a computer program that, when executed by a processor, implements the method for prompting usage information as described in any one of claims 1-10.

Images