Streaming live at 10am (PST)

Can you send an automated email when a specific input in a collection item is updated?

I’m working on a site for a client that is mostly set up, but they’ve asked me for a specific automation.

When a user adds a member from the ’ InfoPort Members ’ collection to an ’ InfoPort Projects ’ collection (via the last input box called ’ InfoPort User Access '), they want an automated email sent out to the InfoPort Member to say that they have been added to an InfoPort Project.

I’ve tried to set this up using Zapier, and Mailchimp, however it doesn’t look like it’s possible in Zapier (looks like you can only create a zap when a form is submitted or an order has been made/updated).

Is there any other way to do this at all?

Here is the read only link. Any suggestions and help will be greatly appreciated!