Gets all events that occur within a given time range, and that include the specified guest email in the guest list.
###Parameters:###
This Google Apps Script runs in a spreadsheet, where it prompts the user for the identity of two calendars, and a range of dates, then copies the corresponding events from one calendar to the other.
This script is incomplete, ignoring a number of event attributes. (Feel free to enhance it, if you wish!) There are also some known issues:
This is the source repository for the SheetConverter Google Apps Script library.
Libary documentation is available here.
This script is incomplete, ignoring some types of formatting. (Feel free to fork and enhance it, if you wish! Broadly applicable enhancements can be merged and the library updated) There are also some known issues:
The components involved in this workflow are:
doPost()
function to handle responses. The script must be [deployed as a Web App][1].Here is an example of such a workflow, conducting a Commuting Survey. Recipients will receive a survey email like this:
##sendAndLabel(recipient, subject, body, options, label)##
An alternative to GmailApp.sendEmail(), which applies a label to the message thread in the sender's account.
Sends an email message with optional arguments. The email can contain plain text or an HTML body. The size of the email
getAllLinks.js
getAllLinks(element) - returns array of all UrlLinks in Document
findAndReplaceLinks(searchPattern,replacement) - changes all matching links in Document
changeCase.js - Document add-in, provides case-change operations in the add-in Menu.
onOpen - installs "Change Case" menu
_changeCase - worker function to locate selected text and change text case. Case conversion is managed via callback to a function that accepts a string as a parameter and returns the converted string.
helper functions for five cases
/** | |
* Returns a non-destructive Array of elements that are not found in | |
* any of the parameter arrays. | |
* | |
* @param {...Array} var_args Arrays to compare. | |
*/ | |
Array.prototype.uniqueFrom = function() { | |
if (!arguments.length) | |
return []; | |
var a1 = this.slice(0); // Start with a copy |
/** | |
* Produce a dataTable object suitable for use with Charts, from | |
* an array of rows (such as you'd get from Range.getValues()). | |
* Assumes labels are in row 0, and the data types in row 1 are | |
* representative for the table. | |
* | |
* @param {Array} data Array of table rows | |
* | |
@ @returns {DataTable} Refer to GAS documentation | |
*/ |