Is there an easy way to make 2 fields interchange from input to calculated

[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?

[ktsmediaprod]

1. Virtual columns?

I've avoided using them though as my row and table sizes are massive now

2. Update with automation on row value change (bots)

3. A third table interface that can do massive computations when you open a row and change things then update the main table on save. Complicated to an extent needing linktoview deep links and probable user value filtering

4. Add a button in your ui (maybe inline with your output value), have it be the manually compute button

[Suvrutt_Gurjar]

This implementation is through forms 🙂

This implementation will work for the new as well as existing records.

On caveat is the computation is through actions. So the revised computation reflects upon saving the form.

EA computation from days.

Please notice that as soon as days are entered the [EA] fields is non editable.

Days computation from EA

Please notice that as soon as [EA] field is entered the [Days] field is non editable because at a time only one can be editable.

Please let me know and I can share any of the implementations if those seem to be useful to you.

[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

The [Days] change from 30 to 35 when EA is changed from 600 to 700

The implementation below is in table view with an inline action.

When [EA] is changed from 1500 to 2000 , the [Days] change from 75 to 100

When [Days] are change from 50 to 75, the [EA] changes from 1000 to 1500

[Robbo]

Thanks ktsmediaprod and Suvrutt. I will play around tomorrow to see if I can utilise these options. I'll leave the question open in case I need clarification. I appreciate your help

[Mahadevlube]

Nothing is impossible. with the help of bots you can do this very easily.

[Mahadevlube]

Columns are qty, days and ea

Set ea column initial value =qty*days

bot 1

if qty or days change.

Condition : (OR([_THISROW_BEFORE].[qty]<>[_THISROW_AFTER].[qty],[_THISROW_BEFORE].[days]<>[_THISROW_AFTER].[days]))

New Step : data action : set row values for ea =[_THISROW_AFTER].[qty]*[_THISROW_AFTER].[days]

bot 2

if ea change

Condition : ([_THISROW_BEFORE].[ea]<>[_THISROW_AFTER].[ea])

New Step : data action : set row values for days =[_THISROW_AFTER].[ea]/[_THISROW_AFTER].[qty]

after saved you can quick edit three column at the same time.

[Robbo]

Thanks to all of you for your suggestions.  All of the suggestions provide a solution, but none work as seamlessly as I'd like. Suvrutt's approach calls popups, which I was hoping to avoid. Mahadevlube's solution works without popups, but the Bot's don't seem to trigger on a Quick Edit list view until I press save, so I lose the instantaneous update I was hoping for. I might explore VC's as suggested by ktsmediaprod but the fact that there's no easy, seamless way to make this happen easily makes me think I might go back to my end users and see which approach they prefer.

I'm not sure how to accept all 3 options as a solution because they all provide workable options. Is that possible?

[Mahadevlube]

why brother ..its work with quick edit in details view and if you would like to go with list view then u can use the popup methods.