JavaScript - Help With Array Merge

I'm trying to setup a mail merge using a gmail docs script from http://www.labnol.org/software/mail-...h-gmail/13289/. So far, it works pretty well, but I want to edit it to include the following:

1) The script should start with "Dear Noah" as opposed to "Dear Noah_Kaplan"

2) I want to add my canned response to the script so that it always appears at the bottom of the e-mail.

3) Lastly, I want the outgoing mail to be saved as individual drafts in my drafts folder in gmail before it's sent out. That way, I can decide if I want to add a sentence or two to personalize each individual email draft.

Thanks in advance for your awesome help.

Best,
Noah

By the way, here's the script I want to edit:

function onOpen() {
var mySheet = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [ {name: "Step 1: Import Gmail Contacts", functionName: "importContacts"},
{name: "Step 2: Start Mail Merge", functionName: "sendEmail"},
{name: "Help / About", functionName: "showHelp"}];
mySheet.addMenu("Mail Merge", menuEntries);
}

function importContacts() {
var groupName = Browser.inputBox("Enter the name of your Gmail Contacts group he ");
var mySheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var myContacts = ContactsApp.findContactGroup(groupName).getContacts();
for (i=0; i < myContacts.length; i++) {
var myContact = [[myContacts[i].getFullName(), myContacts[i].getPrimaryEmail(), "Pending"]];
mySheet.getRange(i+2, 1,1,3).setValues(myContact);
}
Browser.msgBox("You have successfully imported " + myContacts.length + " contacts from Gmail. Please proceed to Step 3.");
}

function sendEmail() {

var mySheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var newLine = "<br><br>";

var emailSubject = mySheet.getRange("F2").getValue();
var emailSalutation = mySheet.getRange("F3").getValue();

var emailLine1 = mySheet.getRange("F4").getValue() + newLine;
var emailLine2 = mySheet.getRange("F5").getValue()?
mySheet.getRange("F5").getValue() + newLine : "";
var emailLine3 = mySheet.getRange("F6").getValue()?
mySheet.getRange("F6").getValue() + newLine : "";
var emailLine4 = mySheet.getRange("F7").getValue()?
mySheet.getRange("F7").getValue() + newLine : "";
var emailLine5 = mySheet.getRange("F8").getValue()?
mySheet.getRange("F8").getValue() + newLine : "";

var emailBody = emailLine1 + emailLine2 + emailLine3 + emailLine4 + emailLine5;

var emailSignature = mySheet.getRange("F9").getValue() + newLine;
var emailYourName = mySheet.getRange("F10").getValue();
emailBody = emailBody + emailSignature + emailYourName + "<br>";

var emailReplyTo = mySheet.getRange("F11").getValue();

var myContacts = mySheet.getDataRange();
var myContact = myContacts.getValues();
for (i=1; i < myContact.length; i++) {
var person = myContact[i];
if (person[1] != "" && person[2] != "OK") {
var emailMsg = emailSalutation + " " + person[0] + "," + newLine + emailBody;
var advancedArgs = {htmlBody:emailMsg, name:emailYourName, replyTo:emailReplyTo};
MailApp.sendEmail(person[1], emailSubject, emailMsg , advancedArgs);
mySheet.getRange(i+1,3).setValue("OK");
}
}
SpreadsheetApp.flush();
}

function showHelp() {
Browser.msgBox("With Mail Merge, you can send personalized email messages to your Gmail contacts in two easy steps. For help, visit http://labnol.org/?p=13289 or send me a tweet @labnol.");
}​

I am working on a page where the user will select a location from a dynamically generated dropdown list.

I was able to create the php multidimensional array (tested and working) from a MySql database using the users information at login, but I'm having problems converting it to a javascript multidimensional array. I need to be able to access variables that I can pass to a number of text fields within an html form.

For instance, if a user belongs to a company with multiple addresses, I need to be able to let them select the address they need to prepopulate specific text fields.

php array creation:
Code:

if ($row_locations) 
{ 
	while ($row_locations = mysql_fetch_assoc($locations))  
	{ 
		$mail[$row_locations['comp_id']]=array('mailto'=>$row_locations['mailto'], 'madd'=>$row_locations['madd'], 'madd2'=>$row_locations['madd2'], 'mcity'=>$row_locations['mcity'], 'mstate'=>$row_locations['mstate'], 'mzip'=>$row_locations['mzip'], 'billto'=>$row_locations['billto'], 'badd'=>$row_locations['badd'], 'badd2'=>$row_locations['badd2'], 'bcity'=>$row_locations['bcity'], 'bstate'=>$row_locations['bstate'], 'bzip'=>$row_locations['bzip']);
	} 
}

javascript function - this should create the array and send variables to text fields.
Code:

function updateAddress() {
var mail = $.parseJSON(<?php print json_encode(json_encode($mail)); ?>);
{
if (comp_id in mail) {
document.getElementById('mailto').value=mail.comp_id.mailto.value;
document.getElementById('madd').value=mail.comp_id.madd.value;
document.getElementById('madd2').value=mail.comp_id.madd2.value;
document.getElementById('mcity').value=mail.comp_id.mcity.value;
document.getElementById('mstate').value=mail.comp_id.mstate.value;
document.getElementById('mzip').value=mail.comp_id.mzip.value;
} else {
document.getElementById('mailto').value='';
document.getElementById('madd').value='';
document.getElementById('madd2').value='';
document.getElementById('mcity').value='';
document.getElementById('mstate').value='';
document.getElementById('mzip').value='';
}
}
}

Where is this breaking?
Thanks in advance.

I can't seem to figure out how to accomplish this. In my website, I would like the user to input text into a single or multiple textbox(es) and then have the contents of the textbox(es) stored to either a variable or an array. Then I would like to have that variable/array compared to other arrays. Basically, the user is searching for items in a database. The user can search for as many or as little items as they want. Then the item(s) will be compared to multiple arrays to find out if what the user wants is in the database.

So for example, let's say the user is searching for recipes that have all or part of these ingredients: chicken, broccoli, lemon, honey. So, there would have been a total of 4 textboxes...one for each ingredient. These ingredients are stored to an array..lets call it ingredient(). In the database of recipes, each recipe has its own array which includes the ingredients needed to make the recipe, we'll call them tag1(), tag2(), and tag3(). Now, I want the array, ingredient(), to be compared to each of the "tag" arrays to see if any of the "tag" arrays include exactly match the ingredient() tag in part or in whole. Is this possible?

Hey guys,

I'm hoping this is possible or that there is an easier way to do this.
I'm having an issue with displaying data from one array that contains information about users in a table that is controlled by a different array.
Is it possible to do this or is this use of arrays to display the data the wrong approach?

The table is located on one webpage, I simply want to extract one piece of information that I have placed in the initial array as part of the login script that contains user information (for validation for login etc) and display it in a table on the new webpage that is opened as a result of successful validation of the user details.

I'm completely stumped and after many attempts I just can't seem to get it to work.

I have the following array that contain the people who are on off on certain time:

Code:

var all = [
    ["1234", "Jim", "2011-10-23 00:00:00", "2011-10-25 07:00:00"],
    ["1235", "Jack", "2011-10-21 00:00:00", "2011-10-21 08:00:00"],
    ["1236", "Jane", "2011-10-11 00:00:00", "2011-10-11 00:30:00"],
    ["1237", "June", "2011-10-20 00:00:00", "2011-10-20 12:00:00"],
    ["1238", "Jill", "2011-10-14 00:00:00", "2011-10-14 11:00:00"],
    ["1239", "John", "2011-10-16 00:00:00", "2011-10-16 10:30:00"],
    ["1240", "Jacab", "2011-10-19 00:00:00", "2011-10-20 08:30:00"]
];

The above array, I wish to use javascript to insert into the FullCalendar (http://arshaw.com/fullcalendar/). I notice that the only way seems to be using the FullCalendar array style (or structure) as follows:

Code:

$('#calendar').fullCalendar({
    events: [
        {
            title  : 'event1',
            start  : '2010-01-01'
        },
        {
            title  : 'event2',
            start  : '2010-01-05',
            end    : '2010-01-07'
        },
        {
            title  : 'event3',
            start  : '2010-01-09 12:30:00',
            allDay : false // will make the time show
        }
    ]
});

So, the question is: How do I insert my array to match with the FullCalendar array? cause FullCalendar array had a different array structure from my array - and I don't think so that I can write in this way:
Code:

$('#calendar').fullCalendar({
    events:all
});

Appreciate any help provided.

Hi,
In a nutshell,can anyone tell me how to copy a 2d (two dimensional ,2 dimensional) php array to 2d javascript array?I would be obliged if anyone can provide me a method of doing that

OR
I have written a code to copy a 2d php array to a 2d javascript array.It is working but there is one problem(please see the following).Can anyone tell me what I am doing wrong here?


The 2d php array is $quest[100][6] and the 2d javascript array is questions[100][6] . I have written the javascript code inside the <?php....?> itself using echo "<script language="javascript" type="text/javascript">.......</script>;




Now ,inside the javascript,when I try to copy the 2d php array to the 2d javascript array using the following method it works

questions[0]= ["<?php echo join("\", \"", $quest[0]); ?>"];
questions[1]= ["<?php echo join("\", \"", $quest[1]); ?>"]; ... and so on


However, if I try to do the same using the following method it does not work
for (var i= 0; i <= 99; i++)
{ questions[i]= ["<?php echo join("\", \"", $quest[i]); ?>"]; }

Why is that?What mistake am I making?Any help will be deeply appreciated.Thanks



-----------------------------THE CODE------------------------------------
<?php


Access database and store result of mysq_query in $result.......
$result = mysql_query($query);


for ( $count = 0; $count <= 99; $count++)
{
$quest[$count]=mysql_fetch_array($result,MYSQL_NUM);;

}

echo "<script language="javascript" type="text/javascript">

var questions = new Array(100);
for (var i = 0; i <100; i++)
{ questions[i] = new Array(6); }



/*The following method of copying 2d php array to 2d javascript array is not working
for ( var i = 0; i <= 99; i++)
{ questions[i]= ["<?php echo join("\", \"", $quest[i]); ?>"]; }
*/

/*The following method ,however,is working*/
questions[0]= ["<?php echo join("\", \"", $quest[0]); ?>"];
questions[1] = ["<?php echo join("\", \"",$quest[1]); ?>"];
questions[2] = ["<?php echo join("\", \"",$quest[2]); ?>"]; ....and so on




</script>";


mysql_close($db_server);

?>

Hi,
Here is a working code to copy 2d php array to 2d javascript array.


Code:

<html>

<head>

<?php

for($i = 0; $i < 3; $i++)
 {
   for($j = 0; $j < 2; $j++)
                   {$quest[$i][$j] = $i*10+$j;}
 }


?>



<script type="text/javascript">


var questions = new Array(3);

  for (var i = 0; i < 3; i++)
  {
   questions[i] = new Array(2);
  }

questions[0] = ["<?php echo join("\", \"", $quest[0]); ?>"];
questions[1] = ["<?php echo join("\", \"", $quest[1]); ?>"];
questions[2] = ["<?php echo join("\", \"", $quest[2]); ?>"];



document.write(questions[0][0] + "<br />");
document.write(questions[0][1] + "<br />");
document.write(questions[1][0] + "<br />");
document.write(questions[1][1] + "<br />");
document.write(questions[2][0] + "<br />");
document.write(questions[2][1] + "<br />");


</script>




</head>

</html>

Now,here's the thing.Notice these lines in the code


questions[0] = ["<?php echo join("\", \"", $quest[0]); ?>"];
questions[1] = ["<?php echo join("\", \"", $quest[1]); ?>"];
questions[2] = ["<?php echo join("\", \"", $quest[2]); ?>"];

I would like to put these lines in a loop,something like

for (var i = 0; i < 3; i++)
{
questions[i] = ["<?php echo join("\", \"", $quest[i]); ?>"];
}

But even after a lot of efforts I am unable to do so,what am I doing wrong?Thanks

Hi,
i can't find the mistake in my little script hope someone can help me.

PHP Code:
<?php

/* -------------------- read thumbfolder -------------------- */
    
    function isRdyPfD($filename){ 

        if ($filename == '.' || $filename == '..') {
        // To-Top-Dir
        return false;
    }
    
    $ext = explode(".",$filename);
    $ext = $ext[sizeof($ext) - 1];
    $allowedformats = array (
        'jpg', 
        'png',
        'jpeg',
        'gif'
    );
    
    return in_array($ext,$allowedformats);
    } 

    function getPicsfromDir($dir){ 
    /* array with names of the pictures in  $dir */

        if (is_dir($dir)) {
        if ($dh = opendir($dir)) {
                $filearray = array();
        while (($file = readdir($dh)) !== false) {
            if (isRdyPfD($file) === true) {
                $filearray[] = $file;
            }
        }
        closedir($dh);
                return $filearray;
        }
    }
    else {
        return false;
    }
    } // End Function


    $thumbs = getPicsfromDir("./images/thumbs/");
    

/* -------------------- thumbfolder  -------------------- */    
    echo "<div id='thumbslider'>\n";
    echo "<ul id='thumbs'>\n";
    for($i = 0; $i < count($thumbs); $i++){
            echo "<li><img src=\"./images/thumbs/$thumbs[$i]\" onclick=\"thumbClick($i)\"  /></li>\n";
            
    }
    echo "</ul>\n";
    echo "</div>\n";
    




/* -------------------- big size images folder -------------------- */
    $bigSizeImages = getPicsfromDir("./images/");
    //print_r($bigSizeImages);
    
    $jsValue = '';
    for ($j=0; $j < count($bigSizeImages); $j++){
                $jsValue = $jsValue . $bigSizeImages[$j];
                if ($j < (count($bigSizeImages)-1)) {
                        $jsValue = $jsValue . ",";
                }
   }
    
?> 


<script type="text/javascript">
        images = new Array(<?php echo $jsValue ?>);
        
    

    
    
    function thumbClick(pos){
            
            //alert(pos);
            alert(images[pos]);
            
    }

</script>

I can't trace the images array values?
thanks for a feedback!!!

I'm having major pains trying to figure this out. I'm kind of new to Javascript, I need to open a text file from an external server, store each line in an array, then search that array for a certain word (HIGH), and if it exists then write something to the webpage, and if not, write something else. Here is what I have so far:

Code:

<html>
<head>
<title>Test</title>
<script>
<!--
function test(x) {
  if (wxd1txt.readyState === 4 && wxd1txt.status === 200) {  // Makes sure the document is ready to parse and Makes sure it's found the file.
	 var wxd1text = wxd1txt.responseText; 
     var wxd1array = wxd1txt.responseText.split("\n"); // Will separate each line into an array
	 var wxd1high = wxd1array.toString();  //Converting the String content to String
	//var highsearchreg = new RegExp("HIGH");
//var wxd1high = wxd1array[x].search(highsearchreg);
document.write(wxd1high);
	if (wxd1high.search("HIGH") >= 0){
		document.write("HIGH RISK");}
		else {
		document.write("NO RISK");}
		}
}
//-->
</script>
</head>
<body>
Hi!
<script>
<!--
var Today = new Date();
var ThisDay = Today.getDate();
var ThisMonth = Today.getMonth()+1;
var ThisYear = Today.getYear();
var Hour = Today.getHours();
var Day2 = Today.getDate()+1;
var Day3 = Today.getDate()+2;
if (navigator.appName != "Microsoft Internet Explorer") {
ThisYear = ThisYear + 1900;}
if (ThisMonth < 10) {
	ThisMonth = "0" + ThisMonth;}
if (ThisDay < 10) {
	ThisDay = "0" + ThisDay;}
if (Hour == 2 || Hour == 22 || Hour == 23 || Hour == 0 || Hour == 1) {
	var wxHourd1 = 0600}
	else if (Hour >= 3 && Hour <= 10) {
		var wxHourd1 = 1300;}
			else if (Hour >= 11 && Hour <= 13) {
				var wxHourd1 = 1630;}
					else if (Hour >= 14 && Hour <= 16) {
						var wxHourd1 = 2000;}
							else if (Hour >= 17 && Hour <= 21) {
								var wxHourd1 = 0100;}		
//var wxurld1 = "http://www.spc.noaa.gov/products/outlook/archive/"+ThisYear+"/KWNSPTSDY1_"+ThisYear+""+ThisMonth+""+ThisDay+""+wxHourd1+".txt";
var wxurld1 = "http://www.spc.noaa.gov/products/outlook/archive/2010/KWNSPTSDY1_201005101300.txt" //(High risk day for testing)
//document.write(wxurld1); //Use this to verify this section is working
if (window.XMLHttpRequest)
  {
  wxd1txt=new XMLHttpRequest();
  }
else // IE 5/6
  {
  wxd1txt=new ActiveXObject("Microsoft.XMLHTTP");
  }
wxd1txt.open("GET", wxurld1, true);
wxd1txt.onreadystatechange = test();

// -->
</script>
</body>
</html>

When added to a webpage, nothing shows up except the "Hi!" and there are no errors in the Javascript Console in Google Chrome. Is this possible with Javascript, and if so, what am I doing wrong or not doing?

Also, I have 2 URLs, one is a text file that has the HIGH text I want for an example, the other is the current file, which shouldn't have HIGH in it (unless the weather in the US turns really bad)

Hello I'm have some javascript objects with arrays that should be transferred as php array.
Its posted by ajax httpRequest.

How can I return php array, from the javascript?


JS Code:

['asd1', 'asd2', 'asd3']

via Ajax

=> PHP PHP Code:
array('asd1', 'asd2', 'asd3'); 

Hi,

i have an input value array for customer ids, i also need to make a copy of that array into another input element on submit to use for another process.

So far here is what i have come up with regarding the js


the current html is this

Code:

<!-- original input -->

<input id="cb<?php echo $i;?>" name="cid[]" value="<?php echo $commissions[$i]['id'];?>" onclick="isChecked(this.checked);" type="checkbox" />


<!-- this is new html input which  is outside the $i loop that i need a copy of cid[] stored on submit

<input type="hidden" name="ids[]" onsubmit="valueTovalue();" />


<!-- here is the js so far --> 

<script type="text/javascript">

function valueTovalue()
{

 var valin = document.adminForm.cid.value;  //cid is the array cid[]
 document.adminForm.ids.value = valin; //copy the array to the new input element array ids

}

</script>

so basically if they click 1 cid then ids will also show 1, if they click all cid then ids will show all as well.

will that work the way i have it, am i even close here..

thanks

update: what i have seems to work fine for text values or string values but not for arrays, what am i missing that it wont copy an array?




Array
(
[cid] => Array
(
[0] => 1
)

[task] => remarksonly
[remark] => hhhyyy
[boxchecked] => 1
[ids] => Array
(
[0] =>
)

)




am i getting closer lol


Code:

function valueTovalue()
{
 var valin = cid.concat;  
 document.adminForm.ids.value = valin.concat; 

return(true);

this has to be close i hope

Code:

document.adminForm.ids.value = [].concat(document.adminForm.cid);

Sorry if this question sounds dumb but I'm a JS noob.
Basically I need to create a script that will take three numerical grades entered from a prompt, as well as the student's fictitious name; then take the average of the highest and lowest grades.

So far I've gotten it to:
Accept then display the student's name
Take three grades then figure out and display the average of all three.

I still need it to:
Calculate and Display the average of the highest and lowest scores
Display all three scores that were entered

I assume that I'll have to instantiate an array, then input values from the prompt, but everything I have tried has failed. See my script below.


<script type = "text/javascript">
<!--
var gradeCounter,
gradeValue,
total,
average,
linebreak = "<br />",
name,
grade;
total = 0;
gradeCounter = 0;
name = window.prompt("Input Student Name")
grade = window.prompt( "Input Numerical Grade, -1 to Quit:", "0" );
gradeValue = parseInt( grade );
while ( gradeValue != -1 )
{
total = total + gradeValue;
gradeCounter = gradeCounter + 1;
grade = window.prompt("Input Grade, -1 to Quit:", "0");
gradeValue = parseInt( grade );
}
if ( gradeCounter != 0 )
{
average = total / gradeCounter;
document.write(name)
document.write(linebreak)
document.write("Average: " + average);
}
else
document.write( "<p>No grades were entered</p>" );
// -->
</script>

OK so I am trying to put together a function that takes an array and then takes the square root of each number in old array and writes to the screen the new array of squared numbers. Not looking for answer, just what I need to do for the logic in the for statement.

Code:

<html>
<head>
<script type="text/javascript">
<!---
var Jane=new Array ("Female","Red","Lipstick","28",","45789546");
var Mary=new Array ("Female","Orange","Lipstick","25",","45789547");
var Elle=new Array ("Female","Blue","Lipstick","21",","45789548");
document.write(Jane[0]);
document.write(Jane[1]);
document.write(Jane[2]);
document.write(Jane[3]);
document.write(Jane[4]);
//-->
</script>
<html>

Please help me with the above code. I would like to have a prompt so I can enter one of the three girls name (array) then it would display all the elements. For example:

Enter a name: Jane
the output would be :

Female
Red
Lipstick
28
45789546


Please help. Thank you very much.

Hi,

I want to create a javascript array from a php array.

At the moment, when my page loads, is loads a file called sso.js, which contains the following js array:

var customarray=new Array('Bournemouth University', 'Cambridge Imaging Systems (CIS)', 'Glasgow Metropolitan College', 'Royal Holloway, University of London', 'University of Portsmouth', 'University of Brighton', 'Esher College', 'Canterbury Christ Church University', 'British Universities Film and Video Council (BUFVC)', 'Eduserv');

What I want to happen is that this array is created from a php string/ sql database.

At the moment I have created a php string which has all the values in the array. Ie:
<?echo $entityIDstring;?>
Outputs
'Bournemouth University', 'Cambridge Imaging Systems (CIS)', 'Glasgow Metropolitan College', 'Royal Holloway, University of London', 'University of Portsmouth', 'University of Brighton', 'Esher College', 'Canterbury Christ Church University', 'British Universities Film and Video Council (BUFVC)', 'Eduserv'

How can I put $entityIDstring into the javascript customarray automatically?

I tried using:

<input type="hidden" name="entityIDstring" id='entityIDstring' value="<?=$entityIDstring?>"/>

In the page but when I tried:

var customarray2 = document.getElementById('entityIDstring');
alert(customarray2.value);

In the js, nothing happens.