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.