Form data processing method, device, terminal and storage medium

Abstract

The present disclosure provides a form data processing method and device, a terminal, and a storage medium. The form data processing method includes the steps of: displaying a field screening interface in response to a trigger operation of a specific control related to a specified form; each candidate field name in the field screening interface is a predetermined field name existing in at least one data system, and each candidate field name in the field screening interface has an association relationship with a field name corresponding to a padded column in the specified form; and adding the selected field name to the specified form in response to a field name selection operation on the field screening interface; and supplementing the data of the padded column and the data corresponding to each field name to the specified form, where the supplemented data is data from at least one data system. The method of the present disclosure can directly supplement information to the specified form in a browser or a client, and can reduce the workload of downloading and editing files.

Description

[Technical field]

[0001] This application claims priority to a Chinese patent application with application number 202110839653.9, filed on July 23, 2021, and titled "Form data processing method, device, terminal, and storage medium," the entire contents of which are incorporated herein by reference.

[0002] The present disclosure relates to the field of information technology, and in particular to a form data processing method and device, a terminal, and a storage medium. [Background technology]

[0003] When processing and analyzing some data (e.g. product data), it is usually necessary to import data from different data systems into a form for analysis. Usually, data from multiple data systems should be downloaded into multiple CSV / Excel files, and then manually edited according to the main fields of the rows (e.g. product name, product ID, etc.) and merge the multiple result data; or data can be imported directly into the form from online application programming interfaces (APIs) through the "from web" function in form software such as Excel. Summary of the Invention

[0004] To solve the problems of the prior art, the present disclosure provides a form data processing method and apparatus, a terminal and a storage medium.

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

[0006] In some examples, embodiments of the present disclosure provide a form data processing method, the form data processing method including: displaying a field screening interface in response to a trigger operation of a specific control associated with a specified form; wherein each candidate field name in the field screening interface is a predetermined field name present in at least one data system, and each candidate field name in the field screening interface has a correlation with a field name corresponding to a padded column in the specified form; and in response to a field name selection operation in the field screening interface, adding a selected field name to the specified form; and supplementing the specified form with data of the padded column and data corresponding to each field name, wherein the supplemented data is data from the at least one data system.

[0007] In some embodiments, another embodiment of the present disclosure provides a form data processing device, the form data processing device comprising: a field screening interface display module configured to display a field screening interface in response to a trigger operation of a specific control associated with a specified form, each candidate field name in the field screening interface being a predefined field name present in at least one data system, each candidate field name in the field screening interface having a correlation with a field name corresponding to a padded column in the specified form; a field name adding module configured to add a selected field name to the specified form in response to a field name selection operation in the field screening interface; and a data completion module configured to complete the specified form with data of the padded columns and data corresponding to each field name, wherein the completed data is data from the at least one data system.

[0008] In some embodiments, the present disclosure provides a terminal comprising at least one memory and at least one processor, where the memory is used to store program code and the processor is used to invoke the program code stored in the memory to execute the form data processing method.

[0009] In some embodiments, the present disclosure provides a storage medium, the storage medium being used to store program code, the program code being used to execute the above-mentioned form data processing method.

[0010] An embodiment of the present disclosure adds the selected field name to a specified form in response to a field name selection operation on a field screening interface, and completes the specified form with data from padded columns and data corresponding to each field name, thereby enabling information to be directly completed in the specified form in a browser or client, thereby reducing the workload of downloading and editing files. [Brief description of the drawings]

[0011] The above and other features, advantages and aspects of each embodiment of the present disclosure will become more apparent by reference to the following specific embodiments in conjunction with the accompanying drawings, in which the same or similar reference numerals refer to the same or similar elements throughout the accompanying drawings. It should be understood that the accompanying drawings are schematic and that the devices and elements are not necessarily drawn to scale.

[0012] [Figure 1] 1 is a flowchart of some example form data processing methods of the present disclosure. [Diagram 2] 1 is a schematic table of some embodiments of the present disclosure. [Diagram 3] FIG. 13 is a schematic diagram of a field screening interface according to another embodiment of the present disclosure. [Figure 4] 1 is a schematic flowchart of a form data processing method according to another embodiment of the present disclosure. [Diagram 5] FIG. 2 is a schematic diagram of the logical layers of a server in some embodiments of the present disclosure. [Figure 6] 2 illustrates a partial module of a form data processing device according to some embodiments of the present disclosure. [Figure 7] FIG. 2 is a structural schematic diagram of an electronic device according to an embodiment of the present disclosure. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0013] Hereinafter, the embodiments of the present disclosure will be described in more detail with reference to the accompanying drawings. Although the accompanying drawings show some embodiments of the present disclosure, it should be understood that the present disclosure can be implemented in various forms and is not limited to the embodiments herein, and these embodiments are used to more thoroughly and completely understand the present disclosure. It should be understood that the accompanying drawings and embodiments of the present disclosure are used for illustrative purposes only and are not intended to limit the scope of protection of the present disclosure.

[0014] It should be understood that each step described in the method embodiments of the present disclosure may be performed in a different order and / or in parallel. Furthermore, the method embodiments may add steps and / or omit steps shown. The scope of the present disclosure is not particularly limited in this respect. In the examples of the present disclosure, "and / or" can represent one or more elements, and can represent all elements or some elements included therein. In the present disclosure, "A and / or B" can represent three situations, A, B, A and B in parallel. That is, it can represent at least one of A and B.

[0015] As used herein, the term "including" and variations thereof are open ended, i.e., meaning "including, but not limited to." The term "based on" means "based at least in part on." The term "in one embodiment" means "at least one embodiment," the term "in another embodiment" means "at least one other embodiment," and the term "in some embodiments" means "at least some embodiments." Relevant definitions of other terms are provided in the description below.

[0016] It should be noted that the concepts of "first", "second", etc. referred to in this disclosure are used to distinguish different devices, modules or units, and are not used to define the order or interdependence of functions performed by these devices, modules or units.

[0017] It should be noted that the modification "one" referred to in the present disclosure is intended to be illustrative rather than limiting, and one of ordinary skill in the art would understand that it should be understood as "one or more" unless the context clearly indicates otherwise.

[0018] The names of messages or information interacted between multiple devices in the embodiments of the present disclosure are used for illustrative purposes only and are not intended to limit the scope of these messages or information.

[0019] 1 provides a flowchart of a form data processing method according to an embodiment of the present disclosure. The form data processing method according to the present disclosure includes a step S101 of displaying a field screening interface in response to a trigger operation of a specific control associated with a specified form.

[0020] In some examples, the designated form may be an online form or a non-online form, where a non-online form is an offline spreadsheet. In some examples, an online form generally refers to a form stored on a server rather than a specific terminal, allowing a user to log in to view the online form on a different terminal. In some examples, each candidate field name in the field screening interface is a predefined field name present in at least one data system, and has an association relationship with a field name that corresponds to a padded column in the designated form. In some examples, the at least one data system may refer to a server in which data is stored, a productized data management system, or a data file, such as a spreadsheet, in which data is stored.

[0021] In some embodiments, the form is usually composed of rows and columns, and a padded column refers to a column that is pre-padded with corresponding data (e.g., product name). In some embodiments, each candidate field name in the field screening interface has an association relationship with a field name corresponding to a padded column in the specified form, for example, if the padded column is a mobile phone product, such as model numbers of various mobile phones, the candidate field names in the field screening interface are fields related to mobile phone products, such as parameters related to mobile phones, such as memory, screen size, screen resolution, etc. Thus, when the field name corresponding to the padded column (e.g., product name, etc.) is changed, the candidate field name in the field screening interface is changed accordingly. For example, if the padded column is a skin care product, each candidate field name in the field screening interface is a field related to skin care products, such as expiration date, main ingredient, etc.

[0022] The method of the present disclosure further includes a step S102 of adding the selected field name to the designated form in response to a field name selection operation on the field screening interface. In some embodiments, the field name selection operation on the field screening interface may include an input or check operation of the corresponding field name, etc. For example, as shown in FIG. 2, a schematic diagram of a designated form in some embodiments is shown, in which the padded column is the first column, and the field names corresponding to the padded column are the model numbers of home appliances (e.g., product 1, product 2, etc.), and the selected field names (e.g., control vendor, power, price, etc.) are added to the designated form in response to the field name selection operation on the field screening interface.

[0023] The method of the present disclosure further includes a step S103 of supplementing the designated form with the padded column data and data corresponding to each field name. In some embodiments, the supplemented data is data from at least one data system. As shown in FIG. 2, the designated form is supplemented with the padded column data (product 1, product 2, etc.) and data corresponding to each field name (controller, power, price, etc.).

[0024] In the embodiment of the present disclosure, in response to the trigger operation of a specific control related to the specified form, a field screening interface is displayed, and in response to a field name selection operation on the field screening interface, the selected field name is added to the specified form, and the data of the padded column and the data corresponding to each field name are supplemented to the specified form, so that the information can be directly supplemented to the specified form in the browser or client, and the workload of downloading and editing files can be reduced. A normal operation is to download and combine corresponding data from each data system, and the method of the present disclosure automatically obtains data from at least one data system through the trigger operation of a specific control, etc., and supplements the obtained data to the specified form, thereby greatly reducing the workload of editing and organizing related data.

[0025] 3 is a schematic diagram of a field screening interface in some embodiments. As shown in FIG. 3, in some embodiments, the field screening interface further includes an insert start column input control. In some embodiments, the step of adding the selected field name to the specified form includes adding the selected field name to the specified form from the input insert start column. For example, if the insert start column determined on the field screening interface is column B, the selected field name "Controlling Agent" is added to column B of the specified form, and if the insert start column determined on the field screening interface is column H, the selected field name "Controlling Agent" is added to column H of the specified form. This allows the user to add the corresponding field name to a column specified by the user.

[0026] As shown in FIG. 3, in some embodiments, the field screening interface further includes a field search control. In some embodiments, the form data processing method further includes, in response to information entered into the field search control, displaying a field name matching the entered information, where the displayed field name is a field name existing in at least one data system. For example, if some field names are not displayed in the current field screening interface, they can be searched and displayed in the search control. For example, when "size" is entered in the field search control, a field name "dimension" matching the entered information "size" is displayed, and the field name "dimension" is a field name existing in at least one data system. By setting the field search control in the field screening interface, the user can more easily search and select the corresponding field name.

[0027] In some embodiments, the form data processing method further includes updating data in the specified form in response to a data update request operation and displaying the changed data in a distinctive manner. In some embodiments, data information in the data system may be updated over time, so that the data information in the specified form needs to be updated. This allows the data supplement step to be repeated and the updated data to be overwritten on the previous data, thereby achieving the effect of data update. This allows the data update of the specified form of the present disclosure to be performed based on the previous version, which is very convenient for performing data update. In some embodiments, if the updated data is different from the previous data, the corresponding cell or the updated data is displayed distinctively (e.g., marked). That is, if the updated data is different from the data of the previous version, the data of the corresponding cell is also changed at that time. By displaying the cell or the updated data distinctively, the user can be informed of which data has been changed, which facilitates data processing by the user. In some embodiments, the distinctive display or marking can include changing the font color and / or highlighting the background mark. Existing form data update methods usually require re-downloading from the data system and then reintegrating the data. By adopting the method disclosed herein, data can be updated based on the previous version and the changed data can be displayed distinctly, greatly facilitating the user's data processing.

[0028] In some embodiments, the specific control is a browser plug-in, and the form data processing method is performed by the plug-in. In some embodiments, a specified form (e.g., an online form) is displayed in the browser in real time, and the form data processing method is realized by the browser plug-in, which can greatly facilitate the form data processing and improve the form data processing efficiency.

[0029] In some embodiments, before the step of displaying the field screening interface, the form data processing method further includes the steps of obtaining field names corresponding to the padded columns from the specified form and sending a query request including the obtained field names to the server. In some embodiments, for similar data information, field names used in different data systems may be different, and before making a data query corresponding to the corresponding field names from each data system, a query request including the obtained field names can be sent to the server to obtain specific expressions of the corresponding field names in each data system. Then, a field name query request result is received as feedback from the server. In some embodiments, the field name query request result is obtained by the server querying based on a pre-stored field name mapping list, and the field name mapping list stores a mapping relationship of each field name in at least one system. The field name mapping list enables a query of corresponding field names in multiple different data systems using similar field names corresponding to the padded columns obtained from the specified form.

[0030] In some embodiments, the padded column of the specified form is a pre-designated column or the first column. Usually, the first column is padded with the corresponding information first, but of course, any pre-designated column may be designated as the padded column.

[0031] In some embodiments, before the data of the padded columns and the data corresponding to each field name are supplemented to the specified form, the form data processing method further includes sending a data query request including the data of the padded columns and each field name in the form to a server. For example, when querying the power of product 1, a data query request including product 1 and the field name "power" is sent to a server, and the corresponding data query request result is queried from the server from the server. Then, the data query request result is received as feedback from the server. In some embodiments, the data query request result is obtained by the server querying based on the data of at least one data system. Therefore, the method of the present disclosure can automatically receive the corresponding data query request result from the server, and can improve the data query efficiency.

[0032] In some embodiments, triggering a particular control associated with a given form includes triggering a particular control (e.g., a plug-in) in a browser on an online form page, which is typically the case for online forms.

[0033] In some embodiments, the trigger operation of the specific control related to the specified form includes an operation of inputting an indication of an offline spreadsheet in the specific control to trigger the specific control. This also applies to normal forms, such as Excel forms. For example, by installing a corresponding applet or client, an indication of an offline spreadsheet is input in the specific control of the applet or client, and the spreadsheet to be operated is determined, and then the specific control is triggered to perform subsequent data completion or update, etc.

[0034] In the following, in order to better understand the embodiment of the present disclosure, the above-mentioned form data processing method will be described in conjunction with FIG. 4. As shown in FIG. 4, the data of the padded column (e.g., product number) and the field name input or selected by the user are received, and a data query request is sent to the server, where the data query request includes the data of the padded column of the online form and the field name selected by the user. Then, the server obtains the field name existing in the corresponding data system from the field name mapping list based on the field name, and maps the corresponding field name to the field name of the corresponding other system based on the field name mapping list, and enters into the data access layer. The data information (e.g., data source A, data source B, and data source C) obtained from each data system (e.g., system A, system B, and system C) is returned to the data access layer. Then, the corresponding data information output from the server is received, and the corresponding data information is supplemented to the cells corresponding to the data of the padded column and each field name of the specified form.

[0035] In some embodiments, to clearly show the execution steps of the server in the embodiments of the present disclosure, please refer to FIG. 5, which illustrates a schematic architecture of the server. In some embodiments, the server includes an access layer, an aggregation layer, a query layer, and a data layer, in which the access layer receives a data query request sent by a browser plug-in (or client, applet), and after receiving the data query request, performs service authentication for the data query request, determines whether or not data information acquisition is permitted, restricts the flow when the real-time access volume to the server exceeds a first preset value, restricts the data transfer volume with the aggregation layer, and suspends the reception of the data query request when the real-time access volume exceeds a second preset value. The access layer may also be provided with a cache for temporarily storing the data query request. In the aggregation layer, after receiving the target object related to the target information from the access layer and the preset information type to be searched, a unified entity information query language is provided based on the GraphQL protocol. The aggregation layer has a resolver that analyzes the information acquisition request and generates an information query statement of a source paragraph and a condition paragraph. The specific generation method is the same as that described above. The information query statement is transferred to the query layer. In the query layer, the information query statement is analyzed, information authentication is first performed, and it is determined whether the user has the authority to obtain information related to other preset systems. If the user has the authority, the query layer connects to other systems through a connection port that can access other systems (e.g., information repositories) to obtain information related to the target information stored in other systems. Different preset systems may adopt different databases, such as MySQL databases, SheetDB databases, etc., and different databases require different connectors, so that the MySQL You can use the SheetDB Provider or SheetDB Provider to connect to the corresponding database, or you can use the remote login method to connect to other preset systems. In this case, RPC (Remote Procedure Call Protocol The Connector is used to call the algorithm service via the authentication file License and password Passport to obtain related information. In some embodiments, the server obtains information related to the target information from other systems, and then transmits it to a first plug-in of the browser to enable aggregate display on the browser. In some embodiments, the server transmits information related to the target information obtained from other systems to a first plug-in of the browser of the terminal, and performs information aggregation of the related information obtained by the first plug-in, thereby facilitating the user's browsing.

[0036] An embodiment of the present disclosure further provides a form data processing device 600, comprising a field screening interface display module 601, a field name addition module 602, and a data completion module 603. In some embodiments, the field screening interface display module 601 is configured to display a field screening interface in response to a trigger operation of a specific control associated with the specified form, where each candidate field name in the field screening interface is a predefined field name present in at least one data system and has an association relationship with a field name corresponding to a padded column in the specified form. In some embodiments, the field name addition module 602 is configured to add a selected field name to the specified form in response to a field name selection operation on the field screening interface. In some embodiments, the data completion module 603 is configured to complete data of the padded column and data corresponding to each field name in the specified form, where the completed data is data from the at least one data system.

[0037] It should be understood that the contents relating to the description of the form data processing method are also applicable to the form data processing device 600 herein, and for the sake of brevity, will not be described in detail herein.

[0038] In some embodiments, the field screening interface further includes an insert start column input control, and the step of adding the selected field name to the specified form includes adding the selected field name from the input insert start column to the specified form. In some embodiments, the field screening interface further includes a field search control, and the field screening interface display module is configured to display field names matching the input information in response to information input into the field search control, and the displayed field names are field names present in the at least one data system. In some embodiments, the form data processing device further includes a data update module configured to update data in the specified form in response to a data update request operation and to distinguish and display the changed data. In some embodiments, the specific control is a browser plug-in, and the form data processing method is performed by the plug-in. In some embodiments, before the step of displaying the field screening interface, the form data processing device further includes: a query request sending module configured to obtain field names corresponding to the padded columns from the designated form and send a query request including the obtained field names to the server; and a request result receiving module configured to receive a field name query request result fed back from the server, where the field name query request result is obtained by the server querying based on a pre-stored field name mapping list, and the field name mapping list stores a mapping relationship of each field name in at least one system. In some embodiments, the padded columns of the designated form are pre-designated columns or the first column.In some embodiments, the query request sending module is configured to send a data query request including the data of the padded columns and each field name in the form to the server before complementing the specified form with the data of the padded columns and the data corresponding to each field name, and the request result receiving module is configured to receive the data query request result fed back from the server, where the data query request result is obtained by the server querying based on data of at least one data system. In some embodiments, the triggering operation of a specific control associated with the specified form includes an operation of triggering a specific control of a browser on an online form page, or an operation of triggering a specific control of an offline spreadsheet by inputting an indicator in the specific control.

[0039] The form data processing method disclosed herein can automatically query corresponding data information from multiple different data systems based on the padded column data and field names, and then output to the corresponding cells of the corresponding clients, thereby realizing intelligent organization of data information in a specified form, which can greatly reduce the workload of data organization compared with the conventional method of separately downloading and organizing data from each system. In addition, a field name mapping list is stored in the server, and the field name mapping list includes the mapping relationship of field names in different data systems, so that a field name in one data system can be used to query a field name in another data system based on the mapping relationship of field names between different data systems, and data information corresponding to the field name can be obtained.

[0040] Furthermore, the present disclosure further provides a terminal comprising at least one memory and at least one processor, where the memory is used to store program code, and the processor is used to call the program code stored in the memory to execute the above-mentioned form data processing method.

[0041] Moreover, the present disclosure further provides a computer storage medium, the computer storage medium storing program code, the program code being used to execute the above form data processing method.

[0042] The form data processing method and device of the present disclosure have been described above based on the embodiments and application examples. The present disclosure also provides the following terminal and storage medium.

[0043] Reference is now made to FIG. 7, which illustrates a structural schematic diagram of an electronic device (e.g., a terminal device or a server) 400 suitable for use in the embodiments of the present disclosure. The terminal devices in the embodiments of the present disclosure include, but are not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), and in-vehicle terminals (e.g., in-vehicle navigation terminals), digital TVs, and fixed terminals such as desktop computers. The electronic device illustrated in FIG. 7 is merely an example and does not limit the functions and scope of use of the embodiments of the present disclosure in any way.

[0044] 7, the electronic device 400 includes a processing unit (e.g., a central processing unit, a graphic processor, etc.) 401 that can perform various suitable operations and processes according to a program stored in a read-only memory (ROM) 402 or a program loaded from a storage device 408 into a random access memory (RAM) 403. The RAM 403 further stores various programs and data necessary for the operation of the electronic device 400. The processing unit 401, the ROM 402, and the RAM 403 are connected to each other via a bus 404. An input / output (I / O) interface 405 is also connected to the bus 404.

[0045] Typically, input devices 406 such as a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc., output devices 407 such as a liquid crystal display (LCD), speaker, vibrator, etc., storage devices 408 such as magnetic tape, hard disk, etc., and communication devices 409 are connected to the I / O interface 405. The communication devices 409 may enable the electronic device to communicate wirelessly or wired with other devices to exchange data. Although FIG. 7 illustrates the electronic device 400 with various devices, it should be understood that it is not necessary to implement or include all of the devices illustrated. Alternatively, more or fewer devices may be implemented or included.

[0046] In particular, according to an embodiment of the present disclosure, the process described above with reference to the flowcharts may be implemented as a computer software program. For example, an embodiment of the present disclosure provides a computer program product including a computer program carried on a computer-readable medium, the computer program including program code for performing the method shown in the flowchart. In such an embodiment, the computer program may be downloaded and installed from a network via the communication device 409, or may be installed from the storage device 408, or may be installed from the ROM 402. When the computer program is executed by the processing device 401, the above functions defined in the method of the embodiment of the present disclosure are realized.

[0047] It should be noted that the computer readable medium described in this disclosure may be a computer readable signal medium or a computer readable storage medium or any combination of both. The computer readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination. More specific examples of the computer readable storage medium may be, but not limited to, an electrical connection having one or more conductors, a portable computer disk, a hard disk, a random access memory (RAM), a read only memory (ROM), an erasable programmable read only memory (EPROM or flash memory), optical fiber, a portable compact disk read only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this disclosure, the computer readable storage medium may be any tangible medium that contains or stores a program, which may be used by or in combination with an instruction execution system, apparatus, or device. In this disclosure, the computer readable signal medium may include a data signal propagated in baseband or as part of a carrier, carrying the computer readable program code. Such propagated data signals include, but are not limited to, electromagnetic signals, optical signals, or any suitable combination of the above. A computer-readable signal medium may be any computer-readable medium other than a computer-readable storage medium that transmits, propagates, or transfers a program used by or in combination with an instruction execution system, apparatus, or device. The program code contained in the computer-readable medium may be transferred by any suitable medium, such as, but not limited to, wires, fiber optic cables, RF (radio frequency), etc., or any suitable combination of the above.

[0048] In some embodiments, clients and servers may communicate using any now known or later developed network protocol, such as HTTP (HyperText Transfer Protocol), and may interconnect with any form or medium of digital data communication (e.g., a communications network). Examples of communications networks include a local area network ("LAN"), a wide area network ("WAN"), an internetwork (e.g., the Internet), and an end-to-end network (e.g., an ad hoc end-to-end network), and any now known or later developed network.

[0049] The computer readable medium may be included in the electronic device, or may be separate and not integrated into the electronic device.

[0050] The computer-readable medium stores one or more programs that, when executed by an electronic device, cause the electronic device to perform the method of the present disclosure.

[0051] Computer program code for carrying out the operations of the present disclosure can be written in one or more programming languages ​​or combinations thereof, including object-oriented programming languages ​​(such as Java, Smalltalk, C++, etc.) and traditional procedural programming languages ​​(such as "C" or similar programming languages). The program code may run 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 the case of a remote computer, the remote computer may be connected to the user's computer via any kind of network, such as a local area network (LAN) or wide area network (WAN), or may be connected to an external computer (e.g., connected via the Internet using an Internet Service Provider).

[0052] The flowcharts and block diagrams in the accompanying drawings illustrate possible architectures, functions, and operations of systems, methods, and computer program products according to various embodiments of the present disclosure. In this regard, each box in the flowcharts or block diagrams may represent a module, program segment, or part of code, which includes one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions depicted in the boxes may occur in a different order than that depicted in the accompanying drawings. For example, two boxes depicted in succession may actually be executed substantially in parallel, or may be executed in reverse order depending on the related functionality. It should also be noted that each box in the block diagrams and / or flowcharts, and combinations of boxes in the block diagrams and / or flowcharts, may be implemented in a dedicated hardware-based system that performs the specified functions or operations, or in a combination of dedicated hardware and computer instructions.

[0053] The units described in the embodiments of the present disclosure may be implemented by software or hardware, and the names of the units do not constitute limitations of the units themselves in a given situation.

[0054] The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary hardware logic components that may be used include field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), etc.

[0055] In the context of this disclosure, a machine-readable medium may be a tangible medium that contains or stores a program used by or in combination with an instruction execution system, apparatus or device. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium includes, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus or device, or any suitable combination thereof. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memories (RAMs), read-only memories (ROMs), erasable programmable read-only memories (EPROMs or flash memories), optical fibers, portable compact disk read-only memories (CD-ROMs), optical storage devices, magnetic storage devices, or any suitable combination thereof.

[0056] According to one or more embodiments of the present disclosure, Example 1 provides a form data processing method, the form data processing method including: displaying a field screening interface in response to a trigger operation of a specific control associated with a specified form; wherein each candidate field name in the field screening interface is a predetermined field name present in at least one data system and correlates with a field name corresponding to a padded column in the specified form; and in response to a field name selection operation in the field screening interface, adding a selected field name to the specified form; and supplementing the specified form with data of the padded column and data corresponding to each field name, wherein the supplemented data is data from the at least one data system.

[0057] According to one or more embodiments of the present disclosure, Example 2 provides a method as described in Example 1, where the field screening interface further includes an insert start column input control, and the step of adding the selected field name to the specified form includes adding the selected field name to the specified form from an input insert start column.

[0058] According to one or more embodiments of the present disclosure, Example 3 provides a method as recited in Example 1, where the field screening interface further includes a field search control, and the form data processing method further includes, in response to information entered into the field search control, displaying field names matching the entered information, the displayed field names being field names present in the at least one data system.

[0059] According to one or more embodiments of the present disclosure, Example 4 provides a method as described in Example 1, wherein the form data processing method further includes updating data in the specified form in response to a data update request operation and displaying the changed data in a distinctive manner.

[0060] According to one or more embodiments of the present disclosure, Example 5 provides the method of Example 1, where the specific control is a browser plug-in, and the form data processing method is performed by the plug-in.

[0061] According to one or more embodiments of the present disclosure, Example 6 provides a method as described in Example 5, where, before the step of displaying the field screening interface, the form data processing method further includes the steps of obtaining field names corresponding to padded columns from the specified form, and sending a query request including the obtained field names to a server, and receiving a field name query request result fed back from the server, where the field name query request result is obtained by the server querying based on a pre-stored field name mapping list, and the field name mapping list stores a mapping relationship of each field name in the at least one system.

[0062] According to one or more embodiments of the present disclosure, Example 7 provides the method of Example 6, where the padded columns of the designated form are predesignated columns or the first column.

[0063] According to one or more embodiments of the present disclosure, Example 8 provides a method according to Example 5, where before the step of supplementing the specified form with data of padded columns and data corresponding to each field name, the form data processing method further includes the steps of sending a data query request to a server, the data including the data of the padded columns and each field name in the form, and receiving a data query request result fed back from the server, where the data query request result is obtained by the server querying based on data of the at least one data system.

[0064] According to one or more embodiments of the present disclosure, Example 9 provides a method as described in Example 1, wherein the triggering operation of a specific control associated with the specified form includes an operation of triggering a specific control of a browser on an online form page, or an operation of inputting an indicator of an offline spreadsheet in the specific control to trigger the specific control.

[0065] According to one or more embodiments of the present disclosure, Example 10 provides a form data processing device, the form data processing device comprising: a field screening interface display module configured to display a field screening interface in response to a trigger operation of a specific control associated with a specified form; wherein each candidate field name in the field screening interface is a predetermined field name present in at least one data system, and each candidate field name in the field screening interface has a correlation with a field name corresponding to a padded column in the specified form; a field name adding module configured to add a selected field name to the specified form in response to a field name selection operation in the field screening interface; and a data completion module configured to complete the specified form with data of the padded column and data corresponding to each field name, wherein the completed data is data from the at least one data system.

[0066] According to one or more embodiments of the present disclosure, Example 11 provides a terminal having at least one memory and at least one processor, where the at least one memory is used to store program code, and the at least one processor is used to call the program code stored in the at least one memory to execute a method according to any one of Examples 1 to 9 above.

[0067] According to one or more embodiments of the present disclosure, Example 12 provides a storage medium, the storage medium being used to store program code, and the program code being used to execute a method according to any one of Examples 1 to 9.

[0068] The above description is an illustrative description of the preferred embodiments of the present disclosure and the technical principles employed. Those skilled in the art should understand that the disclosure scope of the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the scope of the above disclosure. For example, it also covers (but is not limited to) technical solutions formed by replacing the above features with technical features having similar functions disclosed in the present disclosure.

[0069] Additionally, although operations are depicted using a particular order, this should not be construed as requiring that operations be performed in the particular order depicted or sequentially. In certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although certain specific implementation details are included in the above discussion, these should not be construed as limiting the scope of the present disclosure. Certain features described in the context of a single embodiment 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 in multiple embodiments individually or in any suitable subcombination.

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

Claims

1. A method for processing form data, comprising: displaying a field screening interface in response to a triggering operation of a particular control associated with a specified form, each candidate field name in the field screening interface being a predefined field name present in at least one data system, the field screening interface further including a field search control; in response to a field name selection in the field screening interface, adding a selected field name to the designated form; supplementing the designated form with data corresponding to padded columns and each field name, the supplemented data being data from the at least one data system; and in response to information entered into the field search control, displaying field names that match the entered information, the displayed field names being field names that exist in the at least one data system.

2. The field screening interface further includes an insert start column input control; 2. The method of claim 1, wherein the step of adding the selected field name to the specified form comprises adding the selected field name from an input insert start column to the specified form.

3. 2. The method according to claim 1, wherein the form data processing method further comprises the step of updating data in the specified form in response to a data update request operation and displaying changed data in a distinctive manner.

4. The method of claim 1 , wherein the particular control is a browser plug-in, and the form data processing method is performed by the plug-in.

5. Prior to the step of displaying the field screening interface, the form data processing method further comprises: obtaining a field name corresponding to the padded column from the specified form, and sending a query request including the obtained field name to a server; 5. The method of claim 4, further comprising: receiving a field name query request result fed back from a server, wherein the field name query request result is obtained by the server querying based on a pre-stored field name mapping list, and the field name mapping list stores a mapping relationship of each field name in the at least one data system.

6. The method of claim 5 , wherein the padded columns of the designated form are predesignated columns or the first columns.

7. Prior to the step of supplementing the specified form with data of padded columns and data corresponding to each field name, the form data processing method includes: sending a data query request to a server, the data including the padded column data and a name of each field in the form; 5. The method of claim 4, further comprising: receiving a data query request result fed back from a server, the data query request result being obtained by the server querying based on data of the at least one data system.

8. The trigger operation of a particular control associated with the specified form is as follows: Actions that trigger certain browser controls on online form pages, or The method of claim 1 , further comprising the step of: inputting an indicator of the offline spreadsheet into a specific control to trigger said specific control.

9. a field screening interface display module configured to display a field screening interface in response to a trigger operation of a particular control associated with a specified form, wherein each candidate field name in the field screening interface is a predefined field name present in at least one data system, and each candidate field name in the field screening interface has a correlation with a field name corresponding to a padded column in the specified form, and the field screening interface further includes a field search control, and in response to information entered into the field search control, a step of displaying field names matching the entered information, wherein the displayed field names are field names present in the at least one data system; a field name adding module configured to add a selected field name to the designated form in response to a field name selection operation in the field screening interface; and a data completion module configured to complete the specified form with data for padded columns and data corresponding to each field name, wherein the completed data is data from the at least one data system.

10. At least one memory and at least one processor, An electronic device, wherein the at least one memory is used to store program code, and the at least one processor is used to call up the program code stored in the at least one memory to execute the form data processing method described in any one of claims 1 to 8.

11. A computer-readable storage medium having stored thereon a program code for, when executed by a processor, executing the form data processing method according to any one of claims 1 to 8.

Images