nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Alex Medved _ConfiForms_

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

All comments

Alex Medved _ConfiForms_

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_

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

confiforms