AnsweredAssumed Answered

Creating a Grid or Metrics Table

Question asked by raykennedy on Sep 6, 2015
Latest reply on Sep 8, 2015 by beverly

Trying to figure out best way to create a grid metrics in FMP. I am able to create this very easy with PHP, Javascript for online apps but I wanted to incorporate this into my FMP project. See attached PDF for a visual example of how it would look.


The project would loop on the top row 1 - 30 horozontal columns representing the number of an item (ex: 1- 30 widgets). The vertical rows would be a representation of how many items sold per day. Sales 1 to 20 sales per day of that widget. The corresponding fields that line up by column and row would represent the resulting price based on number of widgets * num sales for that day. (ex: 5 widgets * 10 sales of each * a static price of $10 = $500 per day). Of course the price I would be changing based on a separate field. Hope my explanation makes sense.


Since in FMP it seems even when you loop values you have to create the tables with those fields to do so unlike creating dynamic temp values on the fly online. This requires more setup in FMP which is fine. Not sure the best way to set this up. I was going to create two tables with a third join table and fourth default price table that would basically hold the price. Example would be table #1: widget table with 30 entries in it or loop them dynamically, table #2 sales table representing 1 - 20 sales per day. Table #3 would be a join table those two tables matching 1 to 1, 1 to 2, 1 to 3 etc. This has the potential of getting big so looping is probably most efficient. Table #4 would be the price table allowing me to modify the price as I need to for user interaction basically to avoid putting a static price in each entry, avoiding redundancy of course.


Where I am getting stuck at is how if possible could I create the grid like I have pictured. Am I missing a much simpler process or am I on the right track. I also posted a picture of the grid of the basic table setup. This was created with PHP/Javascript.


Hope my explanation made sense. Still very new to Filemaker Pro so my understanding of the coding end is very much on the novice side but I am picking it fairly quickly and loving some of the built in features which is saving me a ton of code and time.


I appreciate any input and open to any direction that might be more efficient than my process so far.