Copy rows to new table and associate them to a specific customer

AppSheet AppSheet Q&A
1

Hi, need help creating the following:

  • I have a table for Customers
  • I have a table called “Tasks”
  • I have a table called “Master Tasks List” which is a list of genetic tasks
  • I want to copy all of the rows on the “Master Tasks List” to the “Tasks” table. I am able to do that thru an action but I need the copied tasks to be associated to a selected customer
2

I think you will probably want to use the following action:

[New Action: Add a Row to a table](https://community.appsheet.com/t/new-action-add-a-row-to-a-table/13232) Announcements

We just added an initial version of a new action ‘Data: add a new row to another table using values from this row’ Please try it and give us feedback. Documentation, etc coming later this week. The brief version is here: let’s consider an example with Orders and OrderDetails as two related tables in an app. Add an action ‘CreateChildRow’ to the Orders table that will add a row to the OrderDetails table. You can specify expressions to assign to each column of this row. For example: Order = [O…

I think you should be able to use an expression to make an additional column that associates the newly added row to a particular customer.

2 Likes