AnsweredAssumed Answered

Help with unit conversions and searchability

Question asked by MechEngrGirl on Dec 2, 2015
Latest reply on Dec 2, 2015 by bigtom



I've inherited a FileMaker (version 14) database at work that needs more functionality.

Currently the template uses a Boolean function to populate field labels (gray fields) for specific units of pressure.

Pressure value (white field) is input by user:


Example:  4 Boolean functions include: kg/cm^2,    psi,    kPa,  or   bar


Units are stored in the data base based on selection made by the user.





My goal is to be able to perform searches based on one pressure unit (example: psi) and have all records returned that are equal to 400 psi regardless of the input unit.



Any suggestions on how to accomplish this?

Thank you for your time!