Formula in data table

  • JeffUlanet
    Answered on March 31, 2023 02:51 PM

    I'm a new user trying out your platform.

    Is there a way to add a formula (sum) to a data grid?



  • Mary JotForm Support
    Answered on March 31, 2023 08:15 PM

    Hello Jeff,

    Thanks for reaching out to us for help. Yes, you can achieve that by using the Form Calculation widget. On how to setup the Form Calculation widget on your form you may refer to this guide. I made a sample Demo form that you can explore.

    1. In the Form Builder page, click on Add Form Elements.
    2. In the Form Elements tab, select an either from Basic or Survey Elements you want to add to your form (in my sample Demo form, I chose Input Table)
    1680307830 64277676b36ef  Screenshot 0

    3. In the Form Elements Tab again, click on Widgets.

    1680308091 6427777bcad57  Screenshot 1

    Kindly check out the sample Demo form to explore the simple calculation set and give it a try and let us know how it goes.