Howdy!
The app Iโm designing has a master table (โDetailsโ) and four child tables (โContactsโ, โCommunicationsโ, โHearingsโ, and โEnforcementsโ). For every detail record, there could be multiple child records in each of these tables. The primary key for Details is called โComplaintIDโ and appears in all of the child tables.
Iโm trying to create a workflow that uses data from the Contacts and Communications tables to generate an email attachment and mail it to a static recipient. The workflow begins when the user adds a row to the Communications table. Essentially, the first two fields in the attachment template use data from Communications and then thereโs a start expression that pulls data from Contacts to fill in a table in the middle of the attachment.
Hereโs a visual:
So my question is this: How do I manage to get the data from two indirectly related tables into one email attachment?
Please let me know if you need more explanation or graphics.
Solved! Go to Solution.
Remove [ContactKey].
from the following:
See also Sending Email Only After Adding a Parent Record and All of Its Children here:
Remove [ContactKey].
from the following:
See also Sending Email Only After Adding a Parent Record and All of Its Children here:
Thank you, Steve! This worked very well! You rock!
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |