I’m using AirTable to assign projects to members of a team. Setup is as follows:
- Design Team Table
- Email Address
- Master Table with list of projects,
- Assigned to Field which is pulled manually from the Design Team Table
- Status which starts as Requested, moves to backlog and then is change to Active when the work is assigned to a specific designer
I would like to be able to send an email to a designer when we assign them a project.
I’m pretty sure this is not doable in AirTable natively. Can it be done using a Zap? I have found ways to send emails if you have a single table for one user, but that’s all I’ve seen.
Appreciate any help.