I am trying to figure out if there is a better way of doing this. I have customer’s information stored in a database and I want to retrieve it and add it to a send email workflow. I already know how to retrieve the data and how to send email. What I want to know is, do I have to perform a “Do a search for” for each field I want to display in the email workflow or is there a better and more easier way?
Example of what I know how to do right now First Name: Search for CustomerInfos’s First Name Last Name: Search for CustomerInfos’s Last Name Street Address: Search for CustomerInfos’s Street Address City: Search for CustomerInfos’s City State: Search for CustomerInfos’s State Zip Code: Search for CustomerInfos’s Zip Code
I would like something like this: First Name: CustomerInfos’s First Name Last Name: CustomerInfos’s Last Name Street Address: CustomerInfos’s Street Address City: CustomerInfos’s City State: CustomerInfos’s State Zip Code: CustomerInfos’s Zip Code
Set a group or page to be of content type “customer info”
Use a trigger to send the email … as an example a button. Make sure the button is inside the group that has the type of content set to the object you want … in this case “customerinfo”. And make sure the group has one customer info in it. Perhaps, doing your search for customer info first item.
Upon clicking the button use the action send an email and set each needed info as parent group’s customerinfo email … parent group’s customerinfo name … parentgroup customerinfo “your chosen field”
The above is meant for illustrative purposes. Hopefully it makes sense.
I am sorry I may be a bit confused. Attached are screenshots of what I thought you meant. Are these correct? If not, will you please elaborate a little more.
