Jump to content
Sign in to follow this  
angelleye

Send Mail and include multiple related records...???

Recommended Posts

I'm trying to send an email and include multiple related records in the body of the email.

Specifically this is a task manager app that I've put together that consists of the following tables:

Assignments

AssignmentsNotes

These tables are related by AssignmentID, and of course, you can have multiple notes for a single assignment.

I have a button that is used to mark an assignment complete. This fires a script which sets a couple of fields in the assignment table for that assignement and sends an email to the assignment creator informing them that it's been completed.

I'd like to include all the notes in this email but I'm only able to get the first note to come in. I was thinking maybe I could create a calc. field that would include all notes separated by ¶ or something like that but I'm having trouble figuring that out as well. I can only get 1 of the notes to go into any calc. that I come up with.

Any information on how I can accomplish this would be greatly appreciated. Thanks!

Share this post


Link to post
Share on other sites

you could use the list function in a calc field to gather the assignments.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.