Number of attendes to an event till now

Topic Labels: Formulas
540 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi There!!!

I am trying to figure out how to solve an issue that it doesnt seem very difficult but i am not able to.

I organize groups to go to the theatre. At the moment someone fills up the form to attend an event, I would like to check if there is still tickets available and if not, send him / her to the wiating list.

For that i woukd need the summary of tickets sold at that moment and this would be te trigger of an automation.

Is that possible? Just want to have a field called tickets sold that summarizes the number of tickets sold until the moment of a new record is created.


1 Reply 1

Hi David! I think the easiest way for you to do this would be to link all the records with the “Sold tickets” information to a single record on another table, and then using a rollup to sum the values

I’ve made an example for you here, where the rollup field will sum the values of records that have the checkbox “Sold” ticked

As far as I know, the only way to get sum values via Automations would be to use a script I’m afraid