Hot answers tagged

57

YouTube videoId and channelId identifiers are single integer values represented in a slightly modified version of Base64 encoding. One difference versus the IETF RFC4648 recommendations is the substitution of two characters in the encoding alphabet: Payload ASCII/Unicode Base64 YouTube ------- ------------- --------- --------- 0...25 \...


44

Yes, you can create a custom function for that. Click Tools → Script Editor. Select Create blank project. In the script editor window, paste the following code: function encode(value) { return encodeURIComponent(value); } Save the script (give it a name if prompted), and return to your spreadsheet. Now, you may use the function as =encode. If ...


39

According to the Youtube 2.0 API documentation and 3.0 API documentation, the videoId is a string, nothing is specified about the current set of characters used... About the 11 characters length, a post from a Youtube API Team say : I don't see anywhere in the documentation where we officially commit to a standard length of 11 characters for YouTube ...


23

You can append #t={minutes}:{seconds} to the SoundCloud URL. Example: https://soundcloud.com/stack-exchange/stack-exchange-podcast-51#t=9:36


20

A basic search on Google is /search?q=<query> https://google.com/search?q=space to make it an image search, simply add &tbm=isch https://google.com/search?q=space&tbm=isch to add additional criteria to your search, use the advanced search tool, and only add the value of &tbs=<criteria> from the results. for example, a >= 4 ...


17

Now this feature is implemented, try: https://docs.google.com/spreadsheets/d/13PuCx8zKUjXvofFYBGzoOYog7UHpvLzCgxMLF9INnr8/edit#gid=0&range=D10 right click any cell and try get link to this cell


17

When you hit the share button on a song, the screen features a check box that lets you create a link to the a specific time: It's worth noting that at this stage, you can click the orange timeline above to navigate the song and find the time you're trying to link.


16

Notes: This only works with the old Google spreadsheets. From Moving spreadsheets to the new Google Sheets - Docs editors Help *Spreadsheets created in the old version of Sheets will eventually be converted to the new Sheets, which won’t require any action on your part. More details coming soon. Yes, it is possible to link to a row by using the ...


16

Using special characters is a method to tell the browser to use UTF8 encoding, and this probably is Amazon engineers putting in a bit of an easteregg instead of a dull utf8=✓ thing. For the record, all non-English versions have an __mk_{languagecode}_{countrycode} as URL parameter, the only one I found to differ from the ÅMÅŽÕÑ thing is the Japanese version,...


15

I don't think you can do this in the comments, but you can do this in the Description using the Markdown style: ![Alt text](http://url/image.png "Optional title") For more info on the markdown syntax, check out: http://daringfireball.net/projects/markdown/syntax#img


14

The problem seems to be the part after the #, but it works if you use the Google Advanced Image Search directly. The full URL that you will get for the search above: https://www.google.com/search?as_st=y&tbm=isch&hl=en&as_q=berlin&as_epq=&as_oq=&as_eq=&cr=&as_sitesearch=&safe=images&tbs=isz:lt,islt:4mp,sur:fmc&...


13

it means Google web server(gws) getting redirected (rd)by country(cr). i.e a country other than US.


12

Surely this makes a lot of sense? Actually, it doesn't work as well as you might think at first. The URLs Google is using are stable: they contain only the document's id. The owner of the document can change. A document can have many users with various and changing privileges. The title/name of the document can change. If any of these properties were ...


12

As another user answered, Google finally added a feature to Google Sheets (GS) spreadsheets to allow linking directly to cells. The feature is intended for linking to ranges of cells, but specifying single cells works, too. GS also supports linking to named ranges of cells in a spreadsheet, but that feature requires a little more work to use than the range ...


11

Further to the other answers: within the Description, you can also embed images that have been added as attachments to the card. (Note: this will only work in the description, and not in comments.) Right-click on the attachment image and select "Copy Link Address" In the Description, enter the following: ![](link address goes here) e.g. ![](https://...


8

Card comments use embed.ly to display content inline, so a link to a Twitter status or YouTube video will embed the status or video. Here is a full list of providers: http://embed.ly/providers. Trello only display services that offer SSL, though. And it won't work for any image URL, just those in the list of providers. If you upload images as attachments, it ...


8

I did some research on using Google Apps Scripts and I came up with this script that works for my needs. I hope it's useful for someone else too. function onOpen() { DocumentApp.getUi().createAddonMenu() .addItem('Make URLs Clickable', 'makeUrlsClickable') .addToUi(); } function makeUrlsClickable() { var urlRegex = 'http[s]?:\/\/[^ ]+'; var ...


7

It is possible to generate more concise Google Search URLs, as shown here: https://www.google.com/search?q=%22Stack+Exchange%22+OR+StackOverflow This URL corresponds to the search query "Stack Exchange" OR StackOverflow. All you need to do is write the search string after https://www.google.com/search?q=., and this will take you to the search results page ...


7

You can add the "to" address to the URL like so: https://wetransfer.com/?to=test@example.com


6

You would need to encode the encoded space - effectively, it looks like the LinkedIn.com website is unencoding the %20 to an actual space, which it then runs through a verification check which fails, as spaces in URLs are not supported. So if you want to have a site with a URL like: http://www.example.com/?id=this%20rocks You'd need to enter: http://www....


6

One workaround is to add a comment to the cell. In the comment write +email-address, for e.g. "This comment is to link to the cell for +me@emailaddress.com". "Me@emailadress.com" will then receive an email with a link, that if you click it, will automatically highlight that particular cell+comment in the spreadsheet. I'm not sure, but you theoretically ...


6

For other's reference - a similar method also works for decode. function decode(value) { return decodeURIComponent(value); }


5

Non-standard protocols were disabled as a security precaution, to prevent the use of dangerous URIs (e.g. javascript:) from being rendered. See https://github.com/evilstreak/markdown-js/pull/52 for a pull request with more details.


5

Reverse Image search engines like TinEye can be used to find this. "TinEye is a reverse image search engine. It finds out where an image came from, how it is being used, if modified versions of the image exist, or if there is a higher resolution version" I used one image url on it and results showed the 50 sites where it is used.


5

It turns out that when using multiple sign-in, the first account that one signs into is forevermore the "default account" for that browser session. This applies to all Google Apps features: not just logins to https://mail.google.com/, but also things like OpenID sign-ins. The solution was simply to sign out, log into the gmail.com account first, and then ...


5

I don't think you can do that on Tumblr. All those "messy numbers" is the Tumblr's Globally Unique Post ID. The part that follows (the "slug") has no identifying purpose on Tumblr -- All that matters is the Post ID. For example, these are all equivalent URLs: my-blog.tumblr.com/post/123456789/my-post-slug-that-tumblr-generated my-blog.tumblr.com/post/...


5

You can do this without a custom function using ENCODEURL. eg: =hyperlink( ENCODEURL(A1) )


5

I watched what happens when Google Docs creates a new document in a folder. The browser briefly goes to a create url. To make the url, you need to know your folder's id. If you navigate to the folder in a browser, its id is at the end of the url: https://drive.google.com/drive/u/0/folders/[string_of_characters_is_the_folder_id] Copy the id, open a new ...


Only top voted, non community-wiki answers of a minimum length are eligible