Workflow Multiple Value Lookup

asked on August 13, 2014

Is it possible to implement a database lookup within Workflow with a multi-value field and have it populate other multi-value fields with the return data (keeping it in order) using just the tools that Workflow comes with?

Example:

Table:

001, A, Z

002, B, Y

003, C, X

Laserfiche Fields:

Field 1 (Used to perform lookup):

#1: 001

#2: 002

#3: 003

Field 2 (Populated by lookup):

#1: A

#2: B

#3: C

Field 3 (Populated by lookup):

#1: Z

#2: Y

#3: X

The best I could think up was using a token for each value ID (1-10) in the field and having a lookup process for each one but I am hoping there is a more streamlined solution.

Thanks!

0 0

SELECTED ANSWER

replied on August 14, 2014

Yes, you definitely can! What you can do is use a For Each Value activity to run through each value of the field, and populate a corresponding multi-value field with the database results. Here is an example I threw together:

Here I am looking at an employee database, and grabbing each employee's respective ID. First I grab the employee multi-value field, then create a multi-value token to store the employees ID number. Next, I used the For Each Value activity to run through each employee field value, grab the corresponding ID, and store it in the employee number token I created. From there I just assign the final result of the employee number token to the employee ID field!

We start out with our employees...

And end up with each employee's ID in order!

0 0

Question

Question

Answer

Replies

Sign in to reply to this post.