I think the problem with the timing was that I was using multiple transaction groups with the same SQL tag as a trigger, so one of my groups was using the trigger and resetting it before the other groups could see it.
I would like to be able to decide conditions where I can insert a new block or row AND update a row or block depending on a condition or triggering method inside of the group.