# Create an email list of event attendees for group email **URL:** \ **Category:** Ask for Help\ **Created:** [April 7, 2021, 7:51pm UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271 "2021-04-07T19:51:00Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![rmst60](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rmst60/32/587_2.png) [@rmst60](https://community.glideapps.com/u/rmst60)\ **Post date:** [April 7, 2021, 7:51pm UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/1 "2021-04-07T19:51:00Z")
Probably a simple way to do but I would like to create a list of emails. If someone says they are attending an event then I’d like to add their email list to a field which can used to group email everyone that signed up for that same event. I have a Boolean user specific button that they select if they are attending an event. Having trouble figuring out how to create the email list of everyone who did the same. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 7, 2021, 7:59pm UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/2 "2021-04-07T19:59:11Z")
Im assuming you have a list of events and then a separate list of RSVPs. In the RSVP list, create an ifThenElse column with the following logic: - If RSVP is true/yes/whatever, then EventID - else (blank) Back in the Event list, create a multiple relation column linking the Event ID to the ifThenElse column in the RSVP log. This should create a relation to all affirmative RSVPs. From there, create a joinText column pointing at that relation column to get a comma separated list of emails of people who RSVPd yes. Use that joinText column in an email component or webhook action. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 7, 2021, 8:00pm UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/3 "2021-04-07T20:00:40Z")
Just saw that you’re using user specific columns. My solution won’t account for that. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 7, 2021, 11:13pm UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/4 "2021-04-07T23:13:26Z")
As Robert said, you can’t get a list info with a user-specific columns. Info needs to be written to a new sheet, and each user in his/her own row. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 8, 2021, 1:21am UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/5 "2021-04-08T01:21:53Z")
> [@ThinhDinh](#): > > As Robert said, you can’t get a list info with a user-specific columns. Actually, [you can](https://community.glideapps.com/t/global-announcements-with-user-tracking-copyable/23422) 😉 But I agree, a simpler and more robust solution would be to use a separate linked table. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 8, 2021, 5:30am UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/6 "2021-04-08T05:30:42Z")
Does your solution take into account cases where people would want to revert to unread? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 8, 2021, 5:56am UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/7 "2021-04-08T05:56:34Z")
No, it doesn’t. And that’s definitely a limitation. If I was doing it again now, I’d probably adapt the [technique](https://community.glideapps.com/t/the-magic-inline-list-that-thinks-its-a-choice-component/24834) that @SantiagoPerez and I developed, which in turn was adapted from @Jeff_Hager’s [Reset Multiple Rows example](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211). All roads lead back to Jeff 🤣 PS. Where _is_ he? I assumed he’s off on an easter break somewhere, but it’s not the same without his guiding light leading the way… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 8, 2021, 8:07am UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/8 "2021-04-08T08:07:52Z")
He usually takes some breaks here and there for camping if I’m not wrong haha. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 11, 2021, 7:13pm UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/9 "2021-04-11T19:13:53Z")
I’m still here. I did go camping last weekend, but also needing a mental break for awhile. Might still be sporadic for awhile. Work has been brutal with a lot of long days. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 11, 2021, 11:22pm UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/10 "2021-04-11T23:22:43Z")
Take care Jeff. We all do need those breaks. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 12, 2021, 12:01am UTC](https://community.glideapps.com/t/create-an-email-list-of-event-attendees-for-group-email/25271/11 "2021-04-12T00:01:28Z")
You’ve been missed, but I understand. Take care, Jeff