Adding new record to another table when a record is added

[Virgil_Wilson]

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.

[Suvrutt_Gurjar · Accepted solution]

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

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

help.appsheet.com

View Events

View actions can run when certain events happen and help you create custom navigation.

A sample app that demonstrates event actions

https://www.appsheet.com/samples/How-to-go-to-a-view-based-on-the-users-form-submission?appGuidStrin...

[Virgil_Wilson]

Thanks for the links.