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

Discussion

Discussion

Answer: Get row value when using Save to Repository task for values associated with File Upload fields contained in a Table/Collection

posted on February 11, 2022 Show version history

It was noted at Empower that this method is not commonly known, but it's such a common request that it should be written down in Answers, so I decided to add it here:

 

How to get the row value  associated with a File Upload into the metadata for a Save to Repository task when said File Upload is contained in a Table or Collection. 

 

This works in Self-hosted ("on-prem") and Cloud Laserfiche environments. 

 

The answer is pretty straight forward: [ROW()] -- I put a simple example below to show you what I mean:

The form that is being saved looks like this: 

 

 

This method works for Tables and Collections. The variables associated with the Table/Collection above are ____ SL 1 and  2 respectively. 

In the configure fields options:

Use this syntax:

Just add [ROW()] at the end of the table/collection variable before the curly brace. It looks like this:
{/dataset/Table/Table_SL_1[ROW()]}
{/dataset/Table/Table_SL_2[ROW()]}
{/dataset/Collection/Collection_SL_1[ROW()]}
{/dataset/Collection/Collection_SL_2[ROW()]}

 

Thank you

See also:
https://doc.laserfiche.com/laserfiche.documentation/11/administration/en-us/Default.htm#../Subsystems/Forms/Content/Service-Tasks.htm#SavetoRepositoryServiceTasks

3 0
replied on February 13, 2022
0 0
replied on February 14, 2022

Hello Xiuhong

 

Are there any other Forms formula formatting tricks that can be inserted into the dataset line? I assume ROW() is the only one, but I wanted to make sure. 

 

Thank you

0 0
replied on February 14, 2022

Row() is the only one that is supported.

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

Sign in to reply to this post.