- RACRUSWALAsked on July 15, 2014 at 05:24 AM
Please can you help me?
About 6 months ago I had a requirement to add the Purchase Order total to the totals of some extra fields on my form. It was not possible at the time to do this on the Jotform Server Platform, so you guy's (Ardy) ever so kindly wrote some custom code for me and I have been chopping up my source code adding this custom written code in certain places to get the result I need and its been very successful until now.
Something changed today that stopped all my forms subtotalling on the form and placing the totals in the field NEW TOTAL exVAT.
Jotform have added a new section - Form Calculations feature.
I would be so grateful if you could show me how to fix my forms or show me an alternative easier way, switching back to the Jotform server and possibly the Forms Calculation Feature.
Here is the Original Source on the Jotform Server
Please see screenshot of what I need to achieve - which was working up until today.
Thanks for all your help
- RACRUSWALAnswered on July 15, 2014 at 05:29 AM
I also have some custom code that I have to paste into my source code file on my server that;
On my email notifications, under the Purchase order section - All products with Zero quantities are Hidden.
So I only show Products that the User has changed the quantity to anything but Zero
- JotForm SupportWelvinAnswered on July 15, 2014 at 07:15 AM
Allow me to check this and get back to you later today. We'll see if what we can do using the Calculation Widget.
- JotForm SupportWelvinAnswered on July 15, 2014 at 07:36 AM
Just an update. Unfortunately, there's no way you can add the Purchase Order tool total in the Calculation Widget result. The calculation widget is limited and would only work with the following fields with Numeric entries/options:
I'm afraid that we can't use Calculation Widget without revamping your purchase order options to use, for example, the checkbox field. So I think we would need to just fix the existing codes that my colleague have made to your form source codes.
I've visited your webpage: http://www.electronic-specialist.co.uk/FormsArea/form/form.html. So far, the extra prices are properly calculated, but the Purchase Order total are not included to the result in "NEW TOTAL ex VATt. This is the only issue, right?
- RACRUSWALAnswered on July 15, 2014 at 10:00 AM
Thanks for your reply. I got it working by stripping the code from the server and adding my code snippets again, and updating the JS andCSS folders on the server., I have another problem
Its calculating properly but my problem now is: When the totals run past £1000.00 the NEW TOTAL ex VAT turns to 1.00 or 2.00 if the totals amount to anything past £2,000.00.
Do you know how to fix this, It's happening with all my order forms now. Will I open a new thread. I have to get this fixed as soon as possible |:-)
- JotForm SupportWelvinAnswered on July 15, 2014 at 11:29 AM
Do you have a backup of the old codes before you've change it with a new one? I am close on fixing the total, but I accidentally close my text editor and forgot to save the old codes.
It's okay if you don't have one. I will just check the codes again.
- RACRUSWALAnswered on July 15, 2014 at 11:44 AM
That probably was not supposed to go there :-)
Thanks Welvin - Can you delete that post when you take the code?
- JotForm SupportWelvinAnswered on July 15, 2014 at 12:57 PM
The codes are automatically converted to the actual form view :) Anyway, I'm checking the codes. It's actually the comma that is preventing the actual amount from showing. When there's a comma, the rest of the numbers are not calculated. Using replace function should fix this. I'll get back to you later today.
- JotForm SupportWelvinAnswered on July 15, 2014 at 02:54 PM
I've fixed the issue with the comma. Get the source codes here: http://pastiebin.com/53c578d20a648.
You can see the result here: https://shots.jotform.com/welvin/pages/RACRUSWAL.html
Let us know if you need further assistance.
- RACRUSWALAnswered on July 15, 2014 at 04:10 PM
Welvin Thank you.
You guys really are fantastic. I have never got the level of service from any software company that I have got from Jotform. Not even the ones we deal with face to face. For a company that's on the other side of the globe that's just outstanding. I won't hesitate to recommend you every chance I get.
- RACRUSWALAnswered on July 15, 2014 at 04:34 PM
Just one thing;
If I need to get this to work across all my forms, Which scripts do I need to replace?
- JotForm Support ManagerJeanetteAnswered on July 15, 2014 at 06:23 PM
First of all, I'm very happy to hear your enthusiastic feedback about us. Thank you very much for your words. We really appreciate it.
Since this is a custom workaround provided by Welvin, I'll forward your questions to him.
- RACRUSWALAnswered on July 15, 2014 at 07:07 PM
I worked it out for myself, Thanks again to you all!
- JotForm Support ManagerJeanetteAnswered on July 15, 2014 at 08:09 PM
You are much welcomed!