Still several questions about copy rows from one table to another

[E2p2l_Rics]

Hi, my friends. I want to copy rows from one sheet to another by using behavior: “add a new row to another table using values from this row”. Here are my questions:

1. How it decide which row it copy?
   This is columns of table “alpha”:
   
   
   
   This is my behavior setting:
   
   
2. I check the article of Praveen: New Action: Add a Row to a table. In this article I use his app and find that it can select all options, which does not work in my app:
   
   
   
   I wonder how to set it.
3. What surprise me most that after I click the behavior button in my app, the target table just has two rows. Actually it should have three rows.
   
   
   
   
   
   
   I wonder which step is wrong. Thank you all kindly.

[Marc_Dillon]

E2p2l_Rics:

How it decide which row it copy?

The Action will run on whichever record you run the Action on. How are you triggering this Action?

E2p2l_Rics:

I check the article of Praveen: New Action: Add a Row to a table . In this article I use his app and find that it can select all options, which does not work in my app:

I don’t believe that is a publicly accessible feature. Perhaps something new that is only available to whatever account this sample app is currently on.

I see you are using 3 “create a new record…” Actions inside of 1 Grouped Action. Perhaps you should be using a “data: execute an action on a set of rows”?

[E2p2l_Rics · Accepted solution]

Dear Marc, I have read your several articles in community, I knew you are the master on data transfer. Firstly thank you for your reply, after my verification I found problem appears in the setting of the key column. If the key column has duplicate values it will just show one of the data. For example if I set “sign” column as key column:

If the key column can help app distinguish different data, the action problem can be solved, but I still don’t know how to make a button to make the select-all function. Maybe you are right Marc, when I copy the standard app from Praveen and open it, the original button disappeared, I only can select rows one by one to trigger the action button again.