Yes, it sounds like you are probably doing it wrong! Lol.

You will also hit up against Airtable’s limit of 25 automations soon, too.

Are you trying to insert each guidance counselor’s name and/or email address in the email? Is that why you’re duplicating so many times?

The way to accomplish this is to start with your registration form. The form should have a linked record field which enables people to choose their guidance counselor.

Then, in your registration form table, you’ll want to add one or more lookup fields to lookup the chosen counselor’s email address, along with any other information that you’ll need for your automation.

Assuming that you’re triggering your automation when a new form is submitted, you can just insert the email address, name, or whatever else you need from your registration form table.

Thanks for the response Scott!

I have a multi select field set up with all of the district counselors names for students to choose. That choice will trigger the email to go out only to that counselor. The data we want in the email is ALL of the data that was collected from the form. Because those counselors are not part of our school, I do not want them to have ANY access to the actual base, just send them the registration data.