Question

Sum calculation works on form, but once submitted, field becomes "0"

Self-Hosted Forms How To Forms Layout Designer

Updated August 20, 2024

asked on August 19, 2024 • Show version history

I have multiple radio buttons with rating values calculating into a single line field. That is all working great. Then I have another single line field with a sum calculation to sum the grand total of all of the sub-sections. (Literally just summing 3 single line fields). This is a very simple calculation and when you are completing the form live, or in preview, the calculation works perfectly. However once the form is submitted, that final grand total field shows as "0" (Despite the fact that the number in that field when the form was submitted was something else.)

=SUM(Technical_Quality_Total_Score, Effectiveness_Material_Total_Score, Content_Total_Score)

I am using the new designer, has anyone else experienced this?

Thank you!

0 0

Replies

replied on August 19, 2024

Holly,

When you are saving the form to the repository, which saving option are you using? This could affect the results of your calculations.

0 0

replied on August 19, 2024

Emilee - Thank you for your response!

However, this is occurring even before it is saved to the repository. When the form is routed to the first approver, the value is already zero. I ended up finding a work around though that solved my problem, however I still feel that it is a glitch of some sort.

Instead of marking the field "read-only", we added a field rule to "Disable Always". I didn't do anything to change the actual formula for the calculation, but this solved the issue of the calculated value disappearing upon form submission.

1 0

replied on August 20, 2024

Hi Holly,

I used your formula on 4 single-line fields, the value is still kept after submission. I guess there must be some setting you didn't find that fails to work, glad to see you've worked around it, but if you want to have a deep look why it fails for first time, you can contact your VAR to open a support ticket with your business process, then we can take a look.

0 0

You are not allowed to follow up in this post.

Question

Question

Sum calculation works on form, but once submitted, field becomes "0"

Replies

Sign in to reply to this post.