Formula in data table

  • JeffUlanet
    Asked on March 31, 2023 at 2:51 PM

    I'm a new user trying out your platform.

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

    Thanks

    Jeff

  • Mary JotForm Support
    Replied on March 31, 2023 at 8: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 10

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

    1680308091 6427777bcad57  Screenshot 21

    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.