Re-Calculate Value on field value change

[Markisio]

Not sure how to explain this, but here its ,

I have ConfiForms Definition of the following

hourlyRate

allocation

cost (read only)

I have the following ConfiForms Rules to set value

Condition: allocation is not empty 

Set Value: cost = hourlyRate X allocation

On adding new record it work fine, however when edit it doesn't work unless I tab to allocation to force calculation rule again, any idea why?

I was thinking to do the following

if hourlyRate changes then clear allocation so I force the user to re-enter allocation, therefore the cost rule calculated again 

any help will be much appreciated :) not sure if there is away to force recalculation on edit mode or clear allocation on change of hourlyRate. 

thanks 

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

So, your rule should be bound to the changes in the hourlyRate and allocation fields (first parameter in the rule), and also to be set to be triggered on user action only

Little demo: http://recordit.co/M7Syr4qcu3

Alex

[Markisio]

Thanks @Alex Medved _ConfiForms_  it works now, originally I had allocation, hourlyRate in the bound for change 

however this is what I have done to make it work. I swapped hourlyRate with allocation in bound to change, but I noticed in Add new record it stopped working but edit works fine.

So I had to create 2 rules one for hourlyRate in bound change and another for allocation in bound to change 

now both edit and add mode work fine.

I am sure there is a better way rather creating 2 rules doing the same thing :) 

[Alex Medved _ConfiForms_]

The example I have recorded for you doesn’t need 2 rules and works just fine with one single rule for create and updates

[Markisio]

Thats right I looked at your video again and you didn't have space between the fields: allocation,hourlyRate . originally I had allocation, hourlyRate

now works perfectly with single rule :) thanks @Alex Medved _ConfiForms_ :) 

[Alex Medved _ConfiForms_]

Having a space there shouldn’t really matter 

unless you are on some old ConfiForms version (I recall we had that issue some time ago)