Hello,
I have a collection in the initial form where I get the multiple approvers. What is the best way to sequentially assign to these multiple approvers one by one?
Others may have more elegant solutions, but we handle this by pulling the values out of the collection into hidden fields.
We've been able to identify a maximum number of potential approvers, let's say 10.
Then we create 10 (or however many) hidden single line fields, each with a formula that pulls out the value in the corresponding collection row, like this (this formula was from a table where we did the same thing, but should give you the idea):
=IF(INDEX(mytable.approver,1) <> "",TEXT(INDEX(mytable.approver,1)),"") <-- this pulls out the value from row 1 of the table
Now that we have the approver names in single line fields, we can use them for routing in the process diagram.
I hope that helps!
Thanks, this helps, will try.