Created
October 12, 2017 11:04
-
-
Save benseven/f2cd8e6fa2f6c78d4dd56ff8ad38e2bb to your computer and use it in GitHub Desktop.
Create Trello Card from Google Forms using Google Apps Script
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Fire off this function in the script editor to enable. | |
function init() { | |
var triggers = ScriptApp.getProjectTriggers(); | |
var form = FormApp.getActiveForm(); | |
// Delete all triggers before making a brand new one. | |
for(var i in triggers) { | |
ScriptApp.deleteTrigger(triggers[i]); | |
} | |
// Set up a new trigger | |
ScriptApp.newTrigger('submitToTrello') | |
.forForm(form) | |
.onFormSubmit() | |
.create(); | |
Logger.log('Successful creation of new submitToTrello trigger.'); | |
} | |
function submitToTrello(e) { | |
var form = FormApp.getActiveForm(); | |
var latestItemResponses = form.getResponses().pop().getItemResponses(); | |
if (MailApp.getRemainingDailyQuota() > 0) { | |
// Trello email address goes here | |
var email = "TRELLO BOARD EMAIL"; | |
// Subject line will be the title of the event on Trello card | |
// Array value is in the order of the from from top-down | |
var subject = latestItemResponses[0].getResponse(); | |
// Intial empty body | |
var body = ""; | |
// Loop through recent responses and format them into string | |
latestItemResponses.forEach(function (value, index, array) { | |
var formatted = Utilities.formatString("**%s**\n %s\n\n", value.getItem().getTitle(), value.getResponse()); | |
body = body.concat(formatted); | |
}); | |
MailApp.sendEmail(email, subject, body); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment