
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 02, 2021 08:15 AM
Hoping this is an easy enough set-up! I’m trying to create volunteer sign-ups for specific events, where there will be a fixed list of approved volunteers that can sign-up (so they would select their name from a linked field). Aside from manually closing out the form after a certain number of sign-ups, is there a way to indicate that we have 10 slots available and turn it off after that time?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 02, 2021 09:29 AM
Assuming the form is linking Volunteer records to Event records:
- Add a Count field to the Events table to show how many current signups there are.
- Add a Formula field to the Events table that calculates
IF({Count of signups} > {Max signups}, "full", "not full")
. - Adjust the Event link field in the Sign Up Form view to only pull from an Events table view that filters out “full” events.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 02, 2021 10:58 AM
Just a slight tweak. Use >=
and not just >
IF({Count of signups} >= {Max signups}, "full", "not full")
You can also combine the count and the comparison into a single rollup field, instead of having two fields.
IF(COUNTALL(values) >= {Max signups}, "full", "not full")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 26, 2024 12:10 PM
Has anyone done this ? I am looking to create a sign up form as well for volunteers within a group and limit them - example - Beer Shift 1 - Need 10 People - Once I reach 10 I want to close the sign up for that shift out.
