Close Form At Limit
Google Forms can't stop at 50 sign-ups or at Friday 5pm on its own. closeFormAtLimit(form, {maxResponses, closeAt, message}) checks both and…
10 posts tagged with “google-forms”
Split Multi Select To Rows
Google Forms stores checkbox answers in one cell: Sheets, Gmail, Docs. Pivot tables and COUNTIF can't count that. splitMultiSelectToRows…
Build Prefilled Form Url
A Google Form with fields you already know from a sheet row — name, email, client id — and a recipient who shouldn't have to retype them…
Validate Form answers before they hit your master sheet
Linked Forms feel convenient until one typo in “Email” breaks every nightly job that trusts the master tab. The fix isn’t a sterner form…
COMPLETE Guide to Event Triggers w/ 5 examples
In this video, we'll go over 5 examples of using Event Triggers to help you go from doing tedious work to being a SUPERCHARGED automation…
Easiest Way To Upload Responses to Google Forms
We all wish that uploading responses to your Google Form was as easy as inserting new rows into the linked Google Sheet, but it's not... It…
How to Automatically Update your Google Form Options
If you have a drop down field in your Google Form where the options tend to change, we're going to show you how you can easily make changes…
How to add Hidden Fields to your Google Form
Using hidden fields is a great way to set default values within a form submission to make it easier for you to organize the data you're…
How to Auto-Send Emails on a Google Form Submission
Are you using Google Forms and wish you could send auto-replies to your form responders? Better yet, how about personalized auto-reply…
A Guide to Checkbox Controls in Google Sheets
In this guide, we're going to create an automated way to update the tasks through the Todo list we created in our guide to creating custom…