Question

Concatenate field entries for current row of a table

Laserfiche Forms

Updated April 12, 2022

asked on April 11, 2022

I am trying to figure out if there is a way for laserfiche to reference the values from the current row of a table.

I do not know css and javascript (I occasionally steal SIMPLE code and get it to work) and I need to capture the row data for use in an email.

This is the user input and a field where I WANT to concatenate the entry for that row so I can just pull that field in an email where it would be acceptable to have the standard table field output format.

The concat is just simple and I was hoping there was a way to actually reference the current row for use in the formula.

0 0

Replies

replied on April 11, 2022

You can use the INDEX() and ROW() functions for that.

The format is INDEX(Table.Variable,ROW())

INDEX tells it to retrieve one value from the multi-value variable (i.e., a table/collection variable)

ROW tells it to use the index of the current row

Just be sure you are wrapping each individual variable in its own index function.

1 0

replied on April 11, 2022

PERFECT! That did exactly what I needed! Thank you! :)

0 0

replied on April 12, 2022

May I ask ONE more (probably VERY dumb) question? Is there a character that can be used within a concatenation string to indicate a carriage return?

0 0

replied on April 12, 2022

CHAR(10) = Line Feed/New Line (LF) = \n

CHAR(13) = Carriage Return (CR) = \r

They won't display in a single line field for obvious reasons, but those are the character codes.

I typically just use CHAR(10) and from what I can tell CR is kind of a legacy thing.

0 0

You are not allowed to follow up in this post.

Question

Question

Concatenate field entries for current row of a table

Replies

Sign in to reply to this post.