Since manually adding a comment doesn’t go into any existing “fields” of the table, I can’t use trigger to automate this.
Can this be achieved using scripts instead?
Solved
Email notifications when user makes a comment on any record
Best answer by JonathanB
If you use @[user] in a comment box for a record they will receive an email notification. Or it’s non-users you want to notify, you could try using a field that is hidden from general view for people to add comments, which then triggers a notification. If you do this you’ll want to put some kind of time delay on the notification though, because the trigger fires automatically as soon as the user starts typing, so you tend to get a notification with just the first letter of their comment!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.