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…
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…
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…
I need to make a countifs function work, it has to match the number of orders received from a specific country during a month. Hello! I'm trying to make a COUNTIFS function work: In sheet 1 I have a table…
let me start by saying that I am very inexperienced with this type of coding so I apologize if any relevant details are missing. I started developing an API script to run on a Google sheets file, the script as…
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,…