Skip to main content

Filtered Submission Limit (Count only submissions matching a condition)

Current behavior: "Limit number of submissions" counts all submissions regardless of their content. Once the limit is reached, the form closes.

Problem: I use the form as an event sign-up (quiz night). Participants can update their status to "Not coming," but those entries still count toward the submission limit. This means the event appears full even when spots have freed up.

Proposed behavior: Allow an optional filter on the submission limit, so only submissions matching a condition count toward the limit.

Example configuration:

  • Limit: 30 submissions

  • Count only where: status == "Going"

A participant who changes their status to "Not coming" would no longer count, freeing up their spot automatically.

Use case: A coffee shop runs weekly quiz nights for 30 people. Sign-ups come through the form. When someone cancels (status → "Not coming"), their spot should reopen without manual intervention. Currently, the organizer must manually increase the limit or reopen the form.

1 comment

Log in to comment and vote

Comments1

  • Archie

    Team•

    Apr 21

    Hi Peter,

    Thanks for sending this over!

    I really appreciate the clear breakdown of the "Quiz Night" scenario. It makes total sense why having "Not coming" entries count toward your limit is a hurdle for managing event capacity.

    Detailed use cases like yours are exactly what we need as we look at how to improve OpnForm. Thanks for taking the time to share this with us.

    Best,