Forum Discussion
Funny, I just had this exact conversation with the client yesterday. We came to the conclusion that the best solution would be a loop in callable pipeline that would call itself.
so there would be a manual trigger after your import, and that would trigger a Pipeline and the pipeline would just have two steps. It would sense the trigger and then it would call the COLA Pipeline.
then the color of a pipe line with start with the first step of pipeline called,
Then the next step would search for records, which needs a parent added, but limit the search results to one. Then branch on IF the search was not null, to create a Parent and then Call itself.
It is important to put in the test for the search not being null. Otherwise the pipeline will loop forever. Note that when you call a pipeline that will count as a step run. If the plan you are on limits your step runs it will cost you a step run per parent created.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------