Skip to main content

Posts

Showing posts from July, 2021

Link image to an url in googlesheet

To create a link to an image and access external url in googlesheet is quit easy by using a simple app script. This is very usefull for creating multiple links to different websites or clients. Use following script : - function   imageLink () {    var   html  =  "<script>window.open('https://tekrayz.blogspot.com/');google.script.host.close();</script>" ;    var   userInterface  =  HtmlService . createHtmlOutput ( html );     SpreadsheetApp . getUi (). showModalDialog ( userInterface ,  'Loading...' ); } Also watch video - >