Welcome to Code Forum!

Join a community that supports you and your coding journey from day one. We strive to be a friendly, supportive community that empowers everyone to be better developers. By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!
  • Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.

    GIF shows where to locate </> in the thread and or post editor toolbar.
    To learn more about how to use our BBCode feature, review our "How to post your code into threads" here.

    Thank you, Code Forum.

HTML & CSS Creating an Automatic Email Script in App Scripts, I have done it before, but I am having trouble replacing the info

SammieBabie1

New Coder
I am having trouble with placing the information throughout the script. Can anyone help me?

Here is the link to the sheet as well: https://docs.google.com/spreadsheets/d/1dRIqIhIgFOAgr-e0ex8M_tcLOR9in0Pm8G8gQtChqnk/edit?usp=sharing

[CODE lang="rich" title="Automated Email"]function onSendEmail(e) {

var range = e.range.getA1Notation();

//Check if SendEmail column is edited

if(range.match(/^L[\d]+$/)){

if(e.value == true){

var sh = e.range.getSheet();

var data = sh.getDataRange().getValues();

var rowIndex = e.range.getRow()-1;

//This will prevent sending email if the header is edited

if(rowIndex > 0){

var product = data[rowIndex][3];

var email = data[rowindex][9];

var subject = 'Product Notification';

var body = 'A product you were interested in:' + product + ' is back in stock. Please contact us at 1-800-748-7001 to place an order.';

//Send email

MailApp.sendEmail(email, subject, body);

}

}

}

}[/CODE]
 

Buy us a coffee!

Buy me a coffee.
Back
Top Bottom