CN111079393A - Spreadsheet system for storing customer information based on two-dimensional code - Google Patents
Spreadsheet system for storing customer information based on two-dimensional code Download PDFInfo
- Publication number
- CN111079393A CN111079393A CN201911016631.1A CN201911016631A CN111079393A CN 111079393 A CN111079393 A CN 111079393A CN 201911016631 A CN201911016631 A CN 201911016631A CN 111079393 A CN111079393 A CN 111079393A
- Authority
- CN
- China
- Prior art keywords
- dimensional code
- identified
- worksheet
- workbook
- dimensional
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000005516 engineering process Methods 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000000034 method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/955—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL]
- G06F16/9554—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL] by using bar codes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K19/00—Record carriers for use with machines and with at least a part designed to carry digital markings
- G06K19/06—Record carriers for use with machines and with at least a part designed to carry digital markings characterised by the kind of the digital marking, e.g. shape, nature, code
- G06K19/06009—Record carriers for use with machines and with at least a part designed to carry digital markings characterised by the kind of the digital marking, e.g. shape, nature, code with optically detectable marking
- G06K19/06037—Record carriers for use with machines and with at least a part designed to carry digital markings characterised by the kind of the digital marking, e.g. shape, nature, code with optically detectable marking multi-dimensional coding
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a spreadsheet system for storing customer information based on two-dimensional codes, which adopts three-level two-dimensional codes to respectively identify a workbook, a worksheet and cells, can be linked to a second two-dimensional code group for identifying each worksheet by identifying a first two-dimensional code of the workbook, can be linked to a third two-dimensional code group for identifying each cell by identifying the second two-dimensional code, and can be connected to an instruction module by identifying the third two-dimensional code to send corresponding information of the corresponding cell to a customer. The invention enables the spreadsheet technology to be developed further. Due to the advent of the 5G era, spreadsheets applied to the intelligent mobile terminal also come, and therefore, the spreadsheet system can provide a more convenient intelligent mobile terminal transaction platform for customers.
Description
Technical Field
The invention relates to the field of electronic forms and mobile internet application, in particular to an electronic form system for storing customer information based on two-dimensional codes.
Background
At present, with the development of the internet and the mobile internet, new technologies and new ideas are continuously emerging for realizing the 5G network. Besides the functions of data sorting and calculation, the existing spreadsheet can sort a worksheet for a certain project and can be shown as a plane schematic diagram if being combined with a two-dimensional code; the cells of the spreadsheet may indicate that a certain time of a certain person is shared and a certain time of a certain space is shared; the spreadsheet may serve as a transaction platform for mobile internet online.
Disclosure of Invention
The invention mainly aims to provide an electronic form system for storing customer information based on two-dimension codes to realize the application of the electronic form.
The invention is realized by the following technical scheme:
a spreadsheet system for storing customer information based on two-dimensional codes,
the electronic form comprises at least one workbook, each workbook comprises at least one worksheet, each worksheet comprises at least one cell, each workbook has a unique first two-dimensional code for identifying the workbook, each worksheet has a unique second two-dimensional code for identifying the worksheet, the second two-dimensional codes of the worksheets of each workbook form a second two-dimensional code group of the workbook, each cell has a unique third two-dimensional code for identifying the cell, and the third two-dimensional codes of the cells of each worksheet form a third two-dimensional code group of the worksheet;
the spreadsheet system is internally provided with an instruction module, any first two-dimensional code is identified to be capable of being linked to a second two-dimensional code group of a workbook identified by the identified first two-dimensional code, any second two-dimensional code is identified to be capable of being linked to a third two-dimensional code group of a worksheet identified by the identified second two-dimensional code, and any third two-dimensional code is identified to be capable of being linked to the instruction module and trigger the instruction module to perform preset format control on a cell identified by the identified third two-dimensional code and generate and send information corresponding to the cell identified by the identified third two-dimensional code.
Further, the preset format control is to fill a preset color.
Further, the information is payment voucher or ticket checking information.
Further, the payment voucher is presented in the form of a fourth two-dimensional code.
Furthermore, the first two-dimensional code, the second two-dimensional code and the third two-dimensional code all have parameters and are identified in a long-time pressing mode.
Compared with the prior art, the spreadsheet system for storing customer information based on the two-dimensional codes, provided by the invention, respectively identifies the workbook, the worksheet and the cells by adopting the three-level two-dimensional codes, can be linked to the second two-dimensional code group for identifying each worksheet by identifying the first two-dimensional code for identifying the workbook, can be linked to the third two-dimensional code group for identifying each cell by identifying the second two-dimensional code, and can be connected to the instruction module by identifying the third two-dimensional code, so that the information corresponding to the corresponding cell is sent to the customer. The invention enables the spreadsheet technology to be developed further. Due to the advent of the 5G era, spreadsheets applied to the intelligent mobile terminal also come, and therefore, the spreadsheet system can provide a more convenient intelligent mobile terminal transaction platform for customers.
Drawings
Fig. 1 is a schematic diagram illustrating the composition and operation principle of a spreadsheet system for storing customer information based on two-dimensional codes according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be further described in detail with reference to the following embodiments and the accompanying drawings.
As shown in FIG. 1, the spreadsheet system for storing customer information based on two-dimensional codes provided by the embodiment of the invention comprises a spreadsheet, wherein the spreadsheet comprises at least one workbook 1, each workbook 1 comprises at least one worksheet 4, each worksheet 4 comprises at least one cell, each workbook 1 has a unique first two-dimensional code 2 for identifying the workbook 1, each worksheet 4 has a unique second two-dimensional code 5 for identifying the worksheet 4, the second two-dimensional codes 5 of the worksheets 4 of each workbook 1 form a second two-dimensional code group 3 of the workbook 1, each cell has a unique third two-dimensional code 7 for identifying the cell, and the third two-dimensional codes 7 of the cells of each worksheet 4 form a third two-dimensional code group 6 of the worksheet 4.
The spreadsheet system is internally provided with an instruction module 8, any first two-dimensional code 2 can be identified to be linked to a second two-dimensional code group 3 of the workbook 1 identified by the identified first two-dimensional code 2, any second two-dimensional code 5 can be identified to be linked to a third two-dimensional code group 6 of the worksheet 4 identified by the identified second two-dimensional code 5, any third two-dimensional code 7 can be identified to be linked to the instruction module 8, and the instruction module 8 is triggered to perform preset format control on the cell identified by the identified third two-dimensional code 7 and generate and send information corresponding to the cell identified by the identified third two-dimensional code 7. The preset format control may be, for example, filling a preset color, such as filling green, etc. The aforementioned information may be, for example, payment vouchers or ticket checking information, wherein the payment vouchers may be presented in the form of a fourth two-dimensional code 9.
In this embodiment, the first two-dimensional code 2, the second two-dimensional code 5, and the third two-dimensional code 7 all have parameters, and can be identified by a long press method.
This spreadsheet system based on two-dimensional code storage customer information adopts tertiary two-dimensional code to mark workbook 1, worksheet 4 and cell respectively, can link to the second two-dimensional code 5 of each worksheet 4 of sign through the first two-dimensional code 2 of discernment sign workbook 1, can link to the third two-dimensional code group 6 of each cell of sign through discernment second two-dimensional code 5, can be connected to instruction module 8 through discernment third two-dimensional code 7, send the information that corresponding cell corresponds to the customer. Due to the coming of the 5G era, the electronic forms applied to the intelligent mobile terminals also come, and the electronic form system can be applied to the intelligent mobile terminals such as the intelligent mobile phones and can provide more convenient intelligent mobile terminal transaction platforms for customers.
The above-described embodiments are merely preferred embodiments, which are not intended to limit the scope of the present invention, and any modifications, equivalents, improvements, etc. made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (5)
1. An electronic form system for storing customer information based on two-dimensional codes, comprising an electronic form, wherein the electronic form comprises at least one workbook, each workbook comprises at least one worksheet, each worksheet comprises at least one cell, wherein each workbook has a unique first two-dimensional code for identifying the workbook, each worksheet has a unique second two-dimensional code for identifying the worksheet, the second two-dimensional codes of the worksheets of each workbook form a second two-dimensional code group of the workbook, each cell has a unique third two-dimensional code for identifying the cell, and the third two-dimensional codes of the cells of each worksheet form a third two-dimensional code group of the worksheet;
the spreadsheet system is internally provided with an instruction module, any first two-dimensional code is identified to be capable of being linked to a second two-dimensional code group of a workbook identified by the identified first two-dimensional code, any second two-dimensional code is identified to be capable of being linked to a third two-dimensional code group of a worksheet identified by the identified second two-dimensional code, and any third two-dimensional code is identified to be capable of being linked to the instruction module and trigger the instruction module to perform preset format control on a cell identified by the identified third two-dimensional code and generate and send information corresponding to the cell identified by the identified third two-dimensional code.
2. The spreadsheet system for storing customer information based on two-dimensional code as claimed in claim 1, wherein said predetermined format control is performed such that a predetermined color is filled.
3. The spreadsheet system for storing customer information based on two-dimensional codes as claimed in claim 1, wherein said information is payment voucher or ticket checking information.
4. The two-dimensional code based spreadsheet system for storing customer information as claimed in claim 3, wherein said payment voucher is presented in the form of a fourth two-dimensional code.
5. The two-dimensional code based spreadsheet system of storing customer information of claim 1, wherein said first two-dimensional code, said second two-dimensional code, said third two-dimensional code are all provided with parameters, identified by long press.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911016631.1A CN111079393A (en) | 2019-10-24 | 2019-10-24 | Spreadsheet system for storing customer information based on two-dimensional code |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911016631.1A CN111079393A (en) | 2019-10-24 | 2019-10-24 | Spreadsheet system for storing customer information based on two-dimensional code |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111079393A true CN111079393A (en) | 2020-04-28 |
Family
ID=70310556
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911016631.1A Pending CN111079393A (en) | 2019-10-24 | 2019-10-24 | Spreadsheet system for storing customer information based on two-dimensional code |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111079393A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114239103A (en) * | 2021-03-19 | 2022-03-25 | 深圳微图世界网络科技有限公司 | CAD building plan part area color changing device based on electronic forms and building method thereof |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004318412A (en) * | 2003-04-15 | 2004-11-11 | Matsushita Electric Ind Co Ltd | 2D code receipt, 2D code receipt using device, 2D code receipt generation device, and tabular form code decoding device |
| CN106202571A (en) * | 2016-08-11 | 2016-12-07 | 龙旭光 | Digital Map System based on Quick Response Code storage customer information and using method thereof |
| CN106372205A (en) * | 2016-08-31 | 2017-02-01 | 张宏海 | Method for recording invoice information by two-dimensional code |
| WO2018006724A1 (en) * | 2016-07-08 | 2018-01-11 | 阿里巴巴集团控股有限公司 | Two-dimensional code information query method, server, client, and system |
| CN107742089A (en) * | 2017-09-05 | 2018-02-27 | 广东职业技术学院 | A kind of method that Quick Response Code automatic identification is realized using electrical form |
-
2019
- 2019-10-24 CN CN201911016631.1A patent/CN111079393A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004318412A (en) * | 2003-04-15 | 2004-11-11 | Matsushita Electric Ind Co Ltd | 2D code receipt, 2D code receipt using device, 2D code receipt generation device, and tabular form code decoding device |
| WO2018006724A1 (en) * | 2016-07-08 | 2018-01-11 | 阿里巴巴集团控股有限公司 | Two-dimensional code information query method, server, client, and system |
| CN106202571A (en) * | 2016-08-11 | 2016-12-07 | 龙旭光 | Digital Map System based on Quick Response Code storage customer information and using method thereof |
| CN106372205A (en) * | 2016-08-31 | 2017-02-01 | 张宏海 | Method for recording invoice information by two-dimensional code |
| CN107742089A (en) * | 2017-09-05 | 2018-02-27 | 广东职业技术学院 | A kind of method that Quick Response Code automatic identification is realized using electrical form |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114239103A (en) * | 2021-03-19 | 2022-03-25 | 深圳微图世界网络科技有限公司 | CAD building plan part area color changing device based on electronic forms and building method thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103077185B (en) | A kind of method of object-based self-defined extension information | |
| CN112784112B (en) | Message verification method and device | |
| CN107133777A (en) | A kind of establishment of electronic contract, signature method and system | |
| CN111369247A (en) | Cross-bank transaction data processing method and device | |
| CN109767320A (en) | Order review method, apparatus, computer equipment and storage medium | |
| CN108694617A (en) | Method and system for sharing business circle points | |
| CN106294125A (en) | Core banking system data processing method | |
| CN105828319B (en) | A kind of method and device for replacing client identification module card | |
| CN105045546A (en) | Full-self-service bill printing system | |
| CN105574738A (en) | Cross-platform integral exchange system | |
| CN111626878A (en) | Order processing method and device, electronic equipment and storage medium | |
| CN111881657A (en) | Intelligent marking method, terminal equipment and storage medium | |
| CN111079393A (en) | Spreadsheet system for storing customer information based on two-dimensional code | |
| CN104408503B (en) | The processing method and system of Quick Response Code | |
| CN107609870A (en) | More application key management method, system and POS terminals for POS | |
| CN113536782B (en) | Sensitive word recognition method and device, electronic equipment and storage medium | |
| CN105868172A (en) | Express bill information generating system | |
| JP4063845B2 (en) | Two-dimensional code transmission method, system, and portable terminal | |
| CN112132545A (en) | Evaluation system, information pushing method and device and electronic equipment | |
| CN114186831B (en) | Personal credit risk prediction method and system by applying transfer learning | |
| CN108228688A (en) | A kind of template generation method based on XBRL, system and server | |
| CN104442054A (en) | Two-dimension code printing method and device based on mainframe platform | |
| CN117592986A (en) | Transaction method, device, equipment, system and storage medium | |
| CN115271836A (en) | Electronic invoice generation method, system, equipment and medium for railway electronic passenger ticket | |
| CN202013590U (en) | Payment verifying system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |