Hi! I have two tables with data that’s pulled from another site through Zapier. Table 1 shows a list of registrants for an online class (User ID, Name, Email, Course Name fields), and Table 2 shows a list of users who completed a class (User ID, Name...
And here’s what the rows looks like:
Table 1:
Table 1 also includes their titles and info about their organizations.
Table 2:
That last field is the completion status (Field Name = “Completed?”), which isn’t pulled in automatically through Zapier. ...
Sorry! I was being unclear. Table 1 shows registrations, while Table 2 shows completers. So Table 2 inherently shows people who have registered for a course and have completed it, but doesn’t show registrants who haven’t completed a course.
Hi @Nathaniel_Granor! Thanks! The course name fields look the same across the two tables–text fields with the name of the workshop that a user registered for or completed:
Table 1:
Table 2:
And yeah, I’d ideally want this to run when new data comes...