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 have remaining. For example, a workshop we run has a capacity of six participants. So if we register four people a field can provide the answer that we have 2 remaining.
Your help is welcome!
Julie
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 have remaining. For example, a workshop we run has a capacity of six participants. So if we register four people a field can provide the answer that we have 2 remaining.
Your help is welcome!
Julie
 62 Points
Posted 11 months ago
 558 Points
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].
 1,016 Points
Hi Julie,
A) You can in your event table you can have a Total Positions field with an integer value denoting the total capacity of participants for the event.
B) You can then on your table for participants have a hidden formula integer field (called say [Used Position]) with the number "1" set as the value in the formula.
C) Go to table to table relationships under your event table, under the master table (events) click add summary field and summarize the hidden integer formula field. call this [Total Used Positions] This will provide the total count of participants assigned to each task.
D) Create a new field called [Remaining Position] in the events table integer formula and put in the formula: [Total Positions][Total Used Positions]
E) You can further limit the ability to create records once the positions are used up on each task but this requires a bit more work/scripting.
hope this helps..
Josh
A) You can in your event table you can have a Total Positions field with an integer value denoting the total capacity of participants for the event.
B) You can then on your table for participants have a hidden formula integer field (called say [Used Position]) with the number "1" set as the value in the formula.
C) Go to table to table relationships under your event table, under the master table (events) click add summary field and summarize the hidden integer formula field. call this [Total Used Positions] This will provide the total count of participants assigned to each task.
D) Create a new field called [Remaining Position] in the events table integer formula and put in the formula: [Total Positions][Total Used Positions]
E) You can further limit the ability to create records once the positions are used up on each task but this requires a bit more work/scripting.
hope this helps..
Josh
Related Categories

App builders
 810 Conversations
 43 Followers

Formulas & functions
 2760 Conversations
 64 Followers

Relationships
 2530 Conversations
 38 Followers

Reports & charts
 2978 Conversations
 81 Followers

Tables & fields
 7024 Conversations
 153 Followers

Tips & tricks
 311 Conversations
 24 Followers

Ask about Quick Base functionality
 906 Conversations
 63 Followers