Solved: Is there an easy way to make 2 fields interchange ... - Page 2

Robbo

I'd like to create an editable Table View (if possible) with 3 data columns" Qty and either EA or Days. The idea being if the user enters Qty and EA, the Days field is calculated, or if the user enters Qty and Days, the App calculates the EA.

I can probably mess with Initial values to get it to work 1st time, but then if the user decides to update the data, especially if they change from using the alternate calculated field, how do I get the app to re-calc.

Does anyone know of a relatively easy way to do this, or am I asking the impossible?

Suvrutt_Gurjar

The following may or may not fit your requirement. But just presenting a possibility.

The minimum requirement is the record needs to be an existing record and the implementation is through actions. So it is possible in detail and summary view such as table view with inline action.

The expressions assumed are [Days]* [Quantity]= [EA] and [EA]/[Quantity]= [Days]

Implementation in detail view is captured in GIFs below

Compute EA action.

Please note the [EA] changes from 700 to 800 when the days are changes from 35 to 40