Adding new record to another table when a record is added

AppSheet AppSheet Q&A
,
1

I have a project table and a task table. I would like to add a row to the task table when a new project is added. I need to include the project ID of the project just entered in the task table
Which would be the best way to accomplish this.

2

Please explore below approach.

The approach assumes that the Task table is child table of Project table.

If so , you could use an event action of type “Data: add a new row to another table using values from this row” .The action can be invoked on record save of parent table Project

[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…

A sample app that demonstrates event actions

https://www.appsheet.com/samples/How-to-go-to-a-view-based-on-the-users-form-submission?appGuidString=2f0c35f4-938f-466b-b5f7-ed749ca1d0ef

2 Likes
3

Thanks for the links.

1 Like