{"id":1760,"date":"2019-02-12T08:32:29","date_gmt":"2019-02-12T14:32:29","guid":{"rendered":"https:\/\/www.teamdesk.net\/blog\/?p=1760"},"modified":"2021-09-15T04:09:09","modified_gmt":"2021-09-15T09:09:09","slug":"link-qr-code-scanner-to-your-database","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/","title":{"rendered":"Link a QR code scanner to your database"},"content":{"rendered":"

Let\u2019s consider an example on how to link a QR code scanner to a database. Say you\u2019ve built the \u201cQR Code Scanner\u201d application. The main idea of this database is that users can scan QR codes via a mobile device and then search database tables for records containing QR codes.<\/p>\n

Assume that your database keeps descriptions and photos of different computer parts. Each part has a unique QR code. There are parts of two types: Type A and Type B, so you keep these types in two separate tables:<\/p>\n

\u201cType A Parts\u201d table:<\/p>\n

\"QR<\/a><\/p>\n

\u201cType B Parts\u201d table:<\/p>\n

\"QR<\/a><\/p>\n

So, each user should be able to scan a particular part\u2019s QR code to search the database for this component and get all the supplemental information related to this part.<\/p>\n

For example:<\/p>\n

\"QR<\/a><\/p>\n

What would you have to setup in your database to build this functionality?<\/h2>\n

1.Generated Document<\/h3>\n

In this example each table contains a generated document<\/a> that keeps all the data related to the part. For instance, \u201cDocument A\u201d can be generated in the \u201cType A Parts\u201d table.<\/p>\n

\"DocumentA<\/a><\/p>\n

\u201cDocument B\u201d can be generated in the \u201cType B Parts\u201d table.<\/p>\n

\"DocumentB<\/a><\/p>\n

2.Auxiliary Formula-Text column<\/h3>\n

Moreover, you need to add a \u201cRecordId\u201d auxiliary formula-text<\/a> column to each table with the following formula: RecordId().<\/p>\n

So, let\u2019s create the \u201cRecordId\u201d formula-text column in the \u201cType A Part\u201d table:<\/p>\n

\"RecordID<\/a><\/p>\n

Also, you should create the same column in the \u201cType B Part\u201d table:<\/p>\n

\"RecordsID<\/a><\/p>\n

These columns will be used in the future adjustment.<\/p>\n

3.New \u201cSearch Requests\u201d table<\/h3>\n

Now you need to create a new auxiliary table<\/a>. Let\u2019s name it \u201cSearch Requests\u201d. This table should include the following columns: QR Code, Document, RecordIdA , RecordIdB, DocumentA, DocumentB.<\/p>\n

\"Columns\"<\/a><\/p>\n

First, let\u2019s create a \u201cBarcode type<\/a>\u201d- column called \u201cQR Code\u201d. Select \u201cQR Code\u201d option in the \u201cType\u201d dropdown:<\/p>\n

\"QR<\/a><\/p>\n

Then add a \u201cFile Attachment<\/a>\u201d – type column called \u201cDocument\u201d. It will be used in the workflow action setup.
\nOn the next step it is important to add two Many-to-Many<\/a> relations:
\n– between \u201cType A Parts\u201d and \u201cSearch Requests\u201d tables
\n– between \u201cType B Parts\u201d and \u201cSearch Requests\u201d tables.
\nwith the following match condition<\/a>: [QR Code]=[QR Code]<\/p>\n

As a result, you can now add \u201cRecordIdA\u201d and \u201cRecordIdB\u201d summary columns<\/a> to each relation respectively. These columns pull a maximal record ID from the related \u201cType A Parts\u201d or \u201cType B Parts\u201d table if a scanned QR code value kept in the \u201cSearch Request\u201d record matches the QR code value kept in the \u201cType A Parts\u201d (or \u201cType B Parts\u201d).<\/p>\n

Here is an example of the \u201cRecordIdA\u201d summary column:<\/p>\n

\"RecordIdA<\/a><\/p>\n

The \u201cRecordIdB\u201d summary column should be added to the second relation.<\/p>\n

\"RecordIdB<\/a><\/p>\n

The most difficult step is to build formula-URL<\/a> columns. For instance, the \u201cDocumentA\u201d formula-URL column should contain a URL that consists of the elements described below:<\/p>\n

\"FormulaURL<\/a><\/p>\n\n\n\n\n\n\n\n\n
URL Element<\/th>\nDescription<\/th>\n<\/tr>\n
62922<\/td>\nThis is a database id number that is visible in database URL, for example:
\nhttps:\/\/www.teamdesk.net\/secure\/db\/62922\/overview.aspx?t=516386
\nYour database will have a different number.<\/td>\n<\/tr>\n
9302F8A771AA4C2EB98A13AA35923400<\/td>\nThis is the REST API<\/a> authorization token generated by the system. In your database you will use a different token.<\/td>\n<\/tr>\n
Type%20A%20Part<\/td>\nThis is the table name \u201cType A Part\u201d, please note that spaces are replaced by \u201c%20\u201d.<\/td>\n<\/tr>\n
Document%20A<\/td>\nThis is the document name. In this example the document name is \u201cDocument A\u201d. So, the space is replaced by \u201c%20\u201d.<\/td>\n<\/tr>\n
[RecordIdA]<\/td>\nThis is the name of the summary column described above.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

You need this formula-URL column to generate a URL referring to the document that belongs to a \u201cType A Part\u201d record if the QR code of this record was scanned.<\/p>\n

Also,\u00a0 you should build a similar URL for the \u201cDocumentB\u201d formula-URL column.<\/p>\n

\"FormulaURL<\/a><\/p>\n

4.Form Behavior<\/h3>\n

When all the columns are added, you need to adjust the form behavior<\/a> in the \u201cSearch Requests\u201d table. First, set the \u201cDocument\u201d column as \u2018Readonly\u2019 on the Default Form. After that add the RecordId()<>”0″ criteria and set the \u2018Readonly\u2019 option for the \u201cQR Code\u201d column in this criterion.<\/p>\n

\"Form<\/a><\/p>\n

5.Mobile Device Record Create action<\/h3>\n

Now you need to add a mobile action allowing code scanning and searching. Let\u2019s set it up in the \u201cSearch Requests\u201d table and name this action \u201cSearch for a record\u201d.<\/p>\n

\"Record<\/a><\/p>\n

The \u201cSearch for a record\u201d mobile device \u2018record create\u2019 action<\/a> allows QR code scanning and inserting this code into the \u201cQR Code\u201d column. As a result, a new record is added to the \u201cSearch Requests\u201d table.<\/p>\n

6.Triggers with Mobile Device Record Update actions<\/h3>\n

The next step is to create triggers<\/a> with mobile device record update actions. In our example you need to create two similar Record Change Triggers<\/a>. Let\u2019s name these triggers \u201cIf QRCodeA\u201d and \u201cIf QRCodeB\u201d respectively.<\/p>\n

\"QR<\/a><\/p>\n

Moreover, each trigger should include two actions:<\/p>\n

\"Trigger<\/a><\/p>\n

The first action of the \u2018Update Record<\/a>\u2019 type is called \u201cGenerate DocumentA\u201d.
\nThis action contains one assignment.<\/p>\n

\"Assignments<\/a><\/p>\n

The second action of the \u2018Mobile Device Update Record<\/a>\u2019 type is called \u201cSearch Result\u201d.<\/p>\n

\"Search<\/a><\/p>\n

Please note that this mobile device update record action is used in both triggers.<\/p>\n

Now you can add the \u201cIf QRCodeB\u201d trigger to the \u201cSearch Request\u201d table. The setup is similar to the \u201cIf QRCodeA\u201d trigger setup, but you need to use the \u201cRecordIdB\u201d column in the filter:<\/p>\n

\"Trigger<\/a><\/p>\n

and the \u201cDocumentB\u201d column in the \u201cGenerate DocumentB\u201d action:<\/p>\n

\"Assignmetns<\/a><\/p>\n

After that you can add the existing \u201cSearch Result\u201d mobile device update record action to the \u201cIf QRCodeB\u201d trigger.<\/p>\n

As the result, you can see the following actions<\/a> created in the \u201cSearch Requests\u201d table:<\/p>\n

\"Mobile<\/a><\/p>\n

The database adjustment is done.<\/p>\n

How to link QR scanner to database?<\/h2>\n

1.Connection of mobile device to database account<\/h3>\n

To connect your mobile device, such as smartphone, to your account<\/a>, open the \u201cPersonal information\u201d page and click on the \u201cNew\u201d button in the \u201cDevices\u201d section.<\/p>\n

\"Add<\/a><\/p>\n

Then you will see a QR code of your user account.<\/p>\n

\"DB<\/a><\/p>\n

As the next step you should download TeamDesk Mobile Client App<\/a> and click on the \u201cScan QR Code\u201d button.<\/p>\n

\"Scan<\/a><\/p>\n

As a result, you\u2019ll see the \u201cInbox\u201d screen.<\/p>\n

\"Inbox\"<\/a><\/p>\n

2.Mobile Device Record Create Action<\/h3>\n

To enable QR code scanning you need to activate the \u201cSearch for a record\u201d action.
\nClick on the menu icon to open the menu:<\/p>\n

\"Mobile<\/a><\/p>\n

Choose the \u201cSearch for a record\u201d link in the menu to activate a mobile \u2018record create\u2019 action.<\/p>\n

As you know, the \u201cSearch for a record\u201d action allows to fill in the \u201cQR Code\u201d column value when you scan a particular part\u2019s QR code via your mobile phone.<\/p>\n

\"Mobile<\/a><\/p>\n

Click on the QR code icon to begin scanning.<\/p>\n

When the scan is complete, the text will appear in the \u201cQR Code\u201d field.<\/p>\n

Use the \u201cSend\u201d icon to submit the record.<\/p>\n

\"Submit<\/a><\/p>\n

As a result, the request will be sent to the database and a new record containing QR code value will be created in the \u201cSearch Requests\u201d table.<\/p>\n

\"Search<\/a><\/p>\n

You can see the sent requests in the \u201cSent\u201d menu option:<\/p>\n

\"Mobile<\/a><\/p>\n

3.Mobile Device Record Update action<\/h3>\n

When you enter \u201cInbox\u201d tab, you may review linked document containing Part A (or Part B) detailed description. This document is generated by either \u201cGenerate DocumentA\u201d or \u201cGenerate DocumentB\u201d record update actions and can be opened via a mobile phone with the help of the \u201cSearch Result\u201d mobile device \u2018record update\u2019 action.<\/p>\n

\u201cInbox\u201d tab is updated every 5-10 minutes automatically. You can still update \u201cInbox\u201d manually by scrolling an empty screen down to force uploading of the inbox record\/notification.<\/p>\n

\"Mobile<\/a><\/p>\n

Click on the notification to open the record and review generated \u201cDocument A\u201d.<\/p>\n

As you can see, the QR code you scanned is \u2018Type A Part\u2019 QR code.<\/p>\n

\"Mobile<\/a><\/p>\n

Click on this PDF document to open it and review the part-related details:<\/p>\n

\"QR<\/a><\/p>\n

Here you can review all data related to the \u201cType A Part\u201d record linked to the scanned QR code.<\/p>\n","protected":false},"excerpt":{"rendered":"

How to build the QR Code Scanner application allowing users to scan QR codes via mobile devices and then search database tables for records containing such QR codes.<\/p>\n","protected":false},"author":3,"featured_media":1799,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[164,163,162,165],"class_list":["post-1760","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips-tricks","tag-qr-code-scanner","tag-scan-code","tag-scan-qr","tag-scan-to-database"],"yoast_head":"\nLink a QR code scanner to your database - TeamDesk Blog<\/title>\n<meta name=\"description\" content=\"QR Code Scanner database demonstrates how users can scan QR codes via mobile devices and then search database records containing QR codes.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Link a QR code scanner to your database - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"QR Code Scanner database demonstrates how users can scan QR codes via mobile devices and then search database records containing QR codes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-12T14:32:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-15T09:09:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2019\/02\/QR-Code-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1181\" \/>\n\t<meta property=\"og:image:height\" content=\"779\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Mila\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mila\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/\"},\"author\":{\"name\":\"Mila\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\"},\"headline\":\"Link a QR code scanner to your database\",\"datePublished\":\"2019-02-12T14:32:29+00:00\",\"dateModified\":\"2021-09-15T09:09:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/\"},\"wordCount\":1296,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/QR-Code-3.png\",\"keywords\":[\"qr code scanner\",\"scan code\",\"scan QR\",\"scan to database\"],\"articleSection\":[\"Tips & Tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/\",\"name\":\"Link a QR code scanner to your database - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/QR-Code-3.png\",\"datePublished\":\"2019-02-12T14:32:29+00:00\",\"dateModified\":\"2021-09-15T09:09:09+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\"},\"description\":\"QR Code Scanner database demonstrates how users can scan QR codes via mobile devices and then search database records containing QR codes.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/QR-Code-3.png\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/QR-Code-3.png\",\"width\":1181,\"height\":779,\"caption\":\"QR Code Scanner\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/link-qr-code-scanner-to-your-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Link a QR code scanner to your database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\",\"name\":\"Mila\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"caption\":\"Mila\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/mila\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Link a QR code scanner to your database - TeamDesk Blog","description":"QR Code Scanner database demonstrates how users can scan QR codes via mobile devices and then search database records containing QR codes.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/","og_locale":"en_US","og_type":"article","og_title":"Link a QR code scanner to your database - TeamDesk Blog","og_description":"QR Code Scanner database demonstrates how users can scan QR codes via mobile devices and then search database records containing QR codes.","og_url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/","og_site_name":"TeamDesk Blog","article_published_time":"2019-02-12T14:32:29+00:00","article_modified_time":"2021-09-15T09:09:09+00:00","og_image":[{"width":1181,"height":779,"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2019\/02\/QR-Code-3.png","type":"image\/png"}],"author":"Mila","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mila","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/"},"author":{"name":"Mila","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e"},"headline":"Link a QR code scanner to your database","datePublished":"2019-02-12T14:32:29+00:00","dateModified":"2021-09-15T09:09:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/"},"wordCount":1296,"commentCount":0,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2019\/02\/QR-Code-3.png","keywords":["qr code scanner","scan code","scan QR","scan to database"],"articleSection":["Tips & Tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/","url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/","name":"Link a QR code scanner to your database - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2019\/02\/QR-Code-3.png","datePublished":"2019-02-12T14:32:29+00:00","dateModified":"2021-09-15T09:09:09+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e"},"description":"QR Code Scanner database demonstrates how users can scan QR codes via mobile devices and then search database records containing QR codes.","breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2019\/02\/QR-Code-3.png","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2019\/02\/QR-Code-3.png","width":1181,"height":779,"caption":"QR Code Scanner"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/link-qr-code-scanner-to-your-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Link a QR code scanner to your database"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e","name":"Mila","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","caption":"Mila"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/mila\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=1760"}],"version-history":[{"count":24,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1760\/revisions"}],"predecessor-version":[{"id":2477,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1760\/revisions\/2477"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media\/1799"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=1760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=1760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=1760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}