JavaScript Copy - Paste value from one tab to another

[Felixalgo]

Hi,

My issuse is the following : I would like you to write a google script. This script would allow to automate the following operation. In the tab Interview Tracker, when the value 7 - Offered is selected in the column Status (Column G), the value being on the same line of the column Role (column B) should be copied and pasted in the last row of the tab Offer Tracker in the column Role (column C). I would like rela time results. I can also tell you that The Interview Tracker Tab is composed of columns from A to J. The Offer tracker tab is composed of columns from A to G.



I generated the following code but this does not work. Coud you please help me? Many thanks in advance.

function onEdit(e) {

  var interviewTrackerSheet = e.source.getSheetByName("Interview Tracker");

  var offerTrackerSheet = e.source.getSheetByName("Offer Tracker");

  var editedRange = e.range;

  var editedSheet = editedRange.getSheet();

  if (editedSheet.getName() === "Interview Tracker" && editedRange.getColumn() === 7) {

    var editedRow = editedRange.getRow();

    var status = editedRange.getValue();

    if (status === "7 - Offered") {

      var role = interviewTrackerSheet.getRange(editedRow, 2).getValue(); // Column B

      var lastRow = offerTrackerSheet.getLastRow();

      offerTrackerSheet.getRange(lastRow + 1, 3).setValue(role); // Column C

    }

  }

}

 

[Malcolm]

Hi there 👋

Please remember to use BBCode or Markdown to format your code. Without it, it makes it hard to read your code.

Are you receiving any errors, could you describe more on what's not working?