I've just purchased the module because I read that it was possible to calculate fields. Now I find that you have to program javascript in order to do this. I have no knowledge of Javascript so this is a problem for me.

What I want to do is sell tickets. There are 2 textfields: "tickets for under 14 (5 dollar a piece)" and "tickets for 15 and older (10 dollar a piece)". Now I want a total field that will display the total amount. So if a user types 3 in textfield 1 and 5 in textfield 2, the total field should show 65 dollar.

I also want this total to show in the form results (when downloading as excel sheet).

I hope someone can explain this to me, because viewing the source of the examples on betasprings.com is hard for me to understand.

If no one can help me with this, and knowledge of javascript is mandatory for using this module, then I'm afraid I've made the wrong decision in purchasing this module.

Thanks in advance.

Piet,

Hi. Well first, there is no JavaScript knowledge required for any basic calculation. There are tokens you need to use which that are Dynamic Forms specific which the module will render the javascript for you, but you don't have to actually know javascript to handle these. For example, if you had a field called Price 1 with a short field name of Price1, another for Price 2 with a short field name of Price2 and then a 3rd field called Total with a short field name of MyTotal you could easily create a client side validation such as this:


$(MyTotal) = $(Price1) + $(Price2)


You could put that same client side validation in both of the price client side events sections. This way whenever a user changed either price 1 or price 2 it would update the total field.


Assuming that the Total field was either a textbox or a hidden variable, this would be a seperate form field and therefore would end up being exported when you exported the results to Excel.

So... again, any $(Tocken) such as this is not actually javascript, its Dynamic Forms functionality to reference that field or fields value.

Javascript is usually only required when you need or would like to add additional logic to your scenario or the calculation involves complex field types such as if you wanted to calculate based on a coupon code the user entered or maybe calculate based on radio buttons etc... For these cases we do try and provide as many tutorials and/or forms you can download to start from, and we also provide you with many references for these types of calculations on Beta Springs.

For this example, it sounds to me like you would start with setting up a 'total' field so that you know the total is coming up properly. If you wanted to you could then change it to show the total in HTML or you could change it be a hidden field. Then I would start with a basic client side event to make sure its working so when you change Textfield1 it will update the total. You could do...

$(MyTotal) = 5 + 5


Based on your description I think your end total would be something like:

$(MyTotal) = ($(TextField1) * 10.00) + ($(Textfield2) * 15.00)


If you still run into problems or can't figure it out please setup a test page on Beta Springs and let us know what it is. We will review it and see if we can provide some assistance there.


Thanks!

-Chad

Great! I see that I was too hasty with my conclusions. That's what having a deadline does to you

Thanks a lot, it works great!

Hi. Glad to hear!

This depends on what you are updating... This is because when you are displaying it to the user you are probably showing it in HTML or showing it in a read-only field (which viewstate will not save for readonly fields). I imagine if you used a standard textbox field and not read only it would show up properly.

So... The work around is to use two fields and update the calculation there. For example set the total for the read only textbox or html area, and then also under it set the total for a hidden field variable. Then reference the hidden field variable within the email event.

So.
$(MyTotalReadOnlyField) = 5 + 5;
$(MyTotalHiddenField) = 5 + 5;

Then reference the hidden field as the read only field will render 0.



-Chad

Here's the betasprings page I used as an example.  The only difference is that I'm not using a checkbox calculation just a simple qty.

http://www.betasprings.com/Dynamic-...fault.aspx

I set mine up on betasprings as well, so you can see the difference.  I'm sure it has to do with the client side event language on the field   # of prints (my quantity field), but I can't seem to get it right. 

http://www.betasprings.com/Dynamic-...fault.aspx

Total calculation is working great, but not the Text/HTML.  Thanks again!! H