Tweet
I want to add a field to list and detail view of an Account displaying the number of the Contacts. I wonder if I can use calculated field for that purpose? I don't see any sort of COUNT function though.
-
-
Increment field (number) by default you can only one in database, but Eblasoft has an extension (Number Pro), that you can use for several incremented numbers. Perhaps this would be a solution.
-
I don't want an increment. I want count, which can only go down. If calculated field is not an option my second guess would be a number field which will be updated by script on Contact save. ?Comment
-
is begining for your request
If you could give the project a star on GitHub. EspoCrm believe our work truly deserves more recognition. Thanks.Comment
-
No, on the database level it's not appropriate to use an aggregate function in a row.If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.Comment
-
It's possible to utilize a left join with a sub-query. We did it in sales pack to calculate stock quantity in for a product. I believe it was already covered on the forum before.
Left-join and a select expression can be added in recordDefs > selectApplierClassNameListIf you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.Comment
Comment