Add Invoice Balance Summary to Contact List

Notes on the new SeedCode Complete template for FileMaker 13
Posts: 72
Joined: Mon Feb 04, 2013 11:54 am
PostPosted: Sat Jun 27, 2015 7:38 pm
I am trying to add the balance summary for each contact's invoices to the Contact List layout but the result is not unique for each record on the list.

I am using ContactGlobalsInvoices::Summary_TotalBalance as a field on Layout Contact List. Is there a way to make this field reflect each record's summary_totalbalance?

Here's a sample of the modified layout:

contact_list.png
contact_list.png (94.12 KiB) Viewed 6691 times
SeedCode Staff
SeedCode Staff
Posts: 475
Joined: Wed Jan 02, 2013 11:47 am
PostPosted: Sun Jun 28, 2015 7:14 am
If I'm understanding your question correctly, you would create a calculation field in the Contacts table that adds up the totals of all related invoices. Easiest way would probably be to use the Sum() function. Then put that field on the portal shown in your screen shot. HTH -Jeff

Return to SeedCode Complete 13

Who is online

Users browsing this forum: No registered users and 3 guests

(855) SEEDCODE
[email protected]
Follow us: