AnsweredAssumed Answered

Value List Help

Question asked by RichardStrohman on Jul 24, 2013
Latest reply on Jul 25, 2013 by RichardStrohman

Title

Value List Help

Post

     I am fairly new to FileMaker and am creating an estimating database for work.  We custom manufacture different sized fiberglass vessels.  That being said each size has a different cost.  What I need is a way to select a size and also use the same value to figure the gallons in the tank.  

     I can sucessfully do this if I use generic numbers such as 1-10, but I need to be able to use expressions such as 5'-0".  When I make a value list like that the formula to calculate gallons comes up with an error becuase it cant read the feet and inch marks.

     I have done something similar in Excel and had two lists of values.  One was the list with feet and inches and the other was matching generic numbers.  I used the lookup function to put the matching generic values in the gallons caluculation.

     Is there a similar way of doing this in FileMaker, or is there anyway I can do this at all?

Screen_Shot_2013-07-24_at_4.22.01_PM.png

Outcomes