Question

Table Uploads to Different Paths with [Row()]

Forms

Updated November 11, 2021

asked on November 10, 2021

If you have a Forms table with file uploads, and there are uploaded docs from different rows of the table, you can apply metadata to the documents in a Save to Repository action using [Row()]

For example

{/dataset/Table2/Category[Row()]}

Using this, if you have an Upload field and a Category field on each row, each doc will get the correct Category for its respective row.

However, this does not work for a save location. If you try to use {/dataset/Table2/Category[Row()]} in the save location, and you have 2 rows with different values for Category then the docs will get saved to a folder with both Categories separated by a semicolon

Category1;Category2

Instead of doc from row 1 going into a Category1 folder and doc from row 2 going into a Category2 folder.

Is there a reason this can't be adjusted so it works for folder paths and not just metadata?

0 0

Answer

SELECTED ANSWER

replied on November 10, 2021

Hi Brian,

Which version of Forms is being used? This behavior should have been fixed in Forms 11 https://support.laserfiche.com/kb/1014265/list-of-changes-for-laserfiche-forms-11

Use row() to retrieve field data from the same row for the attachment to always get the value from the same row when saving to a repository. (237166)

2 0

replied on November 11, 2021

Thanks, Ziyan. They are on 10.4.1. I will let the customer know it works in version 11. In the meantime, I changed the save location to an Autofile folder where a workflow will route them to the right place.

1 0

Replies

replied on November 10, 2021

Hi Brian

As a Workaround, it is possible to use a workflow to pull the attachments from your table and use the ROW data to Save those files into the appropriate folder in the Repository.

1 0

You are not allowed to follow up in this post.

Question

Question

Table Uploads to Different Paths with [Row()]

Answer

Replies

Sign in to reply to this post.