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