Forminator email notification with wrong calculation

Hi @sg1magar

I hope you’re well today!

We’ll be more than happy to assist you to get it fixed but we’d need to check the form and actual calculation/notification settings.

Would you, please, export the form and share it with us?

To do so:
– go to the “Forminator -> Forms” page in your site’s back-end
– click on a little “gear” icon next to the form in question
– select “Export” option from there
– copy the given code, put it at https://pastebin.com and post direct link to that new “paste” in your response below.

This way we’ll be able to import the form to a test site, check it thoroughly to find out what’s happening exactly and how to fix it.

Best regards,
Adam

PS: note that exporting the form does not include any submitted form data (so no information submitted via the form will be there – we don’t ask for that and don’t need it).

Thankyou for your reply.
This is the pastebin Url Link:
https://pastebin.com/iaGXRfnQ

• This reply was modified 1 year, 7 months ago by sg1magar.

Hi @sg1magar,

Thanks for sharing the form. I tested in my system but I’m not able to replicate any such issue. The total of the form seems to be the same when compared to the total displayed in the email.

We have a release version of Forminator v 1.25.1. Could you please update the plugin to the latest version and then check whether it works fine?

Please do let us know how that goes.

Best Regards,

Nithin

Thankyou for your reply.
I did updated the version of the plugin but still total in the email notification is not correct. but while filling the form the total seems correct in form but in notification it gets worng.
I want to share you the screenshot of form and the email notification.

I will also attach the data of form

https://pastebin.com/vraZ0GVG

Best Regards

Hi @sg1magar

Thank you for response and sharing the form.

This is a bug in the plugin that’s being investigated currently. It’s related to conditional logic inside repeater field.

In short: if the values come from “different” conditional choices, the issue happens. If they are from “the same” conditional choices, it’s correct. You can see it by selecting e.g. “Gold Coins” and “K24 Coin 30.0g in ALL repeated field sets instead of selecting different ones. If you, e.g. add 2 “sets” both of the same choices the Grand Total will be 60 and it actually will be correctly included in submission and e-mails. But if you make different choices in each repeated set of fields – the issue happens.

Our developers are investigating it and working on a fix but, I’m afraid, I don’t have ETA yet.

Kind regards,
Adam

Hi @sg1magar

As said above, this was already forwarded to our developers and I am marking this thread as resolved, but if you have any additional questions feel free to let us know.

Kind Regards,
Kris

I am also having this issue, the ‘total’ value of the sum of all repeater fields shown on the form is correct, but the value stored in Submissions and sent on email is always zero.

Do you have an updated ETA on a fix for this?

Hi @gigatech

I’m afraid there is no ETA at this point when this will be fixed. Please stay tune to our roadmap: https://wpmudev.com/roadmap/

Kind Regards,
Kris

Hello all,

I had the same issue, solved it and would like to let you know about the solution.

What I experienced: Two radio fields in the form, each with 5 options and associated calculation values (1 – 5). Calculation field at the end that sums up the values of the selected options (e.g. 4 + 2 = 6). The calculation field showed the correct result (6) in the form, while it was a totally different number (14 instead of 6) in the email.

For analysis, I added calculation fields for each radio field that stored the value of the selected option. Result in the database:
– calc field of radio with option 1 or 2 selected was correct (e.g. 2)
– calc field of radio with option 3, 4 or 5 selected was wrong (e.g. 12 instead of 4)
– total calc field was correct because the sum of the correct radio 1 value (2) and the wrong radio 2 value (12) was 14

The solution: After some more research I realized that in the radio fields’ settings, the options 3, 4 and 5 had a red border and a warning about some options having the same value (which was not the case). I deleted the “red” options and recreated them one by one, making sure they had no more red borders. And voilà, the calculation works now and is correct in form, email and database.