// ---- SCRIPT SETTINGS ---- //

const middleman_sheet_id = "1vKtbdxKAQB6xRn8ZRtdJ1x3qwhLyaVBXgixZBY5o8mU";
const middleman_row = 21; // set #row in MIDDLEMAN@DASHBOARD to report datetimes to and get sheet IDs from

var middleman_ErrorCell = SpreadsheetApp.openById(middleman_sheet_id).getSheetByName('DASHBOARD').getRange("F"+middleman_row); // select "Last error" cell in column & variable row number
middleman_ErrorCell.setValue(new Date()).setNumberFormat("yyyy-MM-dd hh:mm:ss"); // output datetime of last error

var middleman_SourceSheetID = SpreadsheetApp.openById(middleman_sheet_id).getSheetByName('DASHBOARD').getRange("J"+middleman_row).getValue(); // select source workbook ID cell
//var middleman_SourceSheetID = "1Ibsi9M7TuLNCFj0slRswpczhPqBgx_EIDlj40J1htTs";

checkPushMODQA_ATT(middleman_SourceSheetID);


function checkPushMODQA_ATT(middleman_SourceSheetID){

  var source_CheckCell = SpreadsheetApp.openById(middleman_SourceSheetID);
  var test = source_CheckCell.getSheetByName('REPORTING').getRange("D4").getValue(); // Value set to "Yes"

  if (test === 'Yes'){
    console.log("OK run script now");
  }
}