I have a field MEETINGS.recapStatus that I would like to use to trigger an action to send an email to everyone assigned to the team. The idea in my head is that when a record has an update and the MEETINGS.recapstatus field = "Ready to send" the trigger will run and send an email to all the users with a URL related to that meeting recap (a url on my website with an embedded Caspio Datapage using an external parameter in the url to show the correct record in the Datapage. Things are complicated by the fact that the email addresses I need are in the USERS table, two tables removed from the MEETINGS table where this triggered action originates.
I know this can be done, but it is my first task/triggered action and I could use some help figuring it out.
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
I have the following tables
The tables are related as follows
where < represents a one-to-many relationship
I have a field MEETINGS.recapStatus that I would like to use to trigger an action to send an email to everyone assigned to the team. The idea in my head is that when a record has an update and the MEETINGS.recapstatus field = "Ready to send" the trigger will run and send an email to all the users with a URL related to that meeting recap (a url on my website with an embedded Caspio Datapage using an external parameter in the url to show the correct record in the Datapage. Things are complicated by the fact that the email addresses I need are in the USERS table, two tables removed from the MEETINGS table where this triggered action originates.
I know this can be done, but it is my first task/triggered action and I could use some help figuring it out.
Link to comment
Share on other sites
9 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.