Restricting Calendar usage with a single day parameter

  • 0
  • 1
  • Question
  • Updated 4 weeks ago
  • Answered
I have an app that allows users to schedule themselves to work as a Primary or Alternate rep for each day of the month. I'd like to limit the number of users that can schedule themselves as Primary to 5 and Alternate at 3 for each day. I have a field labeled as Headcount that places the numeral "1" in the record each time they are scheduled. Is it possible to add the volume of a single day and restrict access to scheduling that day once the limit has been reached?
Photo of NIck Chacon

NIck Chacon

  • 102 Points 100 badge 2x thumb

Posted 4 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
I assume that you mean that the maximum number of primaries in a day is 5 and max # of secondary is 3.

You could load up a table via excel for all the dates for the next 10 years.  Set the Key field to be the date.

Then instead of having users chose the dates from a usual calendar date picker field, you would make a relationships where 1 date has many Primary Rep Bookings.  Then make a summary of the # of Primary rep Bookings.

lastly, you would make a report for the form to use for the drop down list where the # of primary bookings is less than 5.

Then do the same for the secondary bookings.  New relationship to the same dates table 


Photo of NIck Chacon

NIck Chacon

  • 102 Points 100 badge 2x thumb
Thank you so much for the suggestion!