I am trying to create a basic order form, that lets the user to check checkboxes for different fees. Like Basic ($10) Advanced ($20), etc. Is there a way to have the form or email form created a total of all those values??

I am still trying to do this now with 2.5, but using comboboxes. Is this at all possible? I saw that some type of field calc was possible, but not sure how to use in an email event.

Brad,

Hi. Yes you should be able to do this now with client side events. You might download the IPORTABLE file found on this Dynamic Forms Demonstration.

I also just setup a demonstration on Beta Springs to help another user wanting to calculate the field into a textbox or hidden field type so that they could then use SQL.

-Chad

OK, I now see the relation between client-side events, Javascript file, and the "CalculateCheckBoxListValues" function. However, what would a similar Javascript function look like for drop-down list values?

Thanks.

My problematic form is here: http://www.w3portals.com/testform/t...fault.aspx

and now my problem is adding the two values fee1 + fee2.

Any idea what I'm doing wrong? I'm using the client side event: $(total) = $(fee1)+ $(fee2)

Thanks.

Brad,

Hi. Great example of a useable feature, we probably need to add something into the default javascript file to calculate fields such as this.

In this example you are concatenating javascript which would be useful if they were characters (such as concatenating first and last name to be display name or something).

I did a quick search on some Javascript examples for calculating fields and saw the parseInt(field) function call. I setup a test javascript calculation field creating total demonstration form just like yours and it appears to be working.

So...

$(total) = parseInt($(fee1)) + parseInt($(fee2))

-Chad

This might not be the right place to ask, if you would like me to start another post, I certainly wiil.

In calculating a total from check box values exactly like the sample, if the total value ends in a zero, it leaves the "0" out.  For example - total is........... $35.9  -  Instead of $35.90.  I just thought of it, so I did not test what would happen if the cost is $35.00, but my guess is it would drop the two zeros.  What would be the script for showing the zero/zeros?

Thank you for letting me know about the parseInt. I should have looked at this forum entry sooner. This solved my problem but I thought I would give people a heads up. If you are adding an amount to an existing field, you want to make sure all fields have values. You can do this by defaulting the values to 0.00 when you define the form. Otherwise, you may receive an error when you perform the calculation.

As soon as I can find a java language reference on-line, I will offer something on the precision problem posed before (nice alliteration, huh). I am sure use of substring and length functions to find the position of the current decimal in the answer and then concatenate the needed number of digits and decimal depending on how close the decimal is to the end of the string.

Hi,

I have found a very easy solution (I can get it to work in a simple HTML) but I do not know how to implement in custom javascript:

The code that works is:

var field = 35.90;
var total = '$' + field.toFixed(2);
or without calling variables
total = '$' + total.toFixed(2);

So can you create a function in custom javascript to just say $(the inputvalue) = $(the inputvalue).toFixed(2);  Obviously this does not work, but I can't figue out what the "name" of the input field of the question is?? Or just a script to say whatever the end result or value of the textbox input, convert it to xxxxxxx.toFixed(2);  Anybody have any ideas to try??  I like the calculatecheckbox and the way it works, but when yo have 99 options, well, it doesn't look good.  I can't even believe when they were creating JS nobody ever thought of currency, like currency($(shortname).  There is sine, cosine, theories i've never heard of etc...But nothing for currency???

Chad, I am getting a Error on this form "total is undefined", I have you form exactly and it is on your beta site I get that error. It must be some thing on my server , any suggestion on how i could go about fixing this?? Thx

Chad thanks for the response, I spent a few hours on this yesterday, and after no success getting it to work I exported the content from beta springs because I knew that worked. I imported it to my site and wham, same error. so building from scratch on beta springs will work but will not solve my issue. I can setup an admin account for you on my site so you can see what I am talking about. Thx.

I have a total that is calculated from combo boxes .. it worked perfectly .. then I exported the module as template and imported it into a new page ( a second form , and now formatCurrency no longer works. It still works fine on the original form .. but on the copied form it does not .. same code. The total updates correctly in a hidden "Total Field" and if I remove the formatCurrency() from the displayed total HTML field it does works .. but when I add formatCurrency() back in I get an object expected error. ??

I've tried renaming fields and innerHTML id etc .. but no luck.

Kelly 

Hi Chad/Candace, regarding previous post .. I copied the javascript file from the module config in the first page form .. and pasted it into the second page form. This resolved the issue.

So just a note that perhaps .. something in the formatCurrency js gets messed up on export/import. Version 3.3.4 on DNN 5.4.1

Kelly