Question

Forms V10.1 -- Get a value from a table column and copy it to a field

Forms Version 10

Updated August 17, 2016

asked on June 28, 2016 • Show version history

I am trying to use the new Calculation function in Forms V10.1 to copy one info from one field to another field. I have one info on a table, on column_1, at row 1 (First value) and need to copy it to a field called "NewField".

In that "NewField" Calculation section, I am typing the following formula:

=Table.Column_1

The result is I get a bunch of coma. I want to get the first value. I have tried "=Table.Column_1(1)", also tried "=Table.Column_1.val(1)" and a bunch of other tests but it doesn't work. The syntax doesn't seem to be published in the documentation.

Does anyone know the syntax to use for a specific table / column / row?

0 0

Replies

replied on June 28, 2016 • Show version history

for first row you would use something like

=TEXT(INDEX(table.col1,1))

Follow this link if you want more information. please let us know if it helps

1 0

replied on June 28, 2016 • Show version history

Thanks for this quick response. Your formula is working but it however seems to perform the calculation before I want it to.

My use case is that there is a lookup that is being performed when the form is loading. That lookup will put values in a table. then calculation need to take place after the lookup did copy the information to that field, to allow this calculation to copy a specific info to another field.

0 0

replied on June 29, 2016 • Show version history

Hi,

In my use case, this doesn't work as it seems the Lookup rule is not creating an Update Event when filling up my table columns, thus the calculation doesn't trigger when values are updated in the table.

Is this an actual limitation (or bug) in Forms V10.1.0 ?

0 0

View 1 previous reply

replied on July 4, 2016

Hi Daniel, I checked use lookup rule to fill column 1 and reference column 1 in new field using calculation like this"=TEXT(INDEX(Table_1.Column_1,1))", the new field value does updated when column 1's value is updated by lookup rule(http://screencast.com/t/hei2wiO6KP. Can you share how do you set up the lookup rule and calculation?

0 0

replied on July 11, 2016

Hi, the issue is when the lookup is set to put multiple values to separate rows, when the "As new line" is checked.

0 0

replied on July 12, 2016

Hi Daniel, this is bug when use "as new line". We will address it for next release.

0 0

replied on August 17, 2016

The issue has been fixed in Forms 10.1 update 2 (10.1.0.619), you can download the update from https://support.laserfiche.com/kb/1013792

0 0

You are not allowed to follow up in this post.

Question

Question

Forms V10.1 -- Get a value from a table column and copy it to a field

Replies

Sign in to reply to this post.