Forum Discussion

NIckChacon1's avatar
NIckChacon1
Qrew Member
7 years ago

Restricting Calendar usage with a single day parameter

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?
reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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