Announcement

Collapse
No announcement yet.

Use COUNT with calculated field

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Use COUNT with calculated field

    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.
    Tags: None
  • #2
    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.
    Espocrm | EspoCRM Number Pro | Eblasoft
    https://www.eblasoft.com.tr/espocrm-extension-page/number-pro
    Espocrm, New field type named "Number Pro" Similar to Espocrm Number field (auto increment) but you can make it incremental in groups You can pull the prefix from a linked entity varchar field You can specify an int field on the linked entity to hold the counter indicator There is separator param, optional with pad length like in Number fieldUse CaseOn of the most use cases is the order and order items, so if the order has number field you can add number pro to the order item that prefixed by the number of the orderSo if Order number is: O-00046The Order item number will be: O-00046-0001 Read information about the extension . Release notes are available here.

    Comment

    • #3
      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

      • #4
        record - EspoCRM Documentation
        https://docs.espocrm.com/administration/formula/record/#recordcount


        is begining for your request

        Comment

        • #5
          No, on the database level it's not appropriate to use an aggregate function in a row.

          Comment

          • #6
            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 > selectApplierClassNameList​

            Comment

            Previous template Next
            Working...
            X