Get Notified When A Collaborator Made Some Changes On A Shared Google Spreadsheet

No matter how advance Project Management and CRM tools can get, no one can ever ditch Google Sheet.

Google Sheet is still one powerful tool that if you know how to exploit the service to your advantage, you know that it's more than just a spreadsheet-editing software.

And if you're using Google Sheet as an additional tool aside from your usual project management service, here's a nifty tip on how to enable email notification so you'll be notified in real-time whenever a collaborator is making some updates on a shared spreadsheet; no need for you to waste time waiting for hours for other collaborators to update the sheet.

Gmail's Addon Streak Lets You Monitor, Track If Emails Are Read, Viewed By Recipients

Enable Email Notification On A Shared Google Spreadsheet

Email notification for Google Sheet is actually a built-in feature, but not activated by default. You have to manually enable it to start receiving email notifications. Here's how:

• Open the spreadsheet where you want to get notified for any changes.
• Go to the Tools > Notification rules.
• In the window that popups, select when and how often you want to receive email notifications.
• When:
• “Any changes are made”
• “A user submits a form”
• How often:
• “Email - daily digest”
• “Email - right away”
• Hit Save.

You're done. Whenever someone made some changes on a shared spreadsheet, you'll be automatically alerted via email, like this:



You may also need to setup email push notification on your smartphone so that no emails will be missed.

Use Mover.io To Copy, Move Files From FTP To Google Drive, DropBox, SkyDrive and Vice Versa

Google Sheet is still my go-to place when it comes to working and collaborating with clients for a specific project. During a website pre-deployment, after the QA, we have a client review phase where a client is expected to inspect and jot down all design & functionality hiccups of a website. While BaseCamp, Asana or Teamwork may be used to collect the findings, I find it a lot time-saver and efficient if I can get a consolidated view of all findings inside a single Google sheet. And now that I can setup email notification, both the client and I can save time.

Get Notified When Someone Talks About You On The Internet

New Chrome Add-on Lets You Watch YouTube Videos While You Search, Browse — Similar to YouTube Mobile App

Last year, YouTube rolled out a massively popular update to their iOS and Android app which completely redefines every YouTuber's streaming experience. The revamped YouTube's mobile app gets a multi-tasking support which allows you to watch videos while you search and browse channels and playlists.

That was pretty useful, clever functionality which, unfortunately, YouTube's web app counterpart is currently deprived of.

Get Instant Lyrics for Grooveshark, Spotify and YouTube Web Players with This Cool Add-on

Now, if you heavily stream YouTube videos on your computer, you too can get the same multi-tasking treatment with this Chrome extension called Seek 'n Play.

Watch YouTube Videos and Search at the Same Time, Like On Your Mobile Phone (link)

Seek 'n Play is yet another useful Chrome extension that brings YouTube mobile's multi-tasking functionality to your desktop. With Seek 'n Play, you can search and browse for videos while you are watching another video, just like the mobile app.

How it works?

Every time you navigate to another video or you browse through another channels or playlists, the current playing video will be automatically positioned, fixed at the bottom of your screen so you can continue watching while you keep exploring YouTube . And that's a big user experience boost!

New Browser Extension Turn Off The Lights Gives YouTubers The Feel Like They're In A Cinema

Seek 'n Play is truly a great extension. It's lightweight, free, and it works great!



Download: Seek 'n Play or check out developer's website for more.

GistBox: The Best Place to Store, Organize Code Snippets and Pastes

Whether you are a seasoned coder or a newbie dabbler, you need a code snippets repository.

A code snippets repository is a place where you can keep a file of your own most-used codes so you can check back and copy the needed lines of codes without having to rebuild them from scratch. Code snippets will basically save you time when developing or administering a website as you no longer have to rewrite the codes to achieve the desired results.

For example, here's a tiny code snippet you can add in your .htaccess file to speed up your site:

Responsimulator: The Most Accurate, Reliable Web-Based iPhone, iPad Simulator Online

While there are already long standing, well-reputed code snippets storage sites freely available out there, there's not such an abundance of apps that can beautifully store and organize your code snippets similar to how GistBox works.

In this post, we're going to explore how GistBox can help you in becoming more productive and learn why you cannot stay away from it once you get your hands into it.

So, what is GistBox?

GistBox is another code repository service designed to make code snippet management a little less boring. GistBox uses GitHub's backend but it comes with its own advanced label and search functionality — the features which are missing in GitHub's Gist.

Use Mover.io To Copy, Move Files From FTP To Google Drive, DropBox, SkyDrive and Vice Versa

GistBox was designed to be a curated, personal snippet library – like long term memory for the practicing software engineer.

Here's a few reasons why GistBox is the best:

I like Gist, but it's too limited; it lacks of important functionality like being able to organize your code snippets via tags or labels. So here allow me to point out the notable goodness of GistBox.

Color-Coded Labels. You can create labels as much as you want and assign a color for each label. GistBox Labels works like categories, so for every code snippet you add you can organize it by language, project or purpose.

Advance Search. GistBox's search functionality is surprisingly amazing. If you like how Gmail's search works, then, you'll also love GistBox. With GistBox, you can search through the entire code snippet library or through specific labels.

Collaborate with a group. Another cool feature of GistBox is it's ability for you to create groups and share useful snippets among co-workers — great if you're working with a team.

Split Screen: Splits Your Web Browser into Multiple Resizable Windows

GistBox is lightweight, free and usable. And it's a must-have to all devs!
Still not convinced? Go, check out GistBox and see it for your self.

New Chrome Extension Lets You Preview Virtually Any Files (e.g. PSD, AutoCAD) On Your Web Browser

We are a big fan of anything that makes things less of a hassle. Whether it's about extracting text from an image without using image editor or moving around large files from FTP server to your DropBox account, we constantly hunt for the best apps and methods to make the process a little less painful.

And today, we are thrilled to share with you yet another interesting Chrome extension that you might want to add in your arsenal.

Preview Almost Any Kind of File In Your Browser (e.g.PSD, Word, AutoCAD, Video, Audio, etc).

Introducing... FilePreviews.io. It's a nifty browser add-on currently available for Google Chrome designed to generate previews of almost any kind of file including, but not limited to PSD, AI, AutoCAD, Excel files, and much more. And the real cream of the crop? It works straight from your web browser; no need to launch third party apps like Photoshop, Illustrator, AutoCAD apps, etc.

When is it useful?

FilePreviews.io may not be something you use all the time, but in case you want to have a quick look of that large PSD or AutoCAD files you stumbled on the web, you can turn to this app to quickly generate snapshots of those files.

How it works?

As with any other Chrome extension, all you have to do is to install FilePreviews.io from the Chrome WebStore. Once installed, just right-click on a link and from the context menu, select “Preview from source...”. The add-on should automatically take you to a new tab displaying the file preview without ever leaving your browser. How cool is that?

Lazarus Is Your Time-Saving Chrome Add-On That Saves Anything You Type On A Web Form

Go check out FilePreviews.io.

The Quickest Way To Remove Duplicate Tracks In Spotify Playlist

If you've been using Spotify for a long time, chances are you've come across an issue with duplicate tracks. It happens from time to time and as more and more songs you add in your playlist, so do the problems that come with it.

Dealing with duplicate files is no easy feat, much more if you're dealing with a large, collaborative playlist. Thankfully, finding and removing duplicate songs on Spotify playlist is not that difficult as what you might think. Here we're going to show you can easily declutter and deduplicate songs on your Spotify playlist in seconds.

Find, Delete Duplicate Media Files On Windows 7 (CopyTrans Method)

Find and Remove Duplicate Tracks in Your Spotify Playlists

Meet Spotify DeDuplicator, an online tool that allows you to remove all exact duplicate tracks from a selection of Spotify tracks. The tool works this simply:

1) You select all tracks in a Spotify playlist
2) Drag-and-drop them to the the textbox just above the “Deduplicate” button
3) Press Deduplicate
4) Drag-and-drop the result back to your Spotify playlist (or in a new playlist)

As seen on the GIF above, you may need to empty the entire playlist before you drag-and-drop the results back to Spotify, or else those tracks will be added as another duplicates.

Add or Set Music Sleep Timer To Spotify iOS App (No Jailbreak Requried)

So if you start seeing tracks displayed more than once in your Spotify playlist, go check out Spotify DeDuplicator.

New Android App 'Party Player' Lets You Enqueue, Play Song Via SMS

Imagine you're chilling outside together with your friends, maybe on the veranda with beer, enjoying the night while your party playlist is humming in the background.

What if I told you there's an app that allows you or anyone to enqueue, play tracks by simply sending a text message to your phone?

Enqueue, Play Next Song By Title Through Text Message (link)

Well, that's basically the premise of this brand new app called “Party Player”, a free music app currently available for Android that allows your phone to receive and automatically play song requests through text messages. And no, it doesn't need an internet connection to work.

How it works?

The app works this simply: you or your friends will just have to send a text message "Play<space>Song Name" to your Android phone. Party Player will then automatically stop any currently playing song and look for and play the matching track found on your phone. When the song request finishes, the previously playing song will be continued.

How To: Remotely Lock, Password-Protect Your Lost/Forgotten Phone Thru SMS

Party Player is surprisingly smart; if a song request returns multiple results, the sender automatically gets a reply via SMS prompting them which song they want to play.

How cool is that?!

Of course, song requests can come from different sources, including song requests coming from non-Android devices. The app also comes with a simple “Blacklist” support so you can disallow certain contacts from requesting a song, useful if you have friends with poor music taste :D

It's creator, iamcamcamiam22, teased the app on Reddit yesterday, showing how the Party Player works. Here's the creator with his demo video:





Download: Party Player [Play Store]

Remotely Set Alarm Clock By SMS — Send SMS Text Message To Set Alarm Clock

Project Naptha: A Mind-Blowing Chrome Add-on that Lets You Copy, Extract Text from Any Images Online

How many times have you gone to situations when you needed to extract text embedded in an image but went helpless because no app can quickly and perfectly do just that?

Well, not probably once.

To anyone who wants to be more productive on their online gigs, you should go and check out Kevin Kwok's latest work: Project Naptha, a mind-blowing browser extension currently available in Chrome that allows you to copy text from any images straight from any websites.

And yes, it works great.

Use IFTTT As A Spy App: Secretly Collect iOS Photos Taken on iPhone, iPad (No Jailbreak)

But how was it possible?

As with any other text extraction software, Project Naptha is powered by a complex Optical Character Recognition (OCR) technology which quickly identifies and builds a model of text regions, letters and words that you can extract and copy from virtually any images you encounter on the web.

One notable feature of Project Naptha is the "Erase Text" functionality which allows you remove text from any images -- useful if you want to grab images online free from captions or annotations.

Project Naptha has already making a lot of headlines today, and the media attention it gets can potentially attract tech giants like Google, Bing or Yahoo who might consider acquiring it and incorporate into their search engines.

Here's why:

Project Naptha is a clear demonstration that it's possible for search bots to decipher and index all images flooded online, similar to how search engines index the standard text-based websites. And that's music to the ear for search engine companies who might want to take a big step  forward in search. Sooner or later images we embed in our websites will be as valuable as text. And those online images' copyright violators will get the biggest Google slap.

Bubbli Is A Jaw-Dropping App That Lets You Create Streetview-Like, Responsive Spherical Images (iOS)

There's not such an abundance of OCR apps both desktop and online that works out of the box without requiring you to upload the source files for remote processing. With Project Naptha, OCR processing all takes place straight from your web browser. And that's a work of genius.

Project Naptha Firefox extension is expected to arrive in the coming months.



LINK: Project Naptha

Responsimulator: The Most Accurate, Reliable Web-Based iPhone, iPad Simulator Online

Every front-end developer knows how downright disappointing it is to get asked to fix some design hiccups in which you cannot fix as you cannot replicate them on your end.

And this is a very a common problem among web developers: your iPhone/iPad simulator says it's perfect but in real physical device, the overall look-and-feel of a website may be a bit awry, unacceptable. We don't want our clients to get back to us angry right?

Use Mover.io To Copy, Move Files From FTP To Google Drive, DropBox, SkyDrive and Vice Versa

But fret not.

A web design company Flexify has this no less ordinary iPhone/iPad online simulator app that you will gladly welcome into your web dev toolbox: Responsimulator. This is not Screenfly or any other online simulators you may have used before.

Here's why:

The level of accuracy renders by this web-based iPhone/iPad simulator is so impressive that you can quickly squash every single visual bug you encounter which may not normally appear in your usual emulators. And that's great especially if you constantly do web development or QA and you don't have real iPhone or iPad to perform visual checks on your end.

Access, Manage All Files Stored Across Multiple Cloud Accounts All At Once

Simulators have always been the most indispensable tools among front-end web developers. These are everyone's go-to tools to ensure every single detail and element of a website is displayed well on any screens or platforms prior to site deployment. But you've got to be careful as not every simulator delivers results as promised, except of course for Responsimulator which seems to be the most web developer-friendly, accurate iPhone/iPad simulators available as yet.

The Cons:

• Only portrait mode is currently supported
• Works only on websites with RWD implementation (translation: Media Query-reliant websites)

Do you know any other mobile and tablet simulators? Buzz off in the comments.



LINK: Responsimulator

Bubbli Is A Jaw-Dropping App That Lets You Create Streetview-Like, Responsive Spherical Images (iOS)

Drop Photosynth,  AutoStitch Panorama, Cycloramic, or whatever panorama-making apps you used to worship and obsessed with.

Here comes another revolutionary app that will change the way you document, snap your precious travels or events in your life. Think this is another boring Instagram or panorama-shooting apps? That's a big NO.

Bubbli is the next big thing -- here's why (link)

Meet Bubble, a brand new app (currently available for iPhone & iPad) that allows you to create a beautifully stitched, dynamic spherical photo. What I mean with dynamic spherical photo is that the resulting photo is complete with encompassing sides, top, and bottom of the entire scene around you - including sound. Bubbli termed this technology as bubbles.

5 Essential Non-Jailbreak iPhone Apps That Apple Should Allow In App Store

Adding to that 3D multimedia feel is the Gyroscope-guided image navigation, where you can virtually span around the image by changing your device's position and orientation. The result? Not just an ordinary 360-degree shot or the streetview-like images of Google Maps; it's a visually stunning, immersive three-dimensional experience straight from your iPhone/iPad.

Demo Bubbles

Let these featured bubbles do the talk (best viewed on your sensor-enabled iPhone/iPad):







Still not impressed? I don't think so. The first time I used the app it got me thinking Bubbli is the next billion-dollar app Facebook or Google will soon snatch. It has all the potential to become the next Instagram or Snapchat and even beyond that.

Using Bubbli

As with any advance photo-snapping apps, there's a bit of trickery you need to acquaint at first. Right after you launch the app, you'll be greeted with a welcome screen with an intro video, detailing what Bubbli is all about and why it's different from standard Panorama.

Hand Gesture Recognition App CamMe Revolutionizes The Way You Snap Selfies (iOS)

The app then serves you a sample bubble, demonstrating you how to get started. Here, you can tap "next" to proceed with registration, which is required so you can store your Bubbles online. I advise you to go download the app and browse through the manuals/demos built into the app. It got a decent collection of video demos on how to capture a perfect spherical photos.

Bubbli Features

Notable goodness of Bubbli includes: the ability to share your bubbles on social media sites. It also got "Featured" section, displaying a grid of public bubbles published by Bubbli users. You may tap on any of them to explore.

The Bad

My only problem with Bubbli is that it consumes quite a lot of resources (at least in my case). Maybe app like this is naturally a resource-hogger? But thinking of how game-changing & revolutionary the idea & the execution of this brilliant idea, I think this is forgivable.



DOWNLOAD: Bubbli

LICEcap Is The Best Alternative To Recordit To Screencast & Create High Quality GIFs

For the uninitiated, Recordit Fast Screencasts is a Mac-only piece of software recently launched that lets you create video screencasts FAST. This app works similarly to Jing; you decide what particular area of your screen you want to screen-capture, hit the record button, then wait for a few seconds for the app to upload & generate a unique link for the screencast. If you have a Mac, go check out Recordit.

Add Multiple Tabbing, Chrome-like Support To Windows File Explorer With Clover [Must Have]

What makes Recordit unique is the nifty GIF support, which is kind of envy to all Windows users out there considering that there's not much good screencasting apps available for Windows with decent GIF support.

But fret not, I got you here a decent (even better) alternative to Recordit that works well on any Mac and Windows computer.

LICEcap Records Your Screen Activity And Saves It As High Quality GIF (Windows & OSX)

LICEcap is FREE and fully functional GIF creation tool both for Windows and Mac that allows you to capture an area of your computer and store it as a high quality GIF. LICEcap is very lightweight and there's no extra fuss to get started. Just grab and install the app, and you're good to go.

LICEcap Features:

• Record directly to .GIF or
• Move the screen capture frame while recording
• Pause and restart recording, with optional inserted text messages
• Global hotkey (shift+space) to toggle pausing while recording
• Adjustable maximum recording framerate, to allow throttling CPU usage
• Basic title frame, with or without text
• Record mouse button presses
• Display elapsed time in the recording

Why use GIF when there's a video?

The problem with most video screencasting software today is that the size of video or flash file it generates is too large that you can't quickly embed it on a web page nor share it to your co-workers or employer. With GIF as an output format, the size is too minimal, thus saving you time.



Link: LICEcap

Best & FREE Alternatives To Otixo To Manage Multiple Cloud Storage Accounts