AnsweredAssumed Answered

Over booking a date

Question asked by on Jul 14, 2018
Latest reply on Jul 17, 2018 by


  I am trying to figure out the best way to have FileMaker limit the amount of records that can have the same date based on a number field.


Here  is what I am trying to do. We can only build ”X” amount of widgets each day. Each Record entered has a production start date field. Each record also has a numerical quantity field which represents the total widgets required for that record. I would like FileMaker to not allow more records to have the same “Start” date once that date reaches a sum total number of all the widgets booked on that start date.

I hope this makes sense. 

Any help would be greatly appreciated.

Thank you.