title: Uploading images to a Google Spreadsheet using Apps Script
body: <p>I'm new to scripting. I have copied the code from here <a href="https://stackoverflow.com/questions/15461170/upload-an-image-to-a-google-spreadsheet/15474002#15474002">Upload image to Google Spreadsheet</a></p>
  
  <p>The original script allowed a user to upload 1 image via the web app form and then the image would append to a row in a Google spreadsheet and into a Google Doc. I have been able to modify the web app form to allow a user to upload 2 images, but I can't figure out how to get the second image into the spreadsheet and doc.</p>
  
  <pre><code>    var submissionSSKey = 'Google Spreadsheet key';
  var docurl = 'Google document URL'
  var listitems = ['Select a category','Portrait','Landscape','Other','Night shots','Nature','Various']
  var Panelstyle = {'background':'#dddddd','padding':'40px','borderStyle':'solid','borderWidth':'10PX','borderColor':'#bbbbbb'}
  
  function doGet() {
    var app = UiApp.createApplication().setTitle('Photography contest').setStyleAttribute('padding','50PX');
    var panel = app.createFormPanel().setStyleAttributes(Panelstyle).setPixelSize(400, 200);
    var title = app.createHTML('&lt;B&gt;Photography contest&lt;/B&gt;').setStyleAttribute('color','grey').setStyleAttribute('fontSize','25PX');
    var grid = app.createGrid(7,2).setId('grid');
    var list1 = app.createListBox().setName('list1').setWidth('130');
     for(var i in listitems){list1.addItem(listitems[i])}    
    var Textbox1 = app.createTextBox().setWidth('150px').setName('TB1');
    var email = app.createTextBox().setWidth('150px').setName('mail');
    var upLoad = app.createFileUpload().setName('uploadedFile');
    var upLoad1 = app.createFileUpload().setName('uploadedFile1');
    var submitButton = app.createSubmitButton('&lt;B&gt;Submit&lt;/B&gt;'); 
    var warning = app.createHTML('Please fill in all fields').setStyleAttribute('background','#bbbbbb').setStyleAttribute('fontSize','18px');
    //file upload
    var cliHandler2 = app.createClientHandler()
    .validateLength(Textbox1, 1, 40).validateNotMatches(list1,'Select a category').validateEmail(email).validateNotMatches(upLoad, 'FileUpload');
  
  
    var cliHandler3 = app.createClientHandler()
    .validateNotMatches(upLoad1, 'FileUpload').forTargets(submitButton).setEnabled(true)
    .forTargets(warning).setHTML('Now you can submit your form').setStyleAttribute('background','#99FF99').setStyleAttribute('fontsize','12px');
  
    //Grid layout of items on form
    grid.setWidget(0, 1, title)
        .setText(1, 0, 'Category')
        .setWidget(1, 1, list1.addClickHandler(cliHandler2))
        .setText(2, 0, 'Name')
        .setWidget(2, 1, Textbox1.addClickHandler(cliHandler2))
        .setText(3, 0, 'Email')
        .setWidget(3, 1, email)
        .setText(4, 0, 'Image File')
        .setWidget(4, 1, upLoad.addChangeHandler(cliHandler2))
        .setWidget(5, 1, upLoad1.addChangeHandler(cliHandler3))
        .setWidget(6, 0, submitButton)
        .setWidget(6, 1, warning);
  
    var cliHandler = app.createClientHandler().forTargets(warning).setHTML('&lt;B&gt;PLEASE WAIT WHILE THE FILE IS UPLOADING&lt;B&gt;').setStyleAttribute('background','yellow');
    submitButton.addClickHandler(cliHandler).setEnabled(false);  
    panel.add(grid);
    app.add(panel);
    return app;
  }
  
  
  function doPost(e) {
    var app = UiApp.getActiveApplication();
    var ListVal = e.parameter.list1;
    var textVal = e.parameter.TB1;
    var Email = e.parameter.mail;
    var fileBlob = e.parameter.uploadedFile;
    var blob = fileBlob.setContentTypeFromExtension()
    var img = DocsList.createFile(blob);
    try{
    var folder = DocsList.getFolder('photos');
    }catch(e){DocsList.createFolder('photos');var folder = DocsList.getFolder('photos')}
    img.addToFolder(folder);
    img.removeFromFolder(DocsList.getRootFolder());
    var weight = parseInt(img.getSize()/1000);
    var sheet = SpreadsheetApp.openById(submissionSSKey).getSheetByName('Sheet1');
    var lastRow = sheet.getLastRow();
    var targetRange = sheet.getRange(lastRow+1, 1, 1, 4).setValues([[ListVal,textVal,Email,"https://drive.google.com/uc?export=view&amp;id="+img.getId()]]);
    var imageInsert = sheet.getRange(lastRow+1, 5).setFormula('=image("https://drive.google.com/uc?export=view&amp;id='+img.getId()+'")');
    sheet.setRowHeight(lastRow+1, 80);
    var GDoc = DocumentApp.openByUrl(docurl)
    GDoc.appendTable([['Category : '+ListVal,'Name : '+textVal,'Email : '+Email]])
    var inlineI = GDoc.appendImage(img);
    var width = inlineI.getWidth();
    var newW = width;
    var height = inlineI.getHeight();
    var newH = height;
    var ratio = width/height;
  
  
    var fileBlob1 = e.parameter.uploadedFile1;
    var blob1 = fileBlob1.setContentTypeFromExtension()
    var img1 = Doclist.createFile(blob1);
    try{
    var folder = DocsList.getFolder('photos');
    }catch(e){DocsList.createFolder('photos');var folder = DocsList.getFolder('photos')}
    img1.addToFolder(folder);
    img1.removeFromFolder(DocsList.getRootFolder());
    var weight = parseInt(img1.getSize()/1000);
    var sheet = SpreadsheetApp.openById(submissionSSKey).getSheetByName('Sheet2');
    var lastRow = sheet.getLastRow();
    var targetRange = sheet.getRange(lastRow+1, 1, 1, 5).setValues([[ListVal,textVal,Email,"https://drive.google.com/uc?export=view&amp;id="+img1.getId()]]);
    var imageInsert = sheet.getRange(lastRow+1, 6).setFormula('=image("https://drive.google.com/uc?export=view&amp;id='+img1.getId()+'")');
    sheet.setRowHeight(lastRow+1, 80);
    var GDoc = DocumentApp.openByUrl(docurl)
    GDoc.appendTable([['Category : '+ListVal,'Name : '+textVal,'Email : '+Email]])
    var inlineI = GDoc.appendImage(img1);
    var width = inlineI.getWidth();
    var newW = width;
    var height = inlineI.getHeight();
    var newH = height;
    var ratio = width/height;
  
  
    Logger.log('w='+width+'h='+height+' ratio='+ratio);
    if(width&gt;640){
    newW = 640;
    newH = parseInt(newW/ratio);
    }
    inlineI.setWidth(newW).setHeight(newH)
    GDoc.appendParagraph('IMAGE size : '+width+' x '+height+' (eventually) resized to '+newW+' x '+newH+' for PREVIEW ('+weight+' kB)   ');
    GDoc.appendHorizontalRule();
    GDoc.saveAndClose();
    app.add(app.createLabel('Thank you for submitting'));
    return app
  }
  </code></pre>