The Ultimate Site for FileMaker
FileMaker Events
Company: FMPug
Url: www.fmpug.com
Seattle FMPug Chapter Meeting
Place: Washington Mutual Center, 1301 2nd Avenue, Seattle, WA, 98101 - USA
Date: Wednesday May. 28
2008
Pivot Tables & Integrating QuickBooks & FileMaker
Jason Young, FileMaker Authorized Trainer and FileMaker 8 & 9 Certified Developer will be speaking on two topics; pivot tables and how to quickly integrate QuickBooks and FileMaker.
Pivot Tables and Cross Tab Reports:
Pivot tables or Cross Tab Reports are reporting tools used to display the joint distribution of two or more fields in a table. Typically this is done in a matrix called a contingency table, where one set of field values will be represented by rows, and another will be represented by columns. Most people are familiar with these reports from their experience with Excel Pivot Tables, so we’ll start by looking at the Excel functionality. We’ll then look at a traditional FileMaker approach of replicating this by using multiple relationships. We’ll conclude the presentation by looking at a new approach using some of the newer features available in FileMaker like variables, arrays and the List Function, which open up some new ideas for gathering and displaying data.
123Sync™
We will also review a powerful new tool called 123Sync that synchronizes QuickBooks and FileMaker. In about an hour developers and FileMaker novices can integrate a database, stopping the redundant re-entry of data from your FileMaker files into QuickBooks Accounting!
DOOR PRIZE: We will be giving away a copy of FileMaker Pro 9.
TIME: 6:30pm to 8:30pm
Related event url: http://www.fmpug.com/rsvp.php?eventID=784
See all events related to FMPug
Print - Web site - Send to a friend - Add a comment