Is it possible to have Workflow retrieve a multi value field, and then write to a SQL DB with multi row? If it is, what would be the best route to take to achieve this? I have tried for "each value" function, but it keeps duplicating fields when its outputting to SQL. Thanks.
example:
Laserfiche To SQL DB
Multi Field 1 : Multi Field 2 : Multi Field 3 ----> Column 1 : Column 2 : Column 3
Row 1: A ! Test 1 A ! Test 1
Row 2: B @ Test 2 B @ Test 2
example 2:
if I have 3 multi-value fields, here is how it displays:
Grant 1
Grant 2
Grant 3
Project 1
Project 2
Project 3
Amount 1
Amount 2
Amount 3
would it possible to have them output to SQL or Excel like this?
Grant 1 Grant 2 Grant 3
Project 1 Project 2 Project 3
Amount 1 Amount 2 Amount 3
I don't think so but I thought I'd double check just in case. Thanks so much!