Amit Agarwal labnol

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

Best Google Chrome Extensions

List compiled by Amit Agarwal

Vimium — Power users can browse the web using keyboard shortcuts. No mouse required.
Buffer — Share links to multiple social websites with a go.
PushBullet — Send web links, text notes and even push files from computer to your phone.
Clip Better — Don't send raw links over email, send previews that suggest what a link is all about.
Streamus — A YouTube music play for Chrome that also includes a radio.
Mighty Text — Send and receive SMS text messages from your desktop

Learning Google Apps Script

Find the best resources for learning Google Apps Script, the glue that connects all Google Workspace services including Gmail, Google Drive, Calendar, Google Sheets, Forms, Maps, 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.

Google Apps Script Code Samples by Amit Agarwal
Google Apps Script Development - Create Google Apps Script projects locally inside VS Code - video tutorial
Awesome Google Scripts by Amit Agarwal
Google Developer Experts - Follow Apps Scr

Untitled Slide

Welcome to Glide.

Glide is the easiest way to create useful slide for all of your Gists.

input key <- to go backward.
input key -> to go forward.

Publishing

Barack Obama

Barack Hussein Obama II (born August 4, 1961) is the 44th and current President of the United States, and the first African American to hold the office. Born in Honolulu, Hawaii, Obama is a graduate of Columbia University and Harvard Law School, where he served as president of the Harvard Law Review. He was a community organizer in Chicago before earning his law degree.

In 2004, Obama received national attention during his campaign to represent Illinois in the United States Senate with his victory in the March Democratic Party primary, his keynote address at the Democratic National Convention in July, and his election to the Senate in November. He began his presidential campaign in 2007 and, after a close primary campaign against Hillary Rodham Clinton in 2008, he won sufficient delegates in the Democratic Party primaries to receive the presidential nomination. He then defeated Republican nominee John McCain in the general election, and was inaugurated as president on January

Country	1990	2008	2025
China	1141	1333	1458
India	849	1140	1398
USA	250	304	352
Indonesia	178	228	273
Brazil	150	192	223

	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).

	// 1. Go to https://twitter.com/following.
	// 2. Keep scrolling to the bottom repeatedly until all your followers are loaded.
	// 3. Run this in your console.
	[].slice.call(document.querySelectorAll('.unfollow-text')).forEach(function(button) {
	button.click();
	});

	function send2gp() {
	var success = new Boolean(false);
	var retry = 0;
	var max_retry = 3; // 最高リトライ回数 max retry count
	var errmsg = '';
	var tokiboys1 = '長男の名前'; // 長男の名前を設定 define my first boy's name
	var tokiboys2 = '二男の名前'; // 二男の名前を設定 define my second boy's name
	var papa = 'パパの名前'; // 送信者（パパ）の名前を設定 define my name

	// エラーで終了した場合はリトライする（Max3回）