I need to count the number of active "Placements" each fiscal year, for each student (Contact). Each Placement has a formula field indicating if it is active during any given fiscal year, e.g. "Active In FY24-25". I can't use Roll Up Summary since it's not a master detail relationship. So I wrote a flow that first gets all Placements with Active In FY24-25 = TRUE, then gets all Student records. From there, it has nested loops for each student, checking all placements. As expected, this hit a CPU limit exception. There must be a better way to do this, but I can't think of it. Any advice would be much appreciated.
#Flow
Thanks, but I don't write Apex code. Is there any way to do this with Flow?
Ken Tallman
970-903-8818
6512consulting.com“We make a living by what we get, but we make a life by what we give.” Winston Churchill