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

Question

Question

Multi Value Field to Collection

asked on August 8, 2016 Show version history

Hi,

I have a form in which there is a unique id field and a collection with one field where user can add as many rows as he wants. Then that collection and unique id is stored in the template by workflow in a multi value field.

Also, at the same time workflow stores this information in a table in DB by comma separation along with unique id (I couldn't think of any other way of storing it as i tried new line but that didn't work as well).

I am trying to pre populate a second form from DB based on unique id using lookup rules in a collection. 

Currently, it is not working as all values get stored in same row comma separated.

I would like form to pre populate just like it was when input by user.

Any help is greatly appreciated.

Thanks

Junaid Inam

0 0

Replies

replied on August 9, 2016

Is it a must to store the data related with one unique id into one row? Can you update the workflow to store multiple rows in the db table for one unique id? Each row would store unique id and one row of field value in the collection.

And the workflow would look like this:

If so, then you would be able to use lookup rules in forms to match the unique id then fill the collection with user data.

And the lookup rule would look like this:

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

Sign in to reply to this post.