Replicate Row Values

asked on January 31, 2016 • Show version history

Hi,

I have a Laserfiche form process that has two tables (Table1 & Table2). I have set it in such a way that in the submission task Table1 is filled. Now on the following task Table2 is displayed with the same number of rows as the Table1. i.e if the first user filled ten rows, the second user of the following task will see Table1 with ten filled rows and Table2 with ten empty rows for him to fill. The issue is there are a number of fields in Table2 that carry the same value and we wouldnt want to retype them through out the ten rows. How can I input them in the first row and they be replicated automatically in the other following rows of Table2? AM using LF10. Thanks

0 0

replied on February 1, 2016

Hi, this is not natively supported yet. Maybe you can archive using customized JavaScript. In next version of Forms(10 SP1), there will be native Formula functions to archive this. For example, in the field for the table 2 that needs carry over value, you can use formula like "=INDEX(Table1.Column_1,ROW())" to make the rows in table 2 to replicate the rows in table1.

0 0

replied on February 1, 2016 • Show version history

Hi Xiang,

I attach herein an example of the table. Assuming this is Table 2, it has 7 rows when the form is loaded. All the fields are empty and I need to fill in some of the standard numbers whereas the rest are calculated. In the attached table, column Rate, PA rate and tax are the same in most of the rows. All I want is to fill the first row and the values are replicated in row 2 upto row 7. Those rows with different values I can then go and change. Thanks

Mark

table.png (15.78 KB)

| Download

0 0

Question

Question

Replies

Sign in to reply to this post.