Get (foundcount) calc field to count related records + bonus discussion about the ETS program

Lounge (Discussions)
21

Example Finds...

  • ActivityTemplates with 0 related activities
  • Archived Emails with > 0 attachments
  • Etc.

Often using constrain.

A local count field can also be

  • sorted on
  • displayed in a portal
22

I don’t see how that affects use of the unstored calc for Get ( FoundCount ).

Both use cases are almost always best served as stored local fields in those cases. You update them each time a CRUD action is performed. Finds on unstored calcs, on related fields especially, are very often going to create performance problems at some point.

1 Like