Add a quantity limit using script

[Florence_Dorsil]

Hello there,

I’m building a base to manage activities. Table 1 is a registration form. Table 2 is the listing of activities with a rollup to track the number of person for each activity.

I want to add a limit of person for each activity and block the activity in the form when limit is reach.

Here’s a view :arrow_down:

Anyone can help ?

[JonathanBowen · Accepted solution]

Hi @Florence_Dorsile - take a look at this post, which asks (and answers) a similar question:

Limit the Number of Workshop Registrations Ask the community

Hi @Career_Services - yes, this can be done. Here’s how I would set this up: A Workshops table: [Screenshot 2020-11-14 at 17.04.01] And an Attendees table: [Screenshot 2020-11-14 at 17.04.32] The attendees table can use an Airtable form to capture the registrations. The trick is to have a view on the Workshops table for “available workshops” - workshops which have not yet reached their maximum attendance level. You’ll see there is a few fields on the workshops table to support this: T…

[Florence_Dorsil]

Worked perfectly !
Thank you very much :star_struck: