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

Question

Question

Gathering Collection Data

Forms
Updated January 4, 2023
asked on December 11, 2022

Hi all, we are only just starting to look at Collection fields in a form. Can you please help us understand how/if the Collection field data can translate into a single varchar MS-SQL field and, if so, how we do this. Thanks.

0 0

Replies

replied on January 3, 2023

You can use workflow to retrieve the collection field data and get the value of each set and merge them together and then insert the value to a single varchar SQL column, see sample workflow as below.

0 0
replied on January 4, 2023

A much simpler workflow would be following:

add insert data directly after retrieve business process variables and when configure the value for the insert data, use to the token dialog to select the field inside the collection and apply index for the value 

 

With that you don't need to use the For Each Value activity.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...