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

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.

Guest
Reply to this topic...

×   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.

Sign in to follow this  

×
×
  • Create New...

Important Information

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