Can Formulas Be Used in Forms to Show the Results of Calculations Performed on Field Values?

  • Profile Image
    tinman230
    Asked on September 25, 2015 at 08:55 PM

    I would like to have a numerical value that is calculated according to addition and multiplication or subtraction from values that are entered by the person completing the form. 

     

    Example, question 1 = 2, question 3 = 7. I want a formula to say (difference in questions one and three = 5)

  • Profile Image
    abajan
    Answered on September 26, 2015 at 09:00 AM

    Yes, this is quite doable, as illustrated in this demo. Just include a Form Calculation widget in the form (see How to Add a Widget to Your Form) to capture the values entered in the relevant fields and put the requisite expression to output the desired result. If you were to clone the demo and open the calculation field's wizard

    you'd see the following expression in its work area:

    That widget is capable of performing fairly complex calculations but that's the general idea. If you need more assistance with this, please inform us.


    Thanks

  • Profile Image
    tinman230
    Answered on September 26, 2015 at 10:47 AM
    I found it after submitting the question. I've already applied two of them. Thanks for the help. Great product.
    -
    TI
    ...
  • Profile Image
    jonathan
    Answered on September 26, 2015 at 06:36 PM

    Thank you for letting us know all is good now.

    On behalf of our colleague Abajan, you are quite welcome.

    Feel free to contact us again anytime should you need further assistance.

     

    Cheers