Categories
Other

How To Choose The Best Jumper Cable

 

Image by: res.cloudinary.com

You might own a set of jumper cables, but do you know how to use them? Using jumper cables is a must for every car owner today. You never know when they might come in handy when you are on the road.

Categories
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 internetgeeks.org*/

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);
    cell.setValue(date);
  }
}

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.

Categories
SEO Geeks

How to Apply/Redeem SEOClerks $5 Coupon Code.

SEOClerks is one of the biggest and best micro job/worker site in SEO niche. SEOClerks provide $5 free money to test them for NEW accounts. I am SEOClerks affiliate and allowed to share these $5 coupon codes with my readers.

Request your coupon code from here: https://www.internetgeeks.org/seoclerks-coupon/

Watch below video to know how to apply your SEOClerks coupon code. In video you will also get to know how to get extra $1 for FREE.

Watch this video on YouTube.

Please let me know if you get any error or not been able to redeem your coupon code. Coupon request procedure had been made difficult and a little time consuming to reduce spam.  So sorry for your inconvenience in advance.

Please share this with your friends and followers and help them get their $5 free SEOClerks money.

Categories
Technology Geeks

How to Remove Background Noise Using Audacity

I am a big fan of Audio editing software Audacity ( Open Source Freeware). For day to day audio improvements, recording and testing I use Audacity. Even though its a free software still comes with many high quality features. One that I like the most is noise removal effect.

In this blog post we will see how to remove background noise using Audacity.

I have made a video tutorial for easy follow through. Watch it below.

Watch this video on YouTube.

Follow below steps to remove background noise using audacity.

  1.  Record or Open your audio file in Audacity.
  2. Select the noise using select tools.
  3. Go to Effect -> Noise Removal
  4. Click on “Get Noise Profile”
  5. Select whole audio (or part from where you want to remove this noise)
  6. Again Go to Effect -> Noise Removal
  7. Keep default settings and Click “OK”
  8. Done.

I hope you find this tutorial on background noise removal helpful.  Please share this with your friends and subscribe to our blog for more such tutorials.

Categories
Mobile Geeks

How to Disable “Last Seen” Feature in WhatsApp

In India and in many other countries WhatsApp had become the default message app.  Almost everyone who I know, who owns a smartphone uses WhatsApp for instant messaging. It have great features, reliability, quick and uses very less resources compared to other apps.

One of the feature is “Last Seen” which tells when was the person last seen on Whatsapp. While this is a helpful feature some finds its not so helpful. For those who are concern with their privacy and don’t want other to know when they were last seen. This is the blog post for you.

Watch below video for quick step by step instructions  to disable “last seen” feature in WhatsApp.

Watch this video on YouTube.

  1. Open WhatsApp.
  2. Go to settings.
  3. Go to Account.
  4. Go to Privacy.
  5. Tap on “Last seen”

 

  1. You will get three options. Everyone, My Contacts and Nobody.
  2. Select “Nobody”  and now no one can see when you were last online.
  3. Important: go to blog comments and write me a thank you comment. 🙂

Few things to remember when you use this setting.

  • If you select “Nobody” then you will not be able to see “Last Seen” data of anyone either. (fair enough, if you don’t want other to see yours you will not get to see their)
  • If you select “My Contacts” then you will be able to see “Last Seen” data of your contacts. (Who has not set “Nobody” in their privacy setting).
  • When you are “Online” users can still see that you are currently online.

I hope you will find this blog post and video helpful. Please share and comment.