You have lots of files in your Google Drive and it can take some effort to find that elusive file you’ve been looking for. For instance, how do you quickly find the sales presentation that James shared with you last week? Or how do you locate a specific resume among the hundreds of other PDF files in your Google Drive folders? Like Gmail and Twitter, Google Drive supports a plethora of advanced search operators that will help you quickly find the exact file you’ve been looking for. You can use search operators on the Google Drive website and the Drive mobile apps. Chrome users can type drive.google.com in the search bar, press tab and enter the search query.Google Drive, by default, will return files where the search query matches the file’s title, the content or the file’s description. It can also identify objects inside photos so a search for “birthday” may retrieve images of cakes in your Drive. Drive will also perform a OCR and search for text … [Read more...] about How to Search Google Drive Like a Pro!
If you click an email link on a webpage, it opens your default mail program. Similarly, you can make phone numbers on your website “callable” meaning when someone clicks the phone number, it will launch the dialer on their mobile phone and initiate dialing of the specified phone number. It is recommended that you make phone numbers clickable as more and more people would be accessing your site on their mobile devices.How to Insert Clickable Phone Numbers in Web PagesWe use the simple tel protocol to convert a plain text phone number on a web page into a clickable telephone link. For instance, if you click this link on a mobile phone, it will open the phone dialer prefilled with the specified number. There’s no need to copy-paste numbers.How to Type Phone Numbers in a Google SheetIt is a bit tricky to type phone numbers inside Google Spreadsheets. Here’s why:Phone numbers are mostly made of digits preceded by the plus (+) symbol. The problem is as soon … [Read more...] about How to Make Phone Numbers Callable in Google Sheets
Google Forms have this “all-or-none” problem. The forms are either public (anyone can fill your form) or, if you are on Google Apps, you can create forms that are visible to everyone in your organization. It is however not possible to restrict access to forms to specific people.Another shortcoming is that Google Forms do not allow passwords or CAPTCHAs to prevent spam bots from filling your forms with random data. Google itself maintains the reCAPTCHA project but it is not known if integration with Google Forms is in the works. There is a workaround, though.Google Forms do not support CAPTCHA but they do offer an option to attach images with questions. These can be used as picture passwords. The idea is simple.We add a multiple-choice question where the user is asked to pick an image from a selection of multiple images. If they select the correct image, the main form is displayed else an error message is shown. Also, these images are … [Read more...] about How to Add a Picture Password to your Google Forms
Introducing Save Emails, a new Google Docs add-on that will help you easily save email messages and file attachments from Gmail to your Google Drive automatically. The emails threads are converted and saved as PDF files in Drive while the attachments are saved in their native format. You can use the Google add-on to save images, videos, Office documents, project backups and everything else from Gmail to your Google Drive. It also supports the Gmail size search operator so if your mailbox is running out of space, use the add-on to quickly move the large file attachmetns to Drive and delete the corresponding email from Gmail.The YouTube video will help you get started in 2 minutes.All you have to do is visually create a rule, similar to how your create filters in Gmail, and then specify a folder in your Google drive. The add-on runs in the background and will automatically download the matching emails to the corresponding Drive folder. You can choose to save the email message only, the … [Read more...] about How to Save your Gmail to Google Drive Automatically
The Form Notifications add-on sends the Google Forms data in an email message each time a respondent submits then form. It can also send automated emails to the form respondents immediately after they complete your Google Form. The notifications add-on for Google Forms add-on has been updated and it can now send push notifications to your mobile phones as well. That means when respondents complete and submit your online Google Form, you’ll get an instant real-time notification (sample) on your iPhone or Android phone. The notification text can also include answers from the Google Form.A fast response time is a key to success, especially in areas like customer service and closing sales leads, and mobile notifications will ensure that your important form entries are never lost in the daily deluge of emails.Setup Mobile Notifications for Google FormsIt takes a few easy steps (video tutorial) to get up and running. Install the Email Notifications for Google … [Read more...] about How to Receive Push Notifications for Google Forms on your Mobile Phone
Google Forms are the best service for creating online forms but they miss a few key features found in commercial web form builders. For instance, Google Forms do not allow file uploads to Google Drive, there’s no support for CAPTCHAs to prevent spam and, what may be of interest to the legal and retail industry, Google Forms cannot capture electronic signatures. A school teacher may want to build Google Forms where students can upload assignments and the files are automatically saved to her Google Drive but in separate student folders. The HR department of a company may want to build an online form where job applicants can upload their resumes in PDF or Word format. File Upload Forms Demo Google Forms do not allow file uploads but here’s a workaround. To get an idea, open this sample web form and you’ll find that it has all the fields found in native Google Forms but a few extra ones as well. There’s a file … [Read more...] about How to Create Forms that allow File Uploads to Google Drive
The prices of products listed on the Amazon shopping website vary every day and a simple Google Spreadsheet can help you keep monitor and track these price fluctuations via email. Just add the items that you wish to buy from Amazon in a spreadsheet and it will send you an email alert when the product’s price drops on Amazon. You’ll thus never miss the deal again. The Amazon price tracker is easy to configure. All you have to do is add the links (URLs) of Amazon product pages inside a Google Spreadsheet. For instance, here’s the product page for iPad and here’s the search page for iPad – you need to put the URL of the product page in the spreadsheet.The price tracker is available in free and premium editions. The latter allows you to track 600+ products in a single spreadsheet and you can also set the target price for individual products. Features Free Premium Supports all Amazon country-specific websites like .com, .co.uk … [Read more...] about How to Use Google Sheets as an Amazon Price Tracker
Google Domains, if you are new, is a domain registration service where you can buy new domain names or transfer your existing domains from another registrar into the Google service. There’s no official announcement yet but Google Domains are now available in India without you having to use any hacks or proxy servers. I own about a dozen-odd domains and they have been mostly purchased through Gandi, GoDaddy, Dreamhost, and BigRock. Last week, I purchased a new domain reverse.photos through Google Domains and, like most other Google products, loved the overall experience.Everything is tied to your main Google account so there’s one less set of credentials to remember and the account is already secured with 2-factor authentication.Google Domain includes intelligent and powerful search that will not only suggest domain names based on exact keyword matches but related words too. So a search for “blue widgets” will check the availability … [Read more...] about Google Domains Go Live in India – The Best Place to Buy Domain Names