While Loop() Time Delay App Script- Google Sheet Tutorial - How To Use While Loop - Sleep- Hindi
Google Sheet App Script /JavaScript Programming Tutorial in Hindi
In this video tutorial I have shown how to use while loop function and time delay to loop through various cell of range and set value of them by writing a program in java /App script in script editor of google sheet.
Topics covered in this video are : Java/App Script, App Script ,script editor, spreadsheet app structure, functions like While loop () utilites, sleep ()
#SpreadSheet #AppScript #ScriptEditor #GoogleSheet #JavaScript
JavaScript code used in video:
function myFunction() {
var ss= SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Data1");
var a= 1;
while (ss.getRange("C1").getValue()!="x"){
ss.getRange(a, 1).setValue(100);
a++;
Utilities.sleep(2000);
}
}
On this page of the site you can watch the video online While Loop() Time Delay App Script- Google Sheet Tutorial - How To Use While Loop - Sleep- Hindi with a duration of hours minute second in good quality, which was uploaded by the user Bucket Full of Knowledge 23 May 2020, share the link with friends and acquaintances, this video has already been watched 7,254 times on youtube and it was liked by 59 viewers. Enjoy your viewing!
