I need to return several columns from an array pulled out of Google Sheets. Currently my code is let out = data.map(function (row, index) { return [row[1], row[0], row[36], row[6], row[45], row[46], row[47], row[7]]}); This code works well. But the…
Can you please help me why its not working everytime i click on button its not updating. I want to get the old value of column J and column K and set it to column L and M everytime it…
It it possible to reference a cell in the sheet tab before the active sheet tab? For instance, my active sheet is 'Sheet 2' but I want to reference 'A1' in 'Sheet 1'. However I don't want to use the…
Apologies if this thread have already been listed or if I am doing something wrong for what ever reason, I don't know forums that well. I have a piece of code that I am struggling with. I started using google…
I have a google sheet and one of the columns contains a dropdown list where users can select one of the values present on the list. For example the column name is "Duration" and users can select either 10, 20…
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 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…
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…
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.…
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…