{"id":6397,"date":"2020-06-12T17:31:37","date_gmt":"2020-06-12T17:31:37","guid":{"rendered":"https:\/\/max-drake.cc\/?p=6397"},"modified":"2020-06-12T17:31:37","modified_gmt":"2020-06-12T17:31:37","slug":"mobile-qr-scanner-to-google-sheets","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=6397","title":{"rendered":"Mobile QR scanner to Google Sheets"},"content":{"rendered":"\n<p>I was reading an article today &#8220;&#8216;<strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.stuff.co.nz\/business\/121771629\/clunky-government-covid-app-used-minimally-in-marlborough-businesses-say\" target=\"_blank\">Clunky&#8217; government covid app used &#8216;minimally&#8217; in Marlborough, businesses say<\/a><\/strong>&#8220;<\/p>\n\n\n\n<p>I thought about building one with GlideApps. Then I thought about it some more and realised that GlideApps does not actually access any of your Phones features, its only a web page. <\/p>\n\n\n\n<p>Then I saw the video below and thought, App Inventor, yes that is the way to go. And storing the data on a spreadsheet is excellent. <\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Develop QR code Scanner Android App using MIT AppInventor |Google Sheet | App Script|\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/WuH-GBynC8U?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Alos it gives <strong><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/drive\/folders\/0B___GhMLUVtORDV0QXpxYzhOZkE\" target=\"_blank\">links to the templates for setting up the app<\/a><\/strong>, so thats pretty cool too.  The only thing is that this is for Androids only, so for iPhone users a different app would need to be developed. <\/p>\n\n\n\n<p>This is still a fun project to explore.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">The Government Covid Tracking App. <\/h4>\n\n\n\n<p>I  zoomed in on a couple of photos in the article and scanned the QR codes:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"702\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--1024x702.jpg\" alt=\"\" class=\"wp-image-6398 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--1024x702.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--300x206.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--768x526.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--50x34.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--73x50.jpg 73w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--100x69.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--146x100.jpg 146w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--934x640.jpg 934w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--640x439.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_--1121x768.jpg 1121w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-14_07_38-Clunky-government-covid-app-used-minimally-in-Marlborough-businesses-say-_-.jpg 1389w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/702;\" \/><\/figure>\n\n\n\n<p>The right one, the government one, requires you to download their app and create an account and login initially and give your details. When scanning the code  it gives you basic information on the screen (with their app)  and then that dissapears. Actually stored on your phone in &#8220;Check in History&#8221; location in the app. The location, date and time. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"512\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-512x1024.jpg\" alt=\"\" class=\"wp-image-6399 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-512x1024.jpg 512w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-150x300.jpg 150w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-768x1536.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-1024x2048.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-50x100.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-25x50.jpg 25w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-100x200.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-320x640.jpg 320w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-640x1280.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-384x768.jpg 384w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-540x1080.jpg 540w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-140941-scaled.jpg 800w\" data-sizes=\"(max-width: 512px) 100vw, 512px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 512px; --smush-placeholder-aspect-ratio: 512\/1024;\" \/><\/figure>\n\n\n\n<p>On another page you are supposed to fill in your details. There is a location  called &#8220;Check-in history&#8221; that shows you where you have used the app, it stores the information on your phone. Also you can choose to have an alert message (switch) as to whether you get advised if you&#8217;ve been to a place someone who has been identified as having Covid has visited that place too (I presume at the same timeframe as yourself). <\/p>\n\n\n\n<p>If you scan on a normal scanner Zxing Scanner) you get:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"512\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-1024x512.jpg\" alt=\"\" class=\"wp-image-6400 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-1024x512.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-300x150.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-768x384.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-1536x768.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-2048x1024.jpg 2048w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-50x25.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-100x50.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-200x100.jpg 200w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-1280x640.jpg 1280w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-640x320.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-1920x960.jpg 1920w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141012-scaled.jpg 1600w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/512;\" \/><\/figure>\n\n\n\n<p>Which is just gibberish. Thuis could just be a primary key for a DataBase with all the rest of the information relating to that information in a table<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">I&#8217;m here app (left QR code in first image above)<\/h4>\n\n\n\n<p>The 2nd app you just scan with a normal scanner <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"512\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-1024x512.jpg\" alt=\"\" class=\"wp-image-6401 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-1024x512.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-300x150.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-768x384.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-1536x768.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-2048x1024.jpg 2048w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-50x25.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-100x50.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-200x100.jpg 200w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-1280x640.jpg 1280w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-640x320.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-1920x960.jpg 1920w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141026-scaled.jpg 1600w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/512;\" \/><\/figure>\n\n\n\n<p>On that you open a web page and have to fill in data:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"512\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-512x1024.jpg\" alt=\"\" class=\"wp-image-6402 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-512x1024.jpg 512w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-150x300.jpg 150w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-768x1536.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-1024x2048.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-50x100.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-25x50.jpg 25w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-100x200.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-320x640.jpg 320w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-640x1280.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-384x768.jpg 384w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-540x1080.jpg 540w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141116-scaled.jpg 800w\" data-sizes=\"(max-width: 512px) 100vw, 512px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 512px; --smush-placeholder-aspect-ratio: 512\/1024;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"512\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-512x1024.jpg\" alt=\"\" class=\"wp-image-6403 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-512x1024.jpg 512w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-150x300.jpg 150w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-768x1536.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-1024x2048.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-50x100.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-25x50.jpg 25w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-100x200.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-320x640.jpg 320w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-640x1280.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-384x768.jpg 384w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-540x1080.jpg 540w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-141123-scaled.jpg 800w\" data-sizes=\"(max-width: 512px) 100vw, 512px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 512px; --smush-placeholder-aspect-ratio: 512\/1024;\" \/><\/figure>\n\n\n\n<p>You fill in basic info and then have to read declaration and flick switch (I accept) <em>Confirming you have no known signs of illness<\/em>. !!!! Whats that supposed to do? Doesn&#8217;t ask if one of the other attendees is sick or not!!!! Not a well thought out statement, and something that would annoy me. Also you have screen with info, no time or date on it (<em>apart from what is on your Mobile screen with Screenshot)<\/em>. <\/p>\n\n\n\n<p>I see these ask for more info than if you just signed in manually at a shop\/restaurant. Since the information gets sucked away and you have no record of the visit, I can&#8217;t see myself using this app either. Also you have to fill your same information in each time, it would be good if it can remember the details to save you repeating the filling in (maybe via cookies?). <\/p>\n\n\n\n<p>  They are not transparent. The 2nd one is more transparent than the government one is as the QR code is not that complex, whereas the Govt QR code is far more granular and opaque and also is taking extra information off your phone as well. <\/p>\n\n\n\n<p>Of the two I think the Government one is more sensible as you have a record\/log of where you have used it. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">QR Coder with App Inventor with code (video above)<\/h3>\n\n\n\n<p>Great video, takes you step by step through the procedure and voila, it all works fine. I used<a href=\"https:\/\/www.the-qrcode-generator.com\/\"> <\/a><strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.the-qrcode-generator.com\/\" target=\"_blank\">QR Code Generator <\/a><\/strong> to create QR codes to practice with, one of them was V Card &amp; it put all the data into one cell into Google sheet. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"600\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-1024x600.jpg\" alt=\"\" class=\"wp-image-6405 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-1024x600.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-300x176.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-768x450.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-1536x901.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-50x29.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-85x50.jpg 85w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-100x59.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-171x100.jpg 171w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-1092x640.jpg 1092w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-640x375.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-1310x768.jpg 1310w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-14_54_50-QR-Code-Generator-scaled.jpg 1600w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/600;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"411\" height=\"531\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-18_28_50-QR-Scanner-Google-Sheets.jpg\" alt=\"\" class=\"wp-image-6406 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-18_28_50-QR-Scanner-Google-Sheets.jpg 411w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-18_28_50-QR-Scanner-Google-Sheets-232x300.jpg 232w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-18_28_50-QR-Scanner-Google-Sheets-50x65.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-18_28_50-QR-Scanner-Google-Sheets-39x50.jpg 39w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-18_28_50-QR-Scanner-Google-Sheets-100x129.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-12-18_28_50-QR-Scanner-Google-Sheets-77x100.jpg 77w\" data-sizes=\"(max-width: 411px) 100vw, 411px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 411px; --smush-placeholder-aspect-ratio: 411\/531;\" \/><\/figure>\n\n\n\n<p>So, as there is only a single cell for the QR code to drop data in, the exercise worked well. I could scan the Govt QR code and get the string text for that location and keep it and it also has a timestamp for the time you visited. I tried this and it worked fine, unfortunately the string does not give the name of the shop, so its gibberish, but it works. More private and you only need to share if you want. <\/p>\n\n\n\n<p>I didn&#8217;t take this any further, I just wanted to test it as a process, and very happy with the results. A great video and tutorial , well done. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">End comment<\/h3>\n\n\n\n<p>I&#8217;m very happy with the result of this tutorial and it has got me thinking about things. <\/p>\n\n\n\n<p><strong>First<\/strong>. It was good to explore the apps that are being used to track Covid and the methods they use. <\/p>\n\n\n\n<p><strong>Second<\/strong>. It was good to play with App Inventor again, I&#8217;d been playing with it back in 2016 &amp; 17 and it is about time to give it another visit.<\/p>\n\n\n\n<p><strong>Thirdly.<\/strong> Its got me t&#8217;inking. When I got a query from someone about using phones to track paroled people to get them out of prisons due to covid, it showed the limitations of GlideApp as it couldn&#8217;t access the Phone&#8217;s sensor information. But App Inventor will.  And since App Inventor can send\/retrieve information to a Google Sheet and GlideApps can send\/retrieve information to a Google Sheet there is no reason why you can&#8217;t combine the 2 apps to get the best leverage from both. AS LONG AS THEY CAN BOTH CONNECT TO THE SAME GOOGLE SHEET.<\/p>\n\n\n\n<p><strong>Fourthly.<\/strong> This is worth following up as an exercise in Mobile apps using 2 distinct apps for different things. App Inventor to use the phones sensors (only Android) and glide to display, map, manipulate as required as its interface is easy to setup and use. <\/p>\n\n\n\n<p><strong>Fifthly?<\/strong> (Filthy?) These are 2 different types of apps, one you have to load onto your phone, the other is a web link. <\/p>\n\n\n\n<p>Another article will explore these ideas. You can use your phone GPS &amp; Scanner, maybe other sensors too to push info to a google sheet , then retrieve the info via GlideApps. I need to explore App Inventor more to see what it can access.  There seem to be a few, but I&#8217;m not sure a lot of these would be on the average phone, there is also the Camera as well. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"274\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-15_30_00-MIT-App-Inventor-274x1024.jpg\" alt=\"\" class=\"wp-image-6407 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-15_30_00-MIT-App-Inventor-274x1024.jpg 274w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-15_30_00-MIT-App-Inventor-80x300.jpg 80w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-15_30_00-MIT-App-Inventor-50x187.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-15_30_00-MIT-App-Inventor-13x50.jpg 13w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-15_30_00-MIT-App-Inventor-100x374.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-15_30_00-MIT-App-Inventor-27x100.jpg 27w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-15_30_00-MIT-App-Inventor-171x640.jpg 171w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-15_30_00-MIT-App-Inventor-289x1080.jpg 289w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/2020-06-13-15_30_00-MIT-App-Inventor.jpg 316w\" data-sizes=\"(max-width: 274px) 100vw, 274px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 274px; --smush-placeholder-aspect-ratio: 274\/1024;\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I was reading an article today &#8220;&#8216;Clunky&#8217; government covid app used &#8216;minimally&#8217; in Marlborough, businesses say&#8220; I thought about building one with GlideApps. Then I thought about it some more and realised that GlideApps does not actually access any of your Phones features, its only a web page. Then I saw the video below and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6404,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,1,43,42],"tags":[],"class_list":["post-6397","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-barcoding-building-information","category-general","category-javascript","category-productivity"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-182729.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/06\/Screenshot_20200612-182729.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/6397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6397"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/6397\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/6404"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}