Create an email list of event attendees for group email

Ask for Help
1

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.

2

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.

3

Just saw that you’re using user specific columns. My solution won’t account for that.

1 Like
4

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.

1 Like
5

Actually, you can :wink:
But I agree, a simpler and more robust solution would be to use a separate linked table.

1 Like
6

Does your solution take into account cases where people would want to revert to unread?

7

No, it doesn’t. And that’s definitely a limitation.
If I was doing it again now, I’d probably adapt the technique that @SantiagoPerez and I developed, which in turn was adapted from @Jeff_Hager’s Reset Multiple Rows example.

All roads lead back to Jeff :rofl:

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…

3 Likes
8

He usually takes some breaks here and there for camping if I’m not wrong haha.

1 Like
9

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.

2 Likes
10

Take care Jeff. We all do need those breaks.

1 Like
11

You’ve been missed, but I understand.
Take care, Jeff

1 Like