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:
-
How it decide which row it copy?
This is columns of table “alpha”:
This is my behavior setting:
-
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.
-
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.
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”?
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.
2 Likes
