PJBluske
asked on
How can I include a repeating table in a SharePoint Designer 2007 e-mail notification?
We are using SharePoint Designer 2007 to create workflows for a Windows SharePoint Services 3.0 form library. Our InfoPath forms are 2003-compatible. In a workflow, we would like to create an e-mail notification that includes form fields which are from a repeating table, but something is getting lost in the translation. In the e-mail, there are no line breaks between rows. We end up with a single row containing all the values for all of the fields in the repeating table. How can we force line breaks so that the repeating table resembles the one in the InfoPath form?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yah I totally understand.
If you generate the email from InfoPath, you have more options since the data is still in a repeating state. You could have a custom email smtp and do whatever you wanted.
You could store the data in a database, which I would recommend anyway, since then you can do all sorts of reporting and aggregates and all of the repeating elements are preserved.
If you have to work with data in SharePoint then what you see is as good as you get or you have to create another list to store the repeating elements and try to link to them manually.
One have is to create your own additional field, and then in InfoPath manage is and concatenate the data into the way you might want to see it, with your own seperators. Or if there is a finite amount or elements, allocate 10 fields and populate each one with a value from the first 10, etc.
You have just run into a design / architecture limitation with using SharePoint as the data repository.
you may be interested in the Database Accelerator tools www.qdabra.com has to offer.
If you generate the email from InfoPath, you have more options since the data is still in a repeating state. You could have a custom email smtp and do whatever you wanted.
You could store the data in a database, which I would recommend anyway, since then you can do all sorts of reporting and aggregates and all of the repeating elements are preserved.
If you have to work with data in SharePoint then what you see is as good as you get or you have to create another list to store the repeating elements and try to link to them manually.
One have is to create your own additional field, and then in InfoPath manage is and concatenate the data into the way you might want to see it, with your own seperators. Or if there is a finite amount or elements, allocate 10 fields and populate each one with a value from the first 10, etc.
You have just run into a design / architecture limitation with using SharePoint as the data repository.
you may be interested in the Database Accelerator tools www.qdabra.com has to offer.
ASKER