auto-calculate

  • Profile Image
    PiotrD
    Asked on July 12, 2010 at 09:06 PM

    Other form builders allow me to program a field to auto calculate itself based on information that is input into other fields. Do you offer such features? If so, I am having difficulty finding them....

  • Profile Image
    aytekin
    Answered on July 14, 2010 at 07:48 AM

    No, auto-calculations are only available on the payment questions. It can calculate the total of the payment. I added your suggestions to our suggestions list.

  • Profile Image
    stravieso
    Answered on July 26, 2010 at 12:10 PM

    I think it's a must-have feature.

     

    Please, please, please, introduce it!!

     

    Thanks!!!

  • Profile Image
    ebizz
    Answered on September 09, 2010 at 04:10 AM

    We're also struggling with this calculation issue. It seems to me that this must not be very complicated for a web developer.  Please add this feature asap.

  • Profile Image
    PiotrD
    Answered on September 09, 2010 at 07:44 AM

    It would be great if such a feature existed for fields outside of payment. Please please please :)

  • Profile Image
    aytekin
    Answered on September 09, 2010 at 08:17 AM

    Sure. I'll prioritize this. Can you provide some examples on how you would use this? What kind of questions you will have and what will be calculated?

  • Profile Image
    PiotrD
    Answered on September 09, 2010 at 08:44 AM

    I volunteer with a committee at a city hall in Canada and we are trying to figure out city energy and power usage. The information collected does not need to be private as it will not be collecting any names or addresses.

    I would like to use the form to give people the ability to input the rate they pay for energy and how much they use. That information would then be used to autocalculate the total amount of energy used. Subseqently in my personal spread sheet I would determining what percentage of homes input data and use that formation to linearly extrapolating total apporoximate city energy and power usage.

    Also, it would be nice to have the slider function included in auto-calculation aswell. Sometimes things are better expressed via a slightly vague position on a number line rather than a concrete number. For example, people could provide input on how satisfied they are with certain services and the sheet could autocalculate a slider position for resultant satisfaction.

    Another idea, unelated to city hall, is people could be asked to allocated parts of a whole and the slider represeting the whole could move left or right to indicate how much of the whole is left. Negative numbers should be allowed to determine deficits.

    Ok, I would REALLY appreciate this. I hope it's not too hard. All this would really help make your already very helpful form evern better.

    - Piotr.

  • Profile Image
    donaldgg
    Answered on September 13, 2010 at 01:34 PM

    I would like to add fields that are NOT money value, eg. scores that range from 0 to 4 (completed by drop down or radio buttons or both), around 20 items, that I can select combinations, eg. items 1, 5, 8, 11 could get scored up, then items 2,3,8,9, then a total of all of those, and a grand total for everything. 

    The program is already excellent and this would be a major enhancement (it would make me take a pro subscription straight away!)

  • Profile Image
    ebizz
    Answered on September 14, 2010 at 11:19 AM

    I also first want to thank and compliment the jotform developers for their already fantastic development as well as for their open mind and willingness to listen to their customers and adapt the product to their needs.

    Specifically for us it would be used to show some currency calculations for buying our product in different quantities and currencies.

    You could start with a simple, basic calculation line with 3 numeric fields that should allow the 4 calculations (plus, minus, multiply and divide) : Field A [+], [-], [x] or [/] Field B [=] Field C

    1) Field A :
    a) We would fill in a value in this field (or setup a checkbox or dropdown box where we list a predefined number of values), eg. a quantity of some product.
    b) This field could eventually also be left blank so that the user could fill in the values that he wants (or choose from the predefined dropdown or checkbox values that we listed).

    2) Field B : we fill in a value in this field, eg. a unit price.
    Maybe (in a later stadium) you could also consider to add an option for hiding this field eg. if we don't want the customer to see the calculation parameter.

    3) Field C : this field should immediately show the calculation result.

    It would be practical if we could put several calculation lines under each other, e.g. in order to let the user choose from several products.

    Of course the three fields should be able to get a label (with a choice of putting the label in front of the field, behind it, on top of it or under the field ...?)

    I don't dare to ask anything more, but just mentioning : adding a border option around one or more calculation lines would give the ultimate aesthetic finishing touch.

    If you would also consider to add a totaling bottom line, it would make the calculation feature useless for us, unless you offer the option of not showing it.

    Thanks a lot already,

  • Profile Image
    aytekin
    Answered on September 14, 2010 at 11:33 AM

    Thanks for the detailed descriptions and suggestions. These will help us a lot when we develop this feature. :)

  • Profile Image
    ebizz
    Answered on September 24, 2010 at 06:18 AM

    Could you give a hint about the term in which you intend to develop this feature ?

  • Profile Image
    aytekin
    Answered on September 24, 2010 at 07:22 AM

    We hope to develop it within a month. But I can't promise anything.

  • Profile Image
    bhoqeem
    Answered on October 23, 2010 at 10:34 AM

    Mr. Tank,

    It is truly an honor to be able to talk and get answer from you.

    I'm a translator and trying to build my own "Get Your Free Quote" form. So far I have managed to build one similar to that of commonly used by agency sites, but also stuck to the inability to calculate the estimated cost for ordered translation based on the input numbers of words in the previous page. I would like very much if this could be incorporated as well in your development.

    I have tested and do due diligence many similar services and found you to be the only company worths respect. I am a startup venture since August 2010, but intend very much to support you properly once my business develops. Regardless of whether or not my request is implemented. Simply because I sincerely think you are worth it.

    Thank you for your honest and proven efforts to all of us.

  • Profile Image
    jcmbele
    Answered on October 23, 2010 at 04:07 PM

    I had already got quotes from some Web Development Companies to create forms for our small emerging company....Good Lord...I stumbled into Jotform. What a pleasure. What a service. What a product! Auto Calculation is certainly  ideal. We need to create Quotation Forms for various goods and Services. Some Professionals requested US$5000 to develop our forms....my foot!! I have done them in less than an hour without any prior knowledge...!!

  • Profile Image
    bhoqeem
    Answered on October 23, 2010 at 04:19 PM

    @ jcmbele:

    Indeed. Jotform is certainly a fresh wind and a blessing in the mids of various trapping Fremium business models.

  • Profile Image
    aytekin
    Answered on October 24, 2010 at 02:12 AM

    Thanks for your feedback. That will certainly help us with developing the auto-calculation form. So, you both would like to basically have options on the form where users can select to auto-calculate their total quote, but not pay for it.

    We have already tried to design this couple of times but we haven't been able to find a good way to do it yet, so that the auto-calculation feature is both easy to use and also covers most of the requests made by our users. But we like to do the hard things. So, I am completely convinced that we will find a good solution. :)

  • Profile Image
    bhoqeem
    Answered on October 24, 2010 at 03:50 AM

    Yes, thank you, Mr. Tank.

    It's comforting enough that you are readily answer and actually on the process of implementing the said feature.

    I have every faith in you that it will be done, and when it does it will be as great and communally rewarding as the rest of other great features already featured here on Jotform.

  • Profile Image
    aytekin
    Answered on October 27, 2010 at 06:24 AM

    We have reviewed all requests regarding calculations and decided almost all of them can be handled with our existing payment integration tool. So, we have just release a new field type on "Payment Tools". It is called "Purchase Order". It basically allows you to create payment forms without any payment vendor integration. You can use that to accomplishmost of the requests on this thread. Please give it a try.

  • Profile Image
    marshth
    Answered on September 13, 2011 at 01:20 PM

    This would be perfect for me if you would allow for subscription based donations. I tried using the products but you must enter a price or "0.00" which of course displays "Free".

    Rats!

  • Profile Image
    NeilVicente
    Answered on September 14, 2011 at 01:29 PM

    @marshth

    I could be wrong but I think your issue is quite unrelated to the original topic in this thread. Would you mind opening a separate thread to avoid confusion? Thanks!


    Neil

  • Profile Image
    marshth
    Answered on September 14, 2011 at 02:22 PM

    No, this thread is exactly what I am looking for, an auto-calculating set of fields. The only difference is that I would like to able to use it for donations as well.

     

    Thanks!

  • Profile Image
    NeilVicente
    Answered on September 14, 2011 at 02:30 PM

    Alright, but can you please open a new thread containing as much details as possible regarding your goal? What exactly do you want to accomplish?

    I'll be waiting for your responses on the new thread. Thank you.

  • Profile Image
    joybooster
    Answered on March 18, 2012 at 11:10 PM

    Unfortunately, the Purchase Order solution does not work if you already have a Payment field in the form.  (Only 1 payment field allowed per form.) I have a form (#20778353351960) in which I have a created a worksheet to come up with a payment amount.  I cannot use the PayPal payment feature to add up the costs because there is a cap on the amount to be billed.  (Utilizing Payment feature the form may add up to $625, but we have a maximum fee of 500.  If I used the Payment feature to auto calculate the user would be overcharged.  So I have created a manual table for the user to figure out their costs, then they input the total costs due, taking into count the fee cap, into the PayPal Pament field.)  In this type of situation I would like the worksheet table to auto calculate the quantity field times the cost per item field, then add up all the total costs at the bottom of the table.  Having the ability for auto calculate field would be great!  (I would use a Javascript, but I do not think it would work with a JotForm form?!?)

  • Profile Image
    mliz
    Answered on March 19, 2012 at 12:21 AM

    @joybooster

    You can use javascript to create a function that would calculate the fields however this can not be done within the form builder it self. You will have to download the full source code which includes the javascript codes edit it then embed it to your webpage.

    To download the full source codes for your form:

    1.  Go to Setup & Embed
    2.  Click the Embed Form button
    3.  Choose Source
    4.  Click the link that says "here"


    Thanks!

  • Profile Image
    Indianrv
    Answered on June 04, 2012 at 08:18 PM

    How do I select more than one item in a "Purchase Order Field"

    eg. I want to purchase 3 units of an item shown, NOT tick the item.

  • Profile Image
    jeanettebmz
    Answered on June 04, 2012 at 08:27 PM

    @Indianrv

    Could you please open a new thread with your request? In the meantime, could you please check this guide?

    Cheers!

    Jeanette