Hey! I’m looking for some ideas on how to accomplish a goal. I don’t need any specific examples, just a push in the right direction.
Let’s say that I want to build a spreadsheet of people that have attended a meeting on a given day, but only if they have not attended a meeting before. I have created workflow that scrapes the names from an attendance list and creates a spreadsheet of names that have ever attended the meeting. Let’s call it the Master List. I’ve also created a workflow that creates a spreadsheet of names that have attended a specific meeting. Let’s call it the Daily List.
However, I want the Daily List to only include people that are not on the Master List. So, basically the new attendees. I know how to use the “If” activity, but what activity would I use inside the “If” activity to see if the person is on the Master list? Is that the “Collection” activities?
Thanks for your help!