Friday 28 December 2018

Set column Url link to Doc

The following Google Apps Script code is designed to create a clickable Url hyperlink (with a nice name) to a document on a spreadsheet. This has been developed for scenarios where documents are created on Google form submissions (eg Exceptional Circumstances or bulk student feedback) and it is necessary to provide a master spreadsheet where a user can easily access these documents from one screen rather than searching through Google Drive folders.

The code below includes an example docUrl and name which would not be in the function when you use it but is there for demo purposes. Setting the hyperlink requires creating a formula ('setFormula') that is a combination of the docUrl and given name, that is then appended to the last spreadsheet row.

Set Column Doc Link Folder

No comments:

Post a Comment