How to copy values from some columns in a specific row to another set of rows in the same table ?

I am trying to create an inline action where I would want to copy values from a few columns in that row, and set it in the same columns of another set of rows that match the criteria. 

For Example,

I have an order table where I have columns say Billing Ledger , Lead time, Payment terms. For instance, I have filled these columns in one order and I want to copy the same values in the other orders ( rows) matching the customer of this order. 

How do I do that ?

0 2 459
2 REPLIES 2

If for new orders for that customer you will be using form to fill in new orders, you could use link to form action from the detail views of the existing orders.

https://www.appsheet.com/templates/This-app-shows-how-to-link-to-a-form-and-fill-in-default-values?a...

https://help.appsheet.com/en/articles/2357261-linktoform

https://help.appsheet.com/en/articles/1023058-app-column-type-deep-link

 

If you wish to do that for existing already created rows, you could evaluate reference actions.

https://www.appsheet.com/templates/This-app-shows-how-to-use-reference-actions?appGuidString=e76d2e7...

Reference actions can also be triggered on the same table.

 

Thankyou suvrutt. Reference Action could have worked in my case but for now I have used the bulk edit method using Input() to select and fill all those  rows at once. Seems working fine for now. Thanks for the help though. 

Top Labels in this Space