AnsweredAssumed Answered

2-way auto-enter calc fields?

Question asked by flybynight on Aug 15, 2013
Latest reply on Aug 16, 2013 by ch0c0halic

I have 3 fields: Qty, PriceEa and Total.

Pretty simple Qty * PriceEa = Total setup.

 

I want the users to be able to enter a number into either the PriceEa or the Total fields, and have it calculate the other.

So, if the Qty is 10 and the user enters 2 into PriceEa, the Total field updates to 20.

But, then if the user changes the Total to 25, I want the PriceEa field to update to 2.5.

 

I thought I could do it with auto-enter calcs, but that doesn't appear to be working.

 

Do I need to set it up using ScriptTriggers? Not a big deal, I was just hoping to have something that worked at the field level, rather than requiring that trigger setup on every layout.

 

Or if you have a better way, I'm all ears!

 

Thanks!

-Shawn

Outcomes