Question

Creating an annotation for multi-value field group token

Workflow Laserfiche How To

Updated October 31, 2017

asked on October 3, 2017

I am trying to create an annotation using a multi-value field group token. The issue I am having is that the only value retrieved is for the first group. I have line items details entered for 3 (2 lines shown below) lines however only the details for the first line is retrieved. My config is shown below.

0 0

Answer

SELECTED ANSWER

replied on October 27, 2017

In that case, you'd have to build the token value one line at a time.

(For Each Value's iteration token allows you to get the current value in the multi-value tokens and combine it with static text.

0 0

Replies

replied on October 23, 2017

Does anyone have a suggestion how to fulfill the above request?

0 0

View 2 previous replies

replied on October 23, 2017

There isn't enough information to troubleshoot. Are you saying that Retrieve Field Values only gets the first value for the multi-value fields? Or are you saying the compound token in Assign Fields only has one value?

Please add a screenshot of the Tokens tab in the instance details showing your token values.

0 0

replied on October 23, 2017

It appears that the "Retrieve Field Values" is capturing only the values in the first row for the field group. Note that "R" below is the same as line number, we are also capturing "SCOA" and "Fund" however only the data in the first row is captured.

0 0

replied on October 23, 2017

Your screenshot of the Tokens tab does not show the results of Retrieve Field Values. It only shows tokens from a Search Repository activity (and that works as expected, Search Repository, like the search results listing in the Laserfiche Client, only has the first values in multi-value fields).

0 0

replied on October 26, 2017

I was sidetracked for a few days with some other issues. You are absolutely correct, I was showing the search result and not the retrieval tokens.

All the values are being retrieved, see screenshot below from a test I did this morning. How do I configure this to annotate all the values and not just the first line. The "Budget_Line_Item_Values" token is configured as follows "Line#:%(RetrieveFieldValues_Line Number_All) Fund:%(RetrieveFieldValues_Fund_All) SCOA:%(RetrieveFieldValues_SCOA_All)". Do I need to change this?

0 0

replied on October 26, 2017

Oh, you're combining static text and multi-value tokens. That wasn't in your initial screenshot.

The combination of text and tokens in an editbox turns off the multi-value processing for the token, so your value becomes text+first value in the token.

What do you want the end result to be?

label + each value on a new line

Line: 1

Fund: A

label + value on each line

Line: 1

Line: 2

Line: 3

Fund: A

Fund: B

Fund: C

groups of labels and values corresponding to the field group

Line: 1

Fund: A

Line: 2

Fund: B

Line: 3

Fund: C

0 0

replied on October 26, 2017

To further clarify I have entered data for two lines.

However the compound token only captured data for the first line in the "budget_line_item_values" token.

0 0

replied on October 27, 2017

I would like the output to be :

Line: 1 Fund: *** SOCA: ***

Line: 2 Fund: *** SOCA: ***

Line: 3 Fund: *** SOCA: ***

0 0

SELECTED ANSWER

replied on October 27, 2017

In that case, you'd have to build the token value one line at a time.

(For Each Value's iteration token allows you to get the current value in the multi-value tokens and combine it with static text.

0 0

replied on October 28, 2017

Thanks Miruna, I am closer. I am still only seeing one set of values in the annotation however it is now formatted perfectly. I think the issue is likely how I am referring to the token. See basic config below...