I am building a table to register applicants in a program that will occur over multiple dates, but want to limit the maximum number of registrants to "15" for any date.
I was going to build a table with 15 blank records, allowing the registrants only access to modify an existing blank record, and once all of the blank records were filled, well registration would be filled as well (pretty simple except as we are using relationships, I would have to build 15 similar relationships)
Is there a simple method to incorporate such a limit and allowing the registrants to create a record when registering?
The Parent would be called Tournament Date
The Child table would be Registrants
So you would set up all the Tournament Date records yourself.
On the Relationship, set up a summary count of the number of Registrants.
Then all you need to do is to edit the Add Child (Registrant) URL formula field to put an IF around it. That way when you hit 15, the button will go blank.
iF([# of Registrants] < 15, existing formula goes here)
Starting the schedule is easy, you just slot in the team names for home and visitors, but after playing the first game, the winner advances, which will create the data for a later record and the loser disappears.
So for simplicity lets say there are four teams are in the tourney. (I know for a four team tourney just get a piece of paper and do it the old fashion way). And a champion of the tournament is crowned after the third game.
So I am trying to build a database in simple terms that takes the winner of game (record) 1 and adds them to game (record) 3. Does the same to game (record) 2, the winning team is again added to game (record) 3.
So essentially I am trying to build a schedule table that auto populates later records, based on the results of earlier records.
Really simple to do in Excel ... can't make it work in Quickbase
I suspect that there is a very elegant way to do this and if i could get it working as a puzzle project i would post the app to the Exchange.