- DanBlumAsked on February 11, 2018 at 09:17 PM
All of a sudden none of my subtotal calculation fields are working! They show blank. The grand total shows blank too. Can you help me.
You have to select Member or Guest from th "NCSU CLub Member?" field (Q2), then choose any couple of weeks from the Week Picker (Q12). Then pick any enrollment and golf club section and you'll see that the total on the next card is not calculating the sum of the enrollment and golf club selection.
This was working and now not at all. At one time I had somehow gotten the setting of "clear hidden field values" set wrong...but its correctly set on Clear on Submit.
this is really weird
- JotForm SupportAdrianAnswered on February 12, 2018 at 04:57 AM
I have tested the form but I was not able to replicate the issue. I have tried selecting Member and Guest and also selecting different weeks but the total seems to be calculating correctly.
Please try clearing the cache of your browser or using a different browser.
Let us know if the issue persists and which fields you selected to replicate the issue.
- JotForm SupportEltonCrisAnswered on February 12, 2018 at 03:53 PM
As discussed in chat, I'll be using this existing thread and submit it to our developers as a bug.
So, when I test this, I was able to reproduce the problem. It is happening when "multiple selections" is enabled in the drop-down field. I'm not quite certain but this probably has something to do with the recent update since this was working fine as you mentioned.
Here's my test form: https://form.jotform.com/80425793264966
We will let you know here once this is fixed.
- DanBlumAnswered on February 12, 2018 at 06:05 PM
Here's more from my perspective. The calculated fields stopped working again today. Maybe some update was made by the Jotform team?
Elton felt that the "Calculation results are read only" setting had changed on the associated calculation fields. I had not changed these, but then manually put in this setting for one of the calculations, but it didn't fix things.
Elton added at the end that he thought removing the "allow multiple selections" on the dropdowns that were being referenced by the calculation fields would make the symptoms go away. I have subsequently removed the "allow multiple selection" on some of the drop downs, but the calculation field referencing them still didn't show the result. (Does it matter that some of the dropdowns (not referenced by a particular calculation field) still have "allow multiple")?
(For the record, my application requires the "allow multiple selections". )
I'm lost. (and a bit confused). Is the CARD's feature "ready for prime time"?
- JotForm SupportEltonCrisAnswered on February 12, 2018 at 06:21 PM
Apologies for the confusion. It is actually me, Elton who replied your post.
As I've mentioned, we were able to identify the problem and it is caused by the multiple selections in the dropdown field as you can see in my demo form.
Your form has multiple dropdown fields so you need to disable the "multiple selections" in all of them in order for the calculation to work. Here's a cloned version of your form with "multiple selections" disabled in the dropdown fields and the calculation is working https://form.jotform.com/80427063864964. You can clone this form if you want.
Anyway, this problem is already forwarded to our developers. Once this is fixed, you will be surely informed here. We apologize for the inconveniences this has caused.
- JotForm DeveloperbulentAnswered on February 14, 2018 at 02:13 AM
We have just fixed this bug. We apologize for the inconveniences this has caused.
- DanBlumAnswered on February 14, 2018 at 07:51 AM
Thanks. Interesting that when I initially just tried it, it was still not working. I tried a second time, still not. I recalled that I might need to select the calculation option that the field was read-only. I did that and it then worked. Shouldn't that field be set by default? Shouldn't the calculation work whether it's read-only or not?
This was on a Window's 10 desktop. The issue never arose on my IOS Iphone.
- JotForm DeveloperbulentAnswered on February 14, 2018 at 08:11 AM
It must be the cached version, when you updated anything it must be refreshed the cache. Calculation works whether it's read-only or not, I have just tried it and it seems working fine, do you still have this issue?
Thanks for helping us to fix this bug.
- DanBlumAnswered on February 15, 2018 at 10:01 AM
It works now. However, there seems to be something unstable. On occasion, I will go to one of the calculation fields we've been looking at and again it will not be filled in as it should. I go back to look at the 3 "constituent" fields to verify that a numbers are there. Find the constituent appropriately there, return to the calculation field and find it filled in properly. I'm not sure what's going on. I'll just proceed with deploying the form I've created.
- JotForm SupportAdrianAnswered on February 15, 2018 at 11:16 AM
I have tested the form and it seems to be working correctly.
I would suggest clearing the cache of your browser or using the Private Mode of the browser (Incognito) when doing the testing.
Get back to us if you notice something is not working again.