AnsweredAssumed Answered

New to FileMaker! Need help summarizing fields!

Question asked by EddieCamacho on Apr 12, 2014
Latest reply on Apr 12, 2014 by philmodjunk

Title

New to FileMaker! Need help summarizing fields!

Post

     Hi Guys,

     I am a complete newbie to FileMaker, and gotta say...so far I am LOVING it!

     I'm trying to build a spending tracker in FileMaker right now. So far, I have (1) tables for the two credit cards that I have. Essentially, each table has the following fields:

         
  •           Transaction Date
  •      
  •           Description
  •      
  •           Payment Method
  •      
  •           Credit Card Name
  •      
  •           Transaction Amount
  •      
  •           Total Spent

     What I'd like to do is create a "tracking" page/layout where there is a Drop-Down field, in which you can select your Credit Card Name, then based on that Credit Card Name, the next field to the right is a date range where you can type in "4/1/14...4/30/14" for example, and then (sorry this is a long sentence) the next field to the right is a Running Total of the amount spent for that Credit Card Name.

     Hopefully this makes sense! Thanks FIleMaker community!

     Best,

     Eddie

Outcomes