AnsweredAssumed Answered

Create alert if calculation field value is out of range

Question asked by HawkGX on Nov 14, 2016
Latest reply on Nov 14, 2016 by philmodjunk

Our company's printing quotes and order database currently calculates the profit margin for each job.  It's basically set up to allow us to quote prices for up to 4 quantities per job (Quantity Fields A, B, C and D) as well as enter our raw cost for each quantity. What we want it to do is to alert the user whenever the calculated margin for any of the Quantities falls below a certain value.

 

For example... our User enters in a raw cost and a customer cost for Quantity Field A and Quantity Field B.  Margin Field A and Margin Field B are calculation fields that determine what our margin is for each of those quantities.  Let's say the threshold for the acceptable margin value is 0.50.  The User's manually entered customer cost for Quantity Field A results in a Margin Field A value of 0.60. That value meets our margin threshold requirements.  However, the User's manually entered customer cost for Quantity Field B results in a Margin Field B value of 0.45.  In that case, we would want the database to alert the User somehow that the price they entered resulted in an unacceptable Profit Margin for Quantity B.

 

Does this sound possible within Filemaker Pro?

Outcomes