I have a script that basically take info from a website for multiple users, and put these info in a google spreadsheet, with one sheet per users. I have a function that remove values of the firstline, resize every columns, and put back the setValues: my problem is that the script stop executing in the middle of the function. I
I have a sheet with a number of VLOOKUPS which do work BUT whenever a new row is added the VLOOKUP formula is not added to the new row. I’m certain this can be done with app script but I don’t know exactly where to start. It is important (OK vital) that the VLOOKUPs are on every row even new
What I would like to do is to create a script or with a function that will add automatically the day, the month and the year per row for 4 years for example in order to make a calendar of shooting, pre production and post prod per film. It would be so long to do it manually and add each
I am trying to write a wrapper around Google Sheets’ importdata() in code.gs: The idea is to call the function from any sheet in the spreadsheet to get the price of any crypto currency token: I get an error though when I try this: #ERROR Exception: You do not have permission to perform that action. (line 102). Why is this
I am trying to write an App Script that takes string data from multiple different spreadsheets (completely separate documents) and puts them all in a new spreadsheet. When I run the logger, it shows me all the data I want. I want each piece of data to show up in Column A, but when I run my script, it only
I have a download in JSON format that I get through the API. Example: An example of what should happen: enter image description here The ratio of the JSON list of employees with columns in the table: How can I convert JSON to a Google spreadsheet for 300+ rows? At the moment I only have a request to the API.
I want to create a script that I will have in a menu that gets the range “A1:C” and uppercases it. The problem is that throws an error “TypeError: values.toUpperCase is not a function” trying to use toUpperCase(). Got the following code: Im pretty new to JS and sheets api. I feel dumb because it looks like something simple. EDIT
I have a values in google sheet and the format is =+40,-58. This give me ERROR! because the sheet is taking it as formula. I can manually edit this by adding ‘ single qoute before equal sign but when i append qoute using script it append qoute with ERROR!. Tried multiple thing like getting cell type, convert it to string.
I have this code in Google Apps Script that is linked to a Google Sheet: The script is supposed to send reminder emails. Everything works well, except this one line: This line should add the value of 1 to a specific cell in the Google Sheet, in the current row the for loop is at. However, instead of adding the