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
MEETINGS
USERS
USERASSIGNMENTS
The tables are related as follows
MEETINGS.teamID < USERASSIGNMENTS.teamID
USERS.userID < USERASSIGNMENTS.userID
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.
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.
Question
JoeyBrannon
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.
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.