Input Numeric Field in Comments - does not average although it is set

[rennecke]

Hello.
I have set a field type "Input Numeric Field in Comments" and set "Calculate average value".
My understanding is, that all values in the comments will be averaged.

This is not working. It is summarizing the comments values.

Did I set up something wrong?

[support]

"Calculate average value" - this option is just for records listing. Just create new Formula fields for calculation in item page.

[rennecke]

Hello.
Many thanks for the feedback.
Do you have a hint, how to count the number of comments for a record?
Regards Eberhard

[support]

Comments stored in app_comments table. You can use Mysql query field type (for formula) to create sql to count comments for the record.

[rennecke]

OK, got it. Thanks.
I use

Code: Select all

SELECT COUNT(id) FROM app_comments WHERE app_comments.entities_id = 25 AND app_comments.items_id = [id]