Thanks very much in advance for anyone who can help with this.
I use Airtable to manage registration for programs that our non-profit offers to the community. When a person registers for a given program, their name and information populates to a registration form (photo attached of an example) and when they register for multiple programs, they get duplicated to various records - one for each program they are registered for. Is it possible to simplify this so that when a given name or email registers, it lists them only once and then once their name is expanded it lists every workshop they have registered for?
Additionally, all registrants are populated to this single registration spreadsheet tab. We then manually copy them individually to a new spreadsheet with just the registrants of a given workshop (shown in top right corner of attached photo below). Is there a way to have this automatically populated to a specific tab for the workshop?
Thanks very much for any help!