Pipeline Idea Needed
I'm struggling with how to accomplish something in Pipelines. In a previous discussion, it was pointed out that For Each loops run in parallel, which is where this is becoming tricky for me. Parent...
Forum Discussion
Step 1 - Search Materials
FOR EACH MATERIAL
Step 2 - Search Orders where Order Material Group = Step 1 Material Group
CONDITION
If Step 2 is Empty
Step 3 - Create Order where Order Material Group = Step 1 Material Group
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
FOR EACH MATERIAL
Step 2 - Search Orders where Order Material Group = Step 1 Material Group
CONDITION
If Step 2 is Empty
Step 3 - Create Order where Order Material Group = Step 1 Material Group
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- Blake,
The problem with that is, Pipelines does not search the first material, look if empty, and if not create, THEN move to material two.
It starts searching all triggered materials simultaneously and in parallel. So if two are labeled 'B', it will run them at the same time, look, say 'its empty' and create two at the same time with the Group B.
Or in other words - the for each loop - all fires together simultaneously.
------------------------------
Mike Tamoush
------------------------------- MarkShnier__You
Qrew Legend
Mike,
I have not tested this and don't have much experience with Pipeline failures. But assuming that they don't turn themselves off if there are too many errors, then what if you create a formula field set to unique field which is some combination of the order and the group.
Then let the For Each run and some of them will fail as they are essentially in a"race" condition to create the record and cannot all win.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- You could also create Summary fields for Max Record ID# for the Materials. You would want to create one Summary field for each Group option and have it filtered by the Group. You would then bring that down as a Lookup to the Material record and set a Checkbox Formula field to compare the Record ID# to the Max Record ID of the corresponding Group. If they match, the Checkbox is true and you can then use that in your condition for the Create Step . This would limit the creation of a new record to only 1 per Group.
Blake Harrison
Owner / Quickbase Solution Architect
Phone / SMS: 404.800.1702
