I had the identical problem.
My solution was to have a Pause Sep using the clock function which caused a random pause before searching for the Patent.
The duration of the pause with this
{{ range(1, 2000) | random /100}}seconds
which generated a pause from 0 to 20 seconds.
The concept was that instead of being essentially simultaneously triggered to to search and then create the parent record if needed, the competing trigger records would have to wait their turn randomly. It didn't work perfectly to prevent pipeline errors but it improved it a lot.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
