Calculations in Confiforms Field Definition gives different results

Shivalika Sharma
Contributor
October 26, 2024

Hello, 

This is continuation to my last question. 

I have 4 fields which are read only where I am doing calculations with the help of Confiforms Rules for Field Definition (set expression) as follows-

Field 1: Average value of fields A, B, C

Field 2: Average value of fields D, E, F

Field 3: Average value of Field 1 and Field 2

Field 4: Priority ranks given based on value in Field 3 like if Field 3 is 1, then P1, if Field 3 is greater than 1 & less than 2, then P2 etc.,

 

Every time I hit submit and check the results, the Field 4 priority ranks vary. Sometimes its coming out as expected and other times its not. What can I do here to fix it?
Please help.

 

 

1 answer

0 votes
Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 26, 2024

Try enabling “debug” parameter on the ConfiForms Registrations Control macro to see which rules get executed and then

Consider making the rules to run on user action only, so they will not run on form view… unless, of course, you need it that way

Shivalika Sharma
Contributor
October 30, 2024

I believe its happening because fields need some time to calculate their values before submit button is clicked. If submit is hit before the calculations are completed in the background, the answers vary based on where the tricking calculations reached.

Is there a way to make Submit button available after a wait time while calculations are being completed? How can I create that wait time?

Thank you! 

Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 30, 2024

Consider moving your calculations to ConfiForms IFTTT, updating the record on submit if you want to ensure the calculation is done

 

Alex

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events