Technology Geeks

How to Auto Insert Timestamp in Google Sheet

Google sheet is one of my favorite Google App and I use it . Today I came across a video on “How to add a Timestamp in Google Docs“. It shows how to install a script which will add a timestamp automatically to last column. While this is a very good script, but I wanted to make it better.

So I did some tweaking and now you can specify the column where timestamp should  get inserted. You can specify the column which trigger the timestamp script. You can specify the sheet where the script should run.

[contentblock id=20 img=adsense.png]

Below is the code:

/*Updated and maintain by*/

function onEdit(event)
  var timezone = "GMT-5";
  var timestamp_format = "MM-dd-yyyy"; // Timestamp Format. 
  var updateColName = "Email";
  var timeStampColName = "Date Sent";
  var sheet = event.source.getSheetByName('Sheet1'); //Name of the sheet where you want to run this script.

  var actRng = event.source.getActiveRange();
  var editColumn = actRng.getColumn();
  var index = actRng.getRowIndex();
  var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues();
  var dateCol = headers[0].indexOf(timeStampColName);
  var updateCol = headers[0].indexOf(updateColName); updateCol = updateCol+1;
  if (dateCol > -1 && index > 1 && editColumn == updateCol) { // only timestamp if 'Last Updated' header exists, but not in the header row itself!
    var cell = sheet.getRange(index, dateCol + 1);
    var date = Utilities.formatDate(new Date(), timezone, timestamp_format);

Watch below video on how to use this code:

Watch this video on YouTube.

Steps to follow:

  • Go to Tools -> Script editor
  • Delete code if there is any.
  • Copy above mentioned code and paste it into the script editor.
  • Change the code as instructed in the video.
  • Click save.
  • Give the project a name (e.g. “Last Updated”)
  • Done.

I hope that you find this tutorial useful. Please share this with your friends and if you have any queries then feel free to shoot them in the comment section.

Technology Geeks

64-Bit Chrome for Windows is Available for Download

Finally 64-bit Google Chrome browser is here and available for download. This is Chrome 37 with stable channel, which means you can trust it robustness and upgrade your 32-bit Chrome.

Google did not made this new 64-bit version default yet and will not automatically upgrade previous 32-bit version to new 64-bit. So you have to manually download and install it.  Go to this page and download 64bit Chrome.

Note on upgrade: You don’t have to uninstall previous 32-bit version. Just download and install this new 64-bit version and it will replace your 32-bit version perfectly. You will not loose any of your bookmarks, history, addons or settings.

Some of the benefits of new 64-bit Chrome browser are:

  • More speed, stability and security.
  • More speed for web graphics and media.
  • 15% improvement in YouTube video decoding performance. (faster YouTube HD videos)
  • As per testing 64-bit rendering engines are almost twice as stable as 32-bit engines when handling typical web content.
  • Better and improved “Profile switching” and incognito mode.

Some downsides to 64-bit version are:

  • I do see that 64-bit version is taking a bit more RAM compared to 32-bit. (my experience)
  • Google Earth and Google Voice don’t work because they’re 32-bit plugins
  • Lack of 32-bit NPAPI plugin support.  (though NPAPI will be removed from Chrome soon)


Other than few downside 64-bit version is awesome and you should upgrade it as soon as possible. In case you don’t like 64-bit version and have issues, you can always roll back to 32-bit version by downloading and installing it from here.

Please comment and let us know yours experience with new 64-bit Chrome browser.

Technology Geeks

How to Delete Website Property or View from Google Analytics

Google Analytics - How to Delete ViewGoogle Analytics is coming up with lots of cool features very frequently. Thus the usage and work flow changes frequently too. Recently website property are being renamed as “Views” in Google Analytics. Also the process or steps to delete these website property or view is different now. Thus I made this video and blog post to help you.

Watch this video on YouTube.

Remember that when you delete your view or website property, you also delete all data associated with that view or website. Once done it’s is not possible to get back that deleted data. So decide properly if you really want to delete your view/website property forever.

So without further ado here are the steps to delete website property (view) from your Google analytics account.

  1. Go to Admin at the top of any Analytics page.
  2. Use the menu in the PROPERTY column to select the view you want to delete.
  3. Then click on “View Settings” from VIEW column.
  4. Click on “Delete view” at bottom of the page.
  5. Confirm your delete by clicking on “Delete view” button.
  6. Done.

Now you will not be able to see that website property in your dashboard. All the data related to that property is gone.

I hope you find this tutorial helpful. Please share and comment.

Facebook Geeks Social Geeks

RockMelt, Social Surfing Made Fun and Easy

Social networking is the center of internet activity for people across all age groups. Almost everybody enjoys being connected with their friends and family whether by reading their latest tweets, photos or chat messages. With this in mind, the creators of RockMelt designed a solution that seamlessly integrates everything we love into a nifty browser.

RockMelt is a social media web based browser that lets you integrate your social media accounts. Unlike any other browser, RockMelt veered away from the central focus of fast page load times to a whole new social network experience. The browser has three main components; the Friend Edge, App Edge and Search Bar.

Familiar look

Their tagline “Your browser, Re-imagined” represents the very essence of RockMelt. It runs on the Chromium platform so users of Google Chrome will find it very familiar not only in the interface but in browser performance as well. At the same time, it re-imagines the web experience evolving from merely being more than a tool for web browsing to a platform for social interaction. The extensibility of RockMelt is uncanny as it is compatible with thousands of readily available Google Chrome extensions.

The very essence of RockMelt lies in Facebook. You are actually required to log-in to Facebook before you gain access to all of the browser’s features. As it is, RockMelt is just another Google Chrome spinoff but when logged in, it automatically loads your bookmarks and preferences, Facebook friend’s list and news feeds from your sites.

This lets you have a consistent RockMelt experience wherever you use a computer. The development team revealed that the architecture of the site would let them easily add other social network services in the future.

Stay Connected with Friends

One of the major components of RockMelt is its Friend Edge feature. It’s a thin sidebar to the left that shows a list of either your favorite friends or those who are available online for Facebook chat. Clicking on the portraits opens a pop up that displays updates from their Facebook and Twitter accounts. Your profile can be viewed by clicking on your portrait at the Friend Edge Bar. This is where you can update your Facebook status message or Twitter timeline.

The App Edge feature could be found at the right side of the screen. This contains a list of all your favorite sites and alerts you in push notification style. This mainly uses RSS feeds that are compatible with many websites. As a matter of fact, every time you visit a website with RSS it automatically creates an app for it. You could then add it to your favorites for easy access in the future. Apps for social networks are available as well. You can see your Facebook newsfeeds and notifications with the Facebook App. It also updates your Twitter timeline and supports lists with the Twitter App.

Search Made Easy

RockMelt has a feature filled Omnibox, but also a unique search bar. Whenever a search is performed, a drop down list of search results from your specified search engine is displayed. RockMelt then pre-renders these pages so that whenever a link is clicked it loads on your background almost instantly.

This search feature is designed to make searching faster without having to open multiple tabs just to be sure it’s a site with relevant content. Beside the search bar is a Search button that lets you share that website thru Facebook or Twitter.

RockMelt has certainly taken an interesting turn in browser innovation by incorporating something actually relevant – Social networking. The features of the browser make it easy for friends and families to keep in touch in a single location. So if you’re searching for a Social Networking App, you could drop by RockMelt and see what the site has to offer.

Download RockMelt Now.

SEO Geeks

The 4 Critically Essential Off-The-Page SEO Factors

In our last post we talked about the things you can do on your website to help it rank well in the search engines — in other words, the on the page factors. In this post we’re going to talk about the external factors that can influence your rankings — the “off the page” factors.

Your Google PageRank

Before we get into the “hows”, it’s important that you understand a little bit about Google’s PageRank. PageRank is Google’s way of indexing all content and websites based on importance in the internet community. It’s an important factor in Google’s ranking algorithm, and by understanding a little of how it works, you’ll have a better idea about how to boost your rankings in the world’s most popular search engine.

To establish the “importance” of your page, Google looks at how many other websites are linking to your page. These links are like “votes”, and the more “votes” you have, the greater your online “importance” and the higher your PageRank.

And higher PageRank is an important contributor to higher search engine rankings.

It’s not as democratic as it sounds, however: Not every page that links to you is given equal “voting power”. Pages that have a high PageRank have more voting power than pages with low PageRank. This means that the “boost” a link gives to your own PageRank is closely related to the PageRank of the site that’s linking to you.

For instance… receiving just ONE link from a PR5 page might well give you more benefit than receiving 20 links from PR0 pages. It’s quality not quantity that’s important.

The equation for working out how much PR value you’ll get from a link looks something like this:

  • PR = 0.15 + 0.85 x (your share of the link PR)
  • By “your share of the link PR” I mean that every site only has a certain amount of PR “juice” to give out. Let’s say a page has 100 votes. Lets say it has 20 outgoing links on that page. Then each link is sending 5 votes to the other site. (100 / 20 = 5) That is a simple way of looking at the share of the PR of the link. In reality the higher-placed links get higher voting power, (e.g. 10 votes each) while the lower-placed ones will get less, (e.g. 2 votes each).

There are many other factors at play that determine the PageRank of a page:

  1. The amount of PageRank flowing in to your page. PageRank can come from other sites linking to your page, but also from other pages on your website linking to your page.
  2. Your internal linking: As I just mentioned, PageRank can also come from other pages on your website, trickling from one page to another through your internal linking, menus and such. The trick is to “sculpt” the flow of your PageRank so that it “pools” in your most important pages. (In other words, don’t waste your PageRank by linking to your “contact us” page and site-map all over the show… add rel=”nofollow” to those links to stop the PageRank leaking through to them.)
  3. The number of pages in your website: the more pages your website has, the higher your PageRank will be.
  4. The number of external sites you link to. Again, think of PageRank as being something that “flows”. By linking to lots of other websites you’re letting your PageRank flow out of your page, rather than allowing it to pool. Try to have reciprocal links wherever possible, so that the PageRank flows back to you.

The best piece of advice is to keep these points in mind when building your site and try to avoid any on-page factors which might be detrimental to the “flow” of your PageRank through your site. Once you’ve done that, work on getting quality links from quality websites. The easiest way to do this is to fill your website with useful, relevant information that makes people want to link to you!

And remember: PageRank is just part of Google’s ranking algorithm. You’ll often see pages with high PageRank being outranked by pages with lower PageRank, which shows that there’s much more at play here!

#1: Build lots of 1-way incoming links

Do this through article submissions, directory submissions, submitting articles to blog networks (such as the PLRPro blog network), buying links (e.g. from digital point forums), and so on.

But be careful…

Purchased links can sometimes be more powerful than links you get by more natural methods… but Google will penalize you if they know that you are buying links. One way they’ll nab you is if you buy a link on a monthly lease and then end up canceling it. One link might not be enough to send up the red flags, but some people buy and cancel hundreds of links in this manner.

A better idea is to buy lifetime links from places like, and to try to find links from websites that are on topics relevant to your own.

#2: Get some links from good sites

By “good sites” I mean websites that have a high PageRank, or sites with a high “trust” factor (such as Yahoo, Dmoz or sites with a .edu suffix. If you can get good links to the pages on your site that generate the most income for you, even better — if you can improve the ranking of these pages you’ll get more traffic, more conversions, and more money!

#3: Make sure that pages you gain links from are, in fact, indexed.

A link to your site won’t count for anything if the page that is linking to you hasn’t actually been indexed by the search engines. The search engines won’t see the link, and they won’t give you any credit for it. I see a lot of people submitting their sites to article directories and search directories, and then ending up on a page that the search engines don’t visit. This is pointless!

The good news is that it’s pretty simple to get all these pages indexed. All you have to do is let the search engines know about the page yourself. To do this you need to set up a webpage outside of your main site, such as a free blog or a profile. Make sure that the search engines are indexing this page, of course, and then every time you get a new link to your main site, write about it in your blog or Twitter profile! The search engines will see this and visit the other site — hey presto! The page is now indexed, and you’ll get credit for your link.

Important: Don’t link to this blog or Twitter profile from your main money website. Doing this will create a reciprocal link loop…

#4: Don’t loop your links

Reciprocal links aren’t as powerful as one-way links. This is why you want to receive one-way links from other websites whereever possible.

But there are also things called “reciprocal link loops” which are like bigger versions of this. I mentioned one in the last tip… A links to B, B links to C and C links to A. That’s a loop… it eventually comes full circle back to the first site. A “link loop” can get pretty large, but if it eventually ends up back at the start, it’s still a loop, and all links within the loop become less powerful. Small loops are the worst, but try to avoid loops wherever possible.

Some Related Resources:

That brings us to the end of our critical off-page factors for search engine optimization. Feel free to ask any question you have and don’t forget to leave your valuable comment for this post.