My program will go through a course an extract students name, students' email, assignments name and submissions state and insert it to google sheets. The code: function courseData() { const arguments = { teacherId: 'me', courseStates: 'ACTIVE' }; try {…
I want to download the whole table data from this webpage. It has five sub tables having its own thead and tbody each, under 'table[class="calendar"]'. My codes below can pull all thead texts and tbody texts as whole, but doesn't…
I have a spreadsheet that multiple people have access to edit. As part of the spreadsheet, I have a script that copies some data from one sheet to another when a checkbox on that row is set to true to…
After a bunch of iterations, this works to an extent but only returns 50 rows. Using this as my baseline after getting so many errors. How can this be modified to retrieve all links from the account but respect the…
I am trying to append multiple rows to my google sheet all at once, but every time I try, I only append one row. My data comes from my website's rsvp form. In that form each person can rsvp up…
(newbie question) I am trying to figure it out why the following code works. The goal is to create keys from array elements and a .count (number of times the ID appears in the range). I am approaching it this…
Background: I am pretty new to apps script, i have some beginner knowledge in other languages. I am trying to do some dates math, this happens in a loop when a user enters two dates (from and to) in cells.…
I have this code (it's pasted just a portion) var valores = [[FACTURA.getRange(CELDA_NRO_FACTURA).getValue(), //Nro Factura FACTURA.getRange(CELDA_FECHA).getValue(), //Fecha FACTURA.getRange(CELDA_MEDIO_PAGO1).getValue(), //Medio de pago FACTURA.getRange(CELDA_DTO_RGO_GENERAL).getValue(), //Dto/Rgo general //Fila 6 FACTURA.getRange(PRIMERA_FILA,PRIMERA_COLUMNA).getValue(), //Código FACTURA.getRange(PRIMERA_FILA,PRIMERA_COLUMNA + 1).getValue(), //Cantidad FACTURA.getRange(PRIMERA_FILA,PRIMERA_COLUMNA + 2).getValue(), //Descripción FACTURA.getRange(PRIMERA_FILA,PRIMERA_COLUMNA + 7).getValue(), //Unitario…
So I'm trying to create a script that can apply to several tabs in my spreadsheet file and will automatically update the timestamp in each individual tab when something in that tab is updated/changed. The cell that I want the…
I am trying to get my css.html file to be brought into my index.html and am using a html service to call the css file. Simple enough but I cannot seem to get the function to be seen as anything…