Thanks for checking Jesse. Yes I was able to get it to work.
I had to do a multi-step zap to pull data from two tables in the members forum. I also had to do some math on one of the drop-down fields in the table.
In the members forum, there is a drop-down field for Organization - the first option in the field is “Pick one” which is data item #1 in the field. So mysql was passing the Organization # + 1 (e.g. third Organization on the list was being returned as #4), so I had to create a zap step of “Organization - 1” to return the correct number for a lookup in another table.
It’s working great now. Each time a new person registers on the Phpbb forum and is approved, their data is passed over to Mailchimp and they are automatically added to the mailing list.