i'm using google scripts editor in correlation google sheets , forms. there form logs user's email address , stores inside sheet.
i have used:
var username = sheet.getsheetvalues(numrows, 2, 1, 1); //getting username this returns object "testuser@domain.com" send function titled "removeemail"
var newname = removeemail(username); ...
function removeemail(input) { var name =input; var stringlength = name.length; var sub = name.substring(0,stringlength-10); logger.log(sub); //return sub; } when created function had defined email test with, lived inside removeemails function. logger showed removing domain name perfectly. however, when implemented inside bigger main function function errors out. message is:
typeerror: cannot find function substring in object testuser@domain.com. (line 24, file "removeemail")
i believe because function removeemails meant strings, uses string library, way grab data sheet doesn't store variable string. have tried
username.tostring(); before call removeemails, , inside removeemails can't rid of error.
according docs, getsheetvalues returns 2-dimensional array, not string. try getting username this:
var values = sheet.getsheetvalues(numrows, 2, 1, 1); //getting username var username = values[0][0]; // first row, first column since we're requesting 1 cell 