How do you iterate over a field group as a whole?
For instance, I want to concatenate the contract # & component together and store in a single database column.
Do I have to use SDK Script to align the multi-value indexes?
How do you iterate over a field group as a whole?
For instance, I want to concatenate the contract # & component together and store in a single database column.
Do I have to use SDK Script to align the multi-value indexes?
Hi Rich,
You can achieve this with a workflow using the iteration value on a loop as the index.
First retrieve your field values ( All Values ).
In your For Each Value loop iterate over only one of your retrieved field values.
You can then concatenate the values together.
In the assign token value I added the field that I am iterating over %(ForEachValue_Current Value) and also the other field(s) that I retrieved from my Retrieve Values activity, in my case the field is state.
%(ForEachValue_Current Value) %(RetrieveFieldValues_state_All)
Next click the token dialog ...
and place the iteration index on all the fields but the Current Value.
So your final value looks similar to:
%(ForEachValue_Current Value) %(RetrieveFieldValues_state_All#[%(ForEachValue_Iteration)]#)
That gives you the index into each multi value field.