Form Function Library

Some useful functions to jumpstart your next Google Forms related Apps Script Project! Can be used as a library or through copy and pasting the code into your own project.

What is Google Apps Script?

How to use a library in Google Apps Script

About me:

I am a freelance software developer based in the US. Lover of all things google apps script (GAS). I plan to continue development of projects, and see how far I can go with this! Upon purchase you will be invited to a discord community where we can discuss ideas for projects, give feedback on existing ones, and where I will give discount codes on future releases.

Please subscribe to my gumroad profile, and share with anyone you'd think would be interested. Become My Affiliate!

If you find the library helpful, or just feel generous - please donate through my paypal or purchase additional copies. Any amount is appreciated, and will support development on future products and help keep prices low for others.

Name a fair price:

I want this!

5 downloads

Library of Awesome Functions to Jumpstart Your Next Project

Unlink and Delete

Takes a form and unlinks it from the destination spreadsheet and deletes the form sheet, and form entirely

Flatten

Takes a 2d array like that from spreadsheet.getrange().getValues() and turns it into a 1 dimensional array. Useful for getting data from a range of cells and converting it into a more usable data type

Get Form From Sheet

Returns the form from a given sheet within a spreadsheet

Get Sheet From Form

Takes a form, and gets the specific sheet that it is linked to

Get Checkbox Item From Form

Takes a form and a specified title and gets the item with that title from the form

Set Choices

Takes a form, finds a checkbox or multiple choice item by its title, and sets the values for that item