New answers tagged

4

You can't. We use shortlinks like that internally and the recommendation applies to internal products only (e.g. a page changes the URL, we don't need to update the product and just update the shortlink). For your purposes, you can either use the direct link to the MSDN page or use one of the available URL shortening services.


1

After seeing Rubén's answer I decided to write a different custom function for this task, with the following features: The parameter is provided as a range, not as a string: that is, =linkURL(C2) instead of =linkURL("C2"). This is consistent with how parameters usually work, and makes the references more robust: they will be maintained if someone adds a ...


1

Short answer Use a custom function to get the quoted string inside a cell formula. Code The external post shared in the comment by Yisroel Tech includes a script that replaces each formula in the active range by the first quoted string in the corresponding formula. The following is an adaptation as custom function of that script. /** * Extracts the ...


2

Short answer While it's possible to use files stored in Google Drive as website resources at this time it's not officially supported and should not be used for websites that have a lifespan beyond August 31, 2016. Explanation The instructions to publish Google Drive files as website content are in Publish Website Content - Google Drive REST API but ...


2

That is the link to the Google Drive image viewer, rather than a link to the image itself. If you check the URL for the image when you visit that link, you get an URL like: blob:https%3A//drive.google.com/32efcf38-d7e6-4656-9046-eede4c4880f9 That's not useful. You need to do a little URL manipulation of your original URL to be able to hotlink it. You need ...


1

Yes, you can select all these files and get shareable links to them at once. Select files Right-click any of them and pick "Share.." out of the context menu. Click "Get shareable links" in upper right corner of the Share dialog window. This does several things at once: makes files accessible to anyone with a link, and copies the links to your clipboard. ...


0

I had the same issue and thought I'd share my work-around. Since Gmail only lets you insert web or email hyperlinks into the body of an email, I put my network hyperlinks in a Word doc and sent it as an attachment, instructing the recipients to download the attachment to their desktop and open it from there to access the hyperlinks. It's a little ghetto, but ...



Top 50 recent answers are included