google-apps-script Questions

Javascript – Arrays and "The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues." error

September 26, 2023
Gustavo Distel
2 Answers

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…

VIEW QUESTION

Javascript – Apps Script Automatic timestamp when a tab gets updated

September 25, 2023
marybr555
2 Answers

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…

VIEW QUESTION

App Script HTML Service Calling CSS File showing as Plain Text

September 24, 2023
maccollaflower
2 Answers

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…

VIEW QUESTION

Javascript – Equipment Log Google Sheets – fixing while/for loop in Google Apps Script for check in/check out based on checkbox

September 21, 2023
programmerInTraining04
2 Answers

I am trying to create a script on google sheets where when I click a checkbox, another sheet is updated with a new row with a log of that click. My issue right now: I'm trying to get it so…

VIEW QUESTION

Javascript – How do I use filter with an Apps Script array and fetch only the row with specific user ID in the cell?

September 21, 2023
So lost rn
2 Answers

I have an Apps Script which fetches data from four different columns but it fetches all the rows. I'd like it to only push the row that matches the user ID which is a randomly generated 8 digit number. function…

VIEW QUESTION

Javascript – I have to create a script that will find a common value between sheets and then copy data from 3 cells in that row to 3 cells in the related sheet

September 19, 2023
RLCastillo
2 Answers

I need a script for google sheets. My worksheet has 2 sheets called SOURCE and TARGET. The TARGET sheet has the following columns and ranges: BO_BENE_ID range A2 - A2392, BENE_BIRTH_DT range E2 - E2392, BENE_FIRST_NAME range F2 - F2392,…

VIEW QUESTION

Javascript – Compare two json array and update dataSheet with setValues updating empty rows

September 18, 2023
hub2sell
2 Answers

I want to update my question so as to better clarify my goal. Cooper's script works but doesn't do exactly what I need. In column B I stored data row by row so I could quickly check and compare the…

VIEW QUESTION

Accessing Nested Objects in JavaScript where inner objects have serial numbers as labels

September 18, 2023
Einarr
3 Answers

I have a nested object where the inner objects have random serial numbers as their labels. If I have data like this: const user = { id: 101, email: '[email protected]', personalInfo: { name: 'Jack', address: { line1: 'westwish st', line2:…

VIEW QUESTION

Javascript – App Script to set a cell value in the last row based on another cell in the same row

September 1, 2023
Argonous
2 Answers

I am looking for an assistance on creating an App Script. This script needs to do the following: Go to the last row of the active Sheet. Look at the value in last cell of column I, which is Yes…

VIEW QUESTION

Javascript – Speed up my google script function in google sheet

August 30, 2023
Cheaster
2 Answers

Good day! I am a beginner in google script app, I just made a form in the google sheet but it always takes minutes to automate transfer data on the other sheet using app script. I search on how to…

VIEW QUESTION