I have a sheet with a column of checkboxes. They can be set individually in my app but I want an “Admin” to be able to click on a “Clear All” button or switch and have them all unchecked. I tried several different things and so far unsuccessful but I am sure I am making it far more difficult than necessary (which is my standard MO) so appreciate any assists!
Jerry
I wanted the same thing as well but that functionality does not exist. I assume the checkboxes are user specific? If so, an admin cannot see the user values anyway and thus cannot clear them
Actually Robert they are check boxes that indicate which rows will be included in an alert to be sent and they are set by the admin only and could have 1 - 20 set and wanted to be able to uncheck them all to start a new day…thanks for replying!
Could you instead create a script to clear them via a time trigger every morning?
Somebody said scripts here. Do you need my help to set up one @pipharvester?
Here’s how it would work.
The script for this:
function SetCheckbox() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Checkboxes');
var dataRange = sheet.getRange('A2:A');
var values = dataRange.getValues();
for (var i = 0; i < values.length; i++) {
for (var j = 0; j < values[i].length; j++) {
if (values[i][j] == true) {
values[i][j] = false;
}
}
}
dataRange.setValues(values);}
What you need to change:
Navigate to current project’s triggers and setup like I show in the video, change the time to run as you wish.
Well once again this forum proves to be one of the most selfless and helpful ones I have ever been part of. You are all very attentive and helpful! Thank you @Robert_Petitto and @ThinhDinh for your attention and time! Blessings to you both!
Blessings to you as well! Feel free to ask us whenever you need.
Worked flawlessly!
Lovely. Make sure you set the trigger to the time you want it to run, from then on it’s automatically run daily.
O vídeo não estar reproduzindo!
I have uploaded a new GIF, hope it helps!
Olá, obrigado @ThinhDinh , esse deu para eu visualizar perfeitamente. Apesar de eu não ter conseguido executar o script, deu erro aqui pra mim… O meu caso de uso seria de dentro do app acionar o checkbox, e na planilha ele estivesse atrelado a um script programado para apagar certa quantidade de linha 
Sorry I can’t speak Portuguese/Spanish. I used Google Translate, so you want a script that is programmed to erase a certain amount of line. How many lines, and how exactly do you want to trigger it?
Umas 100 linhas
So let me summarize it, you want to trigger a checkbox from Glide, that will delete 100 lines from a sheet.
Do you want to delete them, or just clear their content? And is it the same range of lines every time (let’s say A2:A101)?
Sim, sempre o mesmo intervalo de linhas, e é excluir elas mesmo.
Is the “trigger” checkbox in the same sheet as the lines that need to be deleted, or in a different sheet?
A caixa de seleção estar na mesma planilha, na coluna “H”.
Preciso que somente as linhas venham a ser excluídas quando selecionado o checkbox de A2:A100
So a checkbox in column H will clear all the values from A2:A100 upon selection in Glide?