Button to start next task

I got this working for a client recently using an Automation.  Basically when a task is changed to completed, then trigger an Automation to scan for records which had the Trigger Record ID as a predecessor.

But the predecessors for a record can be multiple record IDs.  So for example if the record ID that got completed as 12, then scanning for a field in other records for where the predecessor contains 12 is not good enough since there can be 212, or 2212 or 120 ...

So I create this field to convert the predecessors to a text string.

var text Pred = ToText([Predecessor]);
var text PredOne =   PadLeft(Trim(Part($Pred,1,",")),6,"0");
var text PredTwo =   PadLeft(Trim(Part($Pred,2,",")),6,"0");
var text PredThree = PadLeft(Trim(Part($Pred,3,",")),6,"0");
var text PredFour =  PadLeft(Trim(Part($Pred,4,",")),6,"0");
var text PredFive =  PadLeft(Trim(Part($Pred,5,",")),6,"0");

List("-",
If($PredOne  <>"000000", $PredOne),
If($PredTwo  <>"000000", $PredTwo),
If($PredThree<>"000000", $PredThree),
If($PredFour <>"000000", $PredFour),
If($PredFive <>"000000", $PredFive)

so it would read like


000012-000013 if the preds were 12 and 13.

Then I also create a field to zero pad the Record ID of the trigger record so it would appear like 000012

Then the Automation would fire looking for where


000012-000013 contains the value in the field 000012 of the trigger record and get a hit.