Created
May 7, 2017 13:52
-
-
Save barrieroberts/eca98a641734f6ae68618d8124dd3240 to your computer and use it in GitHub Desktop.
Apps Script Basics - if, prompt, menu, & onOpen trigger (2)
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi,I'm first time user to google script and have tried example7 which is getting me error "cannot call SpreadsheetApp.getUi() from this context"
here is my code
function prompt()
{
var ss =SpreadsheetApp.openById('XXXXXX');
var sh = ss.getSheetByName('Sheet');
var spreadsheet=ss.getActiveSheet();
Logger.log(sh)
var ui=SpreadsheetApp.getUi();
var response=ui.prompt('Enter name:');
}