I would like to create a product order form with a form line for each product where the field represents the quantity ordered for that item.

Adjacent to that should be a field that shows the total cost for each item ordered (multiplying the quantity ordered field by its assigned per item cost)

I am wondering how to achieve this?

Jarrod,

This can be handled using Dynamic Forms Client Side Events feature. You would just need to have some client side events that would perform a calculation so that when the user changed the quantity it would execute a calculation and show a new total. If you want to create a quick form on www.betasprings.com (login as host/dnnhost) with the look you are wanting, I should be able to assist in getting a client side event that will handle the calculation you need.

-Chad

Ok. Check out your test form now that you setup on Beta Springs. Obviouslly you might not want the total there, you could have it before the submission button, or maybe at the top of the page but I set it up so that it now has a running total.

For anyone else looking for this you can find the test page here that showcases creating a running total as the user is filling out the form.

For these types of implementations you just need to setup the function for totalling all fields (and any other calculations) once and then when its working you can add that same client side event to any additional form fields you would want to have generate the total.


-Chad

Hi Chad,

I need to know how to do the calculation on your Beta Springs page: http://www.betasprings.com/DynamicForms/CalculationField2/tabid/214/Default.aspx

Korry

Hi Chad.

I was playing with the client side event, and for some reason the running total to the right of the field no longer works.  I am not sure why.

http://www.betasprings.com/DynamicForms/JarrodsForm/tabid/276/Default.aspx

As a seperate angle to this question, is it possible to generate a form like the one described here, but somehow drawing the labels for each field from my sql database, as well as the amount that each field is multiplied by being drawn from the price of the item in my database.

For reference, my website is www.bwwines.com

Hi Chad,

 can I have in dynamic forms a field that would act as an  order number that is unique? Thanks,

Eric

There are two ways of doing this. 1 would be a textbox or hidden field with a SQL Default, the SQL default would basically generate a unique variable (such as a GUID). The other way is... Dynamic Forms already has a unique GUID available to you for each unique form submission. The token for this is '$(UniqueCompletionID)'. You can store this as a primary key. There is also an option in module configuration, general settings to 'Pass unique completion ID' which passes the value as a session variable called UniqueCompletionID.

-Chad