{"id":5548,"date":"2019-05-02T19:07:35","date_gmt":"2019-05-02T19:07:35","guid":{"rendered":"https:\/\/max-drake.cc\/?p=5548"},"modified":"2019-05-03T11:48:34","modified_gmt":"2019-05-03T11:48:34","slug":"free-glide-app-for-honey-product-sales-at-market-stall-youtube-thumbnails-glide-email-notifications","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=5548","title":{"rendered":"Free Glide app for Honey product sales at market stall, YouTube thumbnails &#038; Glide email notifications"},"content":{"rendered":"\n<p>Developing and exploring the GlideApp into different areas has been fun and interesting. This particular app was for someone i worked with who also sells honey with a group of people, and one location is at an outdoor  market stall. I thought it would be handy for people who were not prepared to buy immediately to have a way of looking at the product further, so built an app. <\/p>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\">Here is link to the app:  <strong>https:\/\/beefreshfarms.glideapp.io\/ <\/strong><\/p>\n\n\n\n<p class=\"has-background has-light-green-cyan-background-color\">Here is link to the spreadsheet that I used to build the app:  <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/17fiKW97IjzO86BOe4D-htO_UJgnBv2WeuzGrGpjdbrY\/edit#gid=212771587\"><\/a><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1lKW5JFdX41mao2H-uVhxvVTR1NmplhPYpqkK_vxv-CY\/edit#gid=1010704303\">h<\/a><strong><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/17fiKW97IjzO86BOe4D-htO_UJgnBv2WeuzGrGpjdbrY\/edit#gid=212771587\"><\/a><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1ZWJHKBqZFrCiAsgSkD2Jh8UaZcPVkFrio1E5oMAW_Co\/edit?usp=sharing\">ttps:\/\/docs.google.com\/spreadsheets\/d\/1ZWJHKBqZFrCiAsgSkD2Jh8UaZcPVkFrio1E5oMAW_Co\/edit?usp=sharing <\/a><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">YouTube thumbnails <\/h2>\n\n\n\n<p>As well as doing the app, I did a video on it and uploaded it to You Tube. When you do that, it gives you 3 screenshots from your video as a front image, or else you can upload your own thumbnail. In this particular case all 3 images were rubbish, so I thought I&#8217;d bite the bullet and see how to create my own thumbnail for the video.  I followed this chaps video to make one with canva:<\/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=\"How to Make a YouTube Custom Thumbnail Tutorial \u2014 Quick and Easy\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/8YbZuaBP9B8?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>A good, simple video that is easy to follow,  thank you. <\/p>\n\n\n\n<p>The Canva online tool I had come across and tinkered with before, but had&#8217;nt a particular use for it at the time. A bit in your face with trying to get you to go Pro and pay but the free version is handy to use instead of GIMP which can get a bit full on when you are trying just to do something simple. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The Product app<\/h3>\n\n\n\n<p>Below my video on developing the app. A bit of a repeat at one point. <\/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=\"Free Glide mobile app for honey sales products\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/TI9qlGKLEVc?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>The app was pretty straightforward, but I was intrigued  about making a specific map for Wellington region. I ended up creating a NEW GOOGLE MY MAPS (start from Google Drive and select new ) of the Wellington Region shop\/market locations. <\/p>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\">See: <strong>https:\/\/www.google.com\/maps\/d\/edit?mid=1KfI_2vUv5ViWvJQAY-QtBj-vsa9lS00E&amp;ll=-41.103186565541506%2C174.89096025000003&amp;z=11<\/strong><\/p>\n\n\n\n<p>This map initially didn&#8217;t open in the app as I had not given the correct permissions in the share. It was set to private. A good lesson in checking the apps features after you&#8217;ve built them and not presuming they&#8217;ll work. I also had to take a copy of the original Google Sheet and reduce it to one tab, then the Map would import the correct data (<em>I wonder if it would work if I just moved the tab with map references to the front?<\/em>&#8211; YES IT DOES). So another feature to add to the App. Cool. <em>I wish to acknowledge Chris Campbell and his app https:\/\/riverroadwine.glideapp.io\/ where he shows a map image with multiple locations  with a link to the actual map. Thank you Chris.<\/em><\/p>\n\n\n\n<p>Below is a video on how I set this up:<\/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=\"Free Glide with Google MyMaps for multiple locations on same map\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/MJ_VpYeJiPw?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<h2 class=\"wp-block-heading\">Glide features<\/h2>\n\n\n\n<p>but it did bring to my attention a few things I&#8217;d like to play with in Glide. <\/p>\n\n\n\n<p><strong>Calendars<\/strong>.  There is a short video on reserving a room and I thought about exploring this feature with calendar, but in fact Google Calendar does this quite adequately, so you&#8217;d just set that up rather than building an app in m opinion. <\/p>\n\n\n\n<p>I saw someone made a cool app for NFL which allowed people to vote using <strong>Google forms<\/strong>. I think it was set-up with a button, so if you wanted to vote for a particular player, it took you to that players form and submitting added your vote to the count. A limited use of the form but great use of Google form\/sheet integration. This may be an idea for reporting issues in the Property Inspection App.  Another explore for notifications for this may also be the <strong>Email notification in Google Sheets<\/strong> if an element has changed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Google sheets Script for email notification distraction<\/h3>\n\n\n\n<p> I stopped this post to implement that idea, the video is here:<\/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=\"Free GlideApp for Project Defect list with Email notification of repair- vid 2 of 4\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/Fyvo3qJz40A?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>I followed this article:<a rel=\"noreferrer noopener\" aria-label=\"Use Google Sheets to Send an Email Based on Cell Value  (opens in a new tab)\" href=\"https:\/\/www.groovypost.com\/howto\/google-sheets-send-email-based-on-cell-value\/\" target=\"_blank\">Use Google Sheets to Send an Email Based on Cell Value <\/a>to create the script in Google Sheets. <\/p>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\">The app is here: <strong>https:\/\/defects-list.glideapp.io\/<\/strong><\/p>\n\n\n\n<p class=\"has-background has-pale-cyan-blue-background-color\">The sheets are here: <strong>https:\/\/docs.google.com\/spreadsheets\/d\/1lKW5JFdX41mao2H-uVhxvVTR1NmplhPYpqkK_vxv-CY\/edit#gid=1010704303<\/strong><\/p>\n\n\n\n<p>The google sheets script is here, based on the spreadsheet link above<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/https:\/\/www.groovypost.com\/howto\/google-sheets-send-email-based-on-cell-value\/\n\/\/the above link is code for this page\n\nfunction FaultFixed() {\n\/\/ Fetch the Condition\n  var IssueStateRange1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(\"Issue\").getRange(\"J2\"); \n  \/\/ reference to item that needs to be fixed\n  var IssueStateRange2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(\"Issue\").getRange(\"A2\"); \n    var IssueStateRange3= SpreadsheetApp.getActiveSpreadsheet().getSheetByName(\"Issue\").getRange(\"B2\"); \n   var IssueStateRange4= SpreadsheetApp.getActiveSpreadsheet().getSheetByName(\"Issue\").getRange(\"R2\"); \n    \n  var IssueState = IssueStateRange1.getValue();\n   var IssueItemNo= IssueStateRange2.getValue();\n  var IssueItemTitle = IssueStateRange3.getValue();\n  var IssueItemCo = IssueStateRange4.getValue();\n  \/\/set a ui interface\n \/\/ var ui = SpreadsheetApp.getUi(); \n \n   if (IssueState=\"TRUE\"){\n    \/\/ Fetch the email address of Project manager\n    var emailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(\"Issue\").getRange(\"Q2\"); \n    var emailAddress = emailRange.getValues();\n  \n    \/\/ Send Alert Email to the project manager.\n    var message = 'Item Code  '+ IssueItemNo + '-  Item Issue  ' + IssueItemTitle + '   has now been Fixed by ' + IssueItemCo ; \/\/ Second column  + today()\/\/  \n    var subject = 'Defects list item HAS NOW BEEN FIXED  ' + IssueItemNo +\"   -\"+ IssueItemTitle;\/\/    ------\n    MailApp.sendEmail(emailAddress, subject, message);\n    }\n}\n\/\/\/\/this is to test email function working-\n\/\/function FetchEmail() {\n\/\/\/\/ Fetch the email address\n\/\/var emailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(\"Issue\").getRange(\"Q2\"); \n\/\/var emailAddress = emailRange.getValues();\n\/\/\/\/ Send Alert Email.\n\/\/var message = 'This is your Alert email!'; \/\/ Second column\n\/\/var subject = 'Your Google Spreadsheet Alert';\n\/\/MailApp.sendEmail(emailAddress, subject, message);\n\/\/}<\/code><\/pre>\n\n\n\n<p>I only took the code as far as getting a working email to the project manager, but the code can be extended. Also adding the notes column to the email for any other follow up issues that may be required would be an extra feature.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">End comment<\/h3>\n\n\n\n<p>This became a bit of a hap-hazard post. I started out with one topic and drifted to other issues that I&#8217;d been thinking about and decided to test. <\/p>\n\n\n\n<p>One interesting thing was the mapping, I set up a new Google My Map and found older ones from 2016 which I&#8217;d created and completely forgot about. I may need to do a post\/video on that later as its an easy mapping tool with far less hassle than other methods of getting a map on a page. <\/p>\n\n\n\n<p>So, I&#8217;m pleased with the map link, being able to put multiple pins on the same map.<\/p>\n\n\n\n<p>I&#8217;m also please with the process for creating a video thumbnail. A bit more learning for YouTube videos. <\/p>\n\n\n\n<p>I&#8217;m also very pleased with getting the notifications in the app. This is a Google Sheets tool that can be used to work with the Glide tool and it works quite nicely. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Developing and exploring the GlideApp into different areas has been fun and interesting. This particular app was for someone i worked with who also sells honey with a group of people, and one location is at an outdoor market stall. I thought it would be handy for people who were not prepared to buy immediately [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5552,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35,32,265,417,29],"tags":[425,428,422,433,427,53,54,430,426,423,420,421,255,429,424],"class_list":["post-5548","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-api_json","category-power-bi","category-google-docs","category-mobile","category-web","tag-adding-value","tag-am","tag-asset-management","tag-automated-email-notification-using-google-sheets-script","tag-defects-list-app","tag-facility-management","tag-facility-operations","tag-fm","tag-fm-productivity","tag-free-building-maintenance-app","tag-free-mobile-app-creator-with-no-coding","tag-glideapps","tag-google-sheets","tag-simplifying-data","tag-visualise-assets"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/05\/2019-05-03-19_06_22-Windows-Media-Player.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/05\/2019-05-03-19_06_22-Windows-Media-Player.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\/5548","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=5548"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/5548\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/5552"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}