function runTimerLimit() {
const form = FormApp.getActiveForm();
form.setAcceptingResponses(true);
deleteTrigger();
ScriptApp.newTrigger('disableAcceptingResponses')
.timeBased()
.after(40 * 60 * 1000)
.create();
}
function disableAcceptingResponses() {
const form = FormApp.getActiveForm();
form.setAcceptingResponses(false);
}
function runTimerLimit() {
const form = FormApp.getActiveForm();
form.setAcceptingResponses(true);
deleteTrigger();
ScriptApp.newTrigger('disableAcceptingResponses')
.timeBased()
.after(40 * 60 * 1000)
.create();
}
function disableAcceptingResponses() {
const form = FormApp.getActiveForm();
form.setAcceptingResponses(false);
}
ARRAYFORMULA
или INDEX
.=ARRAYFORMULA(IF(A1:A<>0;"Done";))
=ARRAYFORMULA(ROW(A:A) - 1)
={"Номер ответа";ARRAYFORMULA(ROW(A2:A) - 1)}
={"Номер ответа";ARRAYFORMULA(MATCH(A2:A;SORT(A2:A;1;1);0))}