Skip to content

Instantly share code, notes, and snippets.

View labnol's full-sized avatar
🇮🇳
Building stuff for the Internet!

Amit Agarwal labnol

🇮🇳
Building stuff for the Internet!
View GitHub Profile
@labnol
labnol / index.html
Created January 19, 2013 04:12
A CodePen by Amit Agarwal. Bookmarklets - A useful resource for all the people looking for bookmarklets for their favourite services. Additions are welcome. Just comment with the name of the service and a link to the bookmarklets.
<header>
<div class="wrap">
<h1 class="site-heading">Bookmarklets</h1>
<p class="description">Collecting useful bookmarklets accross the web. Curated by <a href="http://twitter.com/RadLikeWhoa_" target="_blank">Sacha Schmid</a>.</p>
<p class="links"><a href="#howto">Read the instructions</a><span class="separator">|</span><a href="http://twitter.com?status=@RadLikeWhoa_ I'd like to suggest a new bookmarklet: " target="_blank">Suggest a bookmarklet</a></p>
</div>
</header>
<section id="toolbar" class="toolbar" style="display: block;">
<div class="column">
<input id="search" class="search" type="search" placeholder="Search by name or by category">
@labnol
labnol / substitute.md
Created May 2, 2024 06:55
Google Sheets function for generating pre-filled Google Form links

This Google Sheets function will help you generate pre-filled Google Form links without nested SUBSTITUE functions.

Watch the video tutorial to learn more.

/**
 * Replaces multiple occurrences of specific values in a string with new values.
 * @returns {string} The modified string with replacements made.
 * 
 * @customfunction
@labnol
labnol / google-apps-script.md
Last active March 25, 2024 14:50 — forked from junaidk/resources.md
How to Learn Google Apps Script

Learning Google Apps Script

Find the best resources for learning Google Apps Script, the glue that connects all GSuite services including Gmail, Google Drive, Calendar, Google Sheets, Forms, Maps, Analytics and more.

A good place to learn more about Google Apps Script is the official documentation available at developers.google.com. Here are other Apps Script resources that will help you get up to speed.

  1. Google Apps Script Code Samples by Amit Agarwal
  2. Google Apps Script Development - Create Google Apps Script projects locally inside VS Code - video tutorial
  3. Awesome Google Scripts by Amit Agarwal
  4. Google Developer Experts - Follow Apps Scr
@labnol
labnol / index.html
Created October 3, 2012 08:24
A textbox that looks like a notepad! Forms are fun!
<div id="wrapper">
<form id="paper" method="get" action="">
<div id="margin">Title: <input id="title" type="text" name="title"></div>
<textarea placeholder="Enter something funny." id="text" name="text" rows="4" style="overflow: hidden; word-wrap: break-word; resize: none; height: 160px; "></textarea>
<br>
<input id="button" type="submit" value="Create">
</form>
</div>
@labnol
labnol / file-upload-forms
Created January 22, 2019 07:36
File Upload Forms for Google Drive
File Upload Forms for Google Drive
----------------------------------
With the File Upload forms, you can upload files of any size and the files are sent directly to the owner’s Google Drive while the form data is saved in a Google Spreadsheet.
A [Pen](https://codepen.io/labnol/pen/QYWvwV) by [Amit Agarwal](https://codepen.io/labnol) on [CodePen](https://codepen.io).
[License](https://codepen.io/labnol/pen/QYWvwV/license).
@labnol
labnol / gist:1907321
Created February 25, 2012 08:19 — forked from mhawksey/gist:1723943
Core Google Apps Script Functions
// The rest of this code is currently (c) Google Inc.
// setRowsData fills in one row of data per object defined in the objects Array.
// For every Column, it checks if data objects define a value for it.
// Arguments:
// - sheet: the Sheet Object where the data will be written
// - objects: an Array of Objects, each of which contains data for a row
// - optHeadersRange: a Range of cells where the column headers are defined. This
// defaults to the entire first row in sheet.
// - optFirstDataRowIndex: index of the first row where data should be written. This
@labnol
labnol / index.html
Created April 30, 2014 13:27
Google Maps
<iframe src="https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d56790.47490202523!2d78.042155!3d27.175014999999924!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x39747121d702ff6d%3A0xdd2ae4803f767dde!2sTaj+Mahal!5e0!3m2!1sen!2s!4v1398864446719" width="800" height="600" frameborder="0" style="border:0"></iframe>
@labnol
labnol / qr.html
Created October 3, 2012 15:23
Social QR Code
<!-- This template was designed by Amit Agarwal of Digital Inspiration (www.labnol.org) -->
<!-- The design and template is licensed under a Creative Commons Attribution 3.0 License -->
<!-- Please see http://www.labnol.org/?p=25841 for instructions on how to modify the file -->
<html>
<head>
<title>QR Code</title>
<meta name="HandheldFriendly" content="True">
@labnol
labnol / google-chrome-extensions.md
Created May 9, 2014 19:44
Google Chrome Extensions

Best Google Chrome Extensions

List compiled by Amit Agarwal

  1. Vimium — Power users can browse the web using keyboard shortcuts. No mouse required.
  2. Buffer — Share links to multiple social websites with a go.
  3. PushBullet — Send web links, text notes and even push files from computer to your phone.
  4. Clip Better — Don't send raw links over email, send previews that suggest what a link is all about.
  5. Streamus — A YouTube music play for Chrome that also includes a radio.
  6. Mighty Text — Send and receive SMS text messages from your desktop
@labnol
labnol / Twitter.js
Created January 20, 2013 12:19
A simple Google App Script to monitor your followers on Twitter by @olak_F
/**
* @fileoverview A simple Google App Script to monitor Twitter followers
* @version 1.0
* @author Twitter: @olaf_k | Github: olaf-k
*/
/**
* Twitter screen name (without @) to monitor
* @constant
*/