MYSQL is the most popular RDBMS. Also it is open-source and is being used by many tech giants like Google and Facebook. Today in this article we will see how to connect and fetch data from MYSQL to Google Spreadsheet. This is possible in Google Apps Script with JDBC connection. Just put the query in …
How to Pause GIF image like Facebook
The GIFs i.e. Graphics Interchange Format is a bitmap image format. These are short animaned images play and pause in loop. In compare to videos the size of GIF image is small so easy to view in slower internet connection as well. GIF is compressed using the LZW lossless data compression technique which reduces file size without affecting …
Create Form to Upload Files in Google Drive
Today Google form is the most widely used web form service used for many purposes. Some of its attractive features include intuitive drag and drop interface, quick integration with Google Sheets and not to mention add-ons which even enhance its capability. Despite all these features, it misses an important one that is uploading files or …
Share Portion of a sheet in Google Spreadsheet
Google brings us a collaborative spreadsheet interface(the Google Spreadsheet) with tons of features and sharing options. We can share spreadsheets with somebody, protect individual sheets and publish it to web. Still it is lacking a feature which may be useful for its users i.e. share portion of data from a sheet. It comes handy when …
Create a Countdown Timer in Google Spreadsheet
Whether it may be countdown for Christmas or time elapsed since we started something, we need some sort of counters. Today in this article we will see how to display countdown and countup timer in Google Spreadsheet. We will try to keep it as simple as possible. No script, just be using formula we will try …