AnsweredAssumed Answered

Data from portal row in merge field

Question asked by angharad on Nov 9, 2009
Latest reply on May 27, 2010 by comment_1


Data from portal row in merge field




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.