Google Apps Script to open a URL

by

This function opens a URL without requiring additional user interaction.

/**
 * Open a URL in a new tab.
 */
function openUrl( url ){
  var html = HtmlService.createHtmlOutput('<html><script>'
  +'window.close = function(){window.setTimeout(function(){google.script.host.close()},9)};'
  +'var a = document.createElement("a"); a.href="'+url+'"; a.target="_blank";'
  +'if(document.createEvent){'
  +'  var event=document.createEvent("MouseEvents");'
  +'  if(navigator.userAgent.toLowerCase().indexOf("firefox")>-1){window.document.body.append(a)}'                          
  +'  event.initEvent("click",true,true); a.dispatchEvent(event);'
  +'}else{ a.click() }'
  +'close();'
  +'</script>'
  // Offer URL as clickable link in case above code fails.
  +'<body style="word-break:break-word;font-family:sans-serif;">Failed to open automatically. <a href="'+url+'" target="_blank" onclick="window.close()">Click here to proceed</a>.</body>'
  +'<script>google.script.host.setHeight(40);google.script.host.setWidth(410)</script>'
  +'</html>')
  .setWidth( 90 ).setHeight( 1 );
  SpreadsheetApp.getUi().showModalDialog( html, "Opening ..." );
}

This method works by creating a temporary dialog box, so it will not work in contexts where the UI service is not accessible, such as the script editor or a custom G Sheets formula.

More Related Contents:

  1. Redirect from an HTML page
  2. Should I make HTML Anchors with ‘name’ or ‘id’?
  3. What is href=”#” and why is it used?
  4. Open link in new tab or window [duplicate]
  5. How to create an HTML button that acts like a link
  6. How to open link in a new tab in HTML?
  7. Linking to another HTML page in Google Apps Script
  8. Linking a UNC / Network drive on an html page
  9. How to pre-populate the sms body text via an html link
  10. Why would a developer place a forward slash at the start of each relative path?
  11. Can I create links with ‘target=”_blank”‘ in Markdown?
  12. Use a normal link to submit a form
  13. html – links without http protocol
  14. What are the ways to make an html link open a folder
  15. html links not working (using base href)
  16. Add target=”_blank” in CSS
  17. How to pass a parameter to html?
  18. HTML Favicon.ico won’t show on Google Chrome
  19. Link to a section of a webpage
  20. Is there a way to bookmark or link to a section of a page without an anchor?
  21. how to make a cell of table hyperlink
  22. Insert a Link Using CSS
  23. Link to reload current page
  24. How to make HTML open a hyperlink in another window or tab?
  25. How to navigate to a section of a page
  26. Does http-equiv=”refresh” keep referrer info and metadata?
  27. Chart data exported to an Apps Script webapp is null
  28. How to upload multiple files using one file input element
  29. How to open native iOS app (calendar, notes…) from a link on website?
  30. How to make a html page to show content from another url

Leave a Comment