javascript - Getting "undefined" when trying to get values from spreadsheet -

i'm getting "undefined" error when try value cell in spreadsheet. thing if execute same command different cell value in cell. difference between 2 cells way value produced.

the value in cell show correctly produced directly google form associated spreadsheet. value doesn't show when called, produced script created in google form.

script form (triggered on form submit):

// code set edit form url value @ cell "c2".  function assignediturls() {     var form = formapp.getactiveform();     var ss = spreadsheetapp.openbyid("my-spreadsheet-id")     var sheet = ss.getsheets()[0];      var urlcol = 3; // column number url's should populated; = 1, b = 2 etc     var formresponses = form.getresponses();      (var = 0; < formresponses.length; i++) {         var resulturl = formresponses[i].geteditresponseurl();         sheet.getrange(2 + i, urlcol).setvalue(resulturl);      }      spreadsheetapp.flush();  } 

table (changed html)

<table>     <tr> <!-- row 1 -->         <td>timestamp</td> <!-- a1 -->         <td>name</td> <!-- b1 -->         <td>edit form url</td> <!-- c1 -->     </tr>     <tr> <!-- row 2 -->         <td>5/26/2015 14:04:09</td> <!-- a2: value came form submittion-->         <td>jones, donna</td> <!-- b2: value came form submittion-->         <td>https://docs.google.com/forms/d/1-few-mxh_8g/viewform?edit2=2_abaoh9</td> <!-- c2: value came the script in form -->     </tr> </table> 

script in spreadsheet (triggered on form submit)

function onformsubmit(e) {      // script values different cells in spreadsheet      // , send them email.      var name = e.range.getvalues()[0][1]; // value cell "b2".     var editformurl = e.range.getvalues()[0][2]; // value cell "c2".      var email = 'my-email@university.edu';     var subject = "here goes email subject."     var message = 'this body of email , includes'                   + 'the value cell "b2" <b>'                   + name + '</b>. value retrieved correctly.'                    + '<br>but value cell "c2" <b>'+ editformurl                   + '</b> show "undefined".';      mailapp.sendemail(email, subject, message, {htmlbody: message}); } 

the email looks this:

sented by: my-email@university.edu

subject: here goes email subject.

body:

this body of email , includes value cell "b2" jones, donna. value retrieved correctly.

but value cell "c2" undefined show "undefined".

question:

what doing wrong?

get correct row, hard code column url:

var ss = spreadsheetapp.openbyid("my-spreadsheet-id") var sheet = ss.getsheets()[0];  var rowforlookup = e.range.getrow(); var columnofurl = 24; //column x var theurl = sheet.getrange(rowforlookup, columnofurl).getvalue();