Hi Paul,
I feel your frustration, and cannot provide any specific solutions to your problems right now. However, I will echo that my experience using Pipelines has been a double-edged sword.
Pipelines have introduced many powerful features and functions for our organization. Some of these we already feel are indispensable. But the User Interface and Pipeline development experience is miserable. I am shocked that the Quickbase Team has allowed this product to exist for so long now without at least resolving some of the biggest issues. And now Automations are already on the path for deprecation, while Pipelines don't feel honed in perfectly yet.
One of my biggest complaints is that you can not re-order steps in the UI, and you cannot insert a brand new trigger as the first step to replace the existing trigger. You can download the YAML file, carefully edit it, and then create a new Pipeline using that.
------------------------------
Joel Hickok
------------------------------