Jump to content

email found set


rservis

This topic is 7343 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a portal on one of my customer databases, shown on this portal is various items ie: title, description, etc.. What I want to do is email a complete list of items the customer will recieve in the message body, I have built a script that finds the found set of records from the related file and I have a summary field which shows all data from one record using the trim (field) in one field but unable to create a field which shows the summary data from all found records so I can use this field in the send mail script.

Link to comment
Share on other sites

I would use a script. Loop through all Customers. For each customer, go to the related records (showing only related records). Then in the items file, loop through, building a concatonation of all the items (separated by commas, returns, whatver) into a global field. Copy this value back to the main file and add it to your email body text.

Jeff

Link to comment
Share on other sites

This topic is 7343 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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