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

Question

Question

Copy row if field contains text

Forms Laserfiche Cloud
Updated September 26, 2022
asked on September 26, 2022

Hello,

I have 2 Tables: Table1 & Table2

 

In Table1 I have a hidden field "Copy", this is being populated by Lookup.

 

I want when the field Copy has value "Yes", the row should be copied to Table2

 

Table1 has 2 visible fields: Description & Amount

Table2 also has these fields & only these 2 need to be copied.

 

It can be either Formula or JS...

 

Many thanks in advance!

 

S

0 0

Replies

replied on September 26, 2022 • Show version history

I managed to get the value with :

 

=IF(INDEX(Bruttolohn.Copy,ROW())="Yes",INDEX(Bruttolohn.BruttoDescription,ROW()),"")

The issue is that if I edit the Source table (Bruttolohn in this case), the Destination doesn't delete the rows, also neither it adds the rows.....

I think it will be JS route, can someone please help?

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

Sign in to reply to this post.

Details
Related Posts
Loading ...