/*
 * Generates a snippet of HTML code based on data in cells.
 * Usage: On a sheet, select "Tools" -> "Script editor" and paste below (modify output as necessary)
 *        Then set the value for a blank column to =generateHTML(dateCell, titleCell, locationCell, linkCell)
 *        ie. =generateHTML(B2, C2, D2, E2)
 */

function generateHTML(date, title, location, link) {
  
  var html = Utilities.formatString(
    '<tr>\n<td>%s</td>\n<td><strong>%s</strong></td>\n<td>%s</td>\n<td><a href="%s" target="_blank">Sign Up Here</a></td>\n</tr>',
    Utilities.formatDate(date, "GMT", "MM/dd/YY"),
    title,
    location,
    link
    );
  
  return html;
}