Google Script to see if text contains a value

javascript google-apps-script
Sharon picture Sharon · Dec 11, 2013 · Viewed 96.7k times · Source

I have a google form that when the user submits it will trigger my function to run which is creating a summary of what they submitted as a Google Doc. I know it can automatically send an email but I need it formatted in a way that my user can edit it later.

There are some check boxes on the form -- but the getResponse() is only populated with the items checked and I need it to show all possible choices. Then I will indicate somehow what was checked.

I can't find a way to see if a text contains a value. Like in Java with a String, I could do either .contains("9th") or .indexOf("9th") >=0 and then I would know that the String contains 9th. How can I do this with google scripts? Looked all through documentation and I feel like it must be the easiest thing ever.

var grade = itemResponse.getResponse();

Need to see if grade contains 9th.

Answer

Serge insas picture Serge insas · Dec 11, 2013

Google Apps Script is javascript, you can use all the string methods...

var grade = itemResponse.getResponse();
if(grade.indexOf("9th")>-1){do something }

You can find doc on many sites, this one for example.

Related questions

TypeError: Cannot read property "0" from undefined

I'm getting a very weird undefined error: function login(name,pass) { var blob = Utilities.newBlob(pass); var passwordencode = Utilities.base64Encode(blob.getBytes()); var ss = SpreadsheetApp.openById(""); var sheet = ss.getActiveSheet(); var data = sheet.getDataRange().getValues(); var i=1; while (name != …

Read More
Count the cells with same color in google spreadsheet

I'm trying count the number of cells with the same background color and put the result in other cell with a script in google apps script, but I can't do it. I have the next script but not work and …

Read More
Convert column index into corresponding column letter

I need to convert a Google Spreadsheet column index into its corresponding letter value, for example, given a spreadsheet: I need to do this (this function obviously does not exist, it's an example): getColumnLetterByIndex(4); // this should return "D" getColumnLetterByIndex(1); // this …

Read More