For this to work properly, I think it would have to be a custom checkbox field that allowed you to define a limit on the number of contacts that can have the value “yes”. That way, you could have a way for attendees to cancel and free up their spot on the list. And if they submited the form more than once because they “weren’t sure if their RSVP form went through,” they wouldn’t take up more than one spot.