It would be awesome if YAMM could...

Move the data about date email opened into a separate column

Currently you have to click each email opened message to see when it was open and the number of times opened. It would improve efficiency if that information was in another column.

109 votes
Vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

4 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    For those landing on this page looking for an immediate solution:

    function getNotesInMergeStatus() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var source = ss.getSheetByName('Merge');
    var values = source.getRange("I2:I");
    var notes = values.getNotes();

    var target = source.getRange("J2:J");
    target.setValues(notes);
    }

  • Lawrence commented  ·   ·  Flag as inappropriate

    I send a pdf file to my clients showing the open results and statistics. Having the number of times opened and dates would be even more impressive. Yes, please break out this data into separate columns.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Can someone write a quick javascript function for this? I just don't know how to read the individual "notes/message" for each cell iteratively. If someone could show me this, I would could certainly help write the function.

Feature requests

Feedback and Knowledge Base