[Google App Script] How to create a Button

Published: 06 March 2022
on channel: Andrew's Tip

151

#GoogleScript #Button
Continuing the last video: Script - Trigger, we will discuss about the script behind a button or image button: Add some function on a button. And how to manage the triggers.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Please make sure to leave a like👍 & comment
❤️ SUBSCRIBE IF YOU ARE NEW AND TURN THE BELL ON🔔
🔵 FOLLOW ME ON TWITTER: / tipsandrew

Souce codes:
function check() {
var ui = SpreadsheetApp.getUi();
var sheet = SpreadsheetApp.getActiveSheet();

//ui.alert(sheet.getName());

var num1 = sheet.getRange("A2").getValue();
var num2 = sheet.getRange("C2").getValue();
var result = sheet.getRange("E2").getValue();
var rangeResult = sheet.getRange("F2");
if (num1+num2==result) {
rangeResult.setValue("Correct");
rangeResult.setBackground("green");
} else {
rangeResult.setValue("Wrong");
rangeResult.setBackground("red");
}
}

function check2() {
var ui = SpreadsheetApp.getUi();
var sheet = SpreadsheetApp.getActiveSheet();

var num1 = sheet.getRange("A2").getValue();
var num2 = sheet.getRange("C2").getValue();
var result = sheet.getRange("E2").getValue();
sheet.getRange("F2").clearContent();

var fileId = '';
if (num1+num2==result) {
fileId = "1gQpDjKI0fH11kHQN-UB99lmlI9o0adm4";
} else {
fileId = "19I8rRc1fgXvGDR5GVys0zm7RO_C5q94W";
}
var imgDoc = sheet.insertImage("https://docs.google.com/uc?id=" + fileId, 6, 2);
imgDoc.setWidth(80);
imgDoc.setHeight(80);

}

On this page of the site you can watch the video online [Google App Script] How to create a Button with a duration of hours minute second in good quality, which was uploaded by the user Andrew's Tip 06 March 2022, share the link with friends and acquaintances, this video has already been watched 151 times on youtube and it was liked by 0 viewers. Enjoy your viewing!