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.
Strict equality (===): a === b results in true if the value a is equal to value b and their types are also the same.
ISBLANK returns TRUE if value is empty or a reference to an empty cell, and FALSE if it contains data or a reference to data.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With