Getting the portal list of all due invoices into an email (as text)
I was reading a post about getting the portal list of all due invoices into an email (as text).
I created the following:
The plain text solution:
Define a calculation field, cPortalRow, in the portal table (Invoices) as:
Inv # & Char ( 9 ) & Qb # & Char ( 9 ) ..... & Char ( 9 ) & Amt. Due (didn't type out entire list of fields here...)
Then, in your email body, use:
List ( Invoices::cPortalRow )
The problem I’m having is that when creating the email I get just the first invoice of the table (first line)
My Layout Name is: Clients Payments
Show Records from: Invoices
In order to send the due invoices I created a script that is saving the data of due invoices into a single pdf and then send the email (please see image attached)
So basically, I cannot copy the list of due invoices (it only list the first row of information).
Any idea how all the rows can be listed?