Data entry method and device, electronic equipment, storage medium and program product

Abstract

The application provides a data entry method and device, electronic equipment, storage medium and program product, and a form is automatically generated from an original data row, so that the data entry interface is more intuitive. When a form control is newly created in the form or a first data column is added in an existing form control, the original data row is synchronously increased with a corresponding data column, so that consistency of the form and the data row data structure is ensured, and tedious steps of manually adjusting the data row structure are reduced. Then, direct data editing operations are allowed in multiple data columns of the form control. After editing is completed, the data can be synchronously returned to corresponding columns in the original data row in real time and automatically, without manual copying and pasting one by one. The efficiency of data entry is greatly improved, and especially when multiple data need to be entered at one time, repeated labor and time consumption can be significantly reduced.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to a data entry method, apparatus, electronic device, storage medium, and program product. Background Technology

[0002] Forms are tools for collecting and recording information. By entering data, this information can be systematically stored, facilitating subsequent retrieval, analysis, and utilization.

[0003] However, existing technologies cannot store multiple data entries into a form at once, which seriously affects data entry efficiency. Summary of the Invention

[0004] In view of this, the purpose of this application is to provide a data entry method, apparatus, electronic device, storage medium and program product to solve or partially solve the above-mentioned technical problems.

[0005] To achieve the above objectives, the first aspect of this application provides a data entry method, comprising:

[0006] Generate a form based on the original data rows;

[0007] In response to creating a new form control in the form or adding a first data column to an existing form control, a second data column is added to the original data row, wherein the newly created form control includes at least one first data column, and the second data column corresponds to the first data column;

[0008] The form control receives data editing operations in multiple first data columns and synchronizes the edited data to the corresponding multiple second data columns in the original data row.

[0009] Based on the same inventive concept, a second aspect of this application proposes a data entry device, comprising:

[0010] The form generation module is configured to generate forms based on the original data rows;

[0011] An add module is configured to add a second data column to the original data row in response to creating a new form control in the form or adding a first data column to an existing form control, wherein the newly created form control includes at least one first data column and the second data column corresponds to the first data column;

[0012] The synchronization module is configured to receive data editing operations in multiple first data columns of the form control and synchronize the edited data to multiple corresponding second data columns in the original data row.

[0013] Based on the same inventive concept, a third aspect of this application proposes an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the method described in the first aspect.

[0014] Based on the same inventive concept, a fourth aspect of this application proposes a non-transitory computer-readable storage medium storing computer instructions for causing a computer to perform the method described in the first aspect.

[0015] Based on the same inventive concept, the fifth aspect of this application provides a computer program product, including computer program instructions that, when run on a computer, cause the computer to perform the method as described in the first aspect.

[0016] As can be seen from the above, the data entry method, apparatus, electronic device, storage medium, and program products provided in this application automatically generate forms from the original data rows, making the data entry interface more intuitive. When a new form control is created in the form or a first data column is added to an existing form control, the original data row synchronously adds the corresponding data column, ensuring the consistency of the form and data row data structure and reducing the tedious steps of manually adjusting the data row structure. Then, data editing operations can be performed directly in multiple data columns of the form control. After editing, the data can be automatically and in real time synchronized back to the corresponding columns in the original data row, eliminating the need for manual copying and pasting. This greatly improves the efficiency of data entry, especially when multiple data entries are required at once, significantly reducing repetitive work and time consumption. Attached Figure Description

[0017] To more clearly illustrate the technical solutions in this application or related technologies, the drawings used in the description of the embodiments or related technologies will be briefly introduced below. Obviously, the drawings described below are only embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0018] Figure 1 This is a schematic diagram illustrating an application scenario of an embodiment of this application;

[0019] Figure 2 This is a flowchart of a data entry method according to an embodiment of this application;

[0020] Figure 3A This is a first schematic diagram of an exemplary page according to an embodiment of this application;

[0021] Figure 3B This is a second schematic diagram of an exemplary page in an embodiment of this application;

[0022] Figure 3C This is a third schematic diagram of an exemplary page in an embodiment of this application;

[0023] Figure 4 This is a schematic diagram of the structure of the data entry device according to an embodiment of this application;

[0024] Figure 5 This is a schematic diagram of an electronic device according to an embodiment of this application. Detailed Implementation

[0025] 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.

[0026] The principles and spirit of this application will now be described with reference to several exemplary embodiments. It should be understood that these embodiments are provided merely to enable those skilled in the art to better understand and implement this application, and are not intended to limit the scope of this application in any way. Rather, these embodiments are provided to make this application more thorough and complete, and to fully convey the scope of this application to those skilled in the art.

[0027] It is understood that before using the technical solutions of the various embodiments in this application, users will be informed of the type, scope of use, and usage scenarios of the personal information involved in an appropriate manner, and user authorization will be obtained.

[0028] 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, based on the prompt message, whether to provide personal information to the software or hardware such as electronic devices, applications, servers, or storage media performing the operations described in this application.

[0029] As an optional but not limited 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.

[0030] It is understood that the above notification and user authorization process is merely illustrative and does not limit the implementation of this application. Other methods that comply with relevant laws and regulations may also be applied to the implementation of this application.

[0031] In this application, it should be understood that any number of elements in the accompanying drawings is for illustrative purposes and not for limitation, and any naming is for distinction only and has no limiting meaning.

[0032] The principles and spirit of this application will be explained in detail below with reference to several representative embodiments.

[0033] refer to Figure 1 This diagram illustrates an application scenario for the data entry method provided in this application. The application scenario includes a terminal device 101 and a data storage system 102. Both the terminal device 101 and the data storage system 102 can be connected via wired or wireless communication networks. The terminal device 101 includes, but is not limited to, desktop computers, mobile phones, mobile computers, tablets, media players, smart wearable devices, personal digital assistants (PDAs), or other electronic devices capable of performing the aforementioned functions. The data storage system 102 can be an independent physical server, a server cluster composed of multiple physical servers, or a distributed system. It can also be a cloud server providing basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms.

[0034] A form is generated based on the original data rows via terminal device 101; the user creates a new form control in the form or adds a first data column to an existing form control via terminal device 101, and adds a second data column to the original data rows. The newly created form control includes at least one first data column, and the second data column corresponds to the first data column; the user receives data editing operations in multiple first data columns of the form control via terminal device 101, and synchronizes the edited data to the corresponding multiple second data columns in the original data rows. The operation of data storage system 102 provides data storage support, such as storing running program code and related data of the first data columns, second data columns, and original data rows.

[0035] The following is combined with Figure 1 The above application scenarios are used to describe the data entry method according to exemplary embodiments of this application. It should be noted that the above application scenarios are only shown to facilitate understanding of the spirit and principles of this application, and the embodiments of this application are not limited in any way in this respect. On the contrary, the embodiments of this application can be applied to any applicable scenario.

[0036] This application provides a data entry method, such as... Figure 2 As shown, the method includes:

[0037] Step 201: Generate a form based on the original data rows.

[0038] In some embodiments, the raw data row represents an existing data structure, typically displaying data in rows and columns. It may contain various types of information, such as text, numbers, dates, etc. This raw data row serves as the basis or reference for generating the form.

[0039] A form is a user interface element used to collect user input data. Forms typically contain various input fields, such as text boxes, checkboxes, and drop-down menus, where users can enter or select information. The process of generating a form involves designing and creating a corresponding form interface based on the structure and content of the original data rows.

[0040] When generating a form, information such as column names, data types, and constraints from the original data rows is taken into account. For example, if a column in the original data row is "Name," then the generated form may have a corresponding text box for that column for the user to enter their name. Similarly, if a column in the original data row has specific data format requirements (such as a date format), then the corresponding input field in the form will also have corresponding format validation.

[0041] The purpose of generating forms from raw data rows is typically to facilitate data entry and management. Forms allow users to easily input data according to preset formats and structures, which can then be stored, processed, or analyzed. This method improves the accuracy and efficiency of data input.

[0042] In some embodiments, the form includes a configuration form and a fill-in form.

[0043] Step 201 includes:

[0044] Step A1: In response to the addition operation of the form control, a form control is generated in the configuration form, and the fields of the first data column are generated in the form control according to the fields of the second data column of the original data row.

[0045] Step A2: In response to the editing operation of the first data column in the form control, determine the configured form, publish the configured form, and generate the fill-in form.

[0046] In some embodiments, the form includes two main functional pages: configuring the form and filling in the form.

[0047] A configuration form is an interface used to configure and set form controls (such as input boxes, selection boxes, etc.). Users can add, edit, or delete form controls, and set their properties on this interface.

[0048] The form is generated based on a pre-configured form, and users can enter or select data on it. The content and structure of the form are based on the settings made during the form configuration.

[0049] When a user wants to add a new form control to the configuration form (such as adding an input box to collect the user's name), the system will respond to this addition operation and generate a new form control in the configuration form.

[0050] The newly generated form control needs to have one or more fields to receive data. This process creates corresponding fields for the first data column in the newly generated form control based on the field information of the second data column of the original data row (assuming the second data column contains the name or type of the data field). For example, if the second data column of the original data row contains "Name" and "Age", then the newly generated form control will have two fields, one for entering the name and the other for entering the age.

[0051] Users can edit these fields in the configuration form, such as modifying the field's label, type, and whether it is required.

[0052] Once the user has completed all the configurations, the configured form will be finalized and published. The published form then becomes a form that users can enter or select data on.

[0053] This process allows users to flexibly define and set form controls and their fields by configuring the form, and then generate a form that users can use to input data based on these settings. This approach improves the flexibility and customizability of the form, enabling it to better adapt to different data collection needs.

[0054] For example, such as Figure 3A As shown, adding a form control (e.g., dragging a detail table control into configuration form 300) generates a form control in configuration form 300. The form control generates the fields of the first data column based on the fields of the second data column of the original data row. For example, if the fields of the second data column in the original data row are name and number, then the fields of the first data column generated in the form control will be name and number.

[0055] When an editing operation is performed on the first data column in a form control, the configured form is determined and published, such as... Figure 3C As shown, form 310 is generated.

[0056] In some embodiments, a moveout form control is set in the form control.

[0057] In step A1, after the configuration form generates form controls, the method further includes:

[0058] Step B1: In response to the triggering operation of the form control on the remove form control, a remove form prompt page is displayed, the form prompt page including a cancel control and a remove control.

[0059] Step B2, in response to the triggering operation of the cancel control on the remove form prompt page, retain the field of the first data column in the form control. Alternatively,

[0060] Step B3: In response to the triggering operation of the remove control on the remove form prompt page, the field of the first data column in the form control is removed.

[0061] In some embodiments, in response to a user's action to remove a form control, a form removal prompt page is displayed. This page is an intermediate step designed to give the user an opportunity to confirm whether they truly want to remove it.

[0062] The remove form prompt page contains two controls: a cancel control and a remove control. These two controls correspond to the user's two possible choices: cancel the removal operation or confirm the removal operation.

[0063] If a user clicks the cancel control on the remove form prompt page, the response to this action should be to keep the field in the first data column of the form control unchanged. This means the user has changed their mind and decided not to remove the field, so the form control remains as is.

[0064] If a user clicks the remove control on the remove form prompt page, in response to this action, the field in the first data column of the form control will be removed. This signifies that the user has confirmed their removal action, and the field will be deleted from the form control.

[0065] The entire process demonstrates a user-friendly and interactive interface, preventing users from losing important data due to accidental operations by providing a confirmation step. This design is especially important when users need to make significant changes (such as deleting data), as it increases the accuracy and security of user operations.

[0066] In some embodiments, in step A1, after the configuration form generates form controls, the method further includes:

[0067] In response to a triggering operation of the form control on the delete control, the form control is removed from the configuration form.

[0068] In some embodiments, a user-interactive element—a delete control—is added to a portion of the form control. This control allows users to easily remove or hide the current form control.

[0069] When a user clicks on or triggers the delete control within a form control, this action will be performed, removing or hiding the form control. The configuration form will then no longer display this form control, and the user will no longer be able to interact with it until it is re-displayed through other means (such as adding it again).

[0070] Overall, this process allows users to dynamically show or hide form controls as needed while editing forms, thus providing a more flexible and user-friendly editing experience.

[0071] In some embodiments, a data row upper limit area is set in the form control.

[0072] In some embodiments, in step A1, after the configuration form generates form controls, the method further includes:

[0073] Step C1, in response to the data row upper limit operation in the data row upper limit area, determines the initial upper limit of the number of data rows.

[0074] Step C2: In response to the initial row count upper limit not exceeding a preset upper limit range, determine the initial row count upper limit as the target row count upper limit for the data rows. Alternatively,

[0075] Step C3: In response to the initial row count limit exceeding a preset upper limit range, determine the maximum or minimum value of the preset upper limit range as the target row count limit for the data rows.

[0076] In some embodiments, a form control has a specific area for setting the upper limit of data rows, known as the data row upper limit area. This area may be an input box, a drop-down menu, or other UI element that allows users to input or select numerical values.

[0077] When a user enters a field in the upper limit area of ​​the data row (for example, by entering a number), the system will respond to this action and read the value entered by the user as the initial upper limit of the number of data rows.

[0078] Next, it will determine whether the user-set initial row limit is within a preset range. This preset range may be set based on system performance, user experience, or other factors.

[0079] If the user's initial row limit does not exceed this preset limit, then the value set by the user will be used as the target row limit for the data rows.

[0080] If the user's initial row count limit exceeds the preset limit range, the user-set value will not be used. Instead, it will select the maximum or minimum value of the preset limit range (whichever value is selected may depend on the system's design logic) as the target row count limit.

[0081] This process ensures that users can customize the upper limit of the number of data rows within a certain range, while also guaranteeing the stability and performance of the system and avoiding potential problems caused by users setting too high a limit on the number of rows.

[0082] Step 202: In response to creating a new form control in the form or adding a first data column to an existing form control, a second data column is added to the original data row, wherein the newly created form control includes at least one first data column, and the second data column corresponds to the first data column.

[0083] In some embodiments, the first data column refers to a column in a form control used for inputting or displaying data.

[0084] In response to the creation of a new form control or the addition of a first data column to an existing form control, the original data row (a data structure or UI element independent of the form control) will be modified. This modification affects a second data column in the original data row, which corresponds to the first data column in the form control. This means the second data column is added based on the content, type, or some logical rule of the first data column. For example, if a data column for entering user names is added to a form control, a corresponding data column for storing those names might be added to the original data row.

[0085] The above description is essentially a design of a linkage mechanism, where a change in one interface element (form control) automatically leads to a corresponding change in another interface element (original data row).

[0086] This design is often used to improve the interactivity of the user interface and the consistency of data, so that when a user interacts with an element, related elements can also be updated automatically, reducing the need for manual data synchronization and thus maintaining data consistency and interface interactivity.

[0087] For example, such as Figure 3B As shown, the first data column added to the form is the name and number columns. Therefore, the second data column of the original data row will also have the name and number columns added. Originally, there were only two columns: XX number and XX date.

[0088] In some embodiments, controls are added by setting fields in newly created form controls or existing form controls in the form.

[0089] In step 202, the creation of a new form control in the form or the addition of a first data column to an existing form control includes:

[0090] In response to a triggered operation that adds a control to a field of a newly created form control or an existing form control in the form, a first data column is added to the newly created form control or the existing form control.

[0091] In some embodiments, the field addition control is used to add a new first data column to the form.

[0092] A new first data column is added based on a triggered action that adds a control to a newly created form control or a field in an existing form control. This new column can now be used as a field for data input or display.

[0093] You can configure the fields of the newly added first data column. This may include setting attributes such as column name, data type, whether it is required, and default value. This ensures that the first data column works as expected and correctly displays or receives data.

[0094] For example, such as Figure 3A As shown, control 301 is added to the configuration form settings field. When the operation of adding the control to the field is executed in the configuration form 301, the first data column is added to the form control, and the fields of the added data row and column can be filled in the form control. For example, two new columns are added, and the fields to be filled in for these two columns are name and number, respectively.

[0095] Step 203: Receive data editing operations in the multiple first data columns of the form control, and synchronize the edited data to the corresponding multiple second data columns in the original data row.

[0096] In some embodiments, when a user edits multiple first data columns of a form control, the edited data is synchronously stored in the corresponding multiple second data columns of the original data row. This operation improves the interactivity of the user interface and the consistency of the data, allowing related elements to update automatically when a user operates on one element, reducing the need for manual data synchronization.

[0097] In some embodiments, step 203, receiving data editing operations in the plurality of first data columns of the form control, includes:

[0098] The form control can be used to modify fields of a selected first data column from a plurality of first data columns; or, the form control can be used to fill in fields of an added first data column.

[0099] In some embodiments, receiving data editing operations in multiple first data columns of a form control can be when a user has selected one or more first data columns in the form and modified some fields (i.e., cells or data items in the columns). For example, in a form containing employee information, a user might select the "Years of Service" column and update the employee information type, which is "Years of Service," to "Employee Age."

[0100] Receiving data editing operations in multiple first data columns of a form control can also mean filling in fields of newly added first data columns. This indicates that the user has added new data columns to the form and filled in the fields of these newly added columns. Adding a new column may mean that the structure of the form has changed; for example, in an order record form, the user may decide to add a new column to record the "order number" information for each product.

[0101] In some embodiments, the fields of the first data column reference fields of the second data column of the original data row or reference fields of the second data column of other data rows besides the original data row; the fields of the first data column include formula fields.

[0102] In some embodiments, fields in the first data column can reference not only fields in the second data column of the original data row, but also fields in other related data rows. This means that the data sources for the form can be diverse, not limited to a single data row. This design increases the flexibility and data processing capabilities of the form.

[0103] The first data column added to the form includes a special field: the formula field. The formula field allows users to define calculation formulas based on other fields, directly displaying the results in the form. This is extremely useful for forms that require data processing and calculations, significantly reducing manual calculations and improving data accuracy and real-time performance.

[0104] In some embodiments, the form includes a fill-in form in which row addition controls are set.

[0105] After step 203, the method further includes:

[0106] Step D1: In response to the triggered operation of adding a control to the row of the form, a first data row is added to the form.

[0107] Step D2: Based on the first data row added in the form, add a second data row to the form page, which corresponds to the first data row.

[0108] In some embodiments, a row-adding control is triggered when filling out a form. The row-adding control may be a button, link, or any other user interface element designed to allow the user to request the addition of a new row to the form.

[0109] Once the user triggers this control, it will respond to the action and dynamically add a new data row to the form.

[0110] Based on the newly added data rows in the form, the original data rows will be updated accordingly. The original data row here refers to the row where the user is currently filling in information; it may contain multiple fields, such as name, address, and phone number.

[0111] Specifically, a new line will be added at the end of the original data row (or other designated position), corresponding to any new row added in the form. This means that if a user adds a row in the form, a corresponding new row will be added to the original data row for the user to fill in the new information.

[0112] In summary, this process allows users to dynamically add data rows as needed while filling out the form, making it easy to add more information. This design improves the flexibility and user experience of the form, enabling it to adapt to different amounts and types of information input requirements.

[0113] For example, such as Figure 3C As shown, control 311 is added to the row setting in form 310. When the operation of adding control 311 to the row is executed in form 310, a new data row is added. Furthermore, based on the data row added in the form, the original data row is also added accordingly.

[0114] In some embodiments, in step D1, in response to a triggering operation that adds a control to a row in the filled-in form, the method further includes:

[0115] Step E1: In response to the number of the first data rows in the form reaching a preset upper limit for data rows, the row addition control is disabled.

[0116] In step E2, in response to the focus being on a row addition control that is in a disabled state, a preset data row limit prompt message is displayed.

[0117] In some embodiments, the number of first data rows refers to the total number of first data rows currently displayed in the form.

[0118] The preset data row limit is a pre-defined value that restricts the maximum number of data rows a user can add when filling out a form. Once this limit is reached, the user will no longer be able to add new rows.

[0119] The row addition control can be a button or a link, which allows users to add a new first data row to a form.

[0120] When the number of rows in the first data set reaches the preset row limit, the row addition control will be disabled to prevent users from adding new rows. Disabled controls are typically grayed out, unclickable, or marked with a disabled icon to clearly inform the user that the current operation is not possible.

[0121] When a user attempts to interact with a control on a disabled row (e.g., hovering the mouse over it or trying to click it), this interaction can be detected, and the system can assume that the focus is on the control.

[0122] When the focus is on a disabled row addition control, a pre-defined message will be displayed informing the user that the maximum number of rows has been reached and therefore no new rows can be added. This message is typically intended to help the user understand why the row addition control is unavailable and to provide relevant guidance or suggestions.

[0123] In some embodiments, the form includes a fill-in form.

[0124] After step 203, the method further includes:

[0125] Step F1, in response to a toolbar retrieval operation on the target first data row selected in the form, displays the toolbar in the form, the toolbar including an up insert control for the target first data row, a down insert control for the target first data row, and / or a delete record control for the target first data row.

[0126] Step F2, in response to the triggered operation of the insert control above the target first data row, adds a first data row above the target first data row. Alternatively,

[0127] Step F3, in response to the triggering operation of the insert control on the target first data row, adds a first data row below the target first data row. Alternatively,

[0128] Step F4: In response to the triggering operation of the delete record control on the target first data row, and since there are no other first data rows besides the target first data row in the form, the fields of the target first data row are cleared in the form. Alternatively,

[0129] Step F5: In response to the triggering operation of the delete record control on the target first data row, and the form contains other first data rows besides the target first data row, the target first data row is deleted in the form.

[0130] In some embodiments, when a user selects a specific target first data row in the form and performs an operation to invoke the toolbar (e.g., right-click), a toolbar will be displayed on the form.

[0131] This toolbar contains several controls: an insert control for the first target data row, a insert control for the first target data row, and a delete control for the first target data row.

[0132] If the user triggers this control, a new data row will be added above the first data row of the target row. This allows the user to insert a new data row above the selected row.

[0133] If the user triggers this control, a new data row will be added below the first data row of the target row. This allows the user to insert a new data row below the selected row.

[0134] The delete record control is used to delete the first data row of the target, but its behavior will vary depending on whether there are other data rows in the form.

[0135] If the form only contains the target first data row (i.e., there are no other data rows besides the target first data row), triggering the delete record control will not directly delete that row, but will instead clear the fields of the data row elements. This is likely to avoid completely deleting the last row, resulting in an empty data row, thus maintaining the integrity of the data row structure.

[0136] If other data rows exist in the form, triggering the delete record control will directly delete the target first data row.

[0137] This design allows users to flexibly manage and edit data rows, adding data by inserting new rows or removing unwanted data by deleting rows. Meanwhile, for data rows with only one row remaining, the strategy of clearing fields instead of directly deleting the row is likely for user experience and data integrity considerations, avoiding the tedious operation of recreating the entire data row if a user accidentally deletes all data.

[0138] In some embodiments, the original data rows are displayed on a form page, and grouping controls are set on the form page.

[0139] After step 203, the method further includes:

[0140] Step G1: In response to a triggering operation on the grouping control on the form page, a grouping toolbar is displayed, the grouping toolbar including multiple grouping type controls.

[0141] Step G2: In response to a trigger operation on any of the multiple group type controls in the grouping toolbar, a target group type is determined, and the original data rows are grouped and displayed on the form page according to the target group type.

[0142] In some embodiments, a grouping control is present on this form page. A grouping control is a user interface element that prompts the user to choose to categorize or group data according to certain rules or criteria.

[0143] When a user triggers (e.g., clicks) this group control, a group toolbar is displayed in response to this action.

[0144] The grouping toolbar is a user interface component that provides multiple grouping type controls, each representing a possible grouping method or grouping criterion.

[0145] Users then select the grouping type they want to apply by triggering (e.g., clicking) any of the multiple grouping type controls on the grouping toolbar. This selected grouping type is called the target grouping type.

[0146] The original form on the form page is grouped according to the target grouping type selected by the user.

[0147] Grouping means reorganizing the raw data according to the grouping criteria selected by the user (such as by date, by category, by priority, etc.) so that it can be displayed to the user in a grouped manner on the same form page.

[0148] Grouped displays make it easier for users to understand and analyze data because they help users organize and view information according to logical or related criteria.

[0149] The entire process achieves dynamic grouping and display of data through user interaction (triggering grouping controls and selecting grouping types), improving the readability and ease of use of the data.

[0150] The above solution automatically generates forms from the original data rows, making the data entry interface more intuitive. When a new form control is created in the form or the first data column is added to an existing form control, the original data row synchronously adds the corresponding data column, ensuring the consistency of the form and data row data structure and reducing the tedious steps of manually adjusting the data row structure. Data editing operations can then be performed directly in multiple data columns of the form control. After editing, the data can be automatically and in real time synchronized back to the corresponding columns in the original data row, eliminating the need for manual copying and pasting. This greatly improves data entry efficiency, especially when multiple data entries need to be entered at once, significantly reducing repetitive work and time consumption.

[0151] It should be noted that the method in this embodiment can be executed by a single device, such as a computer or server. The method can also be applied in a distributed scenario, where multiple devices cooperate to complete the task. In such a distributed scenario, one of these devices may execute only one or more steps of the method in this embodiment, and the multiple devices will interact with each other to complete the method described.

[0152] It should be noted that the above description describes some embodiments of this application. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recorded in the claims can be performed in a different order than that shown in the above embodiments and still achieve the desired result. Furthermore, the processes depicted in the drawings do not necessarily require a specific or sequential order to achieve the desired result. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0153] Based on the same inventive concept, corresponding to any of the above-described embodiments, this application also provides a data entry device.

[0154] refer to Figure 4 The data entry device includes:

[0155] Form generation module 401 is configured to generate forms based on the original data rows;

[0156] Adding module 402 is configured to add a second data column to the original data row in response to creating a new form control in the form or adding a first data column to an existing form control, wherein the newly created form control includes at least one first data column and the second data column corresponds to the first data column;

[0157] The synchronization module 403 is configured to receive data editing operations in multiple first data columns of the form control and synchronize the edited data to multiple corresponding second data columns in the original data row.

[0158] In some embodiments, generating a form based on the original data rows includes configuring a form and filling out a form;

[0159] The form generation module 401 is specifically configured as follows:

[0160] In response to the addition operation of the form control, a form control is generated in the configuration form, and the fields of the first data column are generated in the form control according to the fields of the second data column of the original data row;

[0161] In response to an editing operation on the first data column in the form control, a configured form is determined, and the configured form is published to generate a fill-in form.

[0162] In some embodiments, a move-out form control is set in the form control;

[0163] The data entry device further includes a removal module, which is specifically configured to: After the configuration form generates form controls, the removal module is configured as follows:

[0164] In response to a triggering operation of the form control on the remove form control, a remove form prompt page is displayed, the form prompt page including a cancel control and a remove control;

[0165] In response to a triggering operation on the cancel control on the form removal prompt page, retain the field of the first data column in the form control; or,

[0166] In response to a trigger operation on the remove control on the remove form prompt page, the field of the first data column in the form control is removed.

[0167] In some embodiments, a delete control is set in the form control;

[0168] The data entry device further includes a deletion module. After the configuration form generates form controls, the deletion module is specifically configured as follows:

[0169] In response to a triggering operation of the form control on the delete control, the form control is removed from the configuration form.

[0170] In some embodiments, a data row upper limit area is set in the form control;

[0171] The data entry device also includes a row limit module. After the configuration form generates form controls, the row limit module is specifically configured as follows:

[0172] In response to the operation of filling in the upper limit of data rows in the upper limit area, determine the initial upper limit of the number of data rows;

[0173] In response to the initial row count limit not exceeding a preset upper limit range, the initial row count limit is determined to be the target row count limit for the data rows; or,

[0174] In response to the initial row count limit exceeding a preset upper limit range, the maximum or minimum value of the preset upper limit range is determined to be the target row count limit for the data rows.

[0175] In some embodiments, fields are set in newly created form controls or existing form controls in the form to add controls;

[0176] The added module 402 is specifically configured as follows:

[0177] In response to a triggered operation that adds a control to a field of a newly created form control or an existing form control in the form, a first data column is added to the newly created form control or the existing form control.

[0178] In some embodiments, the synchronization module 403 is specifically configured as follows:

[0179] The form control can be used to modify fields of a selected first data column from a plurality of first data columns; or, the form control can be used to fill in fields of an added first data column.

[0180] In some embodiments, the form includes a fill-in form, in which row addition controls are set;

[0181] The data entry device further includes a row addition module. After receiving data editing operations in the multiple first data columns of the form control and synchronizing the edited data to the corresponding multiple second data columns in the original data row, the row addition module is specifically configured as follows:

[0182] In response to a triggered operation that adds a control to a row in the form, a first data row is added to the form;

[0183] Based on the first data row added in the form, a second data row is added to the form page, corresponding to the first data row.

[0184] In some embodiments, the data entry device further includes an upper limit prompt module, which, in response to a triggering operation of adding controls to rows in the filled-in form, is specifically configured as follows:

[0185] In response to the number of the first data rows in the form reaching a preset data row limit, the row addition control is disabled.

[0186] When the focus is on a disabled row add control, a preset data row limit message is displayed.

[0187] In some embodiments, the form includes filling out a form;

[0188] The data entry device further includes a toolbar module. After receiving data editing operations in the multiple first data columns of the form control and synchronizing the edited data to the corresponding multiple second data columns in the original data row, the toolbar module is specifically configured as follows:

[0189] In response to a request to the toolbar on the selected target first data row in the form, the toolbar is displayed in the form, the toolbar including an up insert control for the target first data row, a down insert control for the target first data row, and / or a delete record control for the target first data row;

[0190] In response to a trigger operation of the insert control above the target first data row, add a first data row above the target first data row; or,

[0191] In response to a trigger operation of the insert control on the target first data row, add a first data row below the target first data row; or,

[0192] In response to a triggered operation of the delete record control on the target first data row, and since there are no other first data rows besides the target first data row in the form, the fields of the target first data row are cleared in the form; or,

[0193] In response to a trigger operation of the delete record control on the target first data row, and if the form contains other first data rows besides the target first data row, the target first data row is deleted in the form.

[0194] In some embodiments, the original data row is displayed on a form page, and a grouping control is set on the form page;

[0195] The data entry module further includes a grouping module. After receiving data editing operations in the multiple first data columns of the form control and synchronizing the edited data to the corresponding multiple second data columns in the original data row, the grouping module is specifically configured as follows:

[0196] In response to a triggering operation on the grouping control on the form page, a grouping toolbar is displayed, the grouping toolbar including multiple grouping type controls;

[0197] In response to a trigger operation on any of the multiple group type controls in the grouping toolbar, a target group type is determined, and the original data rows are grouped and displayed on the form page according to the target group type.

[0198] For ease of description, the above devices are described in terms of function, divided into various modules. Of course, in implementing this application, the functions of each module can be implemented in one or more software and / or hardware.

[0199] The apparatus described above is used to implement the corresponding data entry method in any of the foregoing embodiments, and has the beneficial effects of the corresponding method embodiments, which will not be repeated here.

[0200] Based on the same inventive concept, corresponding to the methods of any of the above embodiments, this application also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the data entry method described in any of the above embodiments.

[0201] Figure 5 This embodiment illustrates a more specific hardware structure of an electronic device, which may include a processor 501, a memory 502, an input / output interface 503, a communication interface 504, and a bus 505. The processor 501, memory 502, input / output interface 503, and communication interface 504 are interconnected internally via the bus 505.

[0202] The processor 501 can be implemented using a general-purpose CPU (Central Processing Unit), microprocessor, application-specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of this specification.

[0203] The memory 502 can be implemented in the form of ROM (Read Only Memory), RAM (Random Access Memory), static storage device, dynamic storage device, etc. The memory 502 can store the operating system and other application programs. When the technical solutions provided in the embodiments of this specification are implemented by software or firmware, the relevant program code is stored in the memory 502 and is called and executed by the processor 501.

[0204] Input / output interface 503 is used to connect input / output modules to realize information input and output. Input / output modules can be configured as components in the device (not shown in the figure) or externally connected to the device to provide corresponding functions. Input devices may include keyboards, mice, touch screens, microphones, various sensors, etc., and output devices may include displays, speakers, vibrators, indicator lights, etc.

[0205] Communication interface 504 is used to connect a communication module (not shown in the figure) to enable communication between this device and other devices. The communication module can communicate via wired means (such as USB, Ethernet cable, etc.) or wireless means (such as mobile network, WIFI, Bluetooth, etc.).

[0206] Bus 505 includes a pathway for transmitting information between various components of the device (e.g., processor 501, memory 502, input / output interface 503, and communication interface 504).

[0207] It should be noted that although the above-described device only shows the processor 501, memory 502, input / output interface 503, communication interface 504, and bus 505, in specific implementations, the device may also include other components necessary for normal operation. Furthermore, those skilled in the art will understand that the above-described device may only include the components necessary for implementing the embodiments of this specification, and not necessarily all the components shown in the figures.

[0208] The electronic devices described above are used to implement the corresponding data entry methods in any of the foregoing embodiments and have the beneficial effects of the corresponding method embodiments, which will not be repeated here.

[0209] Based on the same inventive concept, corresponding to the methods of any of the above embodiments, this application also provides a non-transitory computer-readable storage medium that stores computer instructions for causing the computer to execute the data entry method as described in any of the above embodiments.

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

[0211] The computer instructions stored in the storage medium of the above embodiments are used to cause the computer to execute the data entry method as described in any of the above embodiments, and have the beneficial effects of the corresponding method embodiments, which will not be repeated here.

[0212] Based on the same concept, corresponding to any of the above embodiments, this application also provides a computer program product, including computer program instructions, which, when run on a computer, cause the computer to perform the method described in any of the above embodiments, and have the beneficial effects of the corresponding method embodiments, which will not be repeated here.

[0213] Those skilled in the art should understand that the discussion of any of the above embodiments is merely exemplary and is not intended to imply that the scope of this application is limited to these examples; under the concept of this application, the technical features of the above embodiments or different embodiments can also be combined, the steps can be implemented in any order, and there are many other variations of different aspects of the embodiments of this application as described above, which are not provided in detail for the sake of brevity.

[0214] Additionally, to simplify the description and discussion, and to avoid obscuring the embodiments of this application, the well-known power / ground connections to integrated circuit (IC) chips and other components may or may not be shown in the provided drawings. Furthermore, the apparatus may be shown in block diagram form to avoid obscuring the embodiments of this application, and this also takes into account the fact that the details of the implementation of these block diagram apparatuses are highly dependent on the platform on which the embodiments of this application will be implemented (i.e., these details should be fully understood by those skilled in the art). While specific details (e.g., circuits) have been set forth to describe exemplary embodiments of this application, it will be apparent to those skilled in the art that the embodiments of this application can be implemented without these specific details or with variations thereof. Therefore, these descriptions should be considered illustrative rather than restrictive.

[0215] Although this application has been described in conjunction with specific embodiments thereof, many substitutions, modifications, and variations of these embodiments will be apparent to those skilled in the art from the foregoing description. For example, other memory architectures (e.g., dynamic RAM (DRAM)) may be used with the embodiments discussed.

[0216] The embodiments of this application are intended to cover all such substitutions, modifications, and variations that fall within the broad scope of this application. Therefore, any omissions, modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the embodiments of this application should be included within the protection scope of this application.

Claims

1. A data entry method, characterized in that, include: Generate a form based on the original data rows; In response to creating a new form control in the form or adding a first data column to an existing form control, a second data column is added to the original data row, wherein the newly created form control includes at least one first data column, and the second data column corresponds to the first data column; The form control receives data editing operations in multiple first data columns and synchronizes the edited data to the corresponding multiple second data columns in the original data row.

2. The method according to claim 1, characterized in that, The form includes a configuration form and a fill-in form; The process of generating a form based on the original data rows includes: In response to the addition operation of the form control, a form control is generated in the configuration form, and the fields of the first data column are generated in the form control according to the fields of the second data column of the original data row; In response to an editing operation on the first data column in the form control, a configured form is determined, and the configured form is published to generate a fill-in form.

3. The method according to claim 2, characterized in that, Set the form control to be removed in the form control; After the configuration form generates form controls, the method further includes: In response to a triggering operation of the form control on the remove form control, a remove form prompt page is displayed, the form prompt page including a cancel control and a remove control; In response to a triggering operation on the cancel control on the form removal prompt page, retain the field of the first data column in the form control; or, In response to a trigger operation on the remove control on the remove form prompt page, the field of the first data column in the form control is removed.

4. The method according to claim 2, characterized in that, Set a delete control in the form control; After the configuration form generates form controls, the method further includes: In response to a triggering operation of the form control on the delete control, the form control is removed from the configuration form.

5. The method according to claim 2, characterized in that, Set the upper limit area for data rows in the form control; After the configuration form generates form controls, the method further includes: In response to the operation of filling in the upper limit of data rows in the upper limit area, determine the initial upper limit of the number of data rows; In response to the initial row count limit not exceeding a preset upper limit range, the initial row count limit is determined to be the target row count limit for the data rows; or, In response to the initial row count limit exceeding a preset upper limit range, the maximum or minimum value of the preset upper limit range is determined to be the target row count limit for the data rows.

6. The method according to claim 1, characterized in that, Add controls by setting fields in newly created form controls or existing form controls in the form; The creation of a new form control in the form or the addition of a first data column to an existing form control includes: In response to a triggered operation that adds a control to a field of a newly created form control or an existing form control in the form, a first data column is added to the newly created form control or the existing form control.

7. The method according to claim 1, characterized in that, Receiving data editing operations in the plurality of first data columns of the form control includes: The form control can be used to modify fields of a selected first data column from a plurality of first data columns; or, the form control can be used to fill in fields of an added first data column.

8. The method according to claim 1, characterized in that, The fields of the first data column reference fields of the second data column of the original data row or reference fields of the second data column of other data rows besides the original data row; the fields of the first data column include formula fields.

9. The method according to claim 1, characterized in that, The form includes a fill-in form, in which row controls are added; After receiving data editing operations in the multiple first data columns of the form control and synchronizing the edited data to the corresponding multiple second data columns in the original data row, the method further includes: In response to a triggered operation that adds a control to a row in the form, a first data row is added to the form; Based on the first data row added in the form, a second data row is added to the form page, corresponding to the first data row.

10. The method according to claim 9, characterized in that, In response to a triggering operation that adds a control to a row of the filled-in form, the method further includes: In response to the number of the first data rows in the form reaching a preset data row limit, the row addition control is disabled. When the focus is on a disabled row add control, a preset data row limit message is displayed.

11. The method according to claim 1, characterized in that, The form includes a form to fill out; After receiving data editing operations in the multiple first data columns of the form control and synchronizing the edited data to the corresponding multiple second data columns in the original data row, the method further includes: In response to a request to the toolbar on the selected target first data row in the form, the toolbar is displayed in the form, the toolbar including an up insert control for the target first data row, a down insert control for the target first data row, and / or a delete record control for the target first data row; In response to a trigger operation of the insert control above the target first data row, add a first data row above the target first data row; or, In response to a trigger operation of the insert control on the target first data row, add a first data row below the target first data row; or, In response to a triggered operation of the delete record control on the target first data row, and since there are no other first data rows besides the target first data row in the form, the fields of the target first data row are cleared in the form; or, In response to a trigger operation of the delete record control on the target first data row, and if the form contains other first data rows besides the target first data row, the target first data row is deleted in the form.

12. The method according to claim 1, characterized in that, The original data rows are displayed on the form page, and grouping controls are set on the form page; After receiving data editing operations in the multiple first data columns of the form control and synchronizing the edited data to the corresponding multiple second data columns in the original data row, the method further includes: In response to a triggering operation on the grouping control on the form page, a grouping toolbar is displayed, the grouping toolbar including multiple grouping type controls; In response to a trigger operation on any of the multiple group type controls in the grouping toolbar, a target group type is determined, and the original data rows are grouped and displayed on the form page according to the target group type.

13. A data entry device, characterized in that, include: The form generation module is configured to generate forms based on the original data rows; An add module is configured to add a second data column to the original data row in response to creating a new form control in the form or adding a first data column to an existing form control, wherein the newly created form control includes at least one first data column and the second data column corresponds to the first data column; The synchronization module is configured to receive data editing operations in multiple first data columns of the form control and synchronize the edited data to multiple corresponding second data columns in the original data row.

14. An electronic device comprising a memory, a processor, and a computer program stored in the memory and running on the processor, characterized in that, When the processor executes the program, it implements the method as described in any one of claims 1 to 12.

15. A non-transitory computer-readable storage medium storing computer instructions, characterized in that, The computer instructions are used to cause the computer to perform the method according to any one of claims 1 to 12.

16. A computer program product comprising computer program instructions, characterized in that, When the computer program instructions are executed on a computer, the computer causes the computer to perform the method as described in any one of claims 1-12.

Images