You are viewing limited content. For full access, please sign in.

Question

Question

Iterating Field Group Values

asked on December 28, 2017

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?

12-28-2017 1-30-05 PM.jpg
0 0

Answer

SELECTED ANSWER
replied on December 28, 2017

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.

2 0
replied on December 28, 2017

Perfect!!! 

Worked like a charm!

Thank You!!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.