What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Trouble with final total.Asked by triciadunham on April 23, 2015 at 12:25 PM
Hi there, I got my form all set up, thanks to your great help!
Now I have the order total coming out right, then we have a $30 credit being applied to that amount, and it comes out correct into the Final Pricing box. The problem is in the Paypal amount or My Products box, if there is a negative amount we need it to zero out. As it is, if a negative amount gets totaled into the final pricing box, that negative gets changed to a positive amount in the my products box.
Is there any way to fix that? I have played around in there, but haven't came up with a solution.
If that could get zeroed out when there is a negative balance due, that would be great. If not, is there some way to go around that somehow? We only want to proceed to charge them if there is an overage above the $30 credit.
I hope all of that made sense. :)
Thank you for the explanation about this Tricia. To my understanding you mainly want to have any negative balances negated unless it is an overage that ends up being a positive amount above the existing $30 credit which you are giving your clients.
Our form calculations do allow for much more complex calculations to occur so there is a good chance that something to that effect might be a possibility and we are certainly more than willing to try to help find a solution to resolve this issue of yours.
I will need some time to look into this more to see if I can figure something out for this and get back to you about it as soon as possible.
In the meantime you may want to take a look at http://www.jotform.com/help/267-Form-Calculation-Math-Function-Reference to get a better understanding of using more complex calculations which you might find helpful.
I got it, the link answered my question. I ended up putting a couple of subtotal boxes to pull from and used the link to http://www.jotform.com/answers/368029 to answer my question. Thanks so much. Your customer service is awesome. :)