Question

How do I concatenate multiple retrieved field values into a single string token

Workflow Version 8 Laserfiche

Updated August 27, 2014

asked on August 27, 2014

I've used retrieve field values to pull 3 fields Lname, Fname, and Member ID from a document and now I need to concatenate them into a single string as follows Fname,Lname-MemberID in order to name the document. When I try to use the token dialog it tells me that the token doesn't support multiple values, but I don't want a multi value token I want a token which is a single string.

It's LF 8.3 and workflow 8.3 if that matters.

0 0

Answer

APPROVED ANSWER

replied on August 27, 2014

My mistake - I forgot to publish the rule after the changes.

0 0

replied on August 27, 2014

Glad I could help get this resolved for you.

0 0

Replies

replied on August 27, 2014 • Show version history

I think you may be accidentally adding the second/third tokens into the first token. Can you post a screenshot of the Token dialog menu? That should help us understand more.

Make sure that the tokens are separated and not in the middle of each other.

EDIT:

Without using the Token Dialog, you should just be able to do this as the rename text:

%(Fname), %(Lname)-%(MemberID)

0 0

replied on August 27, 2014

I tried that it doesn't appear to be working

Token Dialog.PNG (67.51 KB)

| Download

0 0

View 1 previous reply

replied on August 27, 2014

None of the fields are multivalue. I have found though that if I don't put a prefix before when I try to rename the document and just use %(DocName) see the image. Then the document just vanishes so it's like it doesn't evaluate it to a string unless it's part of a string.

Capture2.PNG (18.68 KB)

| Download

0 0

replied on August 27, 2014

Hm.... If things like Tokens are not being evaluated, it may be something to contact your VAR about and/or open up a support case. This functionality should be working.

As a test though, can you try using a "Track tokens" activity to see what the values are? maybe the value of the token is actually empty, giving you this result you have found.

0 0

replied on August 27, 2014

I know the token wasn't empty because it clearly evaluates to the proper string when concatenated with a prefix or suffix, just not when it's on its own in the rename document dialog. It's not really a big deal, I really need to just update to 9.1 soon. It works, now since I've just stuck a prefix on the doc name.

Thanks for the help.

0 0

You are not allowed to follow up in this post.

Question

Question

How do I concatenate multiple retrieved field values into a single string token

Answer

Replies

Sign in to reply to this post.