8 Replies Latest reply on May 27, 2010 9:35 AM by comment_1

    Data from portal row in merge field

    angharad

      Title

      Data from portal row in merge field

      Post

      Hello,

       

      I have a table, "Donations," which tracks amounts and dates of gifts for a nonprofit - these fields appear in a portal in my main table (based on Filemaker's template, "Contact Management").  Each gift generated in the portal row creates a new record in the donations table.  I'd like a script that automatically enters the amount & date of the most recent donation in a form letter.  The most recent donation shows up in portal row 1, because I have the portal set to sort by date descending.

       

      Now I want the data from portal row 1 to go into a merge field in my form letter.  How do I specify this?

       

      Thanks in advance for your help.