Online form sharing method, device, electronic device and storage medium
By displaying column attributes in the online table sharing method and generating target online tables, the problem of low information communication efficiency in the existing technology is solved, data logic transparency and security are achieved, and the efficiency and flexibility of online table sharing are improved.
Patent Information
- Application Number
- CN202210501690.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-05-09
- Publication Date
- 2024-11-22
- Estimated Expiration
- 2042-05-09
AI Technical Summary
The existing online form sharing methods are not transparent enough, resulting in inefficient information communication because the shared object cannot understand the data source and data combination logic.
By displaying multiple column attributes of the online table on the sharing and editing interface, and obtaining processing logic information based on the selected column attributes, generating the target online table, and sharing it with the target object, ensuring that the shared object can only view data within its permission range.
It improves the information communication efficiency of online forms, makes the sharing process more intuitive and efficient, and ensures data security and flexibility.
Smart Images

Figure CN114818624B_ABST
Abstract
Description
Technical Field
[0001] The present disclosure relates to the field of Internet technology, and in particular to an online form sharing method, device, electronic device and storage medium. Background Art
[0002] With the advent of the information age, multiple parties often use online spreadsheets for data sharing and office collaboration. Online spreadsheets can support multiple people to edit data online and provide services to distribute the data in the spreadsheet to designated parties.
[0003] Current online form products usually share the data of the current online form, but are unable to share the data processing logic based on the underlying source form of the online form. That is, the object being shared cannot know the data source of the online form, nor can they understand how the data from various sources are combined to obtain the online form. The sharing of online forms is not transparent enough, resulting in low efficiency in information transmission of online forms.
[0004] Therefore, there is an urgent need for an online form sharing method to improve the information transmission efficiency of the online form. Summary of the invention
[0005] The present disclosure provides an online form sharing method, device, electronic device and storage medium, which can improve the information transmission efficiency of online forms. The technical solution of the present disclosure is as follows:
[0006] According to a first aspect of an embodiment of the present disclosure, there is provided an online form sharing method, the method comprising:
[0007] In response to a sharing operation on the online form, displaying multiple column attributes of the online form on a sharing editing interface;
[0008] In response to a selection operation on a first column attribute among the plurality of column attributes, obtaining processing logic information of the online form for the first column attribute, the processing logic information indicating a source table for generating data of the first column attribute, at least one target column in the source table for generating the data, and a generating method of the data;
[0009] A target online form is generated based on the processing logic information and a row corresponding to the target object in the source form, and the target online form is shared with the target object.
[0010] In a possible implementation, generating the target online form based on the processing logic information and the row corresponding to the target object in the source form includes:
[0011] Based on the processing logic information, determining the at least one target column from the source table, the target column being used to generate data of the first column attribute;
[0012] Determining a row corresponding to the target object in the source table based on permission information of the target object, the permission information indicating the row in the source table that the target object is allowed to view;
[0013] Based on the target column and the row corresponding to the target object in the source table, the target online table is generated according to the data generation method.
[0014] In a possible implementation manner, determining, based on the permission information of the target object, a row corresponding to the target object in the source table includes:
[0015] Based on the permission information, determine the column attribute value corresponding to the target object;
[0016] Based on the column attribute value, the row in the source table that satisfies the column attribute value is determined as the row corresponding to the target object in the source table.
[0017] In one possible implementation, the method further includes:
[0018] In response to a selection operation on a first column attribute among the plurality of column attributes, displaying a plurality of column attribute values of the first column attribute on the sharing editing interface;
[0019] In response to selection of a first attribute value among the plurality of column attribute values, a row in the source table that satisfies the first column attribute value is determined as a row corresponding to the target object.
[0020] In a possible implementation, the sharing editing interface includes a time editing area, and the method further includes any of the following:
[0021] Obtaining the deadline entered in the time editing area, the time before the deadline is the time during which the target object is allowed to view the target online form;
[0022] Acquire a time period input in the time editing area, wherein a plurality of periodic time segments corresponding to the time period are times for allowing the target object to view the target online form;
[0023] The deadline and time period entered in the time editing area are obtained, and a plurality of time segments corresponding to the time period before the deadline are the time periods during which the target object is allowed to view the target online form.
[0024] In a possible implementation, the sharing editing interface includes a sharing type option, the sharing type option includes a logic option, and the generating the target online form based on the processing logic information and the row corresponding to the target object in the source form includes:
[0025] In response to selecting the logic option in the sharing type option, a target online form is generated based on the processing logic information and a row corresponding to the target object in the source form.
[0026] In a possible implementation, the sharing editing interface includes an object selection area for selecting an object to share the online form with, and the method further includes:
[0027] Get the object information entered in the object selection area;
[0028] Determine the target object corresponding to the object information based on the organizational structure information associated with the online form;
[0029] In the object selection area, the target object is displayed.
[0030] In one possible implementation, the method further includes:
[0031] In response to a sharing and viewing operation on the online form, a sharing management interface is displayed, the sharing management interface including a plurality of sharing records of the online form, the sharing record including a target object shared by the online form, the first column of attributes corresponding to the target object, and processing logic information of the online form on the first column of attributes.
[0032] In a possible implementation manner, the sharing record further includes a current viewing status of the target object on the target online form, where the current viewing status indicates whether the target object is allowed to view the target online form.
[0033] In a possible implementation manner, the sharing record further includes the time during which the target object is allowed to view the target online form.
[0034] In a possible implementation manner, the sharing record further includes a record editing option, and the record editing option is used to modify the sharing record.
[0035] According to a second aspect of an embodiment of the present disclosure, there is provided an online form sharing device, the device comprising:
[0036] A first display unit is configured to display a plurality of column attributes of the online form on a sharing editing interface in response to a sharing operation on the online form;
[0037] an acquisition unit, configured to execute, in response to a selection operation on a first column attribute among the plurality of column attributes, acquire processing logic information of the first column attribute by the online form, the processing logic information indicating a source table for generating data of the first column attribute, at least one target column in the source table for generating the data, and a generating method of the data;
[0038] The sharing unit is configured to generate a target online table based on the processing logic information and a row corresponding to the target object in the source table, and share the target online table with the target object.
[0039] In a possible implementation manner, the sharing unit includes:
[0040] A first determining subunit is configured to determine, based on the processing logic information, from the source table, the at least one target column, the target column being used to generate data of the first column attribute;
[0041] A second determining subunit is configured to determine a row corresponding to the target object in the source table based on permission information of the target object, the permission information indicating the row in the source table that the target object is allowed to view;
[0042] The generating subunit is configured to generate the target online table based on the target column and the row corresponding to the target object in the source table and in accordance with the data generation method.
[0043] In a possible implementation manner, the second determining subunit is configured to execute:
[0044] Based on the permission information, determine the column attribute value corresponding to the target object;
[0045] Based on the column attribute value, the row in the source table that satisfies the column attribute value is determined as the row corresponding to the target object in the source table.
[0046] In one possible implementation, the device further includes:
[0047] A second display unit is configured to, in response to a selection operation on a first column attribute among the plurality of column attributes, display a plurality of column attribute values of the first column attribute on the sharing editing interface;
[0048] The determining unit is configured to, in response to selecting a first attribute value among the multiple column attribute values, determine a row in the source table that satisfies the first column attribute value as a row corresponding to the target object.
[0049] In a possible implementation manner, the sharing editing interface includes a time editing area, and the device further includes any of the following:
[0050] A first time acquisition unit is configured to acquire a deadline input in the time editing area, wherein the time before the deadline is a time for allowing the target object to view the target online form;
[0051] A second time acquisition unit is configured to acquire a time period input in the time editing area, wherein a plurality of periodic time segments corresponding to the time period are times for allowing the target object to view the target online form;
[0052] The third time acquisition unit is configured to acquire the deadline and time period input in the time editing area, and a plurality of time segments before the deadline and corresponding to the time period are times for allowing the target object to view the target online form.
[0053] In a possible implementation, the sharing editing interface includes a sharing type option, the sharing type option includes a logic option, and the sharing unit is configured to execute:
[0054] In response to selecting the logic option in the sharing type option, a target online form is generated based on the processing logic information and a row corresponding to the target object in the source form.
[0055] In a possible implementation, the sharing editing interface includes an object selection area for selecting a sharing object of the online form, and the device further includes:
[0056] An information acquisition unit is configured to acquire object information input in the object selection area;
[0057] An object determination unit, configured to determine the target object corresponding to the object information based on the organizational structure information associated with the online form;
[0058] The third display unit is configured to display the target object in the object selection area.
[0059] In one possible implementation, the device further includes:
[0060] The fourth display unit is configured to execute a sharing and viewing operation in response to the online form, and display a sharing management interface, wherein the sharing management interface includes a plurality of sharing records of the online form, and the sharing record includes a target object shared by the online form, the first column of attributes corresponding to the target object, and processing logic information of the online form on the first column of attributes.
[0061] In a possible implementation manner, the sharing record further includes a current viewing status of the target object on the target online form, where the current viewing status indicates whether the target object is allowed to view the target online form.
[0062] In a possible implementation manner, the sharing record further includes the time during which the target object is allowed to view the target online form.
[0063] In a possible implementation manner, the sharing record further includes a record editing option, and the record editing option is used to modify the sharing record.
[0064] According to a third aspect of an embodiment of the present disclosure, an electronic device is provided, the electronic device comprising:
[0065] one or more processors;
[0066] A memory for storing program codes executable by the processor;
[0067] The processor is configured to execute the program code to implement the above-mentioned online form sharing method.
[0068] According to a fourth aspect of an embodiment of the present disclosure, a computer-readable storage medium is provided, the computer-readable storage medium comprising: when a program code in the computer-readable storage medium is executed by a processor of an electronic device, the electronic device is enabled to execute the above-mentioned online form sharing method.
[0069] According to a fifth aspect of an embodiment of the present disclosure, a computer program product is provided, including a computer program, and when the computer program is executed by a processor, the online form sharing method described above is implemented.
[0070] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS
[0071] The drawings herein are incorporated into and constitute a part of the specification, illustrate embodiments consistent with the present disclosure, and together with the description are used to explain the principles of the present disclosure, and do not constitute improper limitations on the present disclosure.
[0072] Figure 1 is a schematic diagram of an implementation environment of an online form sharing method according to an exemplary embodiment;
[0073] Figure 2 is a flow chart of an online form sharing method according to an exemplary embodiment;
[0074] Figure 3 is a schematic diagram of an online form according to an exemplary embodiment;
[0075] Figure 4 is a flow chart of an online form sharing method according to an exemplary embodiment;
[0076] Figure 5 is a schematic diagram showing an object selection area according to an exemplary embodiment;
[0077] Figure 6is a schematic diagram showing a time editing area according to an exemplary embodiment;
[0078] Figure 7 is a schematic diagram of a sharing editing interface according to an exemplary embodiment;
[0079] Figure 8 is a schematic diagram of a table creation interface according to an exemplary embodiment;
[0080] Fig. 9 is a schematic diagram showing a sharing type option according to an exemplary embodiment;
[0081] Fig.10 is a schematic diagram of a data screening area according to an exemplary embodiment;
[0082] Fig.11 is a schematic diagram showing a sharing online form according to an exemplary embodiment;
[0083] Fig.12 is a schematic diagram of a sharing management interface according to an exemplary embodiment;
[0084] Fig.13 is a block diagram of an online form sharing device according to an exemplary embodiment;
[0085] Fig.14 It is a structural block diagram of a terminal according to an exemplary embodiment. DETAILED DESCRIPTION
[0086] In order to enable ordinary persons in the art to better understand the technical solutions of the present disclosure, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the accompanying drawings.
[0087] It should be noted that the terms "first", "second", etc. in the specification and claims of the present disclosure and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present disclosure described herein can be implemented in an order other than those illustrated or described herein. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present disclosure. Instead, they are merely examples of devices and methods consistent with some aspects of the present disclosure as detailed in the appended claims.
[0088] It should be noted that the information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, stored data, displayed data, etc.) and signals involved in this disclosure are all authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards of relevant countries and regions. For example, the data and object information in the online forms involved in this disclosure are all obtained with full authorization.
[0089] Figure 1 is a schematic diagram of an implementation environment of an online form sharing method according to an exemplary embodiment. Figure 1 , the implementation environment includes: a terminal 101 and a server 102.
[0090] The terminal 101 may be at least one of a smart phone, a smart watch, a desktop computer, a laptop, a virtual reality terminal, an augmented reality terminal, a wireless terminal, and a laptop computer. The terminal 101 has a communication function and can access the Internet. The terminal 101 may generally refer to one of a plurality of terminals. This embodiment is only illustrated by the terminal 101. Those skilled in the art may know that the number of the above terminals may be more or less. The terminal 101 may run an online form application that supports viewing, editing, and sharing online forms. In some embodiments, the online form application is a browser / server (Browser / Server, B / S) type application, such as a web application. The terminal 101 is based on a web browser, that is, it can access an online form application running in the form of a web application on the Internet, and the online form application provides the above-mentioned various functions based on the Internet. In other embodiments, the online form application is a client / server (Client / Server, C / S) type application, such as a desktop application that needs to be installed in the terminal. The terminal 101 opens the installed online form application and provides the above-mentioned various functions through the application running on the terminal. In some other embodiments, the online form application is a mini program that can access the Internet without downloading and installing to provide the above-mentioned various functions, for example, a small program within an application running on a terminal.
[0091] In some embodiments, the terminal 101 can communicate with the server 102 via the Internet to obtain various background services provided by the server 102 to implement the above-mentioned various functions, such as data storage and data processing services of online forms. The server 102 and the terminal 101 can be directly or indirectly connected via wired or wireless communication, which is not limited in the embodiments of the present disclosure.
[0092] The server 102 may be an independent physical server, or a server cluster or distributed file system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (CDN), and big data and artificial intelligence platforms. In some embodiments, the server 102 can provide the terminal 101 with background services related to online forms, such as data storage and data aggregation computing services for online forms. In some embodiments, the number of the above-mentioned servers 102 may be more or less, and the embodiments of the present disclosure are not limited to this. Of course, the server 102 may also include other functional servers in order to provide more comprehensive and diversified services.
[0093] Figure 2 is a flow chart of an online form sharing method according to an exemplary embodiment. Figure 2 As shown, the method is used in the above terminal 101, comprising the following steps:
[0094] In step 201 , in response to a sharing operation on an online form, the terminal displays a plurality of column attributes of the online form on a sharing editing interface.
[0095] The online table is a data set including multiple rows and multiple columns. Each data column in the online table has a field, which is used to describe the attributes of the data set, and the data column includes the attribute values of multiple data objects under the attribute type; each data row includes the attribute values of a data object in the data set under multiple attributes. The data object is a data subject with various attributes recorded in the online table, for example, an employee in the employee information table.
[0096] In the embodiments of the present disclosure, for ease of explanation, in the online table, the fields of the data columns are called column attributes. The column attributes in the online table are the attributes that describe the data in the online table; the data rows in the online table are composed of column attribute values corresponding to multiple column attributes. For example, the column attributes of the online table Table1 include: column attribute 1 "organization code" and column attribute 2 "employee type", the column attribute value corresponding to column attribute 1 in data row 1 is: "005", and the column attribute value corresponding to column attribute 2 in data row 1 is: "Intern".
[0097] In the disclosed embodiment, the online form supports the collaborative use of multiple objects and can be used to record, count and analyze data online. For example, an online form used for collaborative office work within an enterprise can be viewed, edited and shared by multiple employees within the enterprise organizational structure.
[0098] In some embodiments, the sharing operation may be an operation such as clicking or sliding a sharing button in a terminal by an object using the online form, which is not limited in the embodiments of the present disclosure.
[0099] Among them, the sharing editing interface is used to obtain the sharing method of the online table, for example, the column attributes to be shared among the multiple column attributes of the online table. In an embodiment of the present disclosure, the terminal displays the multiple column attributes of the online table in the form of optional items on the sharing editing interface in response to the sharing operation of the online table. In some embodiments, the optional items corresponding to the multiple column attributes are arranged and displayed in the column attribute selection area of the sharing editing interface according to the character order of the multiple column attributes, for example, the character order indicated by the American Standard Code for Information Interchange (ASCII). In other embodiments, the optional items corresponding to the multiple column attributes are arranged and displayed in the column attribute selection area of the sharing editing interface according to the arrangement order of the multiple column attributes in the table.
[0100] In some embodiments, the multiple column attributes can be completely arranged and displayed in the current page of the sharing editing interface, or can be displayed separately based on multiple pages through switching methods such as turning pages and sliding, or can be arranged and displayed in the form of a drop-down bar in the drop-down pop-up area. This is not limited to the embodiments of the present disclosure.
[0101] In step 202, in response to a selection operation on a first column attribute among the plurality of column attributes, the terminal obtains processing logic information of the online form on the first column attribute.
[0102] In the embodiment of the present disclosure, the first column attribute selected by the selection operation is considered as the column attribute to be shared, based on which, by obtaining the processing logic information of the first column attribute, the data processing logic corresponding to the first column attribute is shared. In some embodiments, the selection operation of the first column attribute can be a click operation on an optional item in the sharing editing interface.
[0103] The processing logic information indicates a source table for generating data of the first column attribute, at least one target column in the source table for generating the data, and a method for generating the data. In some embodiments, the online table is obtained based on multiple source tables, that is, the data in the online table is derived from the multiple source tables. For example, the source tables include "Employee Rank Information Table of City A", "Employee Rank Information Table of City B", and "Employee Rank Information Table of City C". The online table is determined based on the three source tables, including "Employee Rank Information Table 1" of employee rank information of City A, City B, and City C.
[0104] Accordingly, in some embodiments, the data corresponding to the first column attribute in the online table is generated based on at least one target column in the source table, and the target column is a data column in the source table. For example, the first column attribute is "Location" in "Employee Rank Information Table 1", which corresponds to the employee's location information (City A, City B, or City C); in the source tables "City A Employee Rank Information Table", "City B Employee Rank Information Table", and "City C Employee Rank Information Table", the target column used to generate the data corresponding to the first column attribute is a data column including the employee's location information. In order to facilitate understanding of the relationship between the online table and the source table and the relationship between the first column attribute and the target column in the source table, the present disclosure shows a schematic diagram of an online table according to an exemplary embodiment, see Figure 3 .
[0105] Furthermore, in some embodiments, the target column in the source table generates data corresponding to the first column attribute according to a certain generation method, that is, according to a certain data processing logic. For example, the target column A with the column attribute "workload" in the source table sheet1 "January work information table", the target column B with the column attribute "workload" in the source table sheet2 "February work information table", and the target column C with the column attribute "workload" in the source table sheet3 "March work information table", the workload data of the three target columns are accumulated according to the corresponding employees to obtain the data column X corresponding to the first column attribute "quarterly workload" in the online table sheet4 "First Quarter Work Information Table". In some embodiments, the above generation method can be expressed in the form of a calculation formula, for example, INDIRECT("sheet1"&"!A:A"), which means obtaining the target column A of sheet1; SUMIF{INDIRECT("sheet1"&"!A:A"), INDIRECT("sheet2"&"!B:B")}, which means summing the data of the target column A of sheet1 and the target column B of sheet2, where INDIRECT is a reference calculation function and SUMIF is a summation function.
[0106] In step 203, the terminal generates a target online form based on the processing logic information and the row corresponding to the target object in the source form, and shares the target online form with the target object.
[0107] The target object is a sharing object of the online form. In some embodiments, the target object is determined based on object information input in the sharing editing interface.
[0108] In the disclosed embodiment, the terminal generates the target online table based on the target column and the row corresponding to the target object in the source table according to the data generation method, that is, the target online table is obtained by processing the data corresponding to the target object according to the data generation method corresponding to the selected first column attribute. Through the above technical solution, the data processing logic in the online table and the corresponding source table are shared with the target object in the form of a target online table.
[0109] In some embodiments, the row corresponding to the target object in the source table refers to the data row that the target object has permission to view, that is, the data row in the source table that the target object is allowed to view. The terminal determines the data row in the source table that the target object is allowed to view by obtaining the permission information of the target object.
[0110] Through the technical solution provided by the embodiment of the present disclosure, the source table of the online form is used as the data basis, combined with the underlying data processing logic, to achieve personalized sharing of the sharing object, making the sharing of the online form more intuitive and efficient, and greatly improving the information transmission efficiency of the online form.
[0111] Above Figure 2 The following is only a basic process of the present disclosure. The solution provided by the present disclosure is further described based on a specific implementation method. Figure 4 is a flow chart of an online form sharing method according to an exemplary embodiment. Figure 4 As shown, the method is used in a terminal and includes the following steps:
[0112] In step 401, the terminal displays a sharing editing interface in response to a sharing operation on an online form.
[0113] The online form and the sharing operation are defined in step 201 and will not be described in detail here.
[0114] In the embodiment of the present disclosure, the sharing editing interface is used to obtain the sharing mode of the online form. The sharing editing interface will be introduced below based on the different information obtained by the sharing editing interface.
[0115] In some embodiments, the sharing editing interface is used to obtain the sharing object of the online form. In some embodiments, the sharing editing interface includes an object selection area for selecting the sharing object of the online form. The process of the terminal determining the target object to be shared with the online form based on the object selection area includes the following steps 4011 to 4013:
[0116] In step 4011, the terminal obtains the object information input in the object selection area.
[0117] In the embodiments of the present disclosure, the object information is information that can be used to determine the sharing object, such as the Chinese name of the user, the pinyin abbreviation of the name, or the user number. In other embodiments, the object information can be used to determine the object group, such as the name, name abbreviation, or number of the user group, which is not limited in the present disclosure.
[0118] In step 4012, the terminal determines the target object corresponding to the object information based on the organizational structure information associated with the online form.
[0119] In some embodiments, the online form is associated with an organizational structure, for example, an enterprise using the online form for office work. Accordingly, the organizational structure information includes information of multiple objects in the organizational structure and information of the divided object groups, for example, information such as the name and work number of the enterprise employees, the department name and department code of the enterprise department, etc.
[0120] In some embodiments, the object selection area further includes a sharing personnel option, which includes a sharing individual option and a sharing group option. When the sharing individual option is selected, the terminal determines a target object that matches the object information based on the organizational structure information, for example, an employee whose name matches the input name abbreviation; when the sharing group option is selected, the terminal determines a target object group that matches the object information based on the organizational structure information, for example, a department whose department code matches the input information.
[0121] In step 4013, the terminal displays the target object in the object selection area.
[0122] In some embodiments, the terminal displays the target object in the object selection area in the form of an object tag. In some embodiments, the object tag is editable to provide a function of deleting and adding a shared object.
[0123] Figure 5 is a schematic diagram showing an object selection area according to an exemplary embodiment. Figure 5 , Figure 5 Includes Figure (a) and Figure (b). Figure 5 In the middle figure (a), when the share personal option 501 is selected, the object selection area displays a user tag 502 corresponding to the selected target object, and the user tag 502 displays the user's Chinese name and the pinyin of the name, wherein the user tag 502 is in a removable state; see Figure 5 In the middle figure (b), when the share group option 503 is selected, a user group label 504 corresponding to the selected target object group is displayed in the object selection area, and the user group label 504 displays the name of the user group, wherein the user group label 504 is in a removable state.
[0124] Through the above technical solution, a variety of methods for selecting sharing objects associated with the organizational structure are provided, which are suitable for various business scenarios and effectively improve the efficiency of information transmission when sharing online forms.
[0125] In some embodiments, the sharing editing interface is used to obtain the time when the target object is allowed to view the online form. In some embodiments, the sharing editing interface includes a time editing area, and the time editing area is used to obtain the time when the target object is allowed to view the online form. The time editing area provides multiple time types, and the time types include: deadline, periodic time, and a combination of deadline and periodic time. Next, based on the multiple time types, the process of the terminal obtaining the time when the target object is allowed to view the online form is described.
[0126] (1) The time type is a deadline. The deadline can be a time in days, for example, "January 1, 2022", or a time in hours, for example, "January 1, 2022 14:00". In this example, the terminal obtains the deadline entered in the time editing area, and the time before the deadline is the time when the target object is allowed to view the online form.
[0127] (2) The time type is periodic time. The periodic time indicates multiple periodic time segments that conform to the time period, for example, every Monday, or the 15th of every month. In this example, the terminal obtains the time period entered in the time editing area, and the multiple periodic time segments corresponding to the time period are the times when the target object is allowed to view the online form.
[0128] (3) The time type is a combination of a deadline and a time period. In this example, the terminal obtains the deadline and the time period entered in the time editing area, and the multiple time segments before the deadline and corresponding to the time period are the time when the target object is allowed to view the target online form. For example, if the deadline is "January 1, 2022" and the time period is "Monday of each week", the time when the target object is allowed to view the online form is: every Monday between the current time and January 1, 2022.
[0129] In some embodiments, the terminal displays multiple options for time editing modes in the time editing area. The above (1), (2) and (3) can all be edited and combined in the "custom" time editing mode. In some embodiments, the time editing mode also includes "fixed duration" and "permanent". The fixed duration indicates the time within a fixed duration from the current time that the target object is allowed to view the online form. Permanent indicates that there is no limit on the time for the target object to view the online form.
[0130] To facilitate understanding of the above content, the present disclosure shows a schematic diagram of a time editing area according to an exemplary embodiment, see Figure 6 , multiple time editing mode options are displayed in the time editing area, including "Permanent", fixed duration "1 day", fixed duration "7 days", fixed duration "30 days" and "Custom". Among them, when the "Custom" option is selected, Figure 6 Multiple time items with entered information are displayed in the figure, the time type of time item 601 is "deadline", and the deadline is "January 1, 2022"; the time type of time item 602 is "weekly", and the time period is "Monday" and "Wednesday"; the time editing area also displays an editing item 603 for adding more time items to obtain a more complex time combination; the multiple time items are all editable, and a removable button is displayed on the right side of time item 602.
[0131] Through the above technical solution, a variety of sharing time editing methods are provided, which can meet the time limit requirements in various complex business scenarios, and effectively improve the information transmission efficiency of online form sharing while ensuring data security.
[0132] In step 402, the terminal displays multiple column attributes of the online form in the sharing editing interface.
[0133] This step refers to step 201 and is not described in detail here.
[0134] In some embodiments, the sharing editing interface displays multiple column attributes with the same name corresponding to multiple column attributes of the online table in the source table corresponding to the online table. It can be understood that the column attributes with the same name in the source table are distinguished by adding an identifier. For example, for the column attribute "position status" of the online table, the corresponding column attribute in the corresponding source table 1 is displayed as "position status 1" in the sharing editing interface, and the corresponding column attribute in the corresponding source table 2 is displayed as "position status 2". The definition of the source table is shown in step 202, which is not repeated here.
[0135] Through the above technical solution, the column attributes of the online table and the column attributes of the source table are displayed in the sharing editing interface, providing a way to view the underlying source table based on the online table, so that personalized data sharing at the field level can be achieved based on the source table of the online table as the data basis, and the displayed column attributes are determined based on the viewing authority of the online table to the underlying source table data, which not only ensures the data security during the sharing process, but also effectively improves the flexibility of online table sharing.
[0136] For ease of understanding, the present disclosure shows a schematic diagram of a sharing and editing interface according to an exemplary embodiment, see Figure 7, the online table is "employee rank information table", corresponding to source table 1 "basic information table 1" and source table 2 "basic information table 2". In the field selection area of the sharing editing interface, the table name "employee rank information table" is displayed to indicate that the "employee rank information table" is currently shared; under "employee rank information table", the table name "basic information table 1" of source table 1 is displayed, and the drop-down bar area corresponding to "basic information table 1" displays multiple options corresponding to the same-name column attributes, and the table name "basic information table 2" of source table 2 is also displayed. In the drop-down bar area corresponding to "basic information table 2", multiple options corresponding to the same-name column attributes are displayed, where the same-name column attributes of different source tables are distinguished by the numbers "1" and "2".
[0137] In some embodiments, when the terminal creates the online form, it determines the source form corresponding to the online form. In this example, in response to the creation operation of the online form, the terminal displays a form creation interface, and the form creation interface is used to obtain the source form of the online form to determine the online form. In some embodiments, the form creation interface also includes a form type option, which provides a selection of whether to support sharing of the online form and whether to support data association of the online form with other online forms, wherein the data association refers to whether to allow the online form to be used as the source form of other online forms.
[0138] The present disclosure provides a schematic diagram of a table creation interface according to an exemplary embodiment. Figure 8 The table creation interface displays a table name input item, table type options, table data source options, and a source table display area.
[0139] In step 403, in response to a selection operation on a first column attribute among the plurality of column attributes, the terminal obtains processing logic information of the online form on the first column attribute.
[0140] This step refers to step 202 and is not described in detail here.
[0141] In step 404, the terminal determines the at least one target column from the source table based on the processing logic information, where the target column is used to generate data of the first column attribute.
[0142] The definition of the target column in the source table refers to step 202 and Figure 3 , I will not go into details here.
[0143] In some embodiments, the sharing editing interface further includes a sharing type option, and the sharing type option includes a logic option and a page option. When the logic option is selected, the terminal shares the online form based on the data processing logic corresponding to the online form. When the page option is selected, the terminal shares based on the data included in the online form. In this example, the terminal executes step 404 in response to selecting the logic option in the sharing type option. The present disclosure shows a schematic diagram of a sharing type option according to an exemplary embodiment, see Fig. 9 .
[0144] In step 405, the terminal determines the row corresponding to the target object in the source table based on the permission information of the target object, where the permission information indicates the rows in the source table that the target object is allowed to view.
[0145] This step refers to step 203.
[0146] In some embodiments, the permission information indicates that the column attribute value in the source table satisfies the specified condition, for example, the column attribute value of the column attribute "location" is "City A". Based on the permission information, the terminal can determine the column attribute value corresponding to the target object, and then based on the column attribute value, determine the row in the source table that satisfies the column attribute value as the row corresponding to the target object in the source table. That is, the data row whose column attribute value satisfies the specified condition is the row in the source table that the target object is allowed to view. In some embodiments, the permission information is associated with the account corresponding to the target object.
[0147] Through the above technical solution, the data corresponding to the target object is determined based on the permission information, and the sharing of the online form is realized based on the viewing permission of the underlying source form. While ensuring data security, personalized form sharing based on the underlying source form is realized, which effectively improves the efficiency of information transmission when sharing online forms.
[0148] In some embodiments, the sharing editing interface further includes a data filtering area for filtering out rows corresponding to the target object according to column attribute values. In this example, in response to a selection operation for a first column attribute among the multiple column attributes, the terminal displays multiple column attribute values of the first column attribute in the data filtering area. Based on this, in response to the selection of the first attribute value among the multiple column attribute values, the terminal determines the row in the source table that satisfies the first column attribute value as the row corresponding to the target object.
[0149] In some embodiments, the data filtering area provides two filtering modes: "Share with current permissions" and "Custom configuration". In the "Share with current permissions" mode, the data included in the online table is directly used as the row corresponding to the target object. The current permission may be the data permission corresponding to the object that created the online table, indicating the data range of the online table. In the "Custom configuration" mode, multiple column attribute values of the first column attribute, as well as other column attributes of the online table and multiple column attribute values of the other column attributes are displayed. Based on the selection of the multiple column attribute values, the row corresponding to the target object in the source table can be determined based on the data of the online table. A column attribute and its selected column attribute value constitute a filtering item, indicating that the data row in the source table that meets the filtering item is the row corresponding to the target object; multiple filtering items can be combined into a composite filtering condition with different logical relationships, for example, filtering item A and (and) filtering item B, indicating that both filtering item A and filtering item B need to be met; filtering item A or filtering item B, indicating that filtering item A or filtering item B is met.
[0150] The present disclosure shows a schematic diagram of a data screening area according to an exemplary embodiment. Fig.10 , where the data filtering area provides two filtering modes: "Custom Configuration" and "Share with Current Permissions". When the "Custom Configuration" mode is selected, multiple filtering items are displayed in the data filtering area. Filter item 1001 indicates that the column attribute value of "Organization Name" must comply with the "First Function", and filter item 1002 indicates that the column attribute value of "Organization Name" must comply with the "Second Function". The logical relationship between filter item 1001 and filter item 1002 is "or", indicating that the data rows with the organization name of "First Function Department" and the organization name of "Second Function Department" are filtered as the rows corresponding to the target object. The data filtering area also displays an editing item 1003 for adding more filtering items to obtain more complex matching filtering conditions.
[0151] In other embodiments, when the page option is selected, the data included in the online form may conflict with the row corresponding to the target object indicated by the permission information. Since the page option is selected in the online form, the data corresponding to the permission information of the online form is considered to be shared with the target object, and therefore, the data included in the online form is considered to be the row corresponding to the target object. In some embodiments, the permission information of the online form is determined based on the object that created the online form. In this way, permission sharing is achieved when sharing the online form, and the information transmission efficiency of the online form is improved.
[0152] In order to facilitate understanding of the difference between the above logic options and page options, the present disclosure shows a schematic diagram of sharing an online form according to an exemplary embodiment, see Fig.11, wherein the online form 1101 is determined based on multiple source forms 1102, and in the case of sharing based on page options, the sharing table 1103 shared to the target object is determined based on the permission information of the creation object of the online form; in the case of sharing based on logic options, the sharing table 1104 shared to the target object is determined based on the permission information of the target object.
[0153] Through the above technical solution, an online form sharing method based on different sharing options and implemented according to different data processing logics is provided, which can meet the sharing needs in different business scenarios and greatly improve the applicability of online forms.
[0154] In step 406, the terminal generates the target online table based on the target column and the row corresponding to the target object in the source table and in accordance with the data generation method.
[0155] This step refers to step 203 and is not described in detail here.
[0156] In the disclosed embodiment, based on the method of generating the data corresponding to the first column attribute generated by the target column, the row corresponding to the source table and the target column are processed. In some embodiments, the method of generating the data is expressed in the form of a calculation formula. By obtaining the calculation formula, the row corresponding to the target object under the target column is substituted into the calculation formula to generate the target online table. For example, the target column A is the "workload" column of the "January work information table", the target column B is the "workload" column of the "February work information table", and the target column C is the "workload" column of the "March work information table". The row corresponding to the target object in the source table is the data row corresponding to the employee whose "organization name" is the "first functional department". Based on the calculation formula corresponding to the first column attribute, the corresponding data rows of the employees of the first functional department in the target column A, the target column B and the target column C are accumulated accordingly to obtain the target online table "First Quarter Work Information Table", which only includes the data corresponding to the "quarterly workload" of the employees of the first functional department. The calculation formula refers to step 202 and is not repeated here.
[0157] In step 407 , the terminal displays a sharing management interface in response to the sharing management operation on the online form, where the sharing management interface includes a plurality of sharing records of the online form.
[0158] In some embodiments, the sharing record includes the target object shared by the online form, the first column of attributes corresponding to the target object, and the processing logic information of the online form for the first column of attributes. The processing logic information refers to the above content and is not described here.
[0159] In some embodiments, the shared record also includes a record editing option, and the record editing option is used to modify the shared record.
[0160] In some embodiments, the sharing record also includes the time during which the target object is allowed to view the target online form. The process of determining the time during which the target object is allowed to view the target online form is referred to step 401 and will not be described in detail here.
[0161] In some embodiments, the sharing record further includes the target object's current viewing status of the target online form, and the current viewing status indicates whether the target object is allowed to view the target online form. The current viewing status is determined based on the time when the target object is allowed to view the target online form and the current time. For example, if the current time is "Tuesday, March 8, 2022", if the time when the target object is allowed to view the target online form is "every Monday", the current viewing status is displayed as invisible; if the deadline for allowing the target object to view the target online form is "Tuesday, January 1, 2022", the current viewing status is displayed as expired; if the time when the target object is allowed to view the target online form is "every Tuesday before June 6, 2022", the current viewing status is displayed as visible.
[0162] To facilitate understanding of the above content, the present disclosure shows a schematic diagram of a sharing management interface according to an exemplary embodiment, see Fig.12 , wherein the sharing management interface displays multiple sharing records, each of which includes: the user name of the sharing object, the name of the sharing object, the sharing type, the data permission, the current viewing status, and the time limit. The data permission indicates the viewable data limit, for example, the sharing object "Name A" can view the "first-level department" in the "first functional department" and the "third functional department". On the right side of each sharing record, an edit option is displayed, which provides the function of editing and deleting the sharing record. The sharing management interface provides a search function for user names and names in the form of a search icon.
[0163] Through the above technical solution, the functions of viewing, managing and editing the sharing records of the online form are provided in the form of a sharing management interface, which reduces the user's operation cost and effectively improves the work efficiency when sharing online forms.
[0164] Through the technical solution provided by the embodiment of the present disclosure, the source table of the online form is used as the data basis, combined with the underlying data processing logic, to achieve personalized sharing of the sharing object, making the sharing of the online form more intuitive and efficient, and greatly improving the information transmission efficiency of the online form.
[0165] Furthermore, it provides a sharing permission formulation method that combines multiple dimensions such as sharing objects, viewing time, and column attribute value filtering, which can meet the online form sharing needs in various complex business scenarios, and effectively improve the information transmission efficiency of online form sharing while ensuring data security.
[0166] Fig.13 is a block diagram of an online form sharing device according to an exemplary embodiment. Fig.13 , the device comprises:
[0167] The first display unit 1301 is configured to display a plurality of column attributes of the online form on a sharing editing interface in response to a sharing operation on the online form;
[0168] The acquiring unit 1302 is configured to execute, in response to a selection operation on a first column attribute among the plurality of column attributes, acquiring processing logic information of the first column attribute by the online form, the processing logic information indicating a source table for generating data of the first column attribute, at least one target column in the source table for generating the data, and a generating method of the data;
[0169] The sharing unit 1303 is configured to generate a target online form based on the processing logic information and a row corresponding to the target object in the source form, and share the target online form with the target object.
[0170] In a possible implementation, the sharing unit 1303 includes:
[0171] A first determining subunit is configured to determine, based on the processing logic information, from the source table, the at least one target column, the target column being used to generate data of the first column attribute;
[0172] A second determining subunit is configured to determine a row corresponding to the target object in the source table based on permission information of the target object, the permission information indicating the row in the source table that the target object is allowed to view;
[0173] The generating subunit is configured to generate the target online table based on the target column and the row corresponding to the target object in the source table and in accordance with the data generation method.
[0174] In a possible implementation manner, the second determining subunit is configured to execute:
[0175] Based on the permission information, determine the column attribute value corresponding to the target object;
[0176] Based on the column attribute value, the row in the source table that satisfies the column attribute value is determined as the row corresponding to the target object in the source table.
[0177] In one possible implementation, the device further includes:
[0178] A second display unit is configured to, in response to a selection operation on a first column attribute among the plurality of column attributes, display a plurality of column attribute values of the first column attribute on the sharing editing interface;
[0179] The determining unit is configured to, in response to selecting a first attribute value among the multiple column attribute values, determine a row in the source table that satisfies the first column attribute value as a row corresponding to the target object.
[0180] In a possible implementation manner, the sharing editing interface includes a time editing area, and the device further includes any of the following:
[0181] A first time acquisition unit is configured to acquire a deadline input in the time editing area, wherein the time before the deadline is a time for allowing the target object to view the target online form;
[0182] A second time acquisition unit is configured to acquire a time period input in the time editing area, wherein a plurality of periodic time segments corresponding to the time period are times for allowing the target object to view the target online form;
[0183] The third time acquisition unit is configured to acquire the deadline and time period input in the time editing area, and a plurality of time segments before the deadline and corresponding to the time period are times for allowing the target object to view the target online form.
[0184] In a possible implementation, the sharing editing interface includes a sharing type option, the sharing type option includes a logic option, and the sharing unit 1303 is configured to execute:
[0185] In response to selecting the logic option in the sharing type option, a target online form is generated based on the processing logic information and a row corresponding to the target object in the source form.
[0186] In a possible implementation, the sharing editing interface includes an object selection area for selecting a sharing object of the online form, and the device further includes:
[0187] An information acquisition unit is configured to acquire object information input in the object selection area;
[0188] An object determination unit, configured to determine the target object corresponding to the object information based on the organizational structure information associated with the online form;
[0189] The third display unit is configured to display the target object in the object selection area.
[0190] In one possible implementation, the device further includes:
[0191] The fourth display unit is configured to execute a sharing and viewing operation in response to the online form, and display a sharing management interface, wherein the sharing management interface includes a plurality of sharing records of the online form, and the sharing record includes a target object shared by the online form, the first column of attributes corresponding to the target object, and processing logic information of the online form on the first column of attributes.
[0192] In a possible implementation manner, the sharing record further includes a current viewing status of the target object on the target online form, where the current viewing status indicates whether the target object is allowed to view the target online form.
[0193] In a possible implementation manner, the sharing record further includes the time during which the target object is allowed to view the target online form.
[0194] In a possible implementation manner, the sharing record further includes a record editing option, and the record editing option is used to modify the sharing record.
[0195] Through the technical solution provided by the embodiment of the present disclosure, the source table of the online form is used as the data basis, combined with the underlying data processing logic, to achieve personalized sharing of the sharing object, making the sharing of the online form more intuitive and efficient, and greatly improving the information transmission efficiency of the online form.
[0196] It should be noted that: when the online form sharing device provided in the above embodiment performs the corresponding steps, only the division of the above functional modules is used as an example. In actual applications, the above functions can be assigned to different functional modules as needed, that is, the internal structure of the device is divided into different functional modules to complete all or part of the functions described above. In addition, the online form sharing device provided in the above embodiment and the online form sharing method embodiment belong to the same concept, and the specific implementation process is detailed in the method embodiment, which will not be repeated here.
[0197] Fig.14 is a structural block diagram of a terminal according to an exemplary embodiment. Fig.14The terminal 1400 may be a smart phone, a tablet computer, an MP3 player (Moving Picture Experts Group Audio Layer III), an MP4 player (Moving Picture Experts Group Audio Layer IV), a laptop computer, or a desktop computer. The terminal 1400 may also be called a user device, a portable terminal, a laptop terminal, a desktop terminal, or other names.
[0198] Typically, the terminal 1400 includes a processor 1401 and a memory 1402 .
[0199] The processor 1401 may include one or more processing cores, such as a 4-core processor, an 8-core processor, etc. The processor 1401 may be implemented in at least one hardware form of DSP (Digital Signal Processing), FPGA (Field-Progra mmable Gate Array), and PLA (Programmable Logic Array). The processor 1401 may also include a main processor and a coprocessor. The main processor is a processor for processing data in the awake state, also known as a CPU (Central Processing Unit); the coprocessor is a low-power processor for processing data in the standby state. In some embodiments, the processor 1401 may be integrated with a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content to be displayed on the display screen. In some embodiments, the processor 1401 may also include an AI (Artificial Intelligence) processor, which is used to process computing operations related to machine learning.
[0200] The memory 1402 may include one or more computer-readable storage media, which may be non-transitory. The memory 1402 may also include a high-speed random access memory and a non-volatile memory, such as one or more disk storage devices and flash memory storage devices. In some embodiments, the non-transitory computer-readable storage medium in the memory 1402 is used to store at least one program code, which is used to be executed by the processor 1401 to implement the process executed by the terminal in the online form sharing method provided in the method embodiment of the present disclosure.
[0201] In some embodiments, the terminal 1400 may also optionally include: a peripheral device interface 1403 and at least one peripheral device. The processor 1401, the memory 1402 and the peripheral device interface 1403 may be connected via a bus or a signal line. Each peripheral device may be connected to the peripheral device interface 1403 via a bus, a signal line or a circuit board. Specifically, the peripheral device includes: at least one of a radio frequency circuit 1404, a display screen 1405, a camera assembly 1406, an audio circuit 1407, a positioning assembly 1408 and a power supply 1409.
[0202] The peripheral device interface 1403 may be used to connect at least one peripheral device related to I / O (Input / Output) to the processor 1401 and the memory 1402. In some embodiments, the processor 1401, the memory 1402, and the peripheral device interface 1403 are integrated on the same chip or circuit board; in some other embodiments, any one or two of the processor 1401, the memory 1402, and the peripheral device interface 1403 may be implemented on a separate chip or circuit board, which is not limited in the embodiments of the present disclosure.
[0203] The radio frequency circuit 1404 is used to receive and transmit RF (Radio Frequency) signals, also known as electromagnetic signals. The radio frequency circuit 1404 communicates with the communication network and other communication devices through electromagnetic signals. The radio frequency circuit 1404 converts the electrical signal into an electromagnetic signal for transmission, or converts the received electromagnetic signal into an electrical signal. In some embodiments, the radio frequency circuit 1404 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a user identity module card, and the like. The radio frequency circuit 1404 can communicate with other terminals through at least one wireless communication protocol. The wireless communication protocol includes, but is not limited to: a metropolitan area network, various generations of mobile communication networks (2G, 3G, 4G and 5G), a wireless local area network and / or a WiFi (Wireless Fidelity) network. In some embodiments, the radio frequency circuit 1404 may also include circuits related to NFC (Near Field Communication), which is not limited in the present disclosure.
[0204] The display screen 1405 is used to display a UI (User Interface). The UI may include graphics, text, icons, videos, and any combination thereof. When the display screen 1405 is a touch display screen, the display screen 1405 also has the ability to collect touch signals on the surface or above the surface of the display screen 1405. The touch signal can be input to the processor 1401 as a control signal for processing. At this time, the display screen 1405 can also be used to provide virtual buttons and / or virtual keyboards, also known as soft buttons and / or soft keyboards. In some embodiments, the display screen 1405 can be one, set on the front panel of the terminal 1400; in other embodiments, the display screen 1405 can be at least two, respectively set on different surfaces of the terminal 1400 or in a folding design; in other embodiments, the display screen 1405 can be a flexible display screen, set on a curved surface or a folding surface of the terminal 1400. Even, the display screen 1405 can also be set to a non-rectangular irregular shape, that is, a special-shaped screen. The display screen 1405 can be made of materials such as LCD (Liquid Crystal Display) and OLED (Organic Light-Emitting Diode).
[0205] The camera assembly 1406 is used to capture images or videos. In some embodiments, the camera assembly 1406 includes a front camera and a rear camera. Typically, the front camera is disposed on the front panel of the terminal, and the rear camera is disposed on the back of the terminal. In some embodiments, there are at least two rear cameras, which are any one of a main camera, a depth of field camera, a wide-angle camera, and a telephoto camera, so as to realize the fusion of the main camera and the depth of field camera to realize the background blur function, the fusion of the main camera and the wide-angle camera to realize panoramic shooting and VR (Virtual Reality) shooting function or other fusion shooting functions. In some embodiments, the camera assembly 1406 may also include a flash. The flash may be a monochrome temperature flash or a dual-color temperature flash. A dual-color temperature flash refers to a combination of a warm light flash and a cold light flash, which can be used for light compensation at different color temperatures.
[0206] The audio circuit 1407 may include a microphone and a speaker. The microphone is used to collect sound waves from the user and the environment, and convert the sound waves into electrical signals and input them into the processor 1401 for processing, or input them into the radio frequency circuit 1404 to achieve voice communication. For the purpose of stereo acquisition or noise reduction, there may be multiple microphones, which are respectively arranged at different parts of the terminal 1400. The microphone may also be an array microphone or an omnidirectional acquisition microphone. The speaker is used to convert the electrical signal from the processor 1401 or the radio frequency circuit 1404 into sound waves. The speaker may be a traditional film speaker or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, it can not only convert the electrical signal into sound waves audible to humans, but also convert the electrical signal into sound waves inaudible to humans for purposes such as ranging. In some embodiments, the audio circuit 1407 may also include a headphone jack.
[0207] The positioning component 1408 is used to locate the current geographical location of the terminal 1400 to implement navigation or LBS (Location Based Service).
[0208] The power supply 1409 is used to power various components in the terminal 1400. The power supply 1409 can be an alternating current, a direct current, a disposable battery, or a rechargeable battery. When the power supply 1409 includes a rechargeable battery, the rechargeable battery can support wired charging or wireless charging. The rechargeable battery can also be used to support fast charging technology.
[0209] In some embodiments, the terminal 1400 further includes one or more sensors 1410 , including but not limited to: an acceleration sensor 1411 , a gyroscope sensor 1412 , a pressure sensor 1413 , a fingerprint sensor 1414 , an optical sensor 1415 , and a proximity sensor 1416 .
[0210] The acceleration sensor 1411 can detect the magnitude of acceleration on the three coordinate axes of the coordinate system established by the terminal 1400. For example, the acceleration sensor 1411 can be used to detect the components of gravity acceleration on the three coordinate axes. The processor 1401 can control the display screen 1405 to display the user interface in a horizontal view or a vertical view according to the gravity acceleration signal collected by the acceleration sensor 1411. The acceleration sensor 1411 can also be used for collecting game or user motion data.
[0211] The gyro sensor 1412 can detect the body direction and rotation angle of the terminal 1400, and the gyro sensor 1412 can cooperate with the acceleration sensor 1411 to collect the user's 3D actions on the terminal 1400. The processor 1401 can implement the following functions based on the data collected by the gyro sensor 1412: motion sensing (such as changing the UI according to the user's tilt operation), image stabilization during shooting, game control, and inertial navigation.
[0212] The pressure sensor 1413 may be provided at the side frame of the terminal 1400 and / or the lower layer of the display screen 1405. When the pressure sensor 1413 is provided at the side frame of the terminal 1400, it may detect the user's holding signal of the terminal 1400, and the processor 1401 may perform left and right hand recognition or shortcut operation according to the holding signal collected by the pressure sensor 1413. When the pressure sensor 1413 is provided at the lower layer of the display screen 1405, the processor 1401 may control the operability control on the UI interface according to the user's pressure operation on the display screen 1405. The operability control includes at least one of a button control, a scroll bar control, an icon control, and a menu control.
[0213] The fingerprint sensor 1414 is used to collect the user's fingerprint, and the processor 1401 identifies the user's identity based on the fingerprint collected by the fingerprint sensor 1414, or the fingerprint sensor 1414 identifies the user's identity based on the collected fingerprint. When the user's identity is identified as a trusted identity, the processor 1401 authorizes the user to perform relevant sensitive operations, which include unlocking the screen, viewing encrypted information, downloading software, paying, and changing settings. The fingerprint sensor 1414 can be set on the front, back, or side of the terminal 1400. When a physical button or a manufacturer logo is set on the terminal 1400, the fingerprint sensor 1414 can be integrated with the physical button or the manufacturer logo.
[0214] The optical sensor 1415 is used to collect the ambient light intensity. In one embodiment, the processor 1401 can control the display brightness of the display screen 1405 according to the ambient light intensity collected by the optical sensor 1415. Specifically, when the ambient light intensity is high, the display brightness of the display screen 1405 is increased; when the ambient light intensity is low, the display brightness of the display screen 1405 is reduced. In another embodiment, the processor 1401 can also dynamically adjust the shooting parameters of the camera component 1406 according to the ambient light intensity collected by the optical sensor 1415.
[0215] The proximity sensor 1416, also called a distance sensor, is usually disposed on the front panel of the terminal 1400. The proximity sensor 1416 is used to collect the distance between the user and the front of the terminal 1400. In one embodiment, when the proximity sensor 1416 detects that the distance between the user and the front of the terminal 1400 is gradually decreasing, the processor 1401 controls the display screen 1405 to switch from the screen-on state to the screen-off state; when the proximity sensor 1416 detects that the distance between the user and the front of the terminal 1400 is gradually increasing, the processor 1401 controls the display screen 1405 to switch from the screen-off state to the screen-on state.
[0216] Those skilled in the art will understand that Fig.14 The structure shown in the figure does not constitute a limitation on the terminal 1400, and the terminal 1400 may include more or less components than those shown in the figure, or combine some components, or adopt a different component arrangement.
[0217] In an exemplary embodiment, a computer-readable storage medium including program code is also provided, such as a memory 1402 including program code, and the program code can be executed by a processor 1401 of a terminal 1400 to complete the online form sharing method. In some embodiments, the computer-readable storage medium can be a read-only memory (ROM), a random access memory (RAM), a compact-disc read-only memory (CD-ROM), a magnetic tape, a floppy disk, an optical data storage device, and the like.
[0218] In an exemplary embodiment, a computer program product is also provided, including a computer program, and when the computer program is executed by a processor, the online form sharing method is implemented.
[0219] In some embodiments, the computer program involved in the embodiments of the present disclosure may be deployed and executed on a computer device, or on multiple computer devices located at one location, or on multiple computer devices distributed at multiple locations and interconnected through a communication network. Multiple computer devices distributed at multiple locations and interconnected through a communication network may constitute a blockchain system.
[0220] Those skilled in the art will readily appreciate other embodiments of the present disclosure after considering the specification and practicing the invention disclosed herein. The present disclosure is intended to cover any variations, uses or adaptations of the present disclosure that follow the general principles of the present disclosure and include common knowledge or customary techniques in the art that are not disclosed in the present disclosure. The description and examples are to be considered exemplary only, and the true scope and spirit of the present disclosure are indicated by the following claims.
[0221] It should be understood that the present disclosure is not limited to the exact structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.
Claims
1. An online form sharing method, characterized in that: The method comprises: In response to a sharing operation on an online form, a plurality of column attributes of the online form are displayed on a sharing editing interface; the data in the online form is derived from a plurality of source forms; In response to a selection operation on a first column attribute among the plurality of column attributes, obtaining processing logic information of the online form on the first column attribute, the processing logic information indicating a source table for generating data of the first column attribute, at least one target column in the source table for generating the data, and a generating method of the data; Based on the processing logic information, determining the at least one target column from the source table, the target column being used to generate data of the first column attribute; Determining, based on permission information of the target object, a row corresponding to the target object in the source table, wherein the permission information indicates the row in the source table that the target object is allowed to view; Based on the target column and the row corresponding to the target object in the source table, a target online table is generated according to the data generation method, and the target online table is shared with the target object.
2. The online form sharing method according to claim 1, characterized in that: The determining, based on the permission information of the target object, a row corresponding to the target object in the source table includes: Based on the permission information, determining a column attribute value corresponding to the target object; Based on the column attribute value, a row in the source table that satisfies the column attribute value is determined as a row corresponding to the target object in the source table.
3. The online form sharing method according to claim 1, characterized in that: The method further comprises: In response to a selection operation on a first column attribute among the plurality of column attributes, displaying a plurality of column attribute values of the first column attribute on the sharing editing interface; In response to selection of a first attribute value among the plurality of column attribute values, a row in the source table that satisfies the first column attribute value is determined as a row corresponding to the target object.
4. The online form sharing method according to claim 1, characterized in that: The sharing editing interface includes a time editing area, and the method further includes any of the following: Acquire a deadline entered in the time editing area, the time before the deadline being the time during which the target object is allowed to view the target online form; Acquire a time period input in the time editing area, wherein a plurality of periodic time segments corresponding to the time period are times during which the target object is allowed to view the target online form; The deadline and time period input in the time editing area are acquired, and a plurality of time segments before the deadline and corresponding to the time period are times during which the target object is allowed to view the target online form.
5. The online form sharing method according to claim 1, characterized in that: The sharing editing interface includes a sharing type option, and the sharing type option includes a logic option. The method further includes: In response to selecting the logic option in the sharing type option, a target online form is generated based on the processing logic information and a row corresponding to the target object in the source form.
6. The online form sharing method according to claim 1, characterized in that: The sharing editing interface includes an object selection area for selecting a sharing object of the online form, and the method further includes: Acquire object information input in the object selection area; Determining the target object corresponding to the object information based on the organizational structure information associated with the online form; In the object selection area, the target object is displayed.
7. The online form sharing method according to claim 1, characterized in that: The method further comprises: In response to a sharing and viewing operation on the online form, a sharing management interface is displayed, wherein the sharing management interface includes a plurality of sharing records of the online form, wherein the sharing records include a target object shared by the online form, the first column attribute corresponding to the target object, and processing logic information of the online form for the first column attribute.
8. The online form sharing method according to claim 7, characterized in that: The sharing record further includes a current viewing status of the target object on the target online form, where the current viewing status indicates whether the target object is allowed to view the target online form.
9. The online form sharing method according to claim 7, characterized in that: The sharing record also includes the time during which the target object is allowed to view the target online form.
10. The online form sharing method according to claim 7, characterized in that: The sharing record also includes a record editing option, and the record editing option is used to modify the sharing record.
11. An online form sharing device, characterized in that: The device comprises: A first display unit is configured to display a plurality of column attributes of the online form on a sharing editing interface in response to a sharing operation on the online form; the data in the online form is derived from a plurality of source forms; an acquiring unit, configured to execute, in response to a selection operation on a first column attribute among the plurality of column attributes, acquiring processing logic information of the first column attribute by the online form, the processing logic information indicating a source table for generating data of the first column attribute, at least one target column in the source table for generating the data, and a generating method of the data; The sharing unit includes a first determining subunit, a second determining subunit and a generating subunit; The first determining subunit is configured to determine the at least one target column from the source table based on the processing logic information, wherein the target column is used to generate data of the first column attribute; The second determining subunit is configured to determine a row corresponding to the target object in the source table based on permission information of the target object, wherein the permission information indicates a row in the source table that the target object is allowed to view; The generating subunit is configured to generate a target online table based on the target column and the row corresponding to the target object in the source table according to the data generation method, and share the target online table with the target object.
12. The online form sharing device according to claim 11, characterized in that: The second determining subunit is configured to execute: Based on the permission information, determining a column attribute value corresponding to the target object; Based on the column attribute value, a row in the source table that satisfies the column attribute value is determined as a row corresponding to the target object in the source table.
13. The online form sharing device according to claim 11, characterized in that: The device also includes: a second display unit configured to, in response to a selection operation on a first column attribute among the plurality of column attributes, display a plurality of column attribute values of the first column attribute on the sharing editing interface; The determining unit is configured to, in response to selecting a first attribute value from among the plurality of column attribute values, determine a row in the source table that satisfies the first column attribute value as a row corresponding to the target object.
14. The online form sharing device according to claim 11, characterized in that: The sharing editing interface includes a time editing area, and the device further includes any of the following: A first time acquisition unit is configured to acquire a deadline input in the time editing area, wherein the time before the deadline is a time during which the target object is allowed to view the target online form; A second time acquisition unit is configured to acquire a time period input in the time editing area, wherein a plurality of periodic time segments corresponding to the time period are times for allowing the target object to view the target online form; The third time acquisition unit is configured to acquire the deadline and time period input in the time editing area, and a plurality of time segments before the deadline and corresponding to the time period are times for allowing the target object to view the target online form.
15. The online form sharing device according to claim 11, characterized in that: The sharing editing interface includes a sharing type option, the sharing type option includes a logic option, and the sharing unit is configured to execute: In response to selecting the logic option in the sharing type option, a target online form is generated based on the processing logic information and a row corresponding to the target object in the source form.
16. The online form sharing device according to claim 11, characterized in that: The sharing editing interface includes an object selection area for selecting a sharing object of the online form, and the device further includes: An information acquisition unit, configured to acquire object information input in the object selection area; an object determining unit, configured to determine the target object corresponding to the object information based on the organizational structure information associated with the online form; The third display unit is configured to display the target object in the object selection area.
17. The online form sharing device according to claim 11, characterized in that: The device also includes: a fourth display unit, configured to display a sharing management interface in response to a sharing and viewing operation on the online form, wherein the sharing management interface includes a plurality of sharing records of the online form, the sharing records include a target object shared by the online form, the first column attribute corresponding to the target object, and processing logic information of the online form on the first column attribute.
18. The online form sharing device according to claim 17, characterized in that: The sharing record further includes a current viewing status of the target object on the target online form, where the current viewing status indicates whether the target object is allowed to view the target online form.
19. The online form sharing device according to claim 17, characterized in that: The sharing record also includes the time during which the target object is allowed to view the target online form.
20. The online form sharing device according to claim 17, characterized in that: The sharing record also includes a record editing option, and the record editing option is used to modify the sharing record.
21. An electronic device, characterized in that: The electronic device comprises: one or more processors; a memory for storing program code executable by the processor; The processor is configured to execute the program code to implement the online form sharing method according to any one of claims 1 to 10.
22. A computer-readable storage medium, characterized in that: When the program code in the computer-readable storage medium is executed by a processor of an electronic device, the electronic device is enabled to execute the online form sharing method according to any one of claims 1 to 10.
23. A computer program product, characterized in that The invention comprises a computer program, which implements the online form sharing method according to any one of claims 1 to 10 when being executed by a processor.
