Free Glide app for Honey product sales at market stall, YouTube thumbnails & Glide email notifications

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

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.

Here is link to the app: https://beefreshfarms.glideapp.io/

Here is link to the spreadsheet that I used to build the app: https://docs.google.com/spreadsheets/d/1ZWJHKBqZFrCiAsgSkD2Jh8UaZcPVkFrio1E5oMAW_Co/edit?usp=sharing

YouTube thumbnails

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’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:

A good, simple video that is easy to follow, thank you.

The Canva online tool I had come across and tinkered with before, but had’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.

The Product app

Below my video on developing the app. A bit of a repeat at one point.

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.

See: https://www.google.com/maps/d/edit?mid=1KfI_2vUv5ViWvJQAY-QtBj-vsa9lS00E&ll=-41.103186565541506%2C174.89096025000003&z=11

This map initially didn’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’ve built them and not presuming they’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 (I wonder if it would work if I just moved the tab with map references to the front?– YES IT DOES). So another feature to add to the App. Cool. 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.

Below is a video on how I set this up:

Glide features

but it did bring to my attention a few things I’d like to play with in Glide.

Calendars. 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’d just set that up rather than building an app in m opinion.

I saw someone made a cool app for NFL which allowed people to vote using Google forms. 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 Email notification in Google Sheets if an element has changed.

Google sheets Script for email notification distraction

I stopped this post to implement that idea, the video is here:

I followed this article:Use Google Sheets to Send an Email Based on Cell Value to create the script in Google Sheets.

The app is here: https://defects-list.glideapp.io/

The sheets are here: https://docs.google.com/spreadsheets/d/1lKW5JFdX41mao2H-uVhxvVTR1NmplhPYpqkK_vxv-CY/edit#gid=1010704303

The google sheets script is here, based on the spreadsheet link above

//https://www.groovypost.com/howto/google-sheets-send-email-based-on-cell-value/
//the above link is code for this page

function FaultFixed() {
// Fetch the Condition
  var IssueStateRange1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Issue").getRange("J2"); 
  // reference to item that needs to be fixed
  var IssueStateRange2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Issue").getRange("A2"); 
    var IssueStateRange3= SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Issue").getRange("B2"); 
   var IssueStateRange4= SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Issue").getRange("R2"); 
    
  var IssueState = IssueStateRange1.getValue();
   var IssueItemNo= IssueStateRange2.getValue();
  var IssueItemTitle = IssueStateRange3.getValue();
  var IssueItemCo = IssueStateRange4.getValue();
  //set a ui interface
 // var ui = SpreadsheetApp.getUi(); 
 
   if (IssueState="TRUE"){
    // Fetch the email address of Project manager
    var emailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Issue").getRange("Q2"); 
    var emailAddress = emailRange.getValues();
  
    // Send Alert Email to the project manager.
    var message = 'Item Code  '+ IssueItemNo + '-  Item Issue  ' + IssueItemTitle + '   has now been Fixed by ' + IssueItemCo ; // Second column  + today()//  
    var subject = 'Defects list item HAS NOW BEEN FIXED  ' + IssueItemNo +"   -"+ IssueItemTitle;//    ------
    MailApp.sendEmail(emailAddress, subject, message);
    }
}
////this is to test email function working-
//function FetchEmail() {
//// Fetch the email address
//var emailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Issue").getRange("Q2"); 
//var emailAddress = emailRange.getValues();
//// Send Alert Email.
//var message = 'This is your Alert email!'; // Second column
//var subject = 'Your Google Spreadsheet Alert';
//MailApp.sendEmail(emailAddress, subject, message);
//}

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.

End comment

This became a bit of a hap-hazard post. I started out with one topic and drifted to other issues that I’d been thinking about and decided to test.

One interesting thing was the mapping, I set up a new Google My Map and found older ones from 2016 which I’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.

So, I’m pleased with the map link, being able to put multiple pins on the same map.

I’m also please with the process for creating a video thumbnail. A bit more learning for YouTube videos.

I’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.

Add a Comment