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 - >
By using formulas, scripts and buttons we can prepare a complete staff records form. In this form we can assign buttons such as entering the data to the data sheet, search details and clear the form by using script and buttons. Also, get image file url links in google sheet cell to display or enter the data along with other other details. We have detailed script and formulas below to use this form effectively to maintain the staff records. SCRIPT function GdriveFiles () { const folderId = 'YOUR GOOGLE DRIVE FOLDER LINK HERE' const folder = DriveApp . getFolderById ( folderId ) const files = folder . getFiles () const source = SpreadsheetApp . getActiveSpreadsheet (); const sheet = source . getSheetByName ( 'images' ); const data = []; while ( files . hasNext ()) { const childFile = files . next (); var info = [ childFile . getName (), childFile . ge