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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    4 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      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