Calculation field no longer works after upgrade.

  • Profile Image
    john.roscoe
    Asked on March 01, 2014 at 09:35 PM

    Hi - my form was working perfectly until the recent upgrade to calculation fields. Some still work and I notice the new format has been applied to them, however my TOTAL COST field no longer works.

    I have tried clearing the cache, and have cloned my form and used the new widget by creating a new field called CALCULATION but still doesnt work. This is a big concern as this form is due to go live soon and I cant have changes being made which affect reliability. It concerns me that this is not the first time an upgrade has gone live and caused form errors. Is this possibly caused by a delay in replicating new scripts to all servers??  

    Cloned form number is formID=40597663583972 

    Also - the new design is OK although I would prefer plain text. It is however a bit confusing because the fields look like buttons so you naturally click on them to delete etc, but you cant - they still behave like text.

    I notice my existing calculation fields still have an option to calculate field but this option is not an any new fields created. Will the old function still work?

  • Profile Image
    john.roscoe
    Answered on March 01, 2014 at 10:56 PM

    I think I have the answer - but I hope I am wrong!

    It appears that with the new calculation widget it no longer allows you to repeat a field. Previously if you just entered a field name in the calculation it would place the contents of that field in the calculated field. If you wanted to do arithmetic calculations you had to include the equation in square brackets - but this option is no longer there.

    If you just wanted to strip out a numeric value you could perform a calculation by mutiplying the value by 1 - this is now disabled as well because it assumes ALL calculations are numeric!!

    ie If a field called {NAME} contained the value "event 8" and was used in a calculation = {NAME} the result would be 'event 8'

    If the calculation was = [{NAME}*1] the result would be '8'

    NOW, with the new widget you can only apply the second option because the [ ] are implied.

    Furthermore, because the  new script assumes all calculations are numeric only - it does not calculate AT ALL if any of the fields being used do not contain a numeric value.

    THIS IS A MAJOR BUG as far as I am concerned and it has competely destroyed the logic in my enrolment form which is due to go live very soon!. Can you please get back to me on this as urgently as possible!

     

  • Profile Image
    john.roscoe
    Answered on March 02, 2014 at 12:41 AM

    (I have been investigating further and also see other posts coming on the forum about this)

    the new Calculation widget has also removed the ability to concatenate text fields - so my forms logic no longer works !!

    PLEASE REINSTATE THE PREVIOUS CALCULATION SCRIPT until this is sorted out. 

  • Profile Image
    Cesar
    Answered on March 02, 2014 at 02:39 AM

    Thank you for your input. At this time I will go ahead and raise a ticket to te Dev Team, so that they are aware of your request. Once we have additional information in regards to this. It will be posted through this thread. Thank you.

  • Profile Image
    NRCsupport
    Answered on March 02, 2014 at 10:17 AM

    Hear, Hear !!!

    There are so many places where concatenating strings is useful.

  • Profile Image
    egil500
    Answered on March 02, 2014 at 10:50 AM

    It seems to have corrupted my forms too... maybe especially due to the concatenating string change...as I use it in almost every form I have produced  .It may not be regarded to be a bug... but a change i.. so you should have notified the users to give them a chance to change the businees logic and test it  before implementing a major change like this ... 

     

  • Profile Image
    jonathan
    Answered on March 02, 2014 at 12:07 PM

    @egil500 

    Hi, please create a new separate thread about your issue here http://www.jotform.com/contact/

    This will allow us to assign separate support to your case.

    Thanks.

  • Profile Image
    simplebaby
    Answered on March 03, 2014 at 02:55 PM

    I have already opened my own ticket, but yet I agree with @John.Rosco. Reinstating the previous script would be extremely helpful. 

  • Profile Image
    Welvin
    Answered on March 03, 2014 at 03:45 PM

    @simplebaby,

    Thanks for your thoughts about the calculation feature. We will surely pay attention to your own thread and help you resolve the issues.

    Thanks