First you'll need to add a Summary field (To learn how, please see our Create a Summary Field help topic.) on the Master table to count the number of related Detail records which are assigned to the current user:
The simplest thing for you to do is to deny the user access to your billing account. When you put a user on the deny list, QuickBase makes sure that the user cannot log in to any applications in your account.
In order to clean up your user accounts, you'll need help from the Customer Care team to remove the usernames you no longer want. They'll also be able to review any apps you own or have access to under each user, and consolidate them under a single login.
A Billing Account Administrator determines which users are able to create applications. You control this ability using the Create Applications checkbox next to each user's name under the Permissions tab.
When you'd like to cut off a user's access to your applications, you can use the deny option to remove a user’s access to your billing account.
To learn more, read this QuickBase online help topic: Remove a user from a billing account.
There is a way to do this using Application Variables and a Formula User field.
The first thing you need to do is define the number of users that will be participating in the 'round-robin' by creating an Application Variable. For this example let s call the variable [number_of_reps]