Limit Google Form Responses with Form Ranger

Поділитися
Вставка
  • Опубліковано 16 гру 2024

КОМЕНТАРІ • 5

  • @JohnnyTest-ub7ll
    @JohnnyTest-ub7ll 8 місяців тому +1

    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

  • @DeborahLorraine
    @DeborahLorraine 8 місяців тому

    **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*"))

  • @ScottWalker555
    @ScottWalker555 Місяць тому

    Great video, Thanks.

  • @4ewinery
    @4ewinery Рік тому

    Thank you. This is exactly what I needed.

  • @karelfyrbach930
    @karelfyrbach930 10 місяців тому

    Thanks!