Total records linked to another table
Hi I use QuickBase to manage events. I wanted to know if there was a field that could be automated to show how many registrations one event has and then be able to work out how many free seats we ...
Forum Discussion
This should be easy. Create a field (numeric) on the events table known as Capacity. This will be constant for that event.
Then create a new summary field based on the Event-< Registration relationship known as total number of registrations.
Then create a formula numeric field in the events table known as free seats which is [Capacity] - [Total number of Registrations].
Then create a new summary field based on the Event-< Registration relationship known as total number of registrations.
Then create a formula numeric field in the events table known as free seats which is [Capacity] - [Total number of Registrations].