Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Form for Volunteer Sign-Up

2348 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Sara_Stahlberg
6 - Interface Innovator
6 - Interface Innovator

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?

3 Replies 3

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.

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")
Dre_Gonzalez
5 - Automation Enthusiast
5 - Automation Enthusiast

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.