Relative Content

Tag Archive for google-apps-script

Send email when selecting value from dropdown menu

In Column C I have a dropdown menu. When ‘Justin’ is selected, I want an email to automatically be sent. Likewise, when Chris is selected, I want a new email to be sent to Chris. I keep getting undefined variable errors with the following code.

createTextFinder returning null on production

The following code from a web application works perfectly when running in the code editor but it fails when launching from the link I get on implementation. It returns TypeError: Cannot read properties of null (reading 'getColumn'). So the problematic line is line 4: var col = ws.createTextFinder(fldName).findNext().getColumn();

createTextFinder returning null on production

The following code from a web application works perfectly when running in the code editor but it fails when launching from the link I get on implementation. It returns TypeError: Cannot read properties of null (reading 'getColumn'). So the problematic line is line 4: var col = ws.createTextFinder(fldName).findNext().getColumn();

createTextFinder returning null on production

The following code from a web application works perfectly when running in the code editor but it fails when launching from the link I get on implementation. It returns TypeError: Cannot read properties of null (reading 'getColumn'). So the problematic line is line 4: var col = ws.createTextFinder(fldName).findNext().getColumn();

createTextFinder returning null on production

The following code from a web application works perfectly when running in the code editor but it fails when launching from the link I get on implementation. It returns TypeError: Cannot read properties of null (reading 'getColumn'). So the problematic line is line 4: var col = ws.createTextFinder(fldName).findNext().getColumn();