This script is to run on multiple spreadsheets and copy (export) selected data to 1 central SS: Exception: The parameters (number[]) don’t match the method signature for SpreadsheetApp.Range.setValues. doExportBLC @ temp.gs:44 Line 44: search.offset(0, 1, 1, Data.length).setValues(Data); That script is …
Tag: google-apps-script
Several onEdit() functions inside only one not works
I have an onEdit() function that hosts 3 different onEdit() functions. I know the question has been asked several times and I have tested the solutions of many of these answers but I don’t understand why it doesn’t work. In my script, which I wrote based on the most relevant answer, onEdit1(event)…
Searching in google sheet using app script not working with numbers
I’m trying to use app script to give access to my Google sheet by searching through a webpage. so I don’t have to give all the data. the search is based on a specific column and the result can be repeatable on the column itself but the other columns of the same row like price and item are differen…
How to get all sheets by openById while stand-alone
I am trying to make a stand-alone script to action for another spreadsheet. It’s working for the first sheet only, but it’s not working for all sheets. I need an example to work all sheets and need work all except individual sheets. Answer If you want to loop through all the sheets and set the fon…
Understanding apps script api calls?
This script works. It has user id 4 which I am adding their email address to check the google admin API. The resolved column[10] is where managers approve requests. Because some of these usernames are not correctly entered, I was looking for a way to check if they were actually correct user ids. Both .setValu…
Copy/paste a range from one sheet to several others depending on the value of a cell in a column
In a spreadsheet, I have a tab “CUSTOMERS” with values in the range B4:Q,. These values are imported from another spreadsheet with importrange. In C4:C of “CLIENTS”, there are the names of 3 products which correspond to the names of 3 other tabs (“DATA”, “EPHAD”…
Sheet with name as number not being returned with getSheetByName in For loop
I am having trouble getting this for loop to work correctly: I have a sheet named “0” and another named “100” and so on (dependent on how many sheets are in the spreadsheet). The script works for the first sheet (i.e. finds the sheet named “0”): But it returns a “Type…
Google Script – Opting out of a loop before it’s finished, returns later to finish the loop
I have a bit of a weird problem. I built a script that will essentially take variable information from Spreadsheet 1, it will then create a copy of EmptySheet, fill out all the information row by row (let’s refer to it as FilledInSheet after). After that it takes FilledInSheet and deletes the requested …
How to use Class range when coding in apps script
I’m building a Slack Bot for my internship, and I can get it to send direct messages to a private channel, and connect through the API. But my current problem is getting the algorithm to take the information in a spreadsheet and form a message with that data in the channel. I found a tutorial on youtube…
Create an Identification Question WITH Answer, in Google Forms Using Google Script
I’ve been trying so hard to understand javascript as I know only Python. I generate javascript codes using Python, to run it on Google Scripts. I was able to automate creation of any number of Multiple Choice Items by generating codes to be used as script, but I could not figure out how to make a script…