Suming value of child table in parent table

carrarachristophe

Hello,
I refer to the parent child editor.
Is there a way to, instead of counting the number of users

        {
            data: 'users',
            render: (data) => data.length
        }

We make the sum of a users' field, for example their age?

I found this post but I am not sure it is pointing me in the right direction.

Thanks and regards

kthorngren

You should be able to make any calculations you want. Looking at the developer tools for the JSON response in the example you linked to this shows an example of one row of data in the parent:

        {
            "DT_RowId": "row_1",
            "id": "1",
            "name": "Edinburgh",
            "users": [
                {
                    "id": "1"
                },
                {
                    "id": "7"
                },
                {
                    "id": "13"
                },
                {
                    "id": "19"
                },
                {
                    "id": "25"
                },
                {
                    "id": "31"
                }
            ]
        },

The columns.render function is just presenting the length of the users array. The columns.render function will need changed depending on your data structure. Please provide an example of a row of data so we can help with suggestions.

Kevin