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

Question

I need to populate a template field with 2 external database fields using workflow assign field value function

Workflow

Updated June 22, 2015

asked on June 22, 2015

I have an external SQL database that has a last name and a first name, we have a template field called name. It allows me to put in the Last name and First name lookup values but when the workflow runs it does not populate it with any value. If I do the Last Name of First Name individually it populates the field appropriately.

0 0

Replies

replied on June 22, 2015

Are these 2 different rows in SQL going into one field? If so, you will need to do a "For each Row" activity and when you set the field values, make sure to say "append".

0 0

replied on June 22, 2015

If you can recreate the issue, run a search for that Workflow instance in the designer and see if there are any specific warning or error messages relating to the matter. One thing to check for is the width of the Laserfiche field and make sure that the the combination of the first and last names does not surpass that width.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked June 22, 2015
Updated June 22, 2015
89 views