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?
Input Numeric Field in Comments - does not average although it is set
- support
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Input Numeric Field in Comments - does not average although it is set
"Calculate average value" - this option is just for records listing. Just create new Formula fields for calculation in item page.
- rennecke
- Sponsor
- Posts: 214
- Joined: 14 Jan 2018, 12:55
- Name: Eberhard Rennecke
- Location: Switzerland Zurich
Re: Input Numeric Field in Comments - does not average although it is set
Hello.
Many thanks for the feedback.
Do you have a hint, how to count the number of comments for a record?
Regards Eberhard
Many thanks for the feedback.
Do you have a hint, how to count the number of comments for a record?
Regards Eberhard
- support
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Input Numeric Field in Comments - does not average although it is set
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
- Sponsor
- Posts: 214
- Joined: 14 Jan 2018, 12:55
- Name: Eberhard Rennecke
- Location: Switzerland Zurich
Re: Input Numeric Field in Comments - does not average although it is set
OK, got it. Thanks.
I use
I use
Code: Select all
SELECT COUNT(id) FROM app_comments WHERE app_comments.entities_id = 25 AND app_comments.items_id = [id]