6 thoughts on “Google Forms + Form ranger = Event Signup – Part 2”

  1. Hello! I have tried several methods to eliminate choices that have been selected. My question has a picture with each answer choice in addition to some text. The choices are eliminated after the limit has been met, but ALL the images with ALL the answer choices are also eliminated at that time. This is true for Choice Removal, Choice Limit, and Form Ranger. Any suggestions??

  2. Thanks! What if you want to let the people in your example sign up for multiple workshops, while still limiting the number of participants in each workshop? We figured it out using this post as a starting point, so we wanted to share in case it helps others.

    In Step 1, you need to use the “checkbox” answer type instead of “multiple choice” when setting up the Google Form. In Step 2, no changes. All the workshops selected by a given respondent will be returned as a string of comma-separated text in column C of the ‘Form Responses 1’ tab. In Step 3, when you set up the formulas, you need a way to recognize the names of the workshops in that text string and count them to keep track of how many people have registered for each. On the ‘choices’ tab, no changes to Columns A, C, or D. But the formula you enter in B2 will be a bit more complex: =countif(arrayformula(regexmatch(‘Form Responses 1’!C:C,A2)),”TRUE”) You will fill this formula down, same as before. And that does it — no need to change anything else!

    Formula explanation: regexmatch() searches a source text (in this case, a form response) for a so-called “regular expression” (in this case, the workshop name stored in A2) and returns TRUE or FALSE depending on whether it finds a match. A “regular expression” is like search on steriods, but in this example we don’t need any of those superpowers, so we just use the exact string of text we want to find. Regexmatch() searches only one cell of source text at a time. But we want to search a range — in this case, a whole column of form responses — so we have to enclosing regexmatch() inside arrayformula(). Then it returns an entire column of TRUE and FALSE values, checking for a match in each form response received so far. So where is this column of regexmatch() results? In this case, it’s virtual — hidden, held in the spreadsheet’s calculating memory — because we’ve enclosed it in the countif() function. And countif() counts a range and returns a single number. So we’re counting all the TRUE values in the virtual column of regexmatch() results to see how many people have signed up for each session, and the count is the formula result displayed in B2.

  3. Hi! I just wanna ask what if my countif ranges to 5 columns? I put F:J,A2. It worked for me yet it still allows multiple response to that option. Hoping for your utmost response! Thank you very much.

Leave a reply! The IT Babble Team Need Feedback.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s