I'm trying to get from a time formatted Cell (hh:mm:ss) the hour value, the values can be bigger 24:00:00 for example 20000:00:00 should give 20000:  Table:     if your read the Value of E1:   var total = sheet.getRange("E1").getValue()...
I'm trying to create a function that takes in any array and transpose it so that rows turns to  columns and columns to rows.   Not sure what I've done wrong or missing but keep getting this message once the array is pass through....  TypeEr...
My script that generates a pdf document from a template within Google Drive and emails it to a recipient based on columns in a spreadsheet stopped working today due to the depreciation of DocsList. See here: https://developers.google.com/google-app...
Hello I wanted to copy a particular row from one spreadsheet to another spreadsheet using google apps script.Can anyone please help me to get the answer for this....
I've just written my first google apps scripts, ported from VBA, which formats a column of customer order information (thanks to you all of your direction).  Description:   The code identifies state codes by their - prefix, then combines the fo...
I've been going round in circles on this one... I've got a spreadsheet which holds two dates, and I need to find the number of elapsed years between the two (ie. someone's age at a given date; this is a replacement for Excel's DATEDIF...
I am trying to use Trello from a Google Spreadsheet (Google Docs) and am not sure how to import/reference/link the javascript files required to use their library.  My only other option is using their REST API directly (fine, but I'd rather use th...
How do you remove all formatting tags when calling:  GmailApp.getInboxThreads()[0].getMessages()[0].getBody()   such that the only remainder of text is that which can be read.  Formatting can be destroyed; the text in the body is only needed to be pa...
I have an error reporting beacon I created using Google Apps script and it is published to run as myself and to be accessible to "anyone, even anonymous," which should mean that X-domain requests to GAS are allowed.  However, my browsers are...
I'm trying to access the Pingdom API in Google Apps script following that example: https://developers.google.com/apps-script/external_apis  query = 'credits'; var username = 'foo'; var password = 'bar'; var credentials = u...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.