I could really use some help with my onedit triggered scripts. Needing to simplify and condense into one script.

[Jon Beckner]

I have two separate scripts in google sheets that are triggered by "TRUE" value checkboxes. The first script is set to uncheck all checkboxes from the sheet and the second is resetting a dropdown list. I'll post the code below for the two scripts. Ultimately I would like both conditions to run on one checkbox. If the code can be written in a more simplified manor that would not be a bad thing.

Best regards, Jon

Script 1:

function onEdit(e) {
  if (e.range.getSheet().getName() == 'Audits') {
    if (e.range.getA1Notation() == 'J27' && e.value == "TRUE") {
      e.range.setValue("FALSE");
      var ss = SpreadsheetApp.getActive();
      var sh = ss.getActiveSheet();
      var rg = sh.getDataRange();
      var vA = rg.getDataValidations();
      var cbA = [];
      for (var i = 0; i < vA.length; i++) {
        for (var j = 0; j < vA[i].length; j++) {
          var rule = vA[i][j];
          if (rule != null) {
            var criteria = rule.getCriteriaType();
            if (criteria == SpreadsheetApp.DataValidationCriteria.CHECKBOX) {
              sh.getRange(i + 1, j + 1).setValue(null)

            }
          }
        }
      }
    }
  }
}
Script 2

function onEdit(e) {
  if (e.range.getSheet().getName() == 'Audits') {
    if (e.range.getA1Notation() == 'E27' && e.value == "TRUE") {
      e.range.setValue("FALSE");
      var ss = SpreadsheetApp.getActive();
      var sh = ss.getActiveSheet();
      var rg = sh.getDataRange();
      var vA = rg.getDataValidations();
      var cbA = [];
      for (var i = 0; i < vA.length; i++) {
        for (var j = 0; j < vA[i].length; j++) {
          var rule = vA[i][j];
          if (rule != null) {
            var criteria = rule.getCriteriaType();
            if (criteria == SpreadsheetApp.DataValidationCriteria.VALUE_IN_LIST) {
              sh.getRange(i + 1, j + 1).setValue(null)

            }
          }
        }
      }
    }
  }
}

[Jon Beckner]

Also my scripts run whenever they feel like it.

[CBMServices Web]

Hi Jon,

Can you share a sample spreadsheet so that we can understand the environment the script runs in?

This message (including any attachments) may contain confidential and privileged information belonging to the sender, for a specific individual and purpose, and is legally privileged. If you are not the intended recipient, you should delete this message and any disclosure, copying, forwarding or distribution of this message, or the taking of any action based on it, by you is strictly prohibited.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/d56089e8-7d7e-459d-b54c-66422b404e6an%40googlegroups.com.

[Jon Beckner]

I wish I could but company policy says I can't do that I can however share a few screenshots 

[Jon Beckner]

Someone on another forum answered my question...I'll post the new and improved script below

function onEdit(e) {

  var ss = SpreadsheetApp.getActive();
  var sh = ss.getActiveSheet();
  var rg = sh.getDataRange();
  var vA = rg.getDataValidations();

  if (e.range.getSheet().getName() == 'Audits') {
    if (e.range.getA1Notation() == 'E27' && e.value == "TRUE") {
      e.range.setValue("FALSE");

      for (var i = 0; i < vA.length; i++) {
        for (var j = 0; j < vA[i].length; j++) {
          var rule = vA[i][j];
          if (rule != null) {
            var criteria = rule.getCriteriaType();

            if (criteria == SpreadsheetApp.DataValidationCriteria.CHECKBOX || criteria == SpreadsheetApp.DataValidationCriteria.VALUE_IN_LIST) {