Limit Google Form Responses with Form Ranger
Вставка
- Опубліковано 18 вер 2024
- This tutorial will help you set a capacity on how many times a response can be selected on a question in Google Forms - Which is great when you need to make sure an order or a workshop registration does not go over capacity!
This is really helpful, thank you!
If you envelope the filter formula inside an IFERROR function you can leave a custom place holder message:
IFERROR(FILTER(.....),"Session full")
This will swap out the error code #N/A with whatever text you put in the quote marks
**Update** So after testing I found the form was not limiting responses, probably because I edited the formula as shown below. I needed to update the question list in Form Ranger with the new formula and it now appears to work.
So helpful! I'm thrilled to be able to automate our signups. I have a signup form where it's possible to sign up to bring a guest. I modified the Count column to add two columns together:
=(countif('Form Responses 1'!E:E, A2)+countif('Form Responses 1'!F:F, "Bringing*"))
Thank you. This is exactly what I needed.
Thanks!