AnsweredAssumed Answered

Help with unit conversions and searchability

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

Hello,

 

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.

 

 

Example:

 

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!

 

 

 

 

Outcomes