Hi Andrew,
I actually originally took the 1st route that you suggested, but then I realized that the condition on the other collection is not met most of the times and so the trigger would get fired every time, but the function would not run half the times or more and so that’s too many unnecessary triggers.
I think I am going to take a variation of the second route that you suggested. It seems to be a more efficient way for my case.
Thanks for the help.