I have created an Airtable with the purpose of tracking call offs and other write ups at my work, with point values associated with certain infractions. I’m now looking for a way to automate the sending of an email to each person to let them know how many points they received, and their running total.
This is what my table looks like:
I have each team member’s email address saved under the “Team Member” tab at the top.
As you can see in the picture, each infraction has a point value, and then at the top, it shows the sum total of points that person has.
How can I get an email sent to each person as points are assigned to each team member?
If you have any questions to help clarify what I need, please feel free to ask.
EDIT: I’m looking at SendGrid right now, but having trouble figuring out if it can be configured to work the way I’m wanting, and it looks like I’d be required to upgrade to the $20/mo package within Airtable, and I don’t think I can get approval on that spending.