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

Question

Question

Workflow Tokens - Apply Index

asked on October 24, 2014

In Workflow 9.1 I'm collecting data from a Laserfiche form and using it to populate an Adobe PDF Form.  In one of the area's of the PDF Form I'm using the Apply Index token editor in Workflowr to grab the correct values and apply them to the correct field on the PDF.  I'm having an issue where in a table on the Laserfiche form only 1 row of data is submitted, however all of the fields in the table of the PDF are being populated and ignoring the assigned index from the token editor.  I read in the notes of Workflow the following, which I believe is the cause of my issue:

 

"Note: If you are counting values from the start and you specify an index greater than the total number of values in the token, the token will be replaced by the last value. If you are counting values from the end and you specify an index greater than the total number of values in the token, the token will be replaced by the first value.

 

Is there a way around this issue or a way to disable it so that the LF Form submitted values are not repeated?

1 0

Answer

SELECTED ANSWER
replied on October 24, 2014

Use the Table feature in Fill Out PDF Form instead of specifying the field index in each row in the table. Workflow will automatically put the multiple values into the rows for you.

1 0

Replies

replied on October 24, 2014

Miruna,

 

Thanks for your reply.  I'm seeing strange results when using the Table feature.  Some fields won't populate at all, while others will populate the wrong field in the table.  Are their any known compatibility issues with any version of adobe?  Any other settings I should check?  I've provided additional screenshots for reference.

 

Thanks!

ScreenShot006.png
ScreenShot007.png
0 0
replied on October 24, 2014

What's the exact version of your Workflow Server?

0 0
replied on October 26, 2014 Show version history

Hi Nathan -

Last year we were using WF 9.1 and we also had an issue that sounds similar.  In this case, we needed to capture as many as ten names from a form.  The idea was to use an approach like:

FirstName_(Index 1)

FirstName_(Index 2)

etc.

 

And so on.  But we could not get this to work, and ended up naming each field with hard coded names (FirstName_1, FirstName_2) and mapping each field to a token, and then testing to see how many fields had been filled out.  Iterating through an array would have been elegant, and was our original idea.

 

Hopefully, that is fixed in 9.2.

 

0 0
replied on November 3, 2014

Miruna,

 

I apologize for the delayed response as I've been out of the office.  The customer is using Workflow 9.1.1.381

 

Bill,

 

Thanks for the work around.  Sadly, that won't work for this scenario due to the dynamic nature of the data entry.  I have to be able to only fill out the exact number of fields that are also filled out using LF Forms.  There will be additional information added to the PDF form later in the workflow process.

 

Thanks to you both!

0 0
replied on November 4, 2014

Hi Brian -

Happy to try to help. ;-)

Nice form by the way. It looks like you have to accommodate a variable number of sets of fields, with no upper limit. I'd agree with Miruna, and try to get the table feature working in 9.2, and/or open a case.  There are work arounds, but that's all they all. If tables still does not work, I'd consider posting the data from the form to some database tables, where it may be easier to organize and count the result sets. Then you could take things from there.  But that's still a work around -

0 0
replied on November 4, 2014

I've discovered my issue.  In the Fill Out PDF Fields activity there are two tabs; Individual and Table.  For this activity, they cannot be used in combination; you must use one or the other.  By clearing out all items in the Individual tab I was able to successfully use the Table tab and fill out fields properly as Miruna described.

 

Thanks to all for your input!

0 0
replied on April 24, 2015

I am having a similar problem but am using a collection instead of a table.  (The data being recorded is lengthy so a table wouldn't be practical).  To populate the PDF form with workflow I'm using %(Getformdata_CodeBook_All#[1]#), %(Getformdata_CodeBook_All#[2]#), %(Getformdata_CodeBook_All#[3]#) and so on.  The form will accommodate up to 6 codebooks.  If I fill out all 6 the PDF populates correctly but if I only fill out 3 codebooks the last 3 fields populate with the value in the 3rd field.  Is there any way to fix this?  Thanks Sandy  See the attached examples

3-Codes.png
6-Codes.png
3-Codes.png (34.31 KB)
6-Codes.png (34.05 KB)
0 0
replied on April 24, 2015

Could you attach a sample PDF, please?

0 0
replied on April 27, 2015

Attached are both the editable version and the form version that will allow for the PDF to be edited and saved.


Thanks for you help.

Sandy

0 0
replied on April 27, 2015

Indexing multi-value tokens past the last value returns the last value as you've noticed.

Based on the PDF, you should be able to use the table feature to fill in Codebook/Comment/LongDescription fields. The layout doesn't matter, "table" fields are detected by regular expression based on their names. Something like "Codebook(\d?)" will find all 6 "Codebook" fields on the page.

0 0
replied on April 28, 2015

That worked Miruna, thanks!

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.