Hi, Erich R. Bühler

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

We have several built-in integrations with form plugins.

These form integrations are :

- integration for Forminator Forms, ( a free add-on), 

- Formidable Forms integration;   and  Gravity Forms integration

-

You could place a form on the front-end, users can post their answers;

then you can link the form to output the data in a wpDataTable;

Important to know is that,  every field from the form will become a column in the table.

-

We have calculation functions to show average, Total, or minimum, only for tables;

and we have calculated/formula columns.

-

But for charts,  we have Chart Grouping feature;  that groups the data that only for values that have same label from certain column, we don't have an "average" feature at this time.

If you enable this feature, the values of the rows with the same label will be summed up and rendered as a single series, if it’s disabled (the default case) all rows will be rendered as separate series.

This can be helpful if you have repeating rows with identical names in your table, and you want to show them as sum of values for this name in your chart. This feature will also work in combination with Follow table filtering.

-

To filter the data, for example depending on User ID, we have a workaround.

Here is an example.

- First, you would have to add a "user_id" column on the source ( usually form plugins store the user ID for every entry in a hidden field, you can use that) , which you can hide from the table if needed. 

We will add a predefined filter value to this column, using a Place Holder "Current User ID";

- Check that the filter type is set as "Text", as shown on this screenshot.

- Here is how an example table linked to a source file looks before we make any changes, with visible filters above the table.

( for this workaround, we have to enable to show filters above the table, in the Sorting and Filtering tab)

And now, when we set the pre-filter, with Administrator logged in ( In our case, the user ID is 1), we only see rows matching that user ID.

- (If you need more detailed information about using Place Holders in wpDataTables, here is our documentation about that https://wpdatatables.com/documentation/table-features/using-placeholders/);

- The user_ID filter is still visible, which means, if someone changes/deletes this value, they could see the whole table.

We will hide it from the front-end with some custom CSS added in the "Customize" section of the main table settings.

- It should be easy to do, depending on your knowledge of HTML and CSS.

You have to find the correct selector using the browser inspector tool, add the style "display:none" property to it, and it will disappear from the front-end.

On our example table, the custom CSS is :

#table_1_5_filter_sections  {
    display:none; }

- Now, the user_ID filter is gone from the front-end.

- Optionally, you can hide the user_id column from the front-end, if needed, either using the column settings tab or the "column list" button from the back end Admin area.

-

But we did not fully understand everything you described, so if you can please elaborate with a bit more details about what you need to achieve, and more details about the form - and we will do our best to advise if we have a good solution for you?

Thank you