9 Replies Latest reply on Jan 19, 2015 10:28 AM by Alejosor

    Getting the portal list of all due invoices into an email (as text)

    Alejosor

      Title

      Getting the portal list of all due invoices into an email (as text)

      Post

      Hi:

       

      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?

       

      Thanks,

       

      Alejandro

      script_image.jpg