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

Question

Question

Form Collection to a Token to be used in Update Word Document

asked on June 11, 2018 Show version history

I'm trying to take the data in a LaserFiche Form Collection, which has three tokens for each row, to a single token so I can use it in a single field for a Update Word Doc tool.  I also saw that maybe you can do it using a Table Merge field?  The combination token will be used within a sentence along with other Merge Fields.  Which way is the best accomplish this? 

Capture.JPG
Capture.JPG (21.41 KB)
0 0

Replies

replied on June 11, 2018

Collections and Tables from a Retrieve Business Process (Forms) Variables activity are available directly for table merges in Update Word Document. You don't need to generate your own tokens:

0 0
replied on June 12, 2018 Show version history

Miruna

But in my "Adult Charges 2" collection I'm gathering three fields per row using "Charge2" "Adult Level 2" and "Adult IC 2".  There could be a several rows that I need in the Word document in a particular order separated by commas.  I need the data to display on the Word Doc as:

 

Theft (Level 3 Felony IC35-12-12-13), Fraud (Level 2 Felony IC35-2-12-23)

 

There are also other Field Merges on the Word Doc so that is where I'm confused.  See attached Word Doc.   So do I need to create a 2nd Update Word Doc to add the values from the collection or can I do it all in one?  

Capture.JPG
Capture2.JPG
Capture.JPG (41.96 KB)
Capture2.JPG (46.17 KB)
0 0
replied on June 12, 2018

I'm not seeing a "Charges" table in your Word doc. Word merge field tables are designated by "TableStart" and 'TableEnd" tags.

For ex,

When the activity runs, it will add each row as another line:

You can create the TableStart and TableEnd fields the same way as any other merge fields. The table name doesn't matter ("ChargesTable" in my example above), but it needs to match between the start and end tags.

0 0
replied on June 12, 2018

Ok that works!  But there is no way to make them display in a sentence form separated by a comma?  If not this is ok just wanted to see.  Thanks for the help!

Capture1.JPG
Capture2.JPG
Capture1.JPG (26.17 KB)
Capture2.JPG (38.04 KB)
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.