Brad btray77

btray77 / gist:b20b041365a29789458ba0061da063bc

Created September 21, 2022 09:27

Random Order String List Sorted

	var str = "word1 word2 word3 word4 word5";
	var wordList = str.split(" ");
	var wordCount = wordList.length;

	function permute(wordList, wordCount) {
	var results = [];

	if (wordCount === 1) {
	return wordList;
	}

btray77 / submitscriptexmaple.js

Created March 8, 2023 06:28

Example of how to take a google sheet with names and phone numbers and submits to a form.

	function submitForms() {
	// Get the active sheet
	var sheet = SpreadsheetApp.getActiveSheet();

	// Get the data range
	var range = sheet.getDataRange();
	var values = range.getValues();

	// Loop through each row of data
	for (var i = 0; i < values.length; i++) {