Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,465,489
Community Members
 
Community Events
176
Community Groups

Re-Calculate Value on field value change

Edited

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 

1 answer

1 accepted

0 votes
Answer accepted

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

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 :) 

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

Like Markisio likes this

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_ :) 

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)

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events