Show # of Records Made Today

[Conner]

Hi, FMP Fans!

I have a Table that contains a date Field, among others. Whenever a new record is created, the date automatically fills this date Field.

I would like to create another layout that shows how many records were created today and for each day of the past week or two. Preferably, this would look like a bar chart.

How can I create this layout?

[John Mark Osborne]

The easiest way to do this is to use a find. You can enter the current date or a date range (1/1/2006...1/15/2006). Once you have a found set, you will know how many packages were sent in that range.

You could also create a filtered portal. This requires more work but ultimately might be better if you are changing the ranges often since you don't have to change modes. I just posted an example file demonstrating a portal filter for years that will help get you started. You can see it on this thread:

http://fmforums.com/forum/showtopic.php?tid/181366/post/225920/hl//

You might also want to look at this more complicated portal filter from my web site:

http://www.filemakerpros.com/TYPEAHEAD.zip

Once you understand filtered portals, you can certainly combine this with a plug-in that charts like the one from X2Max < http://www.xmchart.com/ > or go a simpler route and use just FileMaker and the following technique:

http://www.filemakerpros.com/barchart7.zip

Hope this helps.