logo
down
shadow

Creating array with change log data and sending it via email


Creating array with change log data and sending it via email

Content Index :

Creating array with change log data and sending it via email
Tag : google-apps-script , By : user86493
Date : November 28 2020, 11:01 PM

Does that help Your first solution using scriptProperties is indeed subject to limitation in the string length these properties can have.
The sheet solution should work, I'd suggest to write a script that would convert the sheets content to an html table to make it more readable.
function sendReport(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var errorMsg = ss.getDataRange().getValues();
  var message = '<body><div style="font-family:arial,sans;font-size:12pt"><p>Change report</p>';  
  message+= '<table style="background-color:#fafafa;border-collapse:collapse;font-family:arial,sans;font-size:9pt;" border = 1 cellpadding = 5>';
  message+='<tr valign="top" bgcolor="#FFA" cellpadding=5><th>Number</th><th>description</th></tr>';
  var c = 1;//counter
  for(var n=0;n<errorMsg.length;n++){
    message+='<tr><td align="center">'+c+'</td><td>';
    message+=errorMsg[n][0]+'</td></tr>';
    c++;
  }
  message+='</table></body>'
  var hh = 100+35*errorMsg.length;
  if(hh>500){hh=500};
  var render = HtmlService.createHtmlOutput(message).setWidth(940).setHeight(hh);
  SpreadsheetApp.getUi().showModelessDialog(render, "preview");  
  MailApp.sendEmail(Session.getActiveUser().getEmail(),'change log','HTML ONLY',{'htmlBody':message})
}

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

php array - sending a single email for each unique email address grouping there data together


Tag : php , By : Der Ketzer
Date : March 29 2020, 07:55 AM
Hope that helps You can group the values into comma-separated strings via GROUP_CONCAT() and optionally split them back up in PHP:
SELECT 
  GROUP_CONCAT(itemnumber) AS items,
  GROUP_CONCAT(quantity) AS quantities,
  vendoremail
FROM orders
WHERE orderid = '$orderID'
GROUP BY vendoremail
name1@email.com    A,C    2,3
name2@email.com    B      1
$results = array();
while($row = mysql_fetch_array($query)){
   $results[] = $row; 
}
foreach ($results as $result) {
  $email = $result['vendoremail'];
  $items = explode(",", $result['items']); // now it's an array...
  $quantities = explode(",", $result['quantities']);  // now it's an array...
}

Sending array of data as email


Tag : php , By : kraszie
Date : March 29 2020, 07:55 AM
seems to work fine I have a PHP array, and I need to test the content of that array via an email. I'm aware that we can see the entire array using var_dump(), but how can I send that output in an email? , try with following code, it will show the complete array clearly
echo "<pre>";
print_r($array);
echo "</pre>";

perl mail function html email not sending multiple array data


Tag : php , By : Schmidt
Date : March 29 2020, 07:55 AM
To fix the issue you can do I need to send users report to admin emails, here i am facing problem only one row data sending remain data not sending. if i submit 2 row data only one row going to email. if i send only one row it is working fine. can any one tell me how to send two rows of data to single email. , Put the data in foreach loop :
  <?php
$sno = $_POST['sno'];
$report = $_POST['report'];
$status = $_POST['status'];

$html = "
<html>
<head>
<style>
table.fancy_table tbody td              
{
font-family:'Calibri';
font-size:15px; line-height:18px; color:#333; background-color:#fff;
word-wrap: break-word;
}
table.fancy_table       {border: 0px solid #dddddd; }
table.fancy_table th    {border: 0px solid #dddddd;  padding:4px; color:#993300; text-transform:uppercase; background-color:#FFFFFF; }
table.fancy_table td    {border: 1px solid #dddddd; background:#ffffff; padding:4px; text-align:left; , height:30px; }
table.fancy_table tbody td   { background:#FFFFFF;}           
table.fancy_table {border-collapse: collapse; border-spacing: 0; width:450px; margin:0 auto; margin-bottom:15px; }
</style>    

</head>
<body>
<table class='fancy_table'>
<tr>
<td span style='color:#993300'><strong>S.NO</span></td>
<td span style='color:#993300'><strong>Report</span></strong></td>
<td span style='color:#993300'><strong>STATUS</span></strong></td>
</tr>";
foreach($sno as $v => $i)
{
$sno[$v];
$report[$v];
$status[$v];
$html.="<tr><td width='50'>$sno[$v]</td><td width='150'>$report[$v]</td><td width='130'>$status[$v]</td></tr>";
}//endforeach
$html.="</table></body></html>";  


$crlf = "\n";
$mime = new Mail_mime;
$mime->setHTMLBody($html);
$body = $mime->get();
$headers = $mime->headers($headers);
$mail = $smtp->send($recipients, $headers, $body);


$errmsg_arr[] =  'Mail Successfully Sent';
$errflag = true;
}


?>

Sending form data via email and show message without refresh or change page


Tag : javascript , By : Waheedoo
Date : March 29 2020, 07:55 AM
To fix the issue you can do Further to my comments and because it's hard to explain in such a little space:
page1.php
    <!-- Name the form myform as an id -->
    <form action="page2.php" method="post" id="myform">
        <label>Nombre </label>
        <input type="text" name="name"><br>
        <label>Email</label> 
        <input type="text" name="email"><br>
        <label>Teléfono</label> 
        <input type="text" name="phone"><br>
        <label>Mensaje</label>
        <textarea name="message"></textarea><br>
        <input id="submit" type="submit" name="submit" value="Enviar">
    </form>
    <!-- Invisible response container -->
    <div id="response"></div>
<script>
    $("#myform").submit(function() {
        $.ajax({
                 // PHP page  
                 url : 'page2.php',
                 // Takes all data from form
                 data: $("#myform").serialize(),
                 // Puts response into the container
                 success: function(response) {
                    $("#response").html(response);
                 }
        });    
        // This stops the page from reloading on submit
        return false;
    });
</script>
if(isset($_POST['submit'])){
    $to = "email@gmail.com"; // email destinatario
    $from = $_POST['email']; // email del cliente
    $name = $_POST['name'];
    $phone = $_POST['phone'];
    $mes = $_POST['message'];
    $subject = "Formulario web";
    $subject2 = "Copia de su formulario de consulta";
    $message = $name . " con número de teléfono: " . $phone . " escribió lo siguiente:" . "\n\n" . $_POST['message'];
    $message2 = "Aquí tiene una copia de su mensaje " . $name . "\n\n" . $_POST['message'];

    $headers = "From:" . $from;
    $headers2 = "From:" . $to;
    $success = (preg_match("/^[0-9]{9}$/",$phone) && preg_match("/^[a-zA-Z]*$/",$name) && $mes!='' && filter_var($from, FILTER_VALIDATE_EMAIL));

    if ($success){
        mail($to,$subject,$message,$headers);
        mail($from,$subject2,$message2,$headers2); // copia para el cliente
        echo "Formulario enviado. Muchas gracias " . $name . ", en breve contactaremos con usted.";
    }
    else {
        echo "Lo sentimos, se ha producido un error al enviar el formulario, revise su contenido y vuelva a intentarlo.";
    }
}

Creating new user account and sending email for creating password - Firebase


Tag : javascript , By : liquidx
Date : March 29 2020, 07:55 AM
I think the issue was by ths following , Visit the firebase console for your project.
Go under Authentication, there will be a tab called templates.
Related Posts Related QUESTIONS :
  • Finding all possible complete pairings from a list in Google Sheets
  • Hide / show specific Sheets tabs for specific users on shared file
  • How do I use the replyTo option parameter of replyAll()?
  • Improve response speed Google sheet script
  • How to link email address too Google Form answer?
  • How to find the row and column of a certain string in a Google Spreadsheet through Google App Scripts
  • Trigger for Google Sheets
  • Is there a way to make this loop more efficient?
  • Inserting variable data into an existing Google Sheet in Google Scripts
  • How to run a function when specific range is edited
  • Hiding different columns on Google sheet using script?
  • How to send html email with variable as "send to" address in Google Apps Script
  • How to use Apps Script to create multiple forms that feed into one sheet WITH SHEET TITLES
  • Share App Script Web App Between Multiple Google Sheets
  • retrieve google forms edit urls and maintain existing data structure
  • Invalid transfer on left side. (line 1, "Tests" file)
  • Error with deleting items from Google Form
  • Cloud build API deploy:run on Google Apps Script doesn't work
  • Does Column Index changes upon adding a column manually in a spreadsheet
  • Is it possible to do Input-based queries in Apps Script?
  • Extract the exact subjects and update the google sheets using apps script
  • Conversion of a Google Form ItemType via Apps Script
  • Display a clickable link on screen in Google Apps Script
  • How to encrypt/decrypt URL parameters in Google Apps Script?
  • Google Sheets filename in cell via formula instead of a script?
  • Google Sheets custom function bug "Unknown function" after successful run
  • Iterate through column, find match and send email based on cell value
  • How to modify details of only a particular occurrence of a recurring calendar event using google app script?
  • How do I make a Google Sheets custom formula that gives the current cell the color of the input cell?
  • Pass spreadsheet data in addRows() as an array
  • getActiveCell() always returns 1,1
  • &amp; is always being decoded (which I don't want) using HtmlOutput or HtmlTemplate
  • How do I loop through a single column of dates in Google Sheets and then send an email based on the date
  • Can i use Google app script for developing google chrome extension
  • How to set absolute reference in G-Sheets using Google Script
  • How to use Vlookup within an OnEdit function
  • How to convert Google Apps script blob to a base64 encoded string?
  • How to Place Two Different Types of Time Stamps in One Sheet?
  • Why can't lock value of User input?
  • How to copy edited cell data to new spreadsheet, into cell and sheet dependent on the edited cell?
  • How can I populate multiple choice questions in a Google Form from data within a Google Sheet
  • Create checkbox in cell by typing in another cell
  • How to make a form using Google Sheets script editor
  • How to get older versions of Google Spreadsheet data?
  • How to use scope "https://www.googleapis.com/auth/script.webapp.deploy"
  • Get a Cell value as value for function
  • Google Script ModalDialog/ ModelessDialog setWidth and setHeight feature not working
  • How to send a custom message when adding a viewer to Google Spreadsheet via Google Apps Scripts?
  • Looping in Creating PDF in Google Sheet
  • Is it possible to create a gmail label and choose its color using Google Apps Script?
  • Can I protect cells (user not allowed to edit) and run script that makes changes in these cells (e.g. hide row, unhides
  • Google Sheets custom sidebar: How to display a current cell value in sidebar without reload the sidebar?
  • oAuth disabled on google script
  • getOAuthToken returns null when called from Google Sheets
  • Use google-apps script url in project html
  • How to adjust as custom size margins and paper size in script to save google spreadsheet in PDF?
  • Google Apps Script HtmlServices template variables and global variables
  • What's the difference between a Page and a Slide in Google Slides?
  • How insert date from cell to google script?
  • Google Forms Add-On - menu item not appearing on initial load after installing plugin
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com