Summation field (calculated)
Last Post 03-05-2009 07:07 AM by David To. 7 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Rob RalstonUser is Offline
going with the flow
going with the flow
Posts:47
Avatar

--
08-06-2007 10:56 AM

    Hi Chad,

    I saw some other recent posts related to calculated fields. I've just started using DynamicForms and would find it useful for a particular application for a Total field which would add up other selected fields.

    This particular scenario would have check boxes next to options. When the options are selected, the summation field would dynamically show the total amount. I am not trying to make a shopping cart, just a form that allows a user to make selections, see the result and submit the form for further action.

    I'm sure you would need to make this much more flexible and handle various other situations, but thought I would let you know there is interest in this ability.

    Rob Ralston

    Rob Ralston
    SilverBullet Technologies LLC
    www.silverbullettech.com
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    08-07-2007 02:49 PM
    Rob,

    Hi. Thanks for your comments. Yes we are for sure adding this to the next releases of Dynamic Forms and Dynamic Registration (as well as build-in payment ability such as Authorizenet and Paypal).

    Not sure exactly how it will function at this point but we will take your comments into consideration. What we are guessing right now is that a certain field will 'Fire' a calculation and the calculation can be based on short field names etc...

    Basically for a checkbox it would be an 'On Checked Change' javascript client side event that could be specified within the field settings. For the textbox fields they could be different. The actual text would be something like this:

    $(TotalValueField) = $(Checkbox1) + $(Checkbox2) + $(Checkbox3) etc.... In your case you would probably have to enter the calculation field on each checkbox field type.

    Anyway, this will end up being a fun release/enhancement as these will be very fast (won't require postback for calculation) events/calculations and the integration as an e-commerce/payment form will be an added plus.

    -Chad

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    08-07-2007 05:54 PM
    Its a little scary when I get so excited about something and let me tell you I am excited about this enhancement

    This feature is basically already being tested in our test environment right now. It will work as I mentioned above. You won't need to know any javascript although since it technically is 'calling' javascript you will still have to be careful with the syntax so....

    $(Field1) = $(Field2) + ($Field3) would work great, still researching all of the calculations that can be done but so far so good.

    Rob RalstonUser is Offline
    going with the flow
    going with the flow
    Posts:47
    Avatar

    --
    08-08-2007 01:26 AM
    That's pretty cool.
    Rob Ralston
    SilverBullet Technologies LLC
    www.silverbullettech.com
    Amy BarkerUser is Offline
    wading in the water
    wading in the water
    Posts:23
    Avatar

    --
    03-03-2009 06:16 PM

    Where do you actually put the code $(Total) = $(field1) + $(field2)??

    that's what I'm most confused with!??

    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    03-04-2009 06:32 AM
    HI Amy, you put these in the client side event under "Advanced Field Options". For example, let's say you have a textbox with shortname "Total" which you want to set equal to sum of textbox shortnames "field1" and "field2". Where you manage the question for Total, expand the "Advanced Field Options" and in the "Client Side Event" box, enter: $(Total) = $(field1) + $(field2)
    You can check out other form demos at this url:
    http://www.datasprings.com/Products...fault.aspx
    -- David
    Amy BarkerUser is Offline
    wading in the water
    wading in the water
    Posts:23
    Avatar

    --
    03-04-2009 05:55 PM

    How / when does it display the answer??

    I would ideally like it to display instantly as you tab off the field1, field2 etc..? Is that possible? or does it need to happen after clicking submit.

    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    03-05-2009 07:07 AM
    It will display the answer right when you tab off the field. -- David


    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi