19 October 2014

Remove Images From Google Maps Views



If you've added photos to Google Maps Views and you'd like to remove them, Google offers a few options: removing photos from Google Maps Views and Google Maps or deleting photos from all Google products, including Google+. Photos are stored in Google+, not in Google Maps.






Open the photo page in Google Maps Views, click "Remove from Google Maps and Views" and you'll see this confirmation dialog: "Your image will remain in Google+, but will be removed from Google Maps products. This may take up to 24 hours."






If you click the "delete" button instead, your photo is deleted from Google+ and all the Google services that use it.






"When uploading your photos to Google Maps Views, your content will be publicly visible to other users. Geolocated photos that are shared on Google Maps may also be displayed in a variety of Google products and services, such as Google Maps for mobile, Google Earth, Google Search, Google+, Google+ Local, and third party sites using embeddable widgets or the Google Maps API," informs Google.



There are other ways to remove photos from Google Maps Views: make the Google+ album private or uncheck the "Show location data" setting in the album properties.



{ Thanks, Jordan. }

Earth View, New Tab Page Powered by Google Maps



"Earth View displays a beautiful and unique Satellite image from Google Maps every time you open a new tab." It's a Chrome extension that replaces the new tab page with a random Google Maps image.






If you want to find more the satellite image, click the globe icon at the bottom of the page and you'll open the current view in Google Maps.



While the Earth View images are fascinating, you'll probably miss some of the features from the standard new tab page: bookmarks bar, frequently visited pages, Google's doodles and navigation links. Earth View only shows a link to Chrome's apps page.





Translate Selected Text in Chrome



Chrome has a built-in translation feature, so why would you install an extension for Google Translate? You can select text from a page, click the small Google Translate icon and get the translation almost instantly.






You can also click the extension's button and type some text you want to translate or click "translate this page".






The nice thing about the extension is that you can change your primary language in the extension's settings without changing your browser's interface language or your operating system's language. For example, Chrome for Mac "determines the browser interface language by the Language & Text setting in System Preferences."






"The Translate team is working hard to connect people by breaking language barriers across computers, mobile devices and Internet browsers. Our users make more than 1 billion translations a day," informs the Google Translate blog.

16 October 2014

How to Color Alternate Rows in Google Sheets



Microsoft Excel and other programs in Microsoft Office provide a handy feature called “Quick Styles” to help you quickly format a selected range as a striped table. The table can have zebra lines meaning alternating rows are formatted with different colors (see example).


Alternate Row Colors in Google Sheets


Google Sheets do not support zebra stripes (yet) but you can use conditional formatting combined with a simple Google Formula to create a formatted table. You can apply alternating colors to both rows and columns in Google Sheets easily.


Here’s the trick.


Open a Google Sheet and choose Conditional formatting from the Format menu. Select Custom Formula from the dropdown and put this formula in the input box.



=ISEVEN(ROW())

Select a Background color for the rule and set the range in A1 notation. For instance, if you wish to apply alternating colors to rows 1 to 100 for columns A to Z, set the range as A1:Z100.


Click the “Add another rule” link and repeat the steps but set =ISODD(ROW()) as the custom formula and choose a different background color. Save the rules and the zebra stripes would be automatically applied to the specified range of cells.


Google Formulas with Conditional Formatting


Tip: If you wish to extend this technique to format columns with different colors, use the =ISEVEN(COLUMN()) formula. Simple!




This story, How to Color Alternate Rows in Google Sheets, was originally published at Digital Inspiration on 16/10/2014 under Google Docs, Internet

Use Google Sheets for Multilingual Chat with Speakers of Different Languages



You can only speak and write English so how do you converse with a person in China who writes Mandarin but doesn’t understand a word of English? Google Translate is no doubt a good option but it is going to be tedious for you (and your Chinese friend) to translate each and every sentence manually before sending them through any messenger.


How do you break down the language barrier and chat with someone in another country when there’s no ‘common’ language between the two parties? Microsoft is building a version of Skype for that will allow real-time translation for voice and video calls. You can watch the video demo though the actual software is expected to become available for Windows 8 later this year.


There’s another option now for people looking to have multi-lingual text chats – Google Sheets. Since two people can work on a Google Sheet simultaneously, it can actually work as a simple chat client. And if you integrate the same sheet with Google Translate – which is easy – the text typed inside Google Sheets can be translated in real-time and automatically (Demo GIF).


Google Chat - Multi Languages


Multi-lingual Chat with Live Translation


Here’s the idea. You have two participants speaking different languages that have opened a Google Sheet at the same time. There are 2 columns in the sheet for each participant. Now Participant A can write text in his own language in column A and the translated version in Participant B’s language will appear instantly in the second column. And vice-versa.


To get started, open this Google Sheet and choose File -> Make a copy to make your own copy of the sheet in your Google Drive. Now hit the share button in your sheet and share it another person with “edit” permissions (since he or she would write the text inside your sheet).


That’s pretty much it. All you have to do now is put your name and your friend’s name in cells C4 and G4 respectively. Also select your native languages from the drop-down in cell C5 and C6. Now type anything in the yellow cell and it will appear in the second column in the participant B’s language. Similarly they can write in the green cell and the translated text would show up in your column.


Multi-lingual Chat in Google Sheets


Internally, the sheet is powered by Google Scripts. And it supports all language pairs that are supported by Google Translate from Hindi to French to German to Tamil. Give it a try!




This story, Use Google Sheets for Multilingual Chat with Speakers of Different Languages, was originally published at Digital Inspiration on 16/10/2014 under Google Translate, Internet

01 October 2014

Open Gmail Images in Google Drive Viewer



Gmail now treats embedded images just like image attachments. You can mouse over an image and click "Download" and "Save to Drive" or you can click the image to open it in the Google Drive viewer, which has additional features like printing, Google+ sharing, zooming, opening the file in a Google Drive app and more. It's also great for opening the image in full-screen mode. You can use the arrow buttons or press right/left arrow keys to open the next/previous image.









"Similar to attachments, you can now click on large images within a message to see them full-screen in Gmail on the web," informs Google. It's not clear what's the minimum image size to get these features, but it didn't work for a 384 x 103 image and a 266 x 210 image, while it worked for a 306 x 198 image.



{ Thanks, Herin Maru. }

30 September 2014

Add Collaboration Features to your Website with a Line of Code



Tools like Google Docs include real-time collaboration features that let multiple people work on the same document or spreadsheet at the same time. Then you have screen sharing tools, join.me or Chrome Remote Desktop for example, where there’s a master presenter and remote viewers can follow along.


Website with Real-time Chat

TogetherJS is a Mozilla project that brings similar collaboration features to your own website but without any coding. Once enabled, visitors to your website will be able to interact with each other on your site in real time.


They’ll able to see each other’s cursor (like in Google Docs), the clicks are highlighted and the screen content stays synchronized. Visitors will also have the ability to text chat and audio chat (using WebRTC) with each other while staying on your website. All this and more with a line of code.


Add TogetherJS to your own Website


To get started, all you have to do is insert a little JavaScript snippet anywhere on your web page(s). There are several configuration parameters available for the widget but we will use the default settings to keep things simple.



<script>
TogetherJSConfig_autoStart = true;
</script>
<script src="http://ift.tt/1vtXj93;

This will add a little floating widget to your website that will be visible to all visitors. They can click the “+” button in the widget to generate a unique TogetherJS URL. Anyone who clicks this URL will be able to interact with each other on your page in real time. It can’t get any simpler.


I have put up a quick page where you can test TogetherJS capabilities. Click the “+” icon and send the unique URL to another person to chat in real-time.


Add TogetherJS to any Website


There’s more. You can add TogetherJS features to any web page on the Internet with the help of a bookmarklet.


TogetherJS


This bookmarklet will load the TogetherJS library on the current web page and you can give the chat session a unique name. Another person can launch the bookmarklet on the same page on their own computer, enter the same session name and you’ll be instantly connected.


You can co-browse, watch each other’s activity or chat atop the page.




This story, Add Collaboration Features to your Website with a Line of Code, was originally published at Digital Inspiration on 30/09/2014 under Bookmarklet, Web Design, Internet

Restrict Google Forms to only Allow One Entry Per Person



You have created a survey using Google Forms but people have quickly figured out a way to game your poll and tilt the results in their favor. They are submitting multiple entries, and because Google Forms will not record the I.P. address or the email of the form submitter, it is nearly impossible for you to separate the duplicate submissions from the genuine entries.


How do you restrict Google Forms to only allow a single entry from a user?


If you are a Google Apps user, you can always restrict the Google Form to accept entries only from users who are part of your domain and the response spreadsheet will then record the username of the form submitter. However if you have a regular Gmail / Google Account, you have another option now to prevent multiple form submissions from the same user.


While creating the Google Form, click the Settings bar and turn on the option that says “Allow only one response per user.” When the unique option is enabled for a Google Form, respondents will have to sign-in with their Google account to access the form. Their email address won’t be recorded in the response sheet but Google Form will not allow another entry from the same Google Account.


If someone tries to fill the Google Form again, a warning message will be displayed saying “You’ve already responded. You can only fill out this form once. Try contacting the owner of the form if you think this is a mistake.”


This is by far the easiest approach though it does put your Google Form out of reach of people who do not have Google Account or those who are skeptical of associating the email address with their form entry (though this association is completely hidden from the form owner).


Google Forms - Multiple Entries




This story, Restrict Google Forms to only Allow One Entry Per Person, was originally published at Digital Inspiration on 30/09/2014 under Google Forms, Internet

29 September 2014

Google Tests Icon for Smartphone-Optimized Results



A Google experiment shows a special icon next to smartphone-optimized search results. Obviously, the icon is only displayed when searching from smartphones.






Back in 2012, Google ran a similar experiment, but it never became a regular feature.



Google has a few articles about building smartphone-optimized sites. Google supports three different configurations: responsive design (same code, same URL - Google's recommended configuration), dynamic serving (different code, same URL) and separate mobile sites (different code, different URL).



{ Thanks, Herin Maru. }

Bonus Storage for Google Maps Views



Sushubh Mittal noticed 8GB of bonus storage in his Google account. The bonus storage is for Google Maps Views and doesn't expire.






Other users got 15GB, 67GB, 72GB of free storage, so it looks like Google's bonus is not the same for everyone. It's not clear how you can obtain the Google Maps Views bonus, but I assume it could be influenced by the number of photos and panoramic images you add to Google Maps Views, the number of photos approved to be displayed in Google Maps and their popularity.



All the photos you've publicly shared in Google+ and they're also tagged with a location and have the "Show location" setting checked are automatically added to Google Maps Views and some of them are added to Google Maps. "Google Maps tries to algorithmically choose a variety of interesting, high-quality photos that give you a sense of place. To keep the focus on the location, photos that have people in them are typically not chosen," explains Google.



You can check your storage here: mouse over the chart to see the breakdown.

28 September 2014

Android Verification Code for Google Accounts



When you're signing in to a Google account from a different country, Google asks you to confirm your identity. You can enter your recovery email address or phone number, enter a verification code received in an SMS messages or voice call and now you can enter a code generated by your Android device.






"If you're signing in from a different location than you usually do, we may ask you to enter a code from the Google Settings app on your Android phone or tablet to make sure you own the account. You don't need an internet connection or phone/SMS connectivity to get codes using this app."






The Google Settings app is the UI for Google Play Services, Google's framework that delivers new features and APIs without installing a new Android version. It has nothing to do with the built-in Settings app, which is part of the operating system and can't be updated by Google.



The verification code has 8 digits and it can be obtained by opening the Google Settings app, tapping the menu button and selecting "Get verification code".



{ Thanks, Herin. }

27 September 2014

Chrome's Offline Easter Egg



Chrome's latest Canary release has an updated offline error page. It still includes a small dinosaur image, a funny way to show how quickly your computer can become a relic from the past without an Internet connection.






The error page has an Easter Egg: if you press space, it lets you play a game. "Your only goal is to avoid hitting cacti. The T. Rex jumps by hitting the space bar. Fret not if you do hit an obstacle, because Chrome T. Rex doesn't stay down for long. (Hit the game-over refresh icon, and you're back at it.) The game tracks your progress and high score, but stats are lost if the window closes or is refreshed," reports Mashable.





Google's 16th Birthday Doodle



Google has an animated doodle for its 16th birthday. It's not a game like last year's doodle, but it's still funny. This time, Google shows the world how much it has grown.






"When's Google’s birthday? I'm not sure even we know – we've celebrated on September 7th, 8th, 26th, and, most recently the 27th. Still, while there’re some differing opinions about when to bust out the candles and cake, one fun fact is that our first doodle was posted even before Google was officially incorporated," says Google.



You can find Google's previous birthday doodles on this page.



Happy Birthday, Google!

26 September 2014

New Interface for Google Takeout



Google Takeout has a new interface. It's easier to pick the services you want to include in an archive and you can now store archives in Google Drive.



"After we finish creating your archive, we will add your archive to Drive and email you a link to its location. These archives will count against your storage quota," informs Google.






Some services let you select the data you want to export: Gmail labels, calendars, Google Drive folders, Blogger blogs, Google+ photo albums, books.









Google can create a download link that expires after a month or save the archive in Google Drive.















{ Thanks, Florian Kiersch. }

Mobile IE Doesn't Show Google Suggestions



If you've changed the search provider to Google in Internet Explorer for Windows Phone and you're wondering why search suggestions aren't that great, there's an explanation: Internet Explorer shows suggestions from Bing even if you're using Google.



Let's say I type in the address bar: "the best way to". Here are the suggestions:






And here are Google's suggestions:






If you go to IE's advanced settings, you'll notice that you can enable or disable "get suggestions from Bing as I type". To get Google's suggestions, you can go to google.com, install Google's app for Windows Phone or install a different browser.









So why would Microsoft show Bing suggestions if you've changed your search provider to Google? Maybe it's an excuse for Microsoft to send all your queries and partial queries to Bing, so that it can improve its search engine.

25 September 2014

Google Structured Snippets



A few weeks ago, I noticed that Google shows facts next to some Wikipedia results. This feature is called Structured Snippets and it's not limited to Wikipedia results.



"Structured Snippets is a new feature that incorporates facts into individual result snippets in Web Search. As seen in the example below, interesting and relevant information is extracted from a page and displayed as part of the snippet for the query [nikon d7100]," informs Google.






"Structured Snippets is the latest collaboration between Google Research and the Web Search team employing that data to seamlessly provide the most relevant information to the user. We use machine learning techniques to distinguish data tables on the Web from uninteresting tables, e.g., tables used for formatting web pages. We also have additional algorithms to determine quality and relevance that we use to display up to four highly ranked facts from those data tables," mentions the Google Research blog.



You don't need special formatting: Google extracts information from existing tables. It's interesting to notice that Google has always used tables from web pages to extract useful data. Google Sets, one of the earliest Google Labs services, used lists and tables from web pages to generate lists of related terms. Google also built a search engine for tables and shows data from tables in cards and snippets.

Obscure Google Maps Results



When you add "google maps" or "map" to a Google query related to a location, it's likely that you'll see a Google Maps card. For example, searching for [google maps bop], [map bop] or [bop map] returns a map for the Bouar Airport (BOP) from the Central African Republic.






Sometimes this feature doesn't work very well. I searched for [google maps location history] and Google returned this map for Location History Collection, a museum from Hungary that appears to be permanently closed. It's obvious that the Google Maps Location History page is more important and should be displayed first.