Categories
User Help Web Apps

How to run a different script on multiple Google Sheet tabs?

The code writes an auto email once a trigger is met in the sheet. There are 3 different tabs pulled from the main sheet and each tab should run the script but with a different message for each tab. When I duplicate the script and change the tab variable only the last script runs. Should […]

Categories
User Help Web Apps

How to run a different script on multiple Google Sheet tabs?

The code writes an auto email once a trigger is met in the sheet. There are 3 different tabs pulled from the main sheet and each tab should run the script but with a different message for each tab. When I duplicate the script and change the tab variable only the last script runs. Should […]

Categories
Mastering Development

Merge two onEdit with if functions?

I have script for Google Sheets that I collected on interwebs and got some help here. No I have 2 onEdit in conflict. I overcome that by creating script Trigger for onEdit2. It works but I don’t think it is the best solution. Could you help get those two separated onEdit with if functions into […]

Categories
Mastering Development

Issue with static cc on Google’s MailApp Script

Okay, so I’m working on a script that will basically pull information from a spreadsheet to then send out in an email once an email address is added into the spreadsheet. The issue is I’m trying to add a noReply and cc setting but it seems to then break my script to where it keeps […]

Categories
Mastering Development

GSheets Script email for each row containing repeated data How to limit it to one row only?

How to send an email once, if the row is repeated in the sheet where this is bringing it from? If I put the MailApp.sendEmail part outside the loop and within a certain period of time the user changes two products’ statuses, it only sends one email, containing one of the product’s updated status. If […]

Categories
Mastering Development

sendEmail function: get one email for multiple values

I need help with google script and I’m stuck on a particular issue. Basically, I want to get emails (once a day or once a week, doesn’t matter – will set a trigger) when the value in column E is zero. So, instead of getting three separate emails that say: “Zero purchases for lemon”, “Zero […]

Categories
User Help Web Apps

Send email using Google script, with filename in spreadsheet

I’m trying to do the same thing as this question: Send an email with attachment using Google Apps Script But with the attachment names as cells in the speadsheet. My code is here: function sendEmailsandAttachments() { var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 1; // First row of data to process var numRows = 3; […]

Categories
Mastering Development

C++ “Space ship”

Hello stack overflow users! I have a question about my program, and a problem I am encountering. I have practically finished the program, but I can’t seem to have a separate void function for my dimensions (width and length of rocket). I currently have them inside my void function that creates my rocket, void draw […]

Categories
Mastering Development

Send to multiple emails using google script

function sendEmails() { var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 2; // First row of data to process var numRows = 5; // Number of rows to process // Fetch the range of cells A2:I6 var dataRange = sheet.getRange(startRow, 1, numRows, 10); // Fetch values for each row in the Range. var data = dataRange.getValues(); […]

Categories
Development

Sending email from sheet using google script

I am trying to send emails to employees by using gs to pull the info from a sheet. I figured out how to pull the email address, message and subject, however, I want to include information from multiple columns in the message. Below is what I have so far….however I also want to include information […]