Combining Arrays in Bridge
Currently I have a Bridge workflow that updates a dropdown list with job numbers anytime the Job Name & Number Master List sheet is updated. This sheet only contains active jobs and is used to update multiple dropdown lists. For this specific dropdown list I need to add 14 static repair account numbers that will never change. Since the Master List sheet is used for multiple dropdown lists I cannot add the 14 repair accounts to the master list.
In Bridge is there a way to take the array from the master list containing the job numbers and the array containing the repair accounts and combine them into one single array that i can then use to update the dropdown list? I would want to add the repair accounts to the bottom of the job name & numbers list.