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,463,473
Community Members
 
Community Events
176
Community Groups

Confiforms Calculation field update as form is filled out or upon initial submission

I have a field that's value is calculated using two fields and then I am setting another field based on the results of the calculated field, however the field that is to be set is not updating upon form submission. It is only after I edit the record does it actually update the field that I want to be set base on the results of the calculation.

 

 

@Alex Medved _ConfiForms_ 

 

1 answer

1 accepted

0 votes
Answer accepted

Hi

When you use a calculated/formula field then this is calculated on submit (on server). Not in UI (on the form)... before the submit

Alex

my apologies we are on data center, so the second field will not set based on the formula field unless I edit the record after its been submitted

I can provide my source if needed

Not sure I get your comments... 

What I mean by "server" is that it is calculated "by server"... not on the form, but while processing your submit

I apologize I misunderstood, so what would you recommend in the following situation

field A is using a formula calculating the input from 2 other fields

then field B is using a separate rule that has a condition that is looking at field A and is going to set the value if field A falls in the range defined in the condition 

 

Below is the source

The fields in reference are 

Project Funding A

Project Funding B (to be set after FDNormalization is calculated)

FDNormalization

 

I apologize I horrible at explaining via messages

 

 

As you are using formula field to calculate some kind of a value and then want to set "ProjectFundingB" value I would switch the (field definition) rules in "Funding Rules to apply values based on users input" section to IFTTT rules that run as post-functions on server and set the  "ProjectFundingB" (sam number, same conditions) via https://wiki.vertuna.com/display/CONFIFORMS/Configuring+ConfiForms+IFTTT+actions+and+rules#ConfiguringConfiFormsIFTTTactionsandrules-Create(Update)ConfiFormsEntry instead

 

As at the moment you have a misconfiguration (logical) where you have formula field that is calculated for you on submit and have "rules" that want to set something on UI, while the value is not available

Your awesome that worked like a charm!!!!!! I was thinking IFTTT rules yesterday but was not sure and just reached the point where I needed help. We greatly appreciate everything!!!!!

Besides, this approach also will work very well if yo decide to add new records via API or via import (as calculations are independent from UI/ form and are done on "server", after submit)

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events