Question

59

How to check a checkbox in Google Apps Script and uncheck all the other cells?

rated 0 times [ 65] [ 6] / answers: 1 / hits: 11452 / 4 Years ago, wed, september 23, 2020, 12:00:00

So I'm trying to make a sign-in/sign-up form on Google Sheets, and I have two checkboxes, one that says login, and one with sign up. In my apps script, I'm trying to make it so that only one of them can be checked. This is my code, and it's not working. Help?

function signupLogin() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();

  var sheet = ss.getSheets()[0];

  if (sheet.getRange('A13').isChecked() === 'TRUE') {

    sheet.getRange('B13').setValue('FALSE');

  } else {

    sheet.getRange('B13').setValue('TRUE'); 

  }

}

The code will always make the second checkbox ticked, even if the first one is ticked.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

darennevina

Add To Favorites

Follow

Total Points: 422

Total Questions: 128

Total Answers: 105

Location: Comoros

Member since Tue, Mar 14, 2023

1 Year ago

darennevina questions

1 Uncaught (in promise) TypeError: Cannot read properties of undefined (reading 'address')

Sun, Jun 5, 22, 00:00, 2 Years ago

1 change the active list when scrolling navbar

Fri, Nov 12, 21, 00:00, 3 Years ago

1 DiscordjsError: Request to use token, but token was unavailable to the client

Wed, Nov 25, 20, 00:00, 4 Years ago

1 How do I extract data from this NodeList?

Fri, Sep 18, 20, 00:00, 4 Years ago

1 How can I query (with SQL) from browser?

Fri, Feb 21, 20, 00:00, 4 Years ago

View All

answered 4 Years ago emerald · Accepted Answer

When you check A13 or B13 the other cell will be unchecked automatically.

Therefore, I think an onEdit() solution is what you are looking for:

function onEdit(e) {

  

  const as = e.source.getActiveSheet();

  const cell = e.range.getA1Notation();

  const cell_checks = ['A13','B13'];

  if(as.getName() == "Sheet1" && cell_checks.includes(cell) && e.range.isChecked())

  {cell_checks.filter(val=>val!=cell).forEach(c=>as.getRange(c).uncheck())}  

}

To use this solution, just save the aforementioned code to the script editor and then every time you click on the checkbox in Sheet1 (modify the name to your needs) the rest checkboxes will be unchecked.

This code is also scalable. Namely, if you want to have multiple checkboxes and when you click one of them, the rest become unchecked. You can define the list of your checkboxes here:

 const cell_checks = ['A13','B13'];