Apps Script Help

Hi, I have a Google form that users fill out to submit work orders. I used the help of AI to write a code that sends an automatic email based on the user's response. However, there is a field in the form where the user can upload images. The code works to send the required info; however, it cannot send those images as clickable links in the automated email. Can anyone please help me solve the issue? 

 

function onFormSubmit(e) {
  var formResponse = e.response;
  var itemResponses = formResponse.getItemResponses();
  
  var email = '';
  var subject = 'New Work Order Received';
  var body = 'Hello, a new work order has been submitted by RFE.<br><br>';
  
  for (var i = 0; i < itemResponses.length; i++) {
    var itemResponse = itemResponses[i];
    var title = itemResponse.getItem().getTitle();
    var response = itemResponse.getResponse();
    
    switch(title) {
      case 'Select Location':
        if(response == 'RAC') {
          email = '************';
        } else if(response == 'MAC') {
          email = '*************';
        }
        break;
      case 'Work Order Required':
        if(response != 'Yes') {
          email = '';
        }
        break;
      case 'Supervisor Name':
      case 'Supervisor Email':
      case 'Description of the issue':
        body += title + ': ' + response + '<br>';
        break;
      case 'Images':
        var fileIds = response.split(', ');
        for (var j = 0; j < fileIds.length; j++) {
          var file = DriveApp.getFileById(fileIds[j]);
          var url = file.getUrl();
          body += 'Image ' + (j+1) + ': <a href="' + url + '">Link</a><br>';
        }
        break;
    }
  }
  
  if(email != '') {
    sendEmail(email, subject, body);
  }
}

function sendEmail(email, subject, body) {
  MailApp.sendEmail({
    to: email,
    subject: subject,
    body: body,
    htmlBody: body
  });
}

function setUpTrigger() {
  var form = FormApp.openByUrl('link hidden');
  ScriptApp.newTrigger('onFormSubmit')
      .forForm(form)
      .onFormSubmit()
      .create();
}

 

 

0 0 45
0 REPLIES 0
Top Labels in this Space