How would I configure grid calculations. I have an order form with Quantity and Cost and would like to do the math to get the total per row. That said, I would also like to get the total of all total columns for a grand total. Looking at the code, it looks like the ids are random as you add/remove rows.

  • No labels

4 Comments

  1. Hugo

    Hey there,

    Just a suggestion. You can make use of custom html element instead and compose all the grid that you want and with javascript, you can get the total computed as well. Try to look into these area. Good luck!

    Hugo

    1. Doug Admin

      Thanks for the suggestion. I have created a custom HTML form. How do I pass the variables into Joget so that the custom HTML data is saved in the same database as the rest of the form data? Can you provide an example.

      Thanks.

      1. Hugo

        Hi,

        Just normal html tags will do. Joget will handle all the columns creation and storing multiple fields' data by itself unless you are creating the form entirely by yourself.

        Example:

        <input type="text" name="address"/>
<input type="text" name="postcode"/>

<input type="text" name="address"/>
<input type="text" name="postcode"/>

<input type="text" name="address"/>
<input type="text" name="postcode"/>

        Hope it helps!

        1. Hugo

          And here's how the stored data and automatically created column would look like.


          Hope it helps!