Sorry if this is more of a Salesforce question. But I’ve been stuck on this for a while. Maybe I am missing something.
I have a parent object (Location) and a child object (Exposure). This means people can add payroll, sales, man hours, etc. to the location on a monthly or quarterly basis.
There is also a child object of location called “Incidents.” To put it simply what I want to do is be able to show the number of incidents that occurred at this location in the exposure period created. Ideally this would be a formula but I don’t think that’s possible.
The other two options I am thinking of are UI only fields, or building some sort of a process/flow that updates a field on the exposure object every time an incident is created/edited on this location.
Anyone have any better ideas?