The following Google Apps Script is my first look at accessing an API and handling the data that comes back. I am using Numbers API to return a random maths fact and append it to a Google Sheet.
API Url: http://numbersapi.com/random/math
We use the 'UrlFetchApp' to then call the API and 'getContentText' to store the returned data. From there we can simple 'appendRow' in the spreadsheet to build up a list each time we run the function.
I'm Phil Bainbridge and I aim to share my experiences of IT projects I've worked on as I continue to learn and develop, through this blog. My main coding language is Google Apps Script (with JavaScript), but there is also some: PowerShell, HTML, SQL and jQuery.
Tuesday, 25 February 2020
Tuesday, 18 February 2020
Bulk create test folders/files in Google Drive
The following Google Apps Script is designed to bulk create a set number of Google Drive folder/files as quickly as possible. Its purpose was to support a bigger project I was working on with bulk moving folders/files from My Drive to Shared Drive.
The script makes use of 4 'loops' with the option to define how many folders/files you want to create at each level. There is an initial top row of folders each with files, then a row of sub-folders under this each with files too.
| Screenshot of example folder structure in Google Drive |
The script makes use of 4 'loops' with the option to define how many folders/files you want to create at each level. There is an initial top row of folders each with files, then a row of sub-folders under this each with files too.
Tuesday, 11 February 2020
Create a slide down panel in jQuery
The following jQuery code creates a clickable area that then slides down a panel with further information displayed.
The 2 panels are created with different 'div' tags so that a 'click' method can be assigned to the first (topbar) which then initiates the 'slideDown' method on the second (panel). Some CSS styling is applied for 'padding', etc.
| Screenshot of side panel with extra content |
Tuesday, 4 February 2020
Create buttons to hide/show text in jQuery
The following jQuery code is designed to have 2 buttons - 1 which hides the webpage text and the other which shows it again.
Each button has its own 'id' name depending on which task it will perform: show or hide. We use the '#id Selector' to target each id and use the 'click' method to either 'show/hide' all elements within a paragraph (<p>) tag.
| Screenshot of show/hide buttons |
Subscribe to:
Comments (Atom)