Hello,
I am making a code to create a function that at the moment of pressing a button, exports the information of several books to a PDF and once finished, it deletes the data of some specific cells, however to make the call of those books I need to call it via URL, but it wonโt let me call them, just doing them 1 by 1 and thatโs very tedious โฆ I donโt know if Iโll have to call them via URL
I leave the code that I am using where the โopenBy URL ()โ is where I must place the addresses of several books โฆ
function clear_sheeds(){
var Activ = SpreadsheetApp.openByUrl(โCaptura4 - Google Sheetsโ);
var uf = Activ.getLastRow();
var cel = Activ.getRange(โC11:Cโ).clearContent();
var cel2 = Activ.getRange(โF11:Fโ).clearContent();
}
This appears to be a question about a Google App Script, and has nothing to do with Appsheet, correct?
Iโll try to answer your question, but just know that this is the Appsheet community and typically you wonโt find much support for GAS here.
You probably should hold an array of all of the URLs, then run a loop over that array, calling your posted function on every iteration, passing each individual URL.
Thank you very much for your support!
Iโll tryโฆ
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |