Hot answers tagged

51

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 ...


38

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 ...


22

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


19

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


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

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.


15

You can do the same thing with headers as you can with bookmarks without creating a Table of Contents. Put the cursor on the header itself, then look at the address bar of your browser. It should change to update the fragment (hash - #) at the end like #heading=h.abc32def4 -- this should correspond to the link created in the Table of Contents. Copy that ...


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


15

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,...


13

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


13

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&...


11

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 ...


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://...


9

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 ...


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

You need to go to Google Takeout (https://www.google.com/takeout) and select Google Reader and do an export. The zipped file you download contains a fairly comprehensive export of your Google Reader settings: followers.json following.json liked.json notes.json shared-by-followers.json shared.json starred.json subscriptions.xml (an OPML file)


7

The short answer (the feed for Freeman's Mind) is: http://gdata.youtube.com/feeds/api/playlists/49C3B7EDD1624C55 The longer answer (to find this on your own): you need to go onto the creator's account page and click on the playlist for the show you want. The playlist ID (in this case, 49C3B7EDD1624C55) is found above the list of episodes, at the end of ...


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

You can use the Youtube Data API to retrieve the feed of all of the episodes. The key is to use the special category of 'Shows': https://gdata.youtube.com/feeds/api/videos? q=freemansmind &orderby=published &author=machinima &category=Shows &v=2


5

This is exactly what the original poster wanted and also what I wanted. I wanted to share this awesome tool for anyone else: http://snag.gy. You just ctrl+v after you print screen and it's there. There are also some editing tools (crop, drawing) if necessary.


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

The direct answer to your question is no. What you are asking for is a stemming wildcard operator, and Google Search does not currently offer one. A stemming wildcard lets you identify a group of search keywords having a common stem (prefix). In other words, a stemming wildcard stands for part of a search term. The asterisk is not a stemming wildcard. It ...


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