Javascript – Email only sends if a cc is set
I'm trying to make my script send an email. The email has mail to and cc but the email wont send if the cc is missing. Not all my rows have a cc email. I want to send the email…
Convert content to text parsing JSON URL response
I've got a url where the result is shown as below "playerInfo": { "059gh": { "eligiblePos": "Flx3,G,Flx,Flx2,PG", "status": "FA" }, "04mr6": { "eligiblePos": "Flx3,G,Flx,Flx2,PG", "status": "FA" }, "059fz": { "eligiblePos": "Flx3,G,Flx,Flx2,PG", "status": "FA" }, "059fw": { "eligiblePos": "Flx3,G,Flx,Flx2,PG", "status": "FA"…
Javascript – Need to return a dynamic set of columns from 2d array
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…
Javascript – Function button not working, only works manual input
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…
Javascript – Can I reference the sheet tab before the active sheet tab without using it's name?
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…
Javascript – Convert languages excel to google sheets
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…
Javascript – Data Validation rule for column in google sheet that contains drop down values
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…
Javascript – problem to insert data in to google sheets in correct order using apps script
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 {…
Javascript – Google Apps Script Race Conditions Handling
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…
Javascript – AppScript append X rows to Google Sheet
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…