Re: All Rows in Email Content

Home Forum Working with Tables All Rows in Email Content Re: All Rows in Email Content

#4403

Anonymous

This feature is still in the works for an upcoming version, however if you are itching to do it now AND have the database connection agent AND can code your own web services you can try this work-around:

1. Save your table data to your database via the connection agent. (I use form instance ID as the key in my table. It’ll call multiple inserts, one for each row.)

2. Write a simple web service to fetch and format these records, storing the result returned by the web service in a hidden multi-line text field. (I’m lazy, so mine just returns a string, instead of acting as a true XML Web Service.)

3. Include that multi-line field in your email.

(Note: if you include any HTML markup in your response: you appear to need to escape it. Our “web service” wraps URLs in anchor tags and would spill an error if I didn’t.)