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

[Joseph]

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_ 

[Alex Medved _ConfiForms_ · Accepted solution]

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

[Joseph]

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

[Joseph]

I can provide my source if needed

[Alex Medved _ConfiForms_]

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

[Joseph]

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

[Alex Medved _ConfiForms_]

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

[Joseph]

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!!!!!

[Alex Medved _ConfiForms_]

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)