Styjun

Are Star Trek races uniform?

Why doesn't hot charcoal glow blue?

Stare long enough and you will have found the answer

I'm half of a hundred

Who inspired the character Geordi La Forge?

Why do military jets sometimes have elevators in a depressed position when parked?

What are these objects near the Cosmonaut's faces?

when to use がつ or げつ readings for 月？

How to pronounce correctly [b] and [p]? As well [t]/[d] and [k]/[g]

Would a spacecraft carry arc welding supplies?

Grade changes with auto grader

Do any languages mark social distinctions other than gender and status?

Examples of problems with non-convex constraint functions but convex feasible region

Meaning of “Bulldog drooled courses through his jowls”

Can I exit and reenter a UK station while waiting for a connecting train?

Visualize a large int

What is the maximum amount of melee weapon attacks a character can make reliably every turn?

C# Toy Robot Simulator

How does an Evocation Wizard's Overchannel ability interact with Chaos Bolt?

How can a stock trade for a fraction of a cent?

I don't want my ls command in my script to print results on screen

Is there a package that allows to write correctly times in hours, minutes and seconds in mathematical mode?

Cutting a 4.5m long 2x6 in half with a circular saw

Can set-like objects obeying ZFC be constructed in Euclidean geometry?

How to create a function in script so that the column of currency data displays the currency in the email generated?

Create Currency Data Type C++How to display Currency in Indian Numbering Format in PHPAndroid Currency Class - How Do you Get the Display Name for the Currency?How to display length of filtered ng-repeat dataHow to display a currency format in MVCHow to format display String to currency in C#In angular 2, how to display a number as two decimal rounded currency?How to display the currency symbol to the right in AngularGoogle Sheets Email Script ErrorR - identify which columns contain currency data $

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

1

I want the total in parameter2 to be in currency format in the generated email.

I have tried to use Number Format but continue to receive an error stating my range can not be found

function sendArticleCountEmails() 
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 ss.setActiveSheet(ss.getSheetByName("Send-Emails"));
 var sheet = SpreadsheetApp.getActiveSheet();
 var dataRange = sheet.getRange("A2:F5");
 var data = dataRange.getValues();
 for (i in data) 
 var rowData = data[i];
 var emailAddress = rowData[1];
 var recipient = rowData[0];
 var message1 = rowData[2];
 var message2 = rowData[3];
 var parameter2 = rowData[4];
 var message3 = rowData[5];

 //Number Format
 var dataRange = sheet.getRange("rowData[4]");
 column.setNumberFormat('$');

 var message = 'Dear Customer ' + recipient + ',nn' + message1 + ' ' +
 message2 + ' ' + parameter2 + ' ' + message3;
 var subject = 'Your YTD Sales';
 MailApp.sendEmail(emailAddress, subject, message);
 

Below is an example of the email generated. I would like the 45000 to read $45,000

Dear Customer John Doe,

Customer #123456789 sales expectations were $50,000. Customer had 45000 in

actual sales.

javascript format currency

share|improve this question

edited Mar 28 at 22:45

kht

47011 silver badge77 bronze badges

asked Mar 28 at 21:32

Lindsay HolwerdaLindsay Holwerda

611 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You're trying to getRange for value "rowData[4]" which doesn't seem to be a valid arguement. I assume this is google sheets? Their documentation is here, looks like you can specify row/column groups. Passing a string representing an object field is not a supported arguement
  
  – kht
  Mar 28 at 22:57
  
  

  
  
  
  

add a comment
 | 

1

I want the total in parameter2 to be in currency format in the generated email.

I have tried to use Number Format but continue to receive an error stating my range can not be found

function sendArticleCountEmails() 
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 ss.setActiveSheet(ss.getSheetByName("Send-Emails"));
 var sheet = SpreadsheetApp.getActiveSheet();
 var dataRange = sheet.getRange("A2:F5");
 var data = dataRange.getValues();
 for (i in data) 
 var rowData = data[i];
 var emailAddress = rowData[1];
 var recipient = rowData[0];
 var message1 = rowData[2];
 var message2 = rowData[3];
 var parameter2 = rowData[4];
 var message3 = rowData[5];

 //Number Format
 var dataRange = sheet.getRange("rowData[4]");
 column.setNumberFormat('$');

 var message = 'Dear Customer ' + recipient + ',nn' + message1 + ' ' +
 message2 + ' ' + parameter2 + ' ' + message3;
 var subject = 'Your YTD Sales';
 MailApp.sendEmail(emailAddress, subject, message);
 

Below is an example of the email generated. I would like the 45000 to read $45,000

Dear Customer John Doe,

Customer #123456789 sales expectations were $50,000. Customer had 45000 in

actual sales.

javascript format currency

share|improve this question

edited Mar 28 at 22:45

kht

47011 silver badge77 bronze badges

asked Mar 28 at 21:32

Lindsay HolwerdaLindsay Holwerda

611 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You're trying to getRange for value "rowData[4]" which doesn't seem to be a valid arguement. I assume this is google sheets? Their documentation is here, looks like you can specify row/column groups. Passing a string representing an object field is not a supported arguement
  
  – kht
  Mar 28 at 22:57
  
  

  
  
  
  

add a comment
 | 

I want the total in parameter2 to be in currency format in the generated email.

I have tried to use Number Format but continue to receive an error stating my range can not be found

function sendArticleCountEmails() 
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 ss.setActiveSheet(ss.getSheetByName("Send-Emails"));
 var sheet = SpreadsheetApp.getActiveSheet();
 var dataRange = sheet.getRange("A2:F5");
 var data = dataRange.getValues();
 for (i in data) 
 var rowData = data[i];
 var emailAddress = rowData[1];
 var recipient = rowData[0];
 var message1 = rowData[2];
 var message2 = rowData[3];
 var parameter2 = rowData[4];
 var message3 = rowData[5];

 //Number Format
 var dataRange = sheet.getRange("rowData[4]");
 column.setNumberFormat('$');

 var message = 'Dear Customer ' + recipient + ',nn' + message1 + ' ' +
 message2 + ' ' + parameter2 + ' ' + message3;
 var subject = 'Your YTD Sales';
 MailApp.sendEmail(emailAddress, subject, message);
 

Below is an example of the email generated. I would like the 45000 to read $45,000

Dear Customer John Doe,

Customer #123456789 sales expectations were $50,000. Customer had 45000 in

actual sales.

javascript format currency

share|improve this question

edited Mar 28 at 22:45

kht

47011 silver badge77 bronze badges

asked Mar 28 at 21:32

Lindsay HolwerdaLindsay Holwerda

611 bronze badge

function sendArticleCountEmails() 
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 ss.setActiveSheet(ss.getSheetByName("Send-Emails"));
 var sheet = SpreadsheetApp.getActiveSheet();
 var dataRange = sheet.getRange("A2:F5");
 var data = dataRange.getValues();
 for (i in data) 
 var rowData = data[i];
 var emailAddress = rowData[1];
 var recipient = rowData[0];
 var message1 = rowData[2];
 var message2 = rowData[3];
 var parameter2 = rowData[4];
 var message3 = rowData[5];

 //Number Format
 var dataRange = sheet.getRange("rowData[4]");
 column.setNumberFormat('$');

 var message = 'Dear Customer ' + recipient + ',nn' + message1 + ' ' +
 message2 + ' ' + parameter2 + ' ' + message3;
 var subject = 'Your YTD Sales';
 MailApp.sendEmail(emailAddress, subject, message);
 

share|improve this question

edited Mar 28 at 22:45

kht

47011 silver badge77 bronze badges

asked Mar 28 at 21:32

Lindsay HolwerdaLindsay Holwerda

611 bronze badge

share|improve this question

edited Mar 28 at 22:45

kht

47011 silver badge77 bronze badges

asked Mar 28 at 21:32

Lindsay HolwerdaLindsay Holwerda

611 bronze badge

edited Mar 28 at 22:45

kht

47011 silver badge77 bronze badges

edited Mar 28 at 22:45

kht

47011 silver badge77 bronze badges

asked Mar 28 at 21:32

Lindsay HolwerdaLindsay Holwerda

611 bronze badge

asked Mar 28 at 21:32

Lindsay HolwerdaLindsay Holwerda

611 bronze badge