I've managed to get the emails sending when the whole table is created/modified etc. But my goal is to only send emails to a specific person, once a specific field has been changed. There doesn't seem to be too much online, and the AI are no good in this language.

My current code is the basic

  sendEmail({
    from: "me@me",
    to: "you@you",
    subject: "New Bug Logged",
    text: "Hi, a new bug has been logged, please hope online and take a look.",
    html: "<h1>Some Text</h1><i>With Markup</i>"
  });

This is sending all the time after every click or update on the table.

Any advice and resources are most appreciated

Thanks