 const sheetName = "Form Responses 1"; // replace this sheet name with yours
const uidHeader = "_SiTE"; // column name of UID in response sheet
const uidPrefix = "SiTE-"; // UID prefeix
const uidDigitLength = 4; // digit length of UID

function _onFormSubmit(e) {
  const { rowStart } = e.range
  var url = SpreadsheetApp.getActive().getFormUrl();
  var form = FormApp.openByUrl(url);
  var response = form.getResponses().pop();
  var url = form.getPublishedUrl();
  const editUrl = response.getEditResponseUrl()
  var responseId = response.getId();
  
  
  // for sequential id
  //var uid = createUid(responseId);
  
  // for random id
  var uid = createRandomUid(responseId);
  writeUidToSheet(uid, rowStart);
  
  var title = "Thanks for Submit Google Form";
//  var lastItem = response.getItemResponses().pop();
  var email = response.getRespondentEmail();
  if (email){
    var subject = form.getTitle();
    var htmlBody = "<table style='width: 600px; margin: 10px auto; background: #dfe4ea;'><tr>" +
                   "<td style='padding: 0px 20px;'>" +
                    "<h2 style='text-align: center; letter-spacing: 0.1em; background: linear-gradient(60deg, #16a085, #1abc9c); color: #fff; padding: 10px;'>" +
                     title + "</h2>" +
                     "<p>Your Registration No</p>" +
                     "<div style='padding: 20px;border-radius: 20px; background: linear-gradient(60deg, #16a085, #1abc9c);'>" +
                       
                       "<div style='font-size: 25px; color: #ecf0f1; text-align: center;'>" + uid +"</div>" +

                     "</div>" +
                     "<p><a href='"+ url +"' style='color: #16a085;'>Submit another response</a></p>" +
                     "<p><a href='"+ editUrl +"' style='color: #16a085;'>Edit your response</a></p>" +

                      

                     "<p>Thanks,<br>Sunrise IT Education</p>" +
                     "</td></tr></table>";
    var options = {
      htmlBody: htmlBody
    };
    GmailApp.sendEmail(email, subject, "", options);
  }
}
  // Write uid to the responses sheet
function writeUidToSheet(uid, rowStart){
  var ws = SpreadsheetApp.getActive().getSheetByName(sheetName);
  var dataRange = ws.getDataRange();
  var values = dataRange.getValues();
  var headers = values[0];
  var indexUid;
  
  // Locate the index of header UID
  for(var c = 0; c < headers.length; c ++){
    if(headers[c] === uidHeader){
      indexUid = c;
      break;
    }
  }
  
  // Insert a new column in B if UID column is not found
  if (indexUid === undefined){
    ws.insertColumnsAfter(1, 1);
    indexUid = 1;
    ws.getRange("B1").setValue(uidHeader);
    dataRange = ws.getDataRange();
    values = dataRange.getValues();
  }
  
  // Check UID's in the sheet row by row
  var isNewUid = true;
  for (var r = 1; r < values.length; r ++){
    var currentUid = values[r][indexUid];
    if (currentUid === uid){
      isNewUid = false;
      break;
    }
  }
  
  if (isNewUid){
    ws.getRange(rowStart, indexUid + 1).setValue(uid)
  }
}
  

// Create a UID in document properties
function createUid(responseId){
  var docProperties = PropertiesService.getDocumentProperties();
  var key = "uid";
  var id = 1;
  if (docProperties.getProperty(responseId)){
    var uid = docProperties.getProperty(responseId);
  }else{
    if(docProperties.getProperty(key)){
      id = parseInt(docProperties.getProperty(key));
    }
    
    var uid = (Math.pow(10, uidDigitLength) + id).toString().substring(1, uidDigitLength+1);
    uid = uidPrefix + uid;
    
    docProperties.setProperty(key, id + 1);
    docProperties.setProperty(responseId, uid);
  }
  return uid;
}

// function a random uid in document properties
function createRandomUid(responseId){
  var docProperties = PropertiesService.getDocumentProperties();
  var key = "randomUids";
  var ids = [];
  if (docProperties.getProperty(responseId)){
    var uid = docProperties.getProperty(responseId);
  }else{
    if(docProperties.getProperty(key)){
      ids = JSON.parse(docProperties.getProperty(key));
    }
    
    do{
      var randomNumber = Math.pow(10, uidDigitLength) + Math.floor(Math.random() * Math.pow(10, uidDigitLength));
      var uid = randomNumber.toString().substring(1, uidDigitLength + 1);
      uid = uidPrefix + uid;
    }while (ids.indexOf(uid) !== -1)
    
    ids.push(uid)
    docProperties.setProperty(key, JSON.stringify(ids));
    docProperties.setProperty(responseId, uid);
  }
  return uid;
}

// Remove all properties from the document properties object, so the uid can be reset
function resetForm(){
  var ui = SpreadsheetApp.getUi();
  var prompt = "This action will delete all responses in the form";
  if (ui.alert("Confirmation",prompt, ui.ButtonSet.OK_CANCEL) === ui.Button.OK){
    PropertiesService.getDocumentProperties().deleteAllProperties();
    const url = SpreadsheetApp.getActive().getFormUrl();
    const form = FormApp.openByUrl(url)
    form.deleteAllResponses();
    var msg = 'All responses have been deleted and UID has been reset. You need to manually remove the old data in sheet "' + sheetName + '".';
    SpreadsheetApp.getActive().toast(msg, "Google Apps Script", 15);
  }
}



function onOpen(){
  var ui = SpreadsheetApp.getUi();
  ui.createMenu("Scripts")
    .addItem("Reset form", "resetForm")
    .addToUi();
}

const sheetName = "Form Responses 1"; // replace this sheet name with yours
const uidHeader = "_SiTE"; // column name of UID in response sheet
const uidPrefix = "SiTE-"; // UID prefeix
const uidDigitLength = 4; // digit length of UID

function _onFormSubmit(e) {
  const { rowStart } = e.range
  var url = SpreadsheetApp.getActive().getFormUrl();
  var form = FormApp.openByUrl(url);
  var response = form.getResponses().pop();
  var url = form.getPublishedUrl();
  const editUrl = response.getEditResponseUrl()
  var responseId = response.getId();
  
  
  // for sequential id
  //var uid = createUid(responseId);
  
  // for random id
  var uid = createRandomUid(responseId);
  writeUidToSheet(uid, rowStart);
  
  var title = "Thanks for Submit Google Form";
//  var lastItem = response.getItemResponses().pop();
  var email = response.getRespondentEmail();
  if (email){
    var subject = form.getTitle();
    var htmlBody = "<table style='width: 600px; margin: 10px auto; background: #dfe4ea;'><tr>" +
                   "<td style='padding: 0px 20px;'>" +
                    "<h2 style='text-align: center; letter-spacing: 0.1em; background: linear-gradient(60deg, #16a085, #1abc9c); color: #fff; padding: 10px;'>" +
                     title + "</h2>" +
                     "<p>Your Registration No</p>" +
                     "<div style='padding: 20px;border-radius: 20px; background: linear-gradient(60deg, #16a085, #1abc9c);'>" +
                       
                       "<div style='font-size: 25px; color: #ecf0f1; text-align: center;'>" + uid +"</div>" +

                     "</div>" +
                     "<p><a href='"+ url +"' style='color: #16a085;'>Submit another response</a></p>" +
                     "<p><a href='"+ editUrl +"' style='color: #16a085;'>Edit your response</a></p>" +

                      

                     "<p>Thanks,<br>Sunrise IT Education</p>" +
                     "</td></tr></table>";
    var options = {
      htmlBody: htmlBody
    };
    GmailApp.sendEmail(email, subject, "", options);
  }
}
  // Write uid to the responses sheet
function writeUidToSheet(uid, rowStart){
  var ws = SpreadsheetApp.getActive().getSheetByName(sheetName);
  var dataRange = ws.getDataRange();
  var values = dataRange.getValues();
  var headers = values[0];
  var indexUid;
  
  // Locate the index of header UID
  for(var c = 0; c < headers.length; c ++){
    if(headers[c] === uidHeader){
      indexUid = c;
      break;
    }
  }
  
  // Insert a new column in B if UID column is not found
  if (indexUid === undefined){
    ws.insertColumnsAfter(1, 1);
    indexUid = 1;
    ws.getRange("B1").setValue(uidHeader);
    dataRange = ws.getDataRange();
    values = dataRange.getValues();
  }
  
  // Check UID's in the sheet row by row
  var isNewUid = true;
  for (var r = 1; r < values.length; r ++){
    var currentUid = values[r][indexUid];
    if (currentUid === uid){
      isNewUid = false;
      break;
    }
  }
  
  if (isNewUid){
    ws.getRange(rowStart, indexUid + 1).setValue(uid)
  }
}
  

// Create a UID in document properties
function createUid(responseId){
  var docProperties = PropertiesService.getDocumentProperties();
  var key = "uid";
  var id = 1;
  if (docProperties.getProperty(responseId)){
    var uid = docProperties.getProperty(responseId);
  }else{
    if(docProperties.getProperty(key)){
      id = parseInt(docProperties.getProperty(key));
    }
    
    var uid = (Math.pow(10, uidDigitLength) + id).toString().substring(1, uidDigitLength+1);
    uid = uidPrefix + uid;
    
    docProperties.setProperty(key, id + 1);
    docProperties.setProperty(responseId, uid);
  }
  return uid;
}

// function a random uid in document properties
function createRandomUid(responseId){
  var docProperties = PropertiesService.getDocumentProperties();
  var key = "randomUids";
  var ids = [];
  if (docProperties.getProperty(responseId)){
    var uid = docProperties.getProperty(responseId);
  }else{
    if(docProperties.getProperty(key)){
      ids = JSON.parse(docProperties.getProperty(key));
    }
    
    do{
      var randomNumber = Math.pow(10, uidDigitLength) + Math.floor(Math.random() * Math.pow(10, uidDigitLength));
      var uid = randomNumber.toString().substring(1, uidDigitLength + 1);
      uid = uidPrefix + uid;
    }while (ids.indexOf(uid) !== -1)
    
    ids.push(uid)
    docProperties.setProperty(key, JSON.stringify(ids));
    docProperties.setProperty(responseId, uid);
  }
  return uid;
}

// Remove all properties from the document properties object, so the uid can be reset
function resetForm(){
  var ui = SpreadsheetApp.getUi();
  var prompt = "This action will delete all responses in the form";
  if (ui.alert("Confirmation",prompt, ui.ButtonSet.OK_CANCEL) === ui.Button.OK){
    PropertiesService.getDocumentProperties().deleteAllProperties();
    const url = SpreadsheetApp.getActive().getFormUrl();
    const form = FormApp.openByUrl(url)
    form.deleteAllResponses();
    var msg = 'All responses have been deleted and UID has been reset. You need to manually remove the old data in sheet "' + sheetName + '".';
    SpreadsheetApp.getActive().toast(msg, "Google Apps Script", 15);
  }
}



function onOpen(){
  var ui = SpreadsheetApp.getUi();
  ui.createMenu("Scripts")
    .addItem("Reset form", "resetForm")
    .addToUi();
}

created 2 years ago

HTML Online Editor & Compiler

Write, Run & Share HTML code online using OneCompiler's HTML online Code editor for free. It's one of the robust, feature-rich online Code editor for HTML language, running on the latest version HTML5. Getting started with the OneCompiler's HTML compiler is simple and pretty fast. The editor shows sample boilerplate code when you choose language as HTML. You can also specify the stylesheet information in styles.css tab and scripts information in scripts.js tab and start coding.

About HTML

HTML(Hyper Text Markup language) is the standard markup language for Web pages, was created by Berners-Lee in the year 1991. Almost every web page over internet might be using HTML.

Syntax help

Fundamentals

Any HTML document must start with document declaration <!DOCTYPE html>
HTML documents begin with <html> and ends with </html>
Headings are defined with <h1> to <h6> where <h1> is the highest important heading and <h6> is the least important sub-heading.
Paragrahs are defined in <p>..</p> tag.

Links are defined in <a> tag.

Example:

<a href="https://onecompiler.com/html">HTML online compiler</a>

Images are defined in <img> tag, where src attribute consists of image name.
Buttons are defined in <button>..</button> tag
Lists are defined in <ul> for unordered/bullet list and <ol> for ordered/number list, and the list items are defined in <li>.

HTML Elements and Attributes

HTML element is everything present from start tag to end tag.
The text present between start and end tag is called HTML element content.
Anything can be a tagname but it's preferred to put the meaningful title to the content present as tag name.
Do not forget the end tag.
Elements with no content are called empty elements.
Elements can have attributes which provides additional information about the element.
In the below example, href is an attribute and a is the tag name.
Example:
```
<a href="https://onecompiler.com/html">HTML online compiler</a>
```

CSS

CSS(cascading style sheets) describes how HTML elements will look on the web page like color, font-style, font-size, background color etc.

Example:

Below is a sample style sheet which displays heading in green and in Candara font with padding space of 25px.

body{
  padding: 25px;
}
.title {
	color: #228B22;
	font-family: Candara;
}

HTML Tables

HTML Tables are defined in <table> tag.
Table row should be defined in <tr> tag
Table header should be defined in <th> tag
Table data should be defined in <td> tag
Table caption should be defined in <caption> tag

HTML-Javascript

Javascript is used in HTML pages to make them more interactive.
<script> is the tag used to write scripts in HTML
You can either reference a external script or write script code in this tag.

Example

<script src="script.js"></script>