Jump to content
  • 0

help sending task based automated email



Our team does a lot of meetings with different clients. We have built an app that will track these meeting agendas and would like to automate the sending out of a meeting agenda to everyone who is on that particular team. 

I have the following tables


The tables are related as follows


where < represents a one-to-many relationship

I have setup a task that I would like to run every hour (currently running on demand during testing) that goes through the meeting list and finds any meeting records where the MEETINGS.sendRecap field is true. It would then send an email to all the users that are assigned to the team that had the meeting.

A secondary function of the task is to go through the meeting list, set the MEETINGS.sendrecap checkbox to false and update a status field to indicate the email was sent.

I have tested this with teams that have 1 user, 2 users and 3 users and every time it says it sends two emails but only one is ever received by any of the users and it is always the same user.

Any help would be greatly appreciated.

Screenshot 2023-10-25 at 9.01.21 PM.png

Screenshot 2023-10-25 at 9.13.50 PM.png

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...