title: Google Script: InputBox with drop down list spreadsheet (Not FORM)
body: <p>I have this simple script:</p>
  
  <pre><code>function myFunction() {
    var ssh = SpreadsheetApp.getActiveSpreadsheet();
    var ss = ssh.getActiveSheet();
    var s = ss.getActiveRange();
  
  
    var rowIndex = s.getRowIndex();
    var colIndex = s.getColumnIndex();
  
    // Get the number of columns in the active sheet.
    var colNumber = ss.getLastColumn();
    if (colIndex == 1 &amp;&amp; rowIndex != 1) {
  
    //Get User Name from inputBox
    var name = Browser.inputBox('Owner', 'Enter your Name', Browser.Buttons.OK_CANCEL);
    var r1 = ss.getActiveRange().getRow();
    //Insert the Name in the active row in the column 6
    ss.getRange(r1, 6).setValue(name)
  
    //Here I have other part of the code but is for copy rows to other sheet.
  
  }
  }
  </code></pre>
  
  <p>In column 6 have active data validation (not permit insert values ​​that are not in the list of items). 
  Example: Charles, Oscar, Paul, Other. If I enter the names all in lower case do not enter. If the value entered is identical as "Charles" the value is entered. </p>
  
  <p>Now, is possible these values ​​may appear as a drop down list in the inputbox? I mean, the user can select from that list and then press Enter or Ok and the value insert into the cell.</p>
  
  <p>Note: This is not a form. This is the spreadsheet.</p>
  
  <p>Thanks,</p>
  
  <h1>UPDATED: 01/09/2014</h1>
  
  <pre><code>function Historic(e) { //CopyRows
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var s = ss.getActiveSheet();
      if (s.getName() == 'ISP1'){
    var r = SpreadsheetApp.getActiveRange();
  
    // Get the row and column of the active cell.
    var rowIndex = r.getRowIndex();
    var colIndex = r.getColumnIndex();
  
    // Get the number of columns in the active sheet.
    var colNumber = s.getLastColumn();
  
  
      // Move row based on criteria in column 1, and if row is not the header.
      if (colIndex == 1 &amp;&amp; rowIndex != 1) { // 1 Is the Comment Column
  
      //Call the Function Menu List
      showNamePicker();
  
      //Get values for the active row bases on the criteria.
      var status = s.getRange(rowIndex, colIndex).getValue();
  
  // --------------- Copy ROW only when someone modify the Column1 --------------------------
  
         // Do nothing if criteria value is not actually changed to something else.
      if (s.getName() != 'Historic') { 
        // The target sheet is the one with the same name as the criteria value.
        var targetSheet = ss.getSheetByName('Historic');
        var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
  
        //=====Copy the Row from ISP1 to Historic=======
        s.getRange(rowIndex, 1, 1, colNumber).copyTo(target);
  }      
  }
  }
  }
  
  
  
  
  function showNamePicker() {
    var app = UiApp.createApplication().setHeight(100).setWidth(180);
    var handler = app.createServerHandler('setName');
    var list = app.createListBox().setName('list').addChangeHandler(handler);
    var names = ['Choose a name here','Charles', 'Oscar', 'Paul', 'Other'];
    for(var n in names){
      list.addItem(names[n]);
    }
    handler.addCallbackElement(list);
    app.add(list);
    SpreadsheetApp.getActive().show(app);
    }
  
  
  function setName(e){
    var ssh = SpreadsheetApp.getActiveSpreadsheet();
    var ss = ssh.getActiveSheet();
    var r1 = ss.getActiveRange().getRow();
    ss.getRange(r1, 6).setValue(e.parameter.list);
  }
  </code></pre>
  
  <blockquote>
    <p>Function Historic: If someone modify the Column 1, the script will copy all data in the row that was modify to historic.</p>
  </blockquote>
  
  <p>Needed:</p>
  
  <blockquote>
    <p>The script should be insert the name in the column 6 for that row before the script copy the row to the historic.</p>
  </blockquote>
  
  <p>Issue:</p>
  
  <blockquote>
    <p>When someone modify the column 1 the user press ENTER and the new active row change because is not the same and the script not insert the name in the row that was modify.
    For example:
    I modify the A2 and press ENTER the new row is A3, and the script will insert the information into F3 and not in F2.</p>
  </blockquote>
  
  <p>I tried to call the function before this line:
  <strong><br>   //Get values for the active row bases on the criteria.
  <br>    var status = s.getRange(rowIndex, colIndex).getValue();</strong>
  <br>
  but I'm still newbie... I this is very easy but I can't get with the solution.
  <br>
  <br>
  I will appreciate if you can help me.</p>
  
  <p>EXAMPLE:</p>
  
  <blockquote>
    <p>Change Cell A2 = ID#12578
    The script should be insert the name in the column F2 and then copy all row include the F2 in the sheet called Historic. (The script is not inserting the name into F2 is inserting in F3</p>
  </blockquote>