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

Question

Question

Use Table Row Value for Assignment - Row Index

asked on November 3, 2017

Hi All,

We are working on a process-flow which requires parallel flow to be configured. We are using a table for selection of user with maximum of 5 rows. Now we want to pass the value of "Assigned to" to the parallel gateway as condition that if specific row index value is not null then take this route. I understand that there is a way to pass row index now in Forms 10.1, but somehow couldn't find the same. 

 

Rgds

Chandresh

0 0

Answer

SELECTED ANSWER
replied on November 3, 2017 Show version history

I don't believe it is currently possible to get a specific row index in the condition evaluations. As a workaround, you could add a hidden field for each row, then use a Function to assign the value from the associated row index. Then you can evaluate those fields instead to get the results you want.

For example, if you had 3 rows, you would create 3 hidden fields and use the following function in the Advanced tab for the new fields (replace the table and column names with those from your table)

=INDEX(Table.Column,1)

=INDEX(Table.Column,2)

=INDEX(Table.Column,3)

Make sure the fields are set to save the values even when hidden. The function will automatically update the value when the associated row/column changes, and that will give you a variable you can access in the conditional outflows.

 

UPDATE: As of 10.2.1 there's apparently an option to apply indexes to table variables.

For example, when you have multiple file uploads in a collection, you can link them to a field from the corresponding row in the save to repository task, like so 

{dataset/table/column[Row()]}

However, I tested and it does not appear to work in gateway conditions (yet).

 

https://answers.laserfiche.com/questions/88482/In-Forms-10-are-you-able-to-relate-field-values-to-a-file-upload-in-a-given-row?sort=newest

1 0
replied on May 6, 2020

Can we use these to assign a user task to this variable?

 

I have a table of approvers and want to assign task 1 to the user in row 1.

1 0

Replies

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

Sign in to reply to this post.