Replicate values from one table to the next

replied on March 13, 2017

Hi Cristobal,

If you are using Forms 10.1 above which supports formula on table, you could use formula like this:

=INDEX(Table.Column_1, ROW())

Set the above formula on the target table column, and replace Table.Column_1 with source table column variable.

The above works if your table has fixed number of rows. If you set the table with "Range of rows" option, you still need JavaScript to keep the target table updated when source table is added with a new row.

The script could be like this (#q3 is the source table "Add" button id while #q7 is the target table "Add" button id):

  $("#q3").click(function(){
    $("#q7").click();
  });

2 0

replied on January 14

Rui Deng : How do we replicate the above formula in new Laserfiche JS? I have similar requirement (Form version 11 using new designer)

0 0

replied on January 14

Hi Bipin, Formula works the same on classic form and new form

0 0

replied on January 14

Rui Deng - Sorry, I meant the script not the formula. Need the following scrip in the new forms JS.

$("#q3").click(function(){
  $("#q7").click();
});

Use case:

I have a form table (T1) that capture clothing details for staff (Staff Name, Item, Size, Location etc). In the same form I have another table (T2) that needs to have same rows as of T1 with only Staff Name and Item filed. I can use the =INDEX(Table.Column_1, ROW()) formula but it populates the 1st row only.

Thank you.

0 0

Question

Question

Replicate values from one table to the next

Replies

Sign in to reply to this post.