AnsweredAssumed Answered

Adding a field that automatically counts other records

Question asked by StevenVincken on Apr 30, 2013
Latest reply on May 13, 2013 by philmodjunk

Title

Adding a field that automatically counts other records

Post

     I have a table with records, each record has 4 fields:

     - recordid
     - productname
     - date
     - number

     I want to add another field to each record, called "futurenumber", that automatically contains the sum of "number" of all records with the same productname that have a date later than the current date (today).
     I'm guessing this should be a calculation field? And it's probably easy to do, but since I'm relatively new to Filemaker, I don't know how. So any suggestions are much appreciated!

Outcomes