4 Replies Latest reply on Dec 14, 2016 11:35 AM by baronvonteabag

    Are formulas possible inside a table?


      Please bear with me as I try and explain what I'm trying to do.  I've recently been reintroduced to Filemaker after about a 15 year absence and I'm finding I'm slow to remember my old training courses.


      I am working on developing an estimating app/database for my current employer who makes and sells wood pallets, crates and reels.


      In my Pallet quoting module I have a table (relational database) that lists the pallet styles and configurations as well as the different component names for each of the board cut lengths.  Once I have selected the config and style I want the quote "grid" auto-populates with all the key info for that particular configuration.  My board thicknesses are a standard starting thickness (can be modified) as well as my board widths.  The board lengths on the other hand will vary depending on a few other variables (ie:  do they run the length or the width of the pallet...are they flush or extended past the edge of the middle boards, etc).  I would dearly love to be able to put a formula into the table so that when my lookup happens, it takes the Length formula related to the configuration chosen and use that formula.


      Can this be done or am I going to be stuck doing embedded if statements in a formula for each component?


      In the example below...my COMPONENTS, THICKNESS & WIDTH auto-populate based on a lookup with CONFIGURATION & STYLE as the keys



      I hope I've made sense.  If I am doing this all wrong let me know...if there is an easier way by all means let me know that too.


      Thanks in advance for any help!