Просто заметки: How to send email only when a row is approved/declined by the user?

 //Script which I am using now
 
var APPROVAL_SPREADSHEET_URL = "https://spreadsheets.google.com/ccc?key=0Aoa2uFiBR26ndE1FZVZSN0QtaXpnNmY2RkpjRG1tUXc&hl=en&pli=1#gid=0";
 var STATE_APPROVED = "APPROVED";
 
var STATE_DECLINED = "DECLINED";
 
var COLUMN_STATE = 12;
 
function onFormSubmit() {
 
    var ss = SpreadsheetApp.getActiveSpreadsheet();
 
    var sheet = ss.getSheets()[0];
 
    var data = getRowsData(sheet);
 
    for (var i = 0; i < data.length; ++i)
     {
         var row = data[i];
 
        row.rowNumber = i + 2;
         Browser.msgBox(row.rowNumber);
 
        sendApprovalResults(row);
         sheet.getRange(row.rowNumber, COLUMN_STATE).setValue(row.status);
     }
 }
 
function onEdit(event)
 {
 

    var ss = SpreadsheetApp.getActiveSpreadsheet();
 
    var r = SpreadsheetApp.getActiveRange();
 
    r.setComment("Last modified" + (new Date()));
 
}
 
function sendApprovalResults(row) {
 
    var approvedOrRejected = (row.status == "Approved") ? "approved" : "declined";
 
    var message = "<HTML><BODY>"
 
        + "<P>Owner has " + approvedOrRejected +" your Request."
 
        + "</HTML></BODY>";
 
    if (row.status == "Approved") {
 
        row.state = STATE_APPROVED;
 
    } else {
 
        Browser.msgBox(row.emailAddress);
 
        MailApp.sendEmail(row.emailAddress, "Fast Assembler Supplier Approval Results", "", {htmlBody: message});
 
        row.state = STATE_DECLINED;
 
    }
 }
 

function getRowsData(sheet, range, columnHeadersRowIndex) {
 
    var headersIndex = columnHeadersRowIndex || range ? range.getRowIndex() - 1 : 1;
 
    var dataRange = range ||
     sheet.getRange(headersIndex + 1, 1, sheet.getMaxRows() - headersIndex,   sheet.getMaxColumns());
 
    var numColumns = dataRange.getEndColumn() - dataRange.getColumn() + 1;
 
    var headersRange = sheet.getRange(headersIndex, dataRange.getColumn(), 1, numColumns);
 

    var headers = headersRange.getValues()[0];
 
    return getObjects(dataRange.getValues(), normalizeHeaders(headers));
 
}
 
function getObjects(data, keys) {
 
    var objects = [];
 
    for (var i = 0; i < data.length; ++i) {
 
        var object = {};
 
        var hasData = false;
 
        for (var j = 0; j < data[i].length; ++j) {
 
            var cellData = data[i][j];
 
            if (isCellEmpty(cellData)) 
             {
                 continue;
             }
 
            object[keys[j]] = cellData;
 
            hasData = true;
         }
 
        if (hasData) {
 
            objects.push(object);
         }
     }
     return objects;
 }
 
// Returns an Array of normalized Strings.
 // Empty Strings are returned for all Strings that could not be successfully normalized.
 // Arguments:
     //   - headers: Array of Strings to normalize
 
function normalizeHeaders(headers) {
 
    var keys = [];
 
    for (var i = 0; i < headers.length; ++i) {
 
        keys.push(normalizeHeader(headers[i]));
 
    }
     return keys;
 }
 
// Normalizes a string, by removing all alphanumeric characters and using mixed case
 // to separate words. The output will always start with a lower case letter.
 // This function is designed to produce JavaScript object property names.
 // Arguments:
 //   - header: string to normalize
 // Examples:
 //   "First Name" -> "firstName"
 //   "Market Cap (millions) -> "marketCapMillions
 //   "1 number at the beginning is ignored" -> "numberAtTheBeginningIsIgnored"
 
function normalizeHeader(header) {
 
    var key = "";
 
    var upperCase = false;
 
    for (var i = 0; i < header.length; ++i) {
 
        var letter = header[i];
 
        if (letter == " " && key.length > 0) {
 
            upperCase = true;
 
            continue;
         }
 
        if (!isAlnum(letter)) {
 
            continue;
         }
         if (key.length == 0 && isDigit(letter)) {
 
            continue; // first character must be a letter
         }
 
        if (upperCase) {
 
            upperCase = false;
 
            key += letter.toUpperCase();
 
        } else {
 
            key += letter.toLowerCase();
         }
     }
 
    return key;
 }
 
// Returns true if the cell where cellData was read from is empty.
 // Arguments:
 //   - cellData: string
 
function isCellEmpty(cellData) {
 
    return typeof(cellData) == "string" && cellData == "";
 }
 
// Returns true if the character char is alphabetical, false otherwise.
 
function isAlnum(char) {
 
    return char >= 'A' && char <= 'Z' ||
     char >= 'a' && char <= 'z' ||
     isDigit(char);
 }
 
// Returns true if the character char is a digit, false otherwise.
 
function isDigit(char) {
 
    return char >= '0' && char <= '9';
 }
Просто заметки

суббота, 22 января 2011 г.

How to send email only when a row is approved/declined by the user?

Комментариев нет:

Отправить комментарий

суббота, 22 января 2011 г.

How to send email only when a row is approved/declined by the user?

Комментариев нет:

Отправить комментарий

суббота, 22 января 2011 г.
