danjact
Forms Fledgling

Workflow to limit the number of items based on date

I have a list (task with calendar) that will serve as a class signup sheet.

Since we're limiting the classes to 20 people, I am trying to write a workflow that is based on the following:

 - For any date (class), if the number of people signed up is 20, you can no longer sign up for that date. 

 

I'm very flexible on the structure of the list as well - We can change it to make it work.  However, even with this, I'm having a hard time wrapping my head around the workflow and list, and how to make this work.

 

Any ideas?

0 Kudos
Reply
4 Replies
Tarf
Design Canvas Artiste

Re: Workflow to limit the number of items based on date

Hi @danjact 
are you sure there will be only one class per day?

Let´s say there could be multiple.

  • Create a List named Classes, make the Title unique
  • Create a List named Registrations (Person, Lookup to Classes:Title)
  • Add a Form to Registrations
    • Add a calculated value with formula: lookup("Registrations","Class",your_Control,"ID",true).length​
      • "Class" is the name of the lookup column and your_control is the lookup control on the form
      • This will show you how many registrations have already been made.
      • Now you can add validation as required.

If you do not need the Extra List for Classes, you could make the same formula work with a date field

lookup("Registrations","Date",your_Control,"ID",true).length​
Please note that by doing the extra list, you gain advantages like

  • multiple classes per day
  • flexible amount of max attendees (by adding a column in the Classes list)
     
0 Kudos
Reply
danjact
Forms Fledgling

Re: Workflow to limit the number of items based on date

I'll see if I can make this work, but yes - one class per day. 

Thanks - I'll keep you posted on my progress.

0 Kudos
Reply
danjact
Forms Fledgling

Re: Workflow to limit the number of items based on date

I can't seem to put together what you've proposed.  How about a bit more detail?

0 Kudos
Reply
danjact
Forms Fledgling

Re: Workflow to limit the number of items based on date

Also, I only have access to Nintex Workflow  - I cannot use Nintex Forms. 

0 Kudos
Reply