CN114297993B - Form data association method and system - Google Patents
Form data association method and system Download PDFInfo
- Publication number
- CN114297993B CN114297993B CN202111671221.8A CN202111671221A CN114297993B CN 114297993 B CN114297993 B CN 114297993B CN 202111671221 A CN202111671221 A CN 202111671221A CN 114297993 B CN114297993 B CN 114297993B
- Authority
- CN
- China
- Prior art keywords
- field
- association
- data
- attribute
- options
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000001914 filtration Methods 0.000 claims abstract description 48
- 238000012216 screening Methods 0.000 claims description 9
- 230000001960 triggered effect Effects 0.000 claims description 7
- 238000012423 maintenance Methods 0.000 description 18
- 230000000875 corresponding effect Effects 0.000 description 13
- 230000001276 controlling effect Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 3
- 238000003860 storage Methods 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a form data association method and a form data association system, wherein the method comprises the following steps: acquiring a first form, selecting/creating a first field with a pull-down attribute; configuring a drop-down attribute of the first field, enabling the first field to select a field of any second form as a value of the first field, and enabling the first form to be associated with the second form; configuring an association filling rule of the second form and the first form, so that data of the second form is filled into the first form; selecting/creating a second field with associated properties in a second form; and configuring the association attribute of the second field, wherein the association attribute comprises a data filtering rule, and the data filtering rule is that the second field contains any one of the first field IDs, so that the second form can view the data of the first form through the second field. The invention can realize real-time data linkage among forms, is convenient for data viewing while improving applicability, avoids repeated input work and improves working efficiency.
Description
Technical Field
The invention relates to the technical field of industrial Internet, in particular to a form data association method and system.
Background
The form is a tool which does not carry task business by itself, but can carry any needed business through the form, such as product management, equipment maintenance and the like.
At present, the interconnection netlist list adopts a mode of independently existing in a certain business scene, so that real-time linkage of form data cannot be realized, and real-time linkage of a certain form to a plurality of pieces of data in another form cannot be realized. For example, in the current production, the maintenance states of various parts in the equipment are checked in real time in the equipment form by associating the parts maintenance states of the equipment with the equipment form, but the realization of the function is not realized at present.
Therefore, in the prior art, real-time data linkage between forms cannot be realized, so that the forms in the user rights of the management layer have redundancy, and the corresponding relation of the data in the forms cannot be realized.
Disclosure of Invention
Based on the above, it is necessary to provide a form data association method and system for solving the above technical problems.
A form data association method comprises the following steps: acquiring a first form, selecting/creating a first field with a pull-down attribute; configuring a pull-down attribute of the first field, so that the first field can select a field of any second form as a value of the first field, and constructing an association relationship between the first form and the second form; configuring an association filling rule of the second form and the first form, so that data of the second form is filled into the first form; after the association relation between the first form and the second form is established, selecting/creating a second field with association attribute in the second form; and configuring the association attribute of the second field, wherein the association attribute comprises a data filtering rule, and the data filtering rule is that the second field contains any one of the first field IDs, so that the second form can view the data of the first form through the second field.
In one embodiment, the obtaining the first form, selecting/creating the first field with the drop-down attribute specifically includes: acquiring a first form, acquiring an existing field according to the first form, and selecting a first field with a pull-down attribute from the existing field; or, creating a first field with a pull-down attribute in the first form, and naming the first field.
In one embodiment, the configuring the pull-down attribute of the first field enables the first field to select a field of an arbitrary second form as a value of the first field, and completes construction of an association relationship between the first form and the second form, which specifically includes: configuring a drop-down attribute of the first field, wherein the drop-down attribute comprises a name, a number, field control, a selection type and options; wherein the name and number are the name and number of the first field; the field control comprises field options and data options, wherein the field options are used for setting a necessary filling field, a hidden field and a read-only field, and the data options are used for controlling the list to be hidden; the selection type comprises single selection or multiple selection; the options include custom or other forms; and determining a second form and an association field according to the drop-down attribute, and completing association of the first form and the second form according to the option.
In one embodiment, the method further comprises: when the selection type is single selection, the associated field corresponds to only one piece of data; and when the selection type is multi-selection, the association field corresponds to a plurality of pieces of data. .
In one embodiment, the determining the second form and the association field according to the drop-down attribute, and completing association between the first form and the second form according to the option specifically includes: when the option is selected for self definition, setting configuration options, wherein the configuration options comprise option fields, searching and acquiring a second form through the option fields, and associating the first form with the second form; when the option selects to associate other forms, setting an association form and an association field, searching and acquiring a corresponding second form according to the association form and the association field, and associating the first form with the second form.
In one embodiment, the configuring the association filling rule of the second form and the first form, so that the data of the second form is filled into the first form specifically includes: screening data in a second form according to the association field, acquiring first association data, and filling the first association data into the first form.
In one embodiment, after the association relationship between the first form and the second form is established, selecting/creating a second field with an association attribute in the second form specifically includes: after the association relation between the first form and the second form is established, selecting a second field through the association field, wherein the second field has association attributes; or, creating a second field with the associated attribute in the second form and naming the second field.
In one embodiment, the configuring the association attribute of the second field includes a data filtering rule, where the data filtering rule includes any one of the first field IDs for the second field, so that the second form can view the data of the first form through the second field, and the method specifically includes: configuring association attributes of the second field, wherein the association attributes comprise names, numbers, field control, association forms, association fields and data filtering rules; wherein the name and number are the name and number of the second field; the field control comprises field options and data options, wherein the field options are used for setting necessary filling fields and hidden fields, and the data options are used for controlling the list to be hidden; and configuring a data filtering rule through an association field, wherein the data filtering rule comprises any one first field ID, filtering data in the first form according to the first field ID, acquiring second association data, and filling the second association data into the second form.
In one embodiment, after the association relationship between the first form and the second form is established, selecting/creating the second field with the association attribute in the second form further includes: screening associated data according to the first field or the second field, and judging whether an early warning condition is triggered or not according to the associated data; when the associated data triggers the early warning condition, error prompt is carried out, and the early warning information is sent to the management terminal.
A form data association system comprising: the first field determining module is used for acquiring a first form, selecting/creating a first field with a pull-down attribute; the drop-down attribute configuration module is used for configuring the drop-down attribute of the first field, so that the first field can select the field of any second form as the value of the first field, and the establishment of the association relationship between the first form and the second form is completed; the data filling module is used for configuring the association filling rule of the second form and the first form so as to fill the data of the second form into the first form; the second field determining module is used for selecting/creating a second field with an association attribute in the second form after the association relation between the first form and the second form is established; the association attribute configuration module is used for configuring association attributes of the second fields, the association attributes comprise data filtering rules, and the data filtering rules are that the second fields contain any one of the first field IDs, so that the second forms can view the data of the first forms through the second fields.
Compared with the prior art, the invention has the advantages that:
The method comprises the steps of obtaining a first form, and setting a first field with a pull-down attribute in a selected or created mode; the method comprises the steps of configuring a pull-down attribute of a first field, enabling the first field to select a field of any second form as a value of the first field, completing association of the first form and the second form, configuring an association filling rule of the second form and the first form, filling data in the second form into the first form, selecting or creating a second field with an association attribute in the second form after the first form is associated with the second form, configuring the association attribute of the second field, wherein the association attribute comprises a data filtering rule, and the data filtering rule is that the second field contains any first field ID, so that the second form can check data of the first form through the second field, thereby realizing real-time data linkage of multiple forms, improving applicability, facilitating data check, avoiding repeated input work and improving work efficiency.
Drawings
FIG. 1 is a flow chart of a form data association method in one embodiment;
FIG. 2 is a schematic diagram of an interface for selecting a custom association form in one embodiment;
FIG. 3 is a schematic diagram of an interface for selecting and associating other form-based association forms in one embodiment;
Fig. 4 is a schematic diagram of a form data association system in an embodiment.
Detailed Description
Before proceeding with a description of the embodiments of the present invention, the general inventive concept will be described as follows:
The invention is developed mainly according to the data acquisition process of the industrial Internet platform, and the current Internet list is independently in a certain service scene, so that real-time association between the form data and the form data cannot be realized, and when a user checks the data, the user needs to frequently switch the service scene, searches the corresponding form, and has complex switching process and complicated operation.
The inventor finds through analysis that the main reason for the problems is that the prior art does not correlate the forms with the association relationship, and all the forms are in independent states, so that the forms with the association relationship can be correlated when the forms are created, and real-time linkage of data in the associated forms is realized.
The invention provides a form data association method, which comprises the steps of acquiring a first form, and selecting/creating a first field with a pull-down attribute; configuring a pull-down attribute of a first field, so that the first field can select a field of any second form as a value of the first field, and constructing an association relationship between the first form and the second form; configuring an association filling rule of the second form and the first form, so that data of the second form is filled into the first form; after the association relation between the first form and the second form is established, selecting/creating a second field with association attribute in the second form; the association attribute of the second field is configured, the association attribute comprises a data filtering rule, the data filtering rule is that the second field contains any one of the first field IDs, so that the second form can check the data of the first form through the second field, real-time data linkage of the fields among the forms can be realized, information of a plurality of forms can be checked in one form, the working efficiency is improved, and the repeated input work is reduced.
After the first form is determined, a first field can be acquired through a selection or creation mode, when the required field exists in the existing form, the existing field is acquired according to the first form, and the first field with the pull-down attribute is selected from the existing fields; when the required fields do not exist in the existing form, a first field with a pull-down attribute is created in the first form, and the first field is named, so that the form association range is enlarged, the applicability is improved, and the user requirement is met.
Configuring a drop-down attribute of the first field, wherein the drop-down attribute comprises a name, a number, field control, a selection type and options; wherein the name and number are the name and number of the first field; the field control comprises field options and data options, wherein the field options are used for setting a necessary filling field, a hidden field and a read-only field, and the data options are used for controlling the list to be hidden; the selection type comprises single selection or multiple selection; options include custom or other forms; and determining the second form and the associated field through the pull-down attribute, completing the association of the first form and the second form through the option, completing the association of the first form and the second form through the configuration of the pull-down attribute of the first field, determining the data needing to be imported into the first form according to the associated field, viewing the data of a plurality of forms in one form, and reducing the workload.
In order to enable various association modes to exist among form data, after form association is carried out, the invention also introduces a selection type, wherein the selection type comprises multiple selections and single selections, and when the selection type is multiple selections, the association field corresponds to multiple pieces of data, namely multiple pieces of association data; when the selection type is single selection, the association field corresponds to one piece of data, namely one piece of association data, so that one-to-many, many-to-one, many-to-many and one-to-one real-time association of the option field or the association field can be realized, and the preparation is carried out for the synchronous data of the following forms.
In the process of form association, a mode of customizing or associating other forms can be adopted. Setting configuration options when options are selected for user definition, wherein the configuration options comprise option fields, searching and acquiring a second form through the option fields, and associating the first form with the second form; when the option selects to associate other forms, setting an association form and an association field, searching and acquiring a corresponding second form according to the association form and the association field, and associating the first form with the second form. Through the two modes, the association of the first form and the second form is realized, the range of the associated form is enlarged, and the universality of the invention is improved.
Configuring association attributes of a second field, wherein the association attributes comprise names, numbers, field controls, association forms, association fields and data filtering rules; wherein the name and number are the name and number of the second field; the field control comprises field options and data options, wherein the field options are used for setting necessary filling fields and hiding fields, and the data options are used for controlling the list hiding; and configuring a data filtering rule through the association field, wherein the data filtering rule comprises any one first field ID, filtering data in the first form according to the first field ID, acquiring second association data, and filling the second association data into the second form. And filling the data in the first form into the second form according to the association attribute, so that the real-time linkage of the data of the forms is realized.
In order to keep the equipment working normally, the invention also introduces an early warning condition, after the data is filled, the corresponding first associated data or second associated data can be screened out according to the first field or the second field, whether the early warning condition is triggered or not is judged, if the early warning condition is triggered, an error prompt is carried out, and early warning information is sent to the management terminal, so that the equipment working abnormality can be processed in time.
Having described the general inventive concept, the present invention will be further described in detail with reference to the accompanying drawings by way of specific embodiments thereof, in order to make the objects, technical solutions and advantages of the present invention more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
In one embodiment, as shown in fig. 1, there is provided a form data association method, including the steps of:
step S101, a first form is acquired, and a first field with a pull-down attribute is selected/created.
Specifically, when the form association is required, determining a first form, creating or selecting a first field with a pull-down attribute in the first form, and if the first field is an existing field, selecting the first field through the field of the first form; if the first field is a new field, a first field with a drop-down attribute may be created in the first form.
The drop-down attribute refers to the value that the first field can select other forms as fields of the current form, including name, number, field control, type of selection, manner of selection, options, and the like. Wherein the name is a field name, such as product information, the number is a field number, and the field control can set a necessary filling field, a hidden field and a read-only field, or set data retrieval or list hiding; the selection types include single selection and multiple selection, so that the number selected can be one or more; the selection mode comprises a pull-down selection or a quick selection, the pull-down selection can be selected correspondingly through the requirement of a client, and the quick selection can be used for quickly selecting data according to default settings, such as the first 5 data in a default selection list.
Step S102, configuring a pull-down attribute of the first field, enabling the first field to select any field of the second form as a value of the first field, and completing construction of an association relationship between the first form and the second form.
Specifically, when form data association is performed, corresponding association data needs to be determined by configuring a pull-down attribute of a first field, so that the first field can select a field of any second form as a value of the first field, and thus association of the first form and the second form is realized. For example, the first field is product information, a device name field in the device form is selected through a pull-down attribute, the device name field in the device form is filled into the first form, and the association between the first form and the device form is completed.
Step S103, configuring association filling rules of the second form and the first form, so that data of the second form are filled into the first form.
Specifically, after the first form is associated with the second form, an association filling rule can be configured to fill data in the second form into the first form, for example, part of fields in the equipment form, including equipment price, equipment model, equipment service life and the like, are filled into the equipment maintenance form, so that a new field in the equipment maintenance form is realized, repeated input work is avoided, and the work efficiency is improved.
Step S104, after the association relation between the first form and the second form is established, selecting/creating a second field with association attribute in the second form.
Specifically, after the first form is associated with the second form, a second field with an associated attribute is selected or created in the second form according to the user's need. When a required field exists in the second form, selecting the corresponding field as a second field, wherein the second field has an associated attribute; when the required fields do not exist in the second form, the second fields can be acquired by a creation mode, the second fields are named, and the second fields with the associated attributes are created at the time of creation.
The associated attribute refers to attribute data supporting the first form, attribute information of the first form is displayed in the second form, the second form can be subjected to view operation, and the attribute information viewed by the second form changes along with the change of the data of the first form.
Step S105, configuring the association attribute of the second field, wherein the association attribute comprises a data filtering rule, and the data filtering rule is that the second field contains any one of the first field IDs, so that the second form can view the data of the first form through the second field.
Specifically, the association attribute of the second field is configured, and the association attribute comprises a name, a number, field control, an association form, an association field and a data filtering rule. For example, the second form is an equipment form, the name is an equipment maintenance state, the number is 00007, the association form is equipment maintenance, the association field is set to be product information, price and maintenance state, the data filtering is configured filtering conditions, the filtering conditions can be any one of first field IDs, such as the equipment maintenance state IDs, the first form is screened out according to the first field IDs, namely the equipment maintenance state in the equipment maintenance form, so that the data of the first form can be checked through the second form, the data association between the forms is realized, various data can be checked in one form, and the forms are linked in real time according to the data, thereby improving the working efficiency.
In this embodiment, a first form is acquired, and a first field with a pull-down attribute is set by selecting or creating; the method comprises the steps of configuring a pull-down attribute of a first field, enabling the first field to select a field of any second form as a value of the first field, completing association of the first form and the second form, configuring an association filling rule of the second form and the first form, filling data in the second form into the first form, selecting or creating a second field with an association attribute in the second form after the first form is associated with the second form, configuring the association attribute of the second field, wherein the association attribute comprises a data filtering rule, and the data filtering rule is that the second field contains any first field ID, so that the second form can check data of the first form through the second field, thereby realizing real-time data linkage of multiple forms, improving applicability, facilitating data check, avoiding repeated input work and improving work efficiency.
The step S101 specifically includes: acquiring a first form, acquiring an existing field according to the first form, and selecting a first field with a pull-down attribute from the existing field; or, creating a first field with a pull-down attribute in the first form, and naming the first field.
Specifically, when the forms are required to be associated, a first form is firstly obtained, an existing field in the first form is displayed, and if the required field exists in the existing field, a first field with a pull-down attribute is selected from the existing field; if the required field does not exist in the existing fields, creating a new field with a pull-down attribute, naming the new field, and acquiring a first field. The first field is obtained by selecting or creating two ways, so that the association between the newly added field and the existing field, between the newly added field and between the newly added field and the existing field can be realized, the form data association range is enlarged, and the actual requirements are met.
The step S102 specifically includes: configuring a drop-down attribute of the first field, wherein the drop-down attribute comprises a name, a number, field control, a selection type and options; wherein the name and number are the name and number of the first field; the field control comprises field options and data options, wherein the field options are used for setting a necessary filling field, a hidden field and a read-only field, and the data options are used for controlling the list to be hidden; the selection type comprises single selection or multiple selection; options include custom or other forms; and determining a second form and an association field through the drop-down attribute, and completing association of the first form and the second form through the option.
Specifically, after determining the first field, configuring a pull-down attribute of the first field, setting the name and the number of the first field through the name and the number, and determining the necessary filling field, the hidden field and the read-only field through field control; the acquired data is determined to be a plurality of pieces or a single piece by selecting the type. Through the association mode of option setting user definition or other associated forms, the selectable range of the associated forms of the user can be improved, and the universality of the functions can be improved. And determining a second form and an association field through the drop-down attribute, and completing association of the first form and the second form through the option and determining a mode of adopting a user-defined mode or other forms to be associated.
When the selection type is single selection, the associated field only corresponds to one piece of data; when the selection type is multi-selection, the associated field corresponds to a plurality of pieces of data.
Specifically, the selection type can be set by a pull-down selection or a hook selection mode, and the selection type comprises a multi-selection mode and a single-selection mode; when the selection is multiple, the associated field corresponds to multiple pieces of data, and one field can correspond to multiple pieces of data; when the selection is single selection, the associated field corresponds to only one piece of data, and only one field can correspond to one piece of data.
For example, when the current form is a device form, if multiple choices are selected, the association field may include product information, price, and device maintenance status fields, enabling the association of one field with multiple pieces of data. If the single selection is selected, the associated field only comprises one piece of data in the product information, the price or the equipment maintenance state, so that the association of one field and one piece of data is realized; when the associated field includes a plurality of fields, the correspondence of the plurality of fields with one piece of data can be achieved, or the correspondence of the plurality of fields with the plurality of pieces of data can be achieved, so that the one-to-many, many-to-one, many-to-many and one-to-one real-time association of the fields with the data can be achieved.
When the option is selected for user definition, setting configuration options, wherein the configuration options comprise option fields, searching and acquiring a second form through the option fields, and associating the first form with the second form; when the option selects to associate other forms, setting an association form and an association field, searching and acquiring a corresponding second form according to the association form and the association field, and associating the first form with the second form.
Specifically, when the first form and the second form are associated, the association is performed by configuring a custom association in the options or associating other forms.
As shown in fig. 2, when associating the first form and the second form in a self-defined association manner, at this time, an option is required to be configured, fields such as an option field and a number field are set, for example, the option field is set to be device 1, the number field is set to be BH001, data to be associated, for example, relevant data of device 1, a device name, a device service life and the like, are determined according to the option field, and data corresponding to the option field is filled into the first form.
As shown in fig. 3, when associating the first form with the second form by adopting a manner of associating other forms, the association form and the association field need to be configured, the second form is determined according to the association form, and a specific field of the second form is selected through the association field; for example, configuring the association form as a device form, associating the device form with the first form; the corresponding association field may be configured as information such as a device name, a device model, etc., and the information such as the device name, the device model, etc. may be filled into the first form, so that relevant data of the device form may be checked in the first form.
Through the two modes, the association between the first form and the second form is realized, the range of the associated form is enlarged, and the universality of the invention is improved.
The step S103 specifically includes: and screening data in the second form according to the association field, acquiring first association data, and filling the first association data into the first form.
Specifically, the pull-down attribute is configured with the associated field, the data in the second form is screened according to the associated field, for example, the second form is an equipment form, if the associated field is the equipment price, the equipment working life and the equipment model, the first associated data in the equipment form is screened according to the associated field, and the first associated data is filled into the first form, so that the data of the second form is checked in the first form, the linkage of the form data is realized, and the working efficiency is improved.
The step S104 specifically includes: after the association relation between the first form and the second form is established, selecting a second field through the association field, wherein the second field has association attributes; or, creating a second field with the associated attribute in a second form and naming.
Specifically, after the association relation between the first form and the second form is established, when a required field exists in the first form, a second field with an association attribute can be selected through the configured association field; when the required fields do not exist in the first form, creating new fields with associated attributes in the second form, naming the new fields, and acquiring the second fields. The second field is obtained by adopting the two modes, so that the field-field association range in the form can be enlarged, and the adaptability is improved.
The step S105 specifically includes: configuring association attributes of a second field, wherein the association attributes comprise names, numbers, field controls, association forms, association fields and data filtering rules; wherein the name and number are the name and number of the second field; the field control comprises field options and data options, wherein the field options are used for setting necessary filling fields and hiding fields, and the data options are used for controlling the list hiding; and configuring a data filtering rule through the association field, wherein the data filtering rule comprises any one first field ID, filtering data in the first form according to the first field ID, acquiring second association data, and filling the second association data into the second form.
Specifically, configuring an associated attribute of the second field, wherein the associated attribute comprises a name and a number of the second field, configuring corresponding field control, and setting a necessary filling field, a hidden field and list hiding through the field control; the control of the form fields is realized, so that the required fields can be accurately screened out. And configuring a data filtering rule, such as a first field ID, through the association field, screening out second association data according to the first field ID, and filling the second association data into a second form, so that the data in the first form can be checked through the second form, and real-time association of the form data is realized.
Wherein, after step S105, further includes: screening the associated data according to the first field or the second field, and judging whether an early warning condition is triggered or not according to the associated data; when the associated data triggers the early warning condition, error prompt is carried out, and the early warning information is sent to the management terminal.
Specifically, the first associated data and the second associated data are obtained through screening according to the first field or the second field, whether an early warning condition is triggered is judged according to the obtained associated data, for example, after equipment maintenance information is associated to an equipment table, equipment early warning can be carried out through the equipment maintenance information, when at least two parts exist in a certain equipment in a maintenance state, the equipment data is in an inoperable state, at this time, early warning can be triggered according to the condition that the at least two parts are in the maintenance state, and early warning information is sent to a management terminal.
In addition, the early warning notifier and the corresponding notification modes can be set. The notification mode can comprise short messages, telephone and APP pushing and the like, and people needing notification, such as task processors, other people, history node processors and the like, are matched with the value through notification object options. The task processor and the history node processor refer to the processor corresponding to the node to be processed and the history node processor who has processed the node to be processed in the process node respectively, and other people represent that the system can also optionally configure the personnel under the enterprise, for example, for equipment maintenance service, the manager of the enterprise can be configured as a notification personnel.
As shown in fig. 4, there is provided a form data association system 40 including: a first field determination module 41, a drop down attribute configuration module 42, a data population module 43, a second field determination module 44, and an associated attribute configuration module 45, wherein:
A first field determining module 41, configured to obtain a first form, and select/create a first field with a pull-down attribute;
The drop-down attribute configuration module 42 is configured to configure a drop-down attribute of the first field, so that the first field can select a field of any second form as a value of the first field, and the establishment of the association relationship between the first form and the second form is completed;
The data filling module 43 is configured to configure association filling rules of the second form and the first form, so that data of the second form is filled into the first form;
A second field determining module 44, configured to select/create a second field with an association attribute in the second form after the association relationship between the first form and the second form is established;
The association attribute configuration module 45 is configured to configure association attributes of the second field, where the association attributes include a data filtering rule, and the data filtering rule includes any one of the first field IDs for the second field, so that the second form can view the data of the first form through the second field.
In one embodiment, the first field determining module 41 is specifically configured to: acquiring a first form, acquiring an existing field according to the first form, and selecting a first field with a pull-down attribute from the existing field; or, creating a first field with a pull-down attribute in the first form, and naming the first field. .
In one embodiment, the drop-down attribute configuration module 42 is specifically configured to: configuring a drop-down attribute of the first field, wherein the drop-down attribute comprises a name, a number, field control, a selection type and options; wherein the name and number are the name and number of the first field; the field control comprises field options and data options, wherein the field options are used for setting a necessary filling field, a hidden field and a read-only field, and the data options are used for controlling the list to be hidden; the selection type comprises single selection or multiple selection; options include custom or other forms; and determining a second form and an association field through the drop-down attribute, and completing association of the first form and the second form through the option.
In one embodiment, the data population module 43 is specifically configured to: and screening data in the second form according to the association field, acquiring first association data, and filling the first association data into the first form.
In one embodiment, the second field determination module 44 is specifically configured to: after the association relation between the first form and the second form is established, selecting a second field through the association field, wherein the second field has association attributes; or, creating a second field with the associated attribute in a second form and naming.
In one embodiment, the association attribute configuration module 45 is specifically configured to: configuring association attributes of a second field, wherein the association attributes comprise names, numbers, field controls, association forms, association fields and data filtering rules; wherein the name and number are the name and number of the second field; the field control comprises field options and data options, wherein the field options are used for setting necessary filling fields and hiding fields, and the data options are used for controlling the list hiding; and configuring a data filtering rule through the association field, wherein the data filtering rule comprises any one first field ID, filtering data in the first form according to the first field ID, acquiring second association data, and filling the second association data into the second form.
Those skilled in the art will appreciate that implementing all or part of the above-described methods in accordance with the embodiments may be accomplished by way of a computer program stored on a computer readable storage medium, which when executed may comprise the steps of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a random-access Memory (Random Access Memory, RAM), or the like.
It will be appreciated by those skilled in the art that the modules or steps of the invention described above may be implemented in a general purpose computing device, they may be centralized on a single computing device, or distributed across a network of computing devices, or they may alternatively be implemented in program code executable by computing devices, such that they may be stored on a computer storage medium (ROM/RAM, magnetic or optical disk) for execution by computing devices, and in some cases, the steps shown or described may be performed in a different order than what is shown or described herein, or they may be individually manufactured as individual integrated circuit modules, or a plurality of modules or steps in them may be manufactured as a single integrated circuit module. Therefore, the present invention is not limited to any specific combination of hardware and software.
The foregoing is a further detailed description of the invention in connection with specific embodiments, and is not intended to limit the practice of the invention to such descriptions. It will be apparent to those skilled in the art that several simple deductions or substitutions may be made without departing from the spirit of the invention, and these should be considered to be within the scope of the invention.
Claims (9)
1. The form data association method is characterized by comprising the following steps of:
Acquiring a first form, selecting/creating a first field with a pull-down attribute;
Configuring a pull-down attribute of the first field, so that the first field can select a field of any second form as a value of the first field, and constructing an association relationship between the first form and the second form; configuring a drop-down attribute of the first field, wherein the drop-down attribute comprises a name, a number, field control, a selection type and options;
Wherein the name and number are the name and number of the first field; the field control comprises field options and data options, wherein the field options are used for setting a necessary filling field, a hidden field and a read-only field, and the data options are used for controlling the list to be hidden; the selection type comprises single selection or multiple selection; the options include custom or other forms;
Determining a second form and an association field through the pull-down attribute, and completing association of the first form and the second form through options;
Configuring an association filling rule of the second form and the first form, so that data of the second form is filled into the first form;
after the association relation between the first form and the second form is established, selecting/creating a second field with association attribute in the second form;
Configuring the association attribute of the second field, wherein the association attribute comprises an association field and a data filtering rule, and the data filtering rule is that the second field contains any one of the first field IDs, so that the second form can view the data of the first form through the second field;
And configuring a data filtering rule through an association field, wherein the data filtering rule comprises any one first field ID, filtering data in the first form according to the first field ID, acquiring second association data, and filling the second association data into the second form.
2. The form data association method according to claim 1, wherein the obtaining the first form, selecting/creating the first field with the pull-down attribute, specifically includes:
acquiring a first form, acquiring an existing field according to the first form, and selecting a first field with a pull-down attribute from the existing field;
or, creating a first field with a pull-down attribute in the first form, and naming the first field.
3. The form data association method according to claim 1, further comprising:
when the selection type is single selection, the associated field corresponds to only one piece of data;
And when the selection type is multi-selection, the association field corresponds to a plurality of pieces of data.
4. The form data association method according to claim 1, wherein the determining the second form and the association field by the pull-down attribute and the associating the first form with the second form by the option specifically includes:
When the option is selected for self definition, setting configuration options, wherein the configuration options comprise option fields, searching and acquiring a second form through the option fields, and associating the first form with the second form;
When the option selects to associate other forms, setting an association form and an association field, searching and acquiring a corresponding second form according to the association form and the association field, and associating the first form with the second form.
5. The form data association method according to claim 1, wherein the configuring the association filling rule of the second form and the first form, so that the data of the second form is filled into the first form, specifically includes:
Screening data in a second form according to the association field, acquiring first association data, and filling the first association data into the first form.
6. The form data association method according to claim 1, wherein after the association relationship between the first form and the second form is established, selecting/creating a second field with an association attribute in the second form specifically includes:
after the association relation between the first form and the second form is established, selecting a second field through the association field, wherein the second field has association attributes;
or, creating a second field with the associated attribute in the second form and naming the second field.
7. The method for associating forms with each other according to claim 1, wherein the configuring the association attribute of the second field includes a data filtering rule, where the data filtering rule includes any one of the first field IDs for the second field, so that the second form can view the data of the first form through the second field, and specifically further includes:
Configuring the association attribute of the second field, wherein the association attribute further comprises a name, a number, field control and an association form;
Wherein the name and number are the name and number of the second field; the field control comprises field options and data options, wherein the field options are used for setting the necessary filling field and the hiding field, and the data options are used for controlling the list hiding.
8. The form data association method according to claim 1, wherein after the association relationship between the first form and the second form is established, selecting/creating the second field with the association attribute in the second form further comprises:
Screening associated data according to the first field or the second field, and judging whether an early warning condition is triggered or not according to the associated data;
When the associated data triggers the early warning condition, error prompt is carried out, and the early warning information is sent to the management terminal.
9. A form data association system, wherein the form data association method according to any one of claims 1 to 8 is applied, comprising:
The first field determining module is used for acquiring a first form, selecting/creating a first field with a pull-down attribute;
The drop-down attribute configuration module is used for configuring the drop-down attribute of the first field, so that the first field can select the field of any second form as the value of the first field, and the establishment of the association relationship between the first form and the second form is completed;
The data filling module is used for configuring the association filling rule of the second form and the first form so as to fill the data of the second form into the first form;
The second field determining module is used for selecting/creating a second field with an association attribute in the second form after the association relation between the first form and the second form is established;
The association attribute configuration module is used for configuring association attributes of the second fields, the association attributes comprise data filtering rules, and the data filtering rules are that the second fields contain any one of the first field IDs, so that the second forms can view the data of the first forms through the second fields.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111671221.8A CN114297993B (en) | 2021-12-31 | 2021-12-31 | Form data association method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111671221.8A CN114297993B (en) | 2021-12-31 | 2021-12-31 | Form data association method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114297993A CN114297993A (en) | 2022-04-08 |
| CN114297993B true CN114297993B (en) | 2024-06-18 |
Family
ID=80972742
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111671221.8A Active CN114297993B (en) | 2021-12-31 | 2021-12-31 | Form data association method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114297993B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115455919A (en) * | 2022-09-30 | 2022-12-09 | 中国农业银行股份有限公司 | Summary processing method, device, electronic device and storage medium of data sheet |
| CN119903825A (en) * | 2024-12-17 | 2025-04-29 | 金蝶软件（中国）有限公司 | Form modification method, device, computer equipment and computer readable storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101263453A (en) * | 2005-09-09 | 2008-09-10 | 微软公司 | Filtering user interface for a data summary table |
| CN106598924A (en) * | 2016-10-28 | 2017-04-26 | 深圳前海微众银行股份有限公司 | Form generation method and device |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10223344B2 (en) * | 2015-01-26 | 2019-03-05 | Adobe Inc. | Recognition and population of form fields in an electronic document |
| CN107153544A (en) * | 2017-05-09 | 2017-09-12 | 合肥汉腾信息技术有限公司 | A form customization method and device |
| CN109933760A (en) * | 2019-01-28 | 2019-06-25 | 平安科技（深圳）有限公司 | Form generation method, apparatus, computer device, and computer-readable storage medium |
| CN110263314B (en) * | 2019-06-19 | 2023-07-11 | 北京明略软件系统有限公司 | Form processing method and device, storage medium and electronic device |
| CN112068911B (en) * | 2020-07-31 | 2023-12-26 | 广东飞企互联科技股份有限公司 | Electronic form generation method, device, system, equipment and medium |
| CN112035092A (en) * | 2020-08-21 | 2020-12-04 | 北京字节跳动网络技术有限公司 | Form processing method, apparatus, device and readable medium |
| CN112947834A (en) * | 2021-01-27 | 2021-06-11 | 维沃移动通信有限公司 | Information input method and device and electronic equipment |
| CN113805853A (en) * | 2021-09-28 | 2021-12-17 | 重庆允成互联网科技有限公司 | A software product development system based on industrial Internet |
-
2021
- 2021-12-31 CN CN202111671221.8A patent/CN114297993B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101263453A (en) * | 2005-09-09 | 2008-09-10 | 微软公司 | Filtering user interface for a data summary table |
| CN106598924A (en) * | 2016-10-28 | 2017-04-26 | 深圳前海微众银行股份有限公司 | Form generation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114297993A (en) | 2022-04-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3467644B1 (en) | Systems and method for service mapping | |
| CN108234168B (en) | Data display method and system based on service topology | |
| US6493755B1 (en) | Automatic notification rule definition for a network management system | |
| Hernantes et al. | IT infrastructure-monitoring tools | |
| CN108287750B (en) | System and method for providing dynamic elasticity of contact center resources | |
| CN114297993B (en) | Form data association method and system | |
| JP5458995B2 (en) | System structure management apparatus, system structure management method, and program | |
| CN104011611A (en) | Systems and methods for managing industrial processes | |
| CN101013954A (en) | Graphical user interface for generic listing of managed objects | |
| JPH06501118A (en) | Network management system with model-based intelligence | |
| US20200228396A1 (en) | Self-monitoring | |
| US20240354670A1 (en) | Titanium task-engine system | |
| US20210263899A1 (en) | System and Method for Automatic Data Migration and Disk Mapping | |
| WO2015027954A1 (en) | Management of operational data from multiple data sources | |
| CN108038665A (en) | Business Rule Management method, apparatus, equipment and computer-readable recording medium | |
| CN106354507A (en) | Enterprise-level application management system and method for operating same | |
| US11531674B2 (en) | System and method for supporting rollback of changes made to target systems via an integration platform | |
| WO2021174064A1 (en) | System and method for infrastructure inventory management, lifecycle management, cloud optimization, and data migration and disk mapping | |
| US7254627B2 (en) | Method, service agent and network management system for operating a telecommunications network | |
| US20120066358A1 (en) | Method of generating a network model | |
| EP1146688B1 (en) | Execution sets for generated error - logs | |
| US20150371175A1 (en) | Enterprise mobile application for monitoring process integration servers | |
| CN115146129B (en) | Data item selection method, device, storage medium and computer equipment | |
| CN115640206A (en) | Test plan establishing method, device and equipment | |
| CN115774706A (en) | Database creation method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230625 Address after: Room 1-1-18, Unit 1, Building 4, No. 1580 Zhiyun Avenue, Yudong Street, Banan District, Chongqing, 401320 Applicant after: Chongqing Yunfeng Technology Co.,Ltd. Address before: 408300 building a, 59 Chaoyang Road, Dianjiang Industrial Park, Chongqing Applicant before: Chongqing Yuncheng Internet Technology Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |