New to FileMaker! Need help summarizing fields!
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
- 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!