Multiple pages within one record. Open a new form to add data to a different table.

[robbertzalm]

I am building a simple fishing inventory app.

I would like to register fishing day with date and weatherconditions and store as decks.

When I select one of the deck I would like to create the option to open a form so I can add data like species, measure. weight and time to a second tab in my google sheet.

I also would like to create an option to open the deck of a fishing day and then look at the catches overview in a table.

So in the first tab I have created a ID column (Unique ID) that will be added when I enter a new fishing day.

When opening the fishing day record I would like to enter an add option in which I enter the same ID vallue to the 2nd tab sheet together with other values like size and weight. This way the catches are linked to the fishing day by the ID.

I think I can create a view option in which I set the rule that the ID of these two columns should be the same.

So far I can transfer the ID by using an action "Data: add a new row to another table using values from this row" but I am not able to add additional fields that only excist in tab 2.

Other option is to open a new form and add data to the same table.

I am looking for the option to open a form and add existing data from table1  together with new data to table 2

Is there a way to create a new form and add to a different tab in the googlesheet that I use as a database?