word field multivalue

asked on June 7, 2018

Hi all,

Under Laserfiche, I have a field with 2 values

Using Workflow and the object Word, I'm trying to populate my *.doc with this values.

But at the end, I only have 1 value.

How can I put a field multivalue in my doc?

This is what I did.

1. Search the Laserfiche's document

2. Update Word

3. Create an entry

4. Merge the Word to this Entry.

My search's object

My Word's object

And the return.

Please, how can I do for have 2 lines?

Thanks in advance

Regards

0 0

SELECTED ANSWER

replied on June 7, 2018 • Show version history

When you populate a table in a word doc from a repository search it treats each entry found as a row of the table. I don't believe that it is set up to pull multiple values from a metadata field within a record.

Coders out there may now how to combine the values with a custom script. But since I don't write code I am only guessing.

All the word docs I update, I pull from a database table. You could attempt to set up a temporary database table to work off of. After your search, you would have to do a For Each activity that would look at the search result and put it into the database table. For multiple values in one field you would either have to have all the values combined into one field, or create an entry for each value.

The you would have to search the database table and use those results to populate the word document.

If you don't want the database table to grow, you could do a custom query to delete all the values at the end of the workflow.

1 0

replied on June 7, 2018

Ok so, if I follow you, I should first split the information and make a new file for each one, then make a search and then with the search's results, I could modify my word, right?

0 0

replied on June 8, 2018

I have never tested it but yes, in theory that should work. So if you have a record with 2 values, you would have to make 2 records with one value each.

0 0

Question

Question

Answer

Replies

Sign in to reply to this post.